Description

You will own the development and maintenance of data integration routines and database objects.

Responsibilities

• Translate business requirements into data analysis and data mapping for data integration.
• Design, implement, and maintain database objects, including tables, views, and indexes.
• Optimize data warehouse performance by tuning batch processing and parallelization.
• Ensure data quality through creating audit controls, monitoring, and cleansing techniques.
• Coordinate deployments and manage scheduled data process integrity checks.

Required Skills

• 5+ years of experience in Data Warehousing and Business Intelligence.
• 3+ years of BI development experience leveraging Microsoft SQL Server.
• Expert level proficiency in T-SQL.
• 5+ years experience with SSIS and Stored Procedures.
• 2+ years experience ingesting and aggregating data using PowerBI.
• Strong understanding of data modeling (conceptual, logical, physical design).
• Deep understanding of relational database design concepts and SQL programming.
• Experience with Source Version Control software like GitHub and CICD pipelines.

Preferred Skills

• 1-2 years in Azure Data Warehouse (Synapse).
• 1-2 years in Azure Data Factory, SQL VMs, building and maintaining ETL and Data lakes.

Key Skills

Education

Any Graduate