BI Data Analyst II

Our associates celebrate lives. We celebrate our associates.

JOB RESPONSIBILITIES

• Build and manage end-to-end ETL/ELT workflows for ingesting, transforming, and loading data from multiple sources.
• Design, develop, and maintain scalable data integration and transformation solutions using Azure Synapse Analytics Pipelines.
• Develop, optimize, and monitor data pipelines to ensure data quality, reliability, and performance.

• Create and maintain data models, datasets, and reporting solutions using Power BI.
• Design interactive dashboards, reports, and visualizations to support business intelligence and decision-making.
• Manage data refresh schedules, report deployments, and security configurations within Power BI.
• Collaborate with business stakeholders to gather reporting and analytics requirements.

• Develop and implement dimensional data models, including star and snowflake schemas, to support data warehousing and business intelligence initiatives.
• Perform data analysis and data profiling to identify data quality issues and improve data integrity across systems.

• Leverage Artificial Intelligence (AI) and Machine Learning (ML) technologies to support advanced analytics, predictive modeling, and business insights.
• Collaborate with data scientists, business analysts, and stakeholders to integrate AI-driven solutions into enterprise reporting and decision-making processes.
• Evaluate emerging AI, Generative AI, and cloud-based analytics technologies to identify opportunities for innovation and process improvement.
• Implement AI-powered data quality, anomaly detection, forecasting, and automation solutions to enhance business operations and reporting capabilities.

MINIMUM REQUIREMENTS

Education

Bachelor’s degree in computer science, Information Systems, Engineering, Business Analytics, Data Science, or a related field.

Experience

• Five (5) years of Information Technology experience with a strong focus on data integration, data warehousing, business intelligence, and analytics solutions.
• Three (3) years of hands-on experience developing and maintaining Azure Synapse Analytics Pipelines.
• Experience integrating data from multiple sources, including cloud and on-premises systems.
• Three (3) years of experience designing, developing, and supporting Power BI dashboards, reports, and datasets.
• Strong experience in data modeling, dimensional modeling, and data transformation techniques.
• Experience developing and optimizing SQL queries, stored procedures, database objects, and SQL Server solutions.
• Experience implementing data quality, validation, and governance processes.
• Experience managing Power BI workspaces, datasets, gateways, row-level security (RLS), and report deployment processes.
• Experience collaborating with business users, data analysts, data scientists, and technical teams to deliver reporting, analytics, and AI-driven solutions.
• Experience supporting AI/ML initiatives through data engineering, data preparation, and analytics platforms is preferred.

KNOWLEDGE, SKILLS & ABILITIES

• Strong knowledge of Azure Synapse Analytics, including Pipelines, Data Integration, and Data Warehousing capabilities.
• Advanced proficiency in SQL for data extraction, transformation, analysis, and performance tuning.
• Strong experience designing and maintaining ETL/ELT solutions.
• Proficiency in Power BI, including report development, dashboard creation, DAX, Power Query, and data modeling.
• Experience developing interactive visualizations and executive-level reporting solutions.
• Understanding of dimensional modeling concepts, including star and snowflake schemas.
• Knowledge of data warehousing principles and best practices.
• Understanding of Artificial Intelligence (AI), Machine Learning (ML), Generative AI, and advanced analytics concepts.
• Experience supporting AI/ML data pipelines, feature engineering, model deployment processes, and AI-enabled reporting solutions.
• Knowledge of Azure AI services, cloud analytics platforms, and modern data architecture patterns is desirable.
• Strong analytical and problem-solving skills with the ability to translate business requirements into technical solutions.
• Strong communication and collaboration skills for working with business stakeholders and technical teams.
• Ability to manage multiple priorities and deliver high-quality solutions in a fast-paced environment.