Sql Server Data Warehouse Developer

Tasks

• Build watermark incremental loading
• Collaborate with BI team on reporting needs
• Create dimensional models
• Create views for BI datasets
• Design and build data warehouse
• Design fact and dimension tables
• Design indexing and partitioning
• Develop stored procedures and functions
• Document data lineage and mapping
• Enforce data quality and reconciliation checks
• Implement MERGE and UPSERT loads
• Implement Medallion layered architecture
• Implement SCD Type 2 history tracking
• Maintain error logging tables
• Optimize SQL queries and stored procedures
• Write complex T-SQL queries

Perks/Benefits

• N/A

Skills/Tech-stack

Agile | Audit Columns | Common table expressions | Constraints | Data Quality | Data Quality Checks | Dimension tables | Error Handling | Fact tables | Foreign Key | Functions | Git | Incremental loading | Indexing | Materialized views | Medallion Architecture | Merge | Partitioning | Plan analysis | Power BI | Primary Key | Quality checks | Query Optimization | Query Plan | Query plan analysis | Reconciliation | SCD Type 1 | SCD Type-2 | SQL Server | SSAS Tabular | SSRS | Star Schema | Stored Procedures | T-SQL | Transaction management | Type 1 | Type 2) | Upsert | Views | Watermark Tables | Window Functions