Description

You will design, implement, and maintain database objects and security while managing large-scale data integration routines.

Responsibilities

• Translate business requirements into data mapping, cleansing, and transformation routines for moving data between systems.
• Design and maintain database objects including tables, views, and indexes while ensuring data warehouse performance through tuning and parallelization.
• Collaborate with Data Architects to develop optimal data models and establish metadata governance processes.
• Ensure data quality through audit controls, proactive monitoring, and scheduled integrity checks.
• Manage deployments, coordinate releases, and provide on-call support as needed.

Required Skills

• 5+ years of experience in Data Warehousing and Business Intelligence.
• 3+ years of BI development leveraging Microsoft SQL Server.
• Expert-level T-SQL proficiency.
• 5+ years of experience with SSIS and Stored Procedures.
• 2+ years of experience with PowerBI.
• Strong expertise in data modeling, including conceptual, logical, and physical design for ODS, Enterprise Data Warehouses, and Data Marts.
• Experience with GitHub and CI/CD pipelines.
• Ability to mentor junior developers and lead technical enablement.
• Bachelor's degree in Computer Science, Information Sciences, Business, or Commerce.

Preferred Skills

• 1-2 years of experience with Azure Data Warehouse (Synapse).
• 1-2 years of experience with Azure Data Factory, SQL VMs, ETL, and Data Lake.

Key Skills

Education

Any Graduate