Job Requirements
Remote Wash, DC
Public Trust Polygraph not specified
Career Level not specified
$125,000 - $160,000
Job Description
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
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
group id: kforcecx
We offer roles across all three clearance levels: Confidential, Secret and Top Secret. With a Top Secret Facilities clearance, a proven subcontractor track record and a deep understanding of agencies across Defense, Intelligence, Homeland, Justice and Federal Civilian Sectors, Kforce brings more than 20 years of experience to supporting critical missions at federal, state and local levels.
