BI Data Analyst II

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

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.