Description

You will design and implement data architectures within an on-premise MS SQL environment.

Responsibilities

• Define requirements and perform data mapping to build Data Marts on MS SQL.
• Manage data movement from ODS to data marts using SSIS, BCP, or similar technologies.
• Implement ETL and ELT processes to support data integration needs.
• Utilize Change Data Capture (CDC) methods to maintain data synchronization.

Required Skills

• 5+ years of experience in ETL architecture or data engineering.
• Advanced SQL Server experience and proficiency with SSIS for data integration.
• Hands-on experience with ETL and ELT patterns.
• Proven ability to implement Change Data Capture (CDC).
• Experience with data mapping and Data Mart construction.
• Knowledge of PowerBI.
• Domain knowledge in the Mortgage industry.
• Ability to work on all-on-premise equipment.

Preferred Skills

• Experience with SSAS.

Key Skills

Education

Any Graduate