Key Responsibilities

• Develop data models (ERD, PK-FK), database objects (SPs, Functions, Views, Indexes), and write advanced SQL.
• Design and build data warehouse structures (facts/dimensions, CDC) and ETL processes using SSIS and Azure (ADLS, DataSets, Logic/Function Apps).
• Integrate data from diverse sources (files, APIs) and implement performance tuning strategies.
• Manage code using GitHub and create source-to-target mappings.
• (Senior) Lead architecture, complex tuning, and mentor team members.

Candidate Profile

Data & SQL: Data modeling, Advanced SQL (hints, optimization), warehousing (facts/dimensions, CDC).

Tools: SSIS (packages, data flows), Azure Data Services (ADLS, DataSets, Logic/Function Apps).

Engineering: Performance tuning, integrating various data sources (.csv, JSON, Parquet, APIs), version control (GitHub).

Nice to Have

MS Dynamics 365 integration experience.

Experience with modern cloud data warehouses (e.g., Synapse, Snowflake, BigQuery).

Levels

Software Engineer: 2-4 years of hands-on experience.

Senior Software Engineer: 5-8+ years with architecture and leadership experience.