DOC - Data Warehouse/BI Developer 3

Key Responsibilities

• Data profiling — Analyze and understand source systems to determine data availability, quality, and extraction logic.
• Data modeling — Design dimensional models and star schemas to support analytics and reporting needs.
• Data flow design — Produce clear, detailed mapping documents that translate business rules into technical specifications.
• SQL Server data mart development — Build and optimize tables, views, stored procedures, and indexes.
• Visual Studio database projects — Create and maintain database projects for versioned, repeatable deployments.
• GIT source control — Manage code changes, branching, and collaboration workflows.
• SSIS ETL development — Build, schedule, and monitor ETL packages to load data marts reliably and efficiently.
• Data validation testing — Ensure accuracy, completeness, and alignment with business rules.
• Dashboard/report creation (nice-to-have) — Build basic dashboards or visualizations using tools such as Power BI or Tableau.