BI Data Analyst II

Our associates celebrate lives. We celebrate our associates.

• 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.

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

• 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 work spaces, 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.

• 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.