2678 IT & Software Developer jobs in the US
Senior Data Warehouse Developer
$160,000 - 190,000
GovCIO
Legato Road 4000, Fairfax
$160,000 - 190,000
Requirements
Must:
- High School diploma with over 10 years of experience in application development (or equivalent experience)
- Active Secret clearance and ability to obtain and maintain DEA suitability
- Proficient in SQL and knowledgeable about Kimball dimensional modeling
- Strong skills in Python, including Pandas, SQLAlchemy, and module structure with unit testing
- Experience with PySpark or willing to quickly gain proficiency
- Familiarity with cloud-based data platforms such as Azure or AWS
- Prior experience in modernizing legacy ETL systems is a significant advantage
- Ability to read and redesign SSIS/SQL-based ETL processes
- Understanding of data ingestion, transformation, and structured warehouse architecture
- Experience with Git, CI/CD pipelines, and contemporary development practices
Responsibilities
- Absorb and comprehend the existing SQL Server structure modeled on Kimball principles over time
- Deconstruct SSIS packages and transition them into Python-based modular ETL pipelines
- Develop reusable Python frameworks for the processes of extraction, transformation, and loading
- Start integrating PySpark to facilitate scalable transformation patterns
- Assist in outlining a future migration strategy (Databricks, Azure Synapse, Snowflake, etc.)
- Enhance practices related to orchestration, dependency management, and data quality
- Identify areas of technical debt and modernize outdated ETL components
- Collaborate with Enterprise Data Warehouse Subject Matter Experts to grasp business logic and data lineage
- Create documentation and establish repeatable procedures for modernization
Description
At GovCIO, we are a dynamic team committed to transforming government IT. Each day, we strive to make a positive impact by delivering innovative IT services and solutions that enhance the operation of government agencies and their service to citizens. We recognize the need for exceptional talent to drive our mission forward, shaping the future of government IT and fostering a workplace that attracts and retains great individuals. Our fully onsite position is based in Merrifield, VA. We offer various employee benefits that foster your personal and professional growth, including an Employee Assistance Program, corporate discounts, development platforms, and flexible working conditions. Join us and be a part of a culture that prioritizes investment in its people.
Something wrong or incorrect with this job? Tell us in the chat 💬 on the right ➡️
You can find Data Engineer salaries in the United States here.
How many Data Engineer jobs are in the United States?
Currently, there are 2678 Data openings. Check also: Spark jobs, Snowflake jobs, Kafka jobs, Hadoop jobs - all with salary brackets.
Is the US a good place for Data Engineers?
The US is one of the best countries to work as a Data Engineer. It has a vibrant startup community, growing tech hubs and, most important: lots of interesting jobs for people who work in tech.
Which companies are hiring for Data Engineer jobs in the United States?
AMERICAN SYSTEMS, Trimlite, Menusifu, Inc., Concordia Group, Peraton, Active Datacomm, DreamPak among others, are currently hiring for Data roles in the United States.
The company with most openings is Lockheed Martin Corporation as they are hiring for 251 different Data Engineer jobs in the United States. They are probably quite committed to find good Data Engineers.
The company with most openings is Lockheed Martin Corporation as they are hiring for 251 different Data Engineer jobs in the United States. They are probably quite committed to find good Data Engineers.