Database Engineer (Pipeline)
On-siteWashington, District of Columbia, United States or Washington, United States
Job Summary
Design, develop, and optimize ETL processes for large-scale data integration while maintaining relational and dimensional data models for business intelligence and reporting. Transform raw data into structured datasets, working with JSON, XML, and semi-structured formats to preserve integrity. Collaborate with data architects and developers to define requirements, implement data governance, and troubleshoot performance issues in database operations. Document models and transformation logic for ongoing maintenance. Requires seven years of ETL experience, U.S. citizenship with Public Trust clearance, and expertise in SQL Server, Oracle, PostgreSQL, or MySQL. Apply to be considered for upcoming opportunities matching qualifications and business demand.
Required Qualifications
- BS degree in Computer Science or related field
- Previous experience working either in or with government environments
- At least seven years of experience designing, developing, testing, and implementing ETL solutions for enterprise-scale data analytics environments
- U.S. Citizenship with the ability to obtain a Public Trust clearance or higher
- Full understanding of Software Development Life Cycle
- Demonstrated expertise in developing data models and managing complex data structures such as JSON, XML, and semi-structured data to support reliable integration and advanced analytical processes
- Experience with database systems such as SQL Server, Oracle, PostgreSQL, or MySQL
- Knowledge of data warehousing concepts, star/snowflake schemas, and OLAP technology
- Experience with visualization and analytical technologies including Tableau, ArcGIS, PowerBI, and Azure Development Framework
- Strong SQL programming skills and performance tuning experience
- Hands-on experience with data modeling methodologies (conceptual, logical, physical models)
- Hands-on experience reviewing, optimizing, and restructuring software code to improve quality and efficiency
- Experience working within Agile development environments and frameworks
- Experience establishing policies and procedures for secure data management and backup operations
- Proven ability to communicate with program product owner, government leadership, customer, and team members to report statuses and blockers
- Excellent verbal and written communication skills
Desired Qualifications
- Familiarity with scripting languages like Python or Java for ETL automation is a plus
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.