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 REQUIREMENTSEducationBachelor'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.
Postal Code: 77019
Category (Portal Searching): Information Technology
Job Location: US-TX - Houston
