Data Warehouse Developer

The Intersect Group

South Portland, ME(remote)

Apply

JOB DETAILS

SKILLS

Business Intelligence, Communication Skills, Data Management, Data Modeling, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Decision Support, Dimensional Modeling, Documentation Models, Electronic Medical Records, Enterprise Architecture, Healthcare, Medical Record System, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Operational Strategy, Patient Care, Power BI, Process Modeling, Query Optimization, Rural Contracts, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Service Delivery, Snowflake Schema, Star Schema, Tableau, Team Player

LOCATION

South Portland, ME

POSTED

7 days ago

Company Overview

Our client is a mission driven healthcare organization focused on delivering critical services and solutions that improve patient outcomes and operational effectiveness. The organization values innovation, collaboration, and the effective use of data to support informed decision making across the business. This is an opportunity to contribute to meaningful work while helping shape a modern data environment.

Role Summary

The Intersect Group is seeking a Data Warehouse Developer for a fully remote contract opportunity with a strong potential for permanent conversion. In this role, you will help build a new enterprise data warehouse environment in Azure that supports reporting, analytics, and business intelligence initiatives across the organization.

You will be responsible for designing scalable data models, developing data integration pipelines, and ensuring data quality and performance across multiple source systems. This position offers the opportunity to play a significant role in a high visibility initiative tied to a major EMR and EHR implementation effort.

Key Responsibilities

Design and develop enterprise data warehouse architecture
Build dimensional data models including fact and dimension tables
Create and maintain ETL and ELT data integration pipelines
Optimize SQL queries, indexing strategies, and database performance
Automate and monitor data loading and transformation processes
Validate data accuracy, integrity, and consistency across systems
Support Power BI reporting and analytics initiatives
Document data models, processes, and warehouse architecture

Key Requirements

3+ years of data warehouse development experience
Proven experience building a data warehouse from scratch
Advanced SQL and T SQL development skills
Experience with Microsoft SQL Server or comparable databases
Experience developing ETL pipelines using SSIS, Azure Data Factory, or similar tools
Expertise with dimensional modeling, star schemas, and snowflake schemas
Experience supporting Power BI, Tableau, or similar reporting platforms
Strong communication skills and ability to work closely with a small team

If you are interested in helping build a modern Azure based data warehouse while contributing to impactful healthcare initiatives, we encourage you to submit your resume and contact information for consideration.

About the Company

The Intersect Group

The Intersect Group is a different and better business partner. We create unparalleled value for our clients by combining industry-leading Consulting capabilities with comprehensive Staffing and recruitment services. Clients trust us to deliver results based on our deep expertise and proven resources within finance, accounting, and information technology. Through our flexible delivery approach, you get the right solution, at the right time to accelerate your success and achieve all of your mission-critical objectives.

COMPANY SIZE

500 to 999 employees

INDUSTRY

Staffing/Employment Agencies

FOUNDED

2006