Description

Design and implement enterprise-wide data warehouse roadmaps and technical architectures. Advise executives on planning, development, and deployment strategies while collaborating with internal teams to produce ETL and report designs. Write clean, scalable T-SQL code, manage technical requirements gathering with stakeholders, test and deploy SSIS packages, and provide technical documentation for all data engineering workflows.

Responsibilities

• Design and implement enterprise-wide data warehouse roadmaps and technical architectures.
• Advise client executives on planning and implementing data warehouse design, development, and deployment.
• Collaborate with internal teams to produce ETL and report designs.
• Write clean, scalable T-SQL code and manage technical requirements gathering with stakeholders.
• Test and deploy SSIS packages and provide technical documentation for all data engineering workflows.

Required Skills

• 8-12 years of experience in data engineering and data warehousing.
• Extensive experience with SQL Server and writing high-quality T-SQL code.
• Proficiency in SSIS ETL and Azure Data Factory.
• Strong expertise in Data Modeling and Dimension Modeling.
• Deep understanding of Data Warehouse concepts.
• Experience working within Agile methodologies.
• Proven troubleshooting and communication skills.
• Bachelor's degree or equivalent experience.

Preferred Skills

• Experience with SSRS.
• Knowledge of Azure SSIS.

Key Skills

Education

Any Graduate