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