Job Responsibilities:
· Design, develop, test, and support enterprise data warehouse and business intelligence solutions.
· Develop scalable data integration workflows using ETL/ELT tools (e.g., SSIS, Azure Data Factory).
· Build and maintain star schema models, including fact and dimension tables and metadata documentation.
· Develop SQL scripts, queries, stored procedures, and optimize performance for large datasets.
· Utilize Azure Synapse Analytics or Microsoft Fabric for cloud-native data warehousing.
· Create visual reports and dashboards using Power BI Service.
· Implement and follow data governance, data quality, and data lineage best practices.
· Integrate data from structured and semi-structured sources (e.g., relational databases, flat files, APIs, cloud storage).
· Apply DevOps practices including CI/CD for data integration pipelines and use of source control systems.
· Troubleshoot data-related issues such as anomalies, ETL job failures, and performance bottlenecks.
· Collaborate with business stakeholders to convert business requirements into technical solutions.
· Document data models, workflows, and data contracts clearly and effectively.
· Participate in Agile/Scrum ceremonies and contribute to sprint deliverables.
Required Skills & Qualifications:
· 3+ years of experience with enterprise BI/data warehouse development.
· Strong proficiency with ETL tools like SQL Server Integration Services (SSIS) and Azure Data Factory___3+Years.
· Experience with Azure Synapse Analytics or Microsoft Fabric___3+Years.
· Advanced SQL development skills, including complex queries, stored procedures, and views___3+Years.
· Experience in building and managing star schema models___3+Years.
· Expertise in Power BI Service for data visualization and reporting___3+Years.
· Deep understanding of data governance, quality, and lineage___3+Years.
· Experience integrating data from multiple structured and semi-structured sources___3+Years.
· Familiarity with DevOps practices, source control, and CI/CD pipelines___3+Years.
· Strong analytical and troubleshooting abilities___3+Years.
· Excellent communication skills, both written and verbal___3+Years.
· Proven ability to work in Agile/Scrum or DevOps teams___3+Years.