ETL Data Modeler with Security Clearance

ETL Developer / Data Modeler (Senior-Level)

Location: Washington, DC area (Hybrid; remote considered)

Clearance: Ability to obtain a Public Trust Overview

We are seeking a senior ETL Developer / Data Modeler to support enterprise data warehouse initiatives within a cloud-based analytics environment. This role will focus on integrating disparate data sources, improving data quality, and enhancing reporting and visualization capabilities.

The ideal candidate brings strong experience in data engineering, ETL development, and data modeling within large-scale environments. Key Responsibilities Develop and maintain ETL/ELT pipelines to support enterprise data warehouse solutions

Integrate multiple data sources into centralized data environments

Assess existing data sources and identify new data requirements and integration opportunities

Support end-to-end data lifecycle management, including ingestion, transformation, and reporting

Build and optimize data models for reporting, analytics, and visualization

Enhance data quality, accessibility, and reporting performance

Collaborate with stakeholders to understand business needs and translate them into data solutions

Promote adoption of data products and analytics capabilities Required Qualifications Strong experience with T-SQL development, including: Complex queries

Stored procedures

Views, indexing, and functions Experience developing ETL/ELT pipelines using tools such as: SQL Server Integration Services (SSIS)

Azure Data Factory Experience with data warehousing concepts and implementations

Experience with dimensional data modeling

Experience with reporting and visualization tools (e.g., SSRS or Power BI)

Experience working directly with stakeholders to: Gather requirements

Translate needs into data solutions and reporting outputs Experience with tabular models and DAX expressions Preferred Qualifications Experience with cloud data platforms and services

Experience with Azure-based data solutions, including data warehouse technologies

Experience developing semantic data models

Experience migrating legacy ETL solutions to modern cloud-based pipelines