Data Analytic - Tableau and Power BI dashboards

Duties include, but are not limited to, the following:

• Analyze and understand business requirements to design effective data models

• Connect BI tools to various data sources, including databases, Excel files, and web services

• Use business intelligence software (Tableau and Microsoft Power BI) to create dashboards and visualize data
• Develop dashboards and key Performance Indicators (KPI) with Power BI and Tableau.

• Design ETL packages dealing with different data transfers between different systems.

• Write, optimize queries and stored procedures
• Create multiple types of reports and packages from SSRS and SSIS

• Designs and prepares periodic reports as per requirements details in official Client policies

• Use technical expertise to automate manual processes and reporting
• Compile and compute data according to statistical formulas for use in data analysis and/or statistical studies
• Work as Data analyst, by interacting with the researchers and gathering requirement for data discovery

• Work with complex data sets to understand problems and recommend procedures while using various analytical and statistical approaches

• Prepare business analytics and assist in preparing metrics and reporting
• Respond to ad hoc requests for data, aggregations, and visualizations
• Conduct research and analysis of data at Client, definitions and usage, system flows, challenges, and opportunities

• Collaborate with business users and business analysts to develop analytical strategies for development of various projects

• Develop documentation including data dictionaries, policies, and procedures
• Other duties as assigned

The candidate must have a minimum of:

1. 5 years of experience in data analytics.
2. 5 years of experience in developing Tableau and Power BI dashboards.
3. Proof of eligibility to work in NYS., * Develop metrics and reports * Data analysis * Data visualization * High-level competency in Excel (advanced formulas, macros, etc.) * Expertise in relational database management systems, SQL, data modeling * Ability to translate complex business requirements to technical specifications for IT * Highly motivated and effective working autonomously and as part of cross-functional teams * Ability to multi-task across projects, and be detail-oriented, and accurate

InterSources Inc. is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.