Data & Analytics, Consultant

Master Works is seeking a Data & Analytics Consultant to lead the business intelligence and data engineering functions, overseeing the enterprise data warehouse, ETL/ELT pipelines, and BI reporting ecosystem. In addition to technical leadership, this role acts as a strategic business partner across Operations, HR, Finance, IT, and Strategy to capture business requirements, define key performance indicators (KPIs), and deliver actionable decision-support tools. Key Responsibilities - Gather, analyze, and document business and data requirements. - Translate business requirements into data and analytics solutions. - Design and develop Power BI dashboards, reports, and data visualizations. - Perform data analysis to identify trends, patterns, opportunities, and business risks. - Develop and optimize SQL queries for data extraction, transformation, and analysis. - Support data modeling, data integration, and data quality activities. - Work with stakeholders to define KPIs, metrics, and performance indicators. - Provide analytical insights and recommendations to support business decisions. - Collaborate with Data Engineers, BI Developers, Data Scientists, and business stakeholders. - Conduct data validation and ensure the accuracy and consistency of analytical outputs. - Prepare presentations, analytical reports, and executive-level insights. - Support the implementation of data governance, standards, and best practices. - Identify opportunities to automate reporting and improve analytics processes. - Provide consulting and advisory services related to data and analytics. - Stay updated on emerging technologies, analytics methodologies, and AI-driven analytics. Requirements - Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Statistics, Business Analytics, or a related field. - 5+ years of experience in Data Analytics, Business Intelligence, or Data Consulting. - Strong experience with SQL and relational databases. - Hands-on experience with Power BI and data visualization. - Strong understanding of data modeling, ETL, and data warehousing. - Experience translating business requirements into technical/analytical solutions. - Strong analytical, problem-solving, and communication skills. - Ability to work effectively with both technical and non-technical stakeholders. - Extensive hands-on background with Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS). - Mastery of SQL Server or modern cloud data warehouses, relational database design, and query optimization. - Expert-level competency in Microsoft Power BI (Power BI Service, Gateway management, Premium capacity, DAX). - Demonstrated cross-functional domain knowledge across business operations, corporate finance, workforce analytics, and strategic execution. - Experience with Microsoft Azure, Azure Data Services, or cloud analytics platforms is preferred. - Knowledge of Python for data analysis is preferred. - Experience with DAX and Power Query is preferred. - Understanding of Data Governance, Data Quality, and Master Data Management is preferred. - Experience in AI/ML analytics or integrating AI capabilities into business solutions is preferred. - Certifications such as Microsoft Power BI Data Analyst, Azure Data Engineer, or related certifications are preferred. Job Location: Client Site

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Statistics, Business Analytics, or a related field. 5+ years of experience in Data Analytics, Business Intelligence, or Data Consulting. Strong experience with SQL and relational databases. Hands-on experience with Power BI and data visualization. Strong understanding of data modeling, ETL, and data warehousing. Experience translating business requirements into technical/analytical solutions. Strong analytical, problem-solving, and communication skills. Ability to work effectively with both technical and non-technical stakeholders. Extensive hands-on background with Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS). Mastery of SQL Server or modern cloud data warehouses, relational database design, and query optimization. Expert-level competency in Microsoft Power BI (Power BI Service, Gateway management, Premium capacity, DAX). Demonstrated cross-functional domain knowledge across business operations, corporate finance, workforce analytics, and strategic execution. Experience with Microsoft Azure, Azure Data Services, or cloud analytics platforms is preferred. Knowledge of Python for data analysis is preferred. Experience with DAX and Power Query is preferred. Understanding of Data Governance, Data Quality, and Master Data Management is preferred. Experience in AI/ML analytics or integrating AI capabilities into business solutions is preferred. Certifications such as Microsoft Power BI Data Analyst, Azure Data Engineer, or related certifications are preferred.

Gather, analyze, and document business and data requirements. Translate business requirements into data and analytics solutions. Design and develop Power BI dashboards, reports, and data visualizations. Perform data analysis to identify trends, patterns, opportunities, and business risks. Develop and optimize SQL queries for data extraction, transformation, and analysis. Support data modeling, data integration, and data quality activities. Work with stakeholders to define KPIs, metrics, and performance indicators. Provide analytical insights and recommendations to support business decisions. Collaborate with Data Engineers, BI Developers, Data Scientists, and business stakeholders. Conduct data validation and ensure the accuracy and consistency of analytical outputs. Prepare presentations, analytical reports, and executive-level insights. Support the implementation of data governance, standards, and best practices. Identify opportunities to automate reporting and improve analytics processes. Provide consulting and advisory services related to data and analytics. Stay updated on emerging technologies, analytics methodologies, and AI-driven analytics.