Senior Microsoft SQL Server Data Warehouse Developer

Consulting Company

100% REMOTE

Needed ASAP

Contract to start with possibility to go perm

Preferred to work on W2

Job Title: Senior Microsoft SQL Server Data Warehouse Developer and Architect

Required Qualifications

Education and Experience

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• 7 years of experience in data warehouse development, ETL, and database architecture.
• 5 years of hands-on experience with Microsoft SQL Server.

Technical Skills

• Expertise in Microsoft SQL Server (versions 2016 and above).
• Proficiency in T-SQL development, stored procedures, and query optimization.
• Strong experience with SSIS for ETL development.
• Knowledge of dimensional data modeling and design (e.g., Kimball methodology).
• Experience with BI tools like SSRS, Power BI, or Tableau.
• Familiarity with Azure Data Factory, Azure SQL Database, or other cloud data platforms.
• Proficiency in scripting languages (e.g., Python, PowerShell) for data processing.

Soft Skills

• Strong problem-solving and analytical skills.
• Excellent communication and presentation abilities.
• Ability to lead projects and collaborate with cross-functional teams.
• Attention to detail and commitment to data quality.

Certifications (Preferred)

• Microsoft Certified: Azure Data Engineer Associate.
• Microsoft Certified: SQL Server Data Management and Analytics.

Data Warehousing or Business Intelligence certifications (e.g., Kimball).

Job Summary

We are seeking an experienced Senior Microsoft SQL Server Data Warehouse Developer and Architect to design, develop, and maintain our enterprise data warehouse solutions. This role requires expertise in data architecture, ETL processes, and performance optimization. You will collaborate with cross-functional teams to ensure data integrity, scalability, and alignment with business objectives.

Key Responsibilities

1. Data Warehouse Architecture and Development

• Design, develop, and maintain data warehouse solutions using Microsoft SQL Server.
• Define and implement data warehouse architecture, including data models, schemas, and pipelines.
• Develop and optimize ETL processes using SQL Server Integration Services (SSIS) or other ETL tools.

2. Data Modeling and Design

• Create and maintain logical and physical data models to support analytical reporting.
• Implement star and snowflake schemas for effective data organization.
• Ensure data warehouse design adheres to best practices for scalability and performance.

3. Data Integration and Transformation

• Integrate data from multiple sources, including on-premises and cloud systems.
• Develop and automate data pipelines to transform raw data into structured datasets.
• Implement data validation, cleansing, and enrichment processes.

4. Performance Optimization

• Analyze and improve the performance of the data warehouse environment.
• Optimize database queries, indexing strategies, and storage structures.
• Monitor and resolve performance issues related to ETL processes and reporting.

5. Collaboration and Stakeholder Engagement

• Collaborate with business analysts, data scientists, and other stakeholders to gather data requirements.
• Provide technical guidance and mentoring to junior developers and team members.
• Translate business needs into technical data solutions.

6. Maintenance and Governance

• Ensure data warehouse systems are secure, reliable, and compliant with organizational standards.
• Implement backup, recovery, and disaster recovery strategies for the data warehouse.
• Define and enforce data governance policies for quality, integrity, and security.