Overview
Remote
On Site
Contract - W2
Contract - Independent
Skills
Advanced Analytics
Business Intelligence
ELT
Snow Flake Schema
Data Engineering
Scalability
Data Quality
Data Validation
Auditing
Collaboration
Specification Gathering
Workflow
Scripting
Dashboard
Microsoft SQL Server
Tableau
Computer Science
Information Systems
Data Warehouse
Microsoft BI
SQL
Transact-SQL
Performance Tuning
Microsoft SSIS
Extract
Transform
Load
Microsoft SSRS
Reporting
Analytics
SQL Azure
Databricks
Data Modeling
Meta-data Management
DevOps
Continuous Integration
Continuous Delivery
Pipeline Management
Data Lake
Storage
Agile
Microsoft
Data Governance
Microsoft Azure
Job Details
Description
We are looking for a Senior Data Warehouse Developer with deep expertise in the Microsoft Data Platform, including SSIS, SSRS, Azure Synapse Analytics, and Azure Databricks. This role will design, build, and maintain scalable data warehouse solutions to enable advanced analytics, reporting, and business intelligence across the organization. You'll collaborate with cross-functional teams to ensure data quality, performance, and security within our On-Prem and Azure-based data ecosystem.
________________________________________
Key Responsibilities
Design, develop, and maintain enterprise data warehouse solutions using Azure Synapse Analytics and SQL Server.
Develop ETL/ELT pipelines using SQL Server Integration Services (SSIS) and Azure Data Factory to extract, transform, and load data from diverse sources.
Design and implement data models (star/snowflake schemas, fact/dimension tables) optimized for analytics and reporting.
Leverage Azure Databricks for data transformation, cleansing, and advanced data engineering workloads.
Optimize performance of queries, ETL jobs, and data models to ensure efficiency and scalability.
Ensure data quality, governance, and security by applying best practices in data validation, auditing, and lineage tracking.
Collaborate with business analysts and stakeholders to translate business requirements into technical specifications.
Automate workflows and deployment processes using CI/CD pipelines, Azure DevOps, and scripting.
Develop and maintain reports and dashboards using SQL Server Reporting Services (SSRS) and Tableau.
Stay current with Azure data services, tools, and best practices to continuously enhance the data platform.
________________________________________
Qualifications
Required:
Bachelor's degree in Computer Science, Information Systems, or related field.
5+ years of experience in data warehouse development within the Microsoft BI stack.
Strong proficiency in SQL (T-SQL) and performance tuning.
Hands-on experience with SSIS for ETL development and SSRS for reporting.
Expertise with Azure Synapse Analytics, Azure Data Factory, and Azure SQL Database.
Experience with Azure Databricks for data transformation and integration with Synapse.
Strong understanding of data modeling, dimensional design, and metadata management.
Familiarity with Azure DevOps for CI/CD pipeline management. Familiarity with Azure Data Lake Storage (ADLS) and Delta Lake.
Understanding of Agile development methodologies.
Plus:
Microsoft certifications (e.g., Azure Data Engineer Associate) are a plus.
Knowledge of data governance and security best practices in Azure environments.
________________________________________
Soft Skills
Strong analytical and problem-solving skills.
Excellent communication and collaboration abilities across teams.
Attention to detail and commitment to high-quality deliverables.
Ability to work independently and mentor junior developers.
Continuous learning mindset with a passion for innovation.
Requirements
Data Warehousing, SSIS ETL, ETL - Extract Transform Load, T-SQL - Transact-SQL, Microsoft SQL Server, Microsoft SSRS, Azure Synapse Analytics, Azure Data Factory, Azure Databricks
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.
We are looking for a Senior Data Warehouse Developer with deep expertise in the Microsoft Data Platform, including SSIS, SSRS, Azure Synapse Analytics, and Azure Databricks. This role will design, build, and maintain scalable data warehouse solutions to enable advanced analytics, reporting, and business intelligence across the organization. You'll collaborate with cross-functional teams to ensure data quality, performance, and security within our On-Prem and Azure-based data ecosystem.
________________________________________
Key Responsibilities
Design, develop, and maintain enterprise data warehouse solutions using Azure Synapse Analytics and SQL Server.
Develop ETL/ELT pipelines using SQL Server Integration Services (SSIS) and Azure Data Factory to extract, transform, and load data from diverse sources.
Design and implement data models (star/snowflake schemas, fact/dimension tables) optimized for analytics and reporting.
Leverage Azure Databricks for data transformation, cleansing, and advanced data engineering workloads.
Optimize performance of queries, ETL jobs, and data models to ensure efficiency and scalability.
Ensure data quality, governance, and security by applying best practices in data validation, auditing, and lineage tracking.
Collaborate with business analysts and stakeholders to translate business requirements into technical specifications.
Automate workflows and deployment processes using CI/CD pipelines, Azure DevOps, and scripting.
Develop and maintain reports and dashboards using SQL Server Reporting Services (SSRS) and Tableau.
Stay current with Azure data services, tools, and best practices to continuously enhance the data platform.
________________________________________
Qualifications
Required:
Bachelor's degree in Computer Science, Information Systems, or related field.
5+ years of experience in data warehouse development within the Microsoft BI stack.
Strong proficiency in SQL (T-SQL) and performance tuning.
Hands-on experience with SSIS for ETL development and SSRS for reporting.
Expertise with Azure Synapse Analytics, Azure Data Factory, and Azure SQL Database.
Experience with Azure Databricks for data transformation and integration with Synapse.
Strong understanding of data modeling, dimensional design, and metadata management.
Familiarity with Azure DevOps for CI/CD pipeline management. Familiarity with Azure Data Lake Storage (ADLS) and Delta Lake.
Understanding of Agile development methodologies.
Plus:
Microsoft certifications (e.g., Azure Data Engineer Associate) are a plus.
Knowledge of data governance and security best practices in Azure environments.
________________________________________
Soft Skills
Strong analytical and problem-solving skills.
Excellent communication and collaboration abilities across teams.
Attention to detail and commitment to high-quality deliverables.
Ability to work independently and mentor junior developers.
Continuous learning mindset with a passion for innovation.
Requirements
Data Warehousing, SSIS ETL, ETL - Extract Transform Load, T-SQL - Transact-SQL, Microsoft SQL Server, Microsoft SSRS, Azure Synapse Analytics, Azure Data Factory, Azure Databricks
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.