Senior ETL & Data Pipeline Engineer (Enterprise Data)

Tenacious Solutions; Washington (District of Columbia); On-site; USD 100,000 - 160,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401(k) with matching

3 weeks paid time off

Paid federal holidays

Parental leave

WellHub membership

Job summary

Tenacious Solutions, LLC is seeking skilled Database Engineers with strong ETL experience to design, implement and maintain enterprise-level data solutions in the DC Metropolitan area.

The ideal candidate has seven+ years designing and implementing ETL for large-scale analytics, with U.S. citizenship and ability to obtain Public Trust clearance. Strong data modeling, SQL, SDLC, and governance experience are expected.

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.
• Familiarity with scripting languages like Python or Java for ETL automation is a plus.
• 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.

Responsibilities

• Design, develop, and optimize ETL processes for large-scale data integration.
• Develop and maintain relational and dimensional data models to support business intelligence, reporting, and analytics.
• Work with complex data types, including JSON, XML, and other semi-structured formats.
• Transform raw data into structured datasets while preserving data integrity and quality.
• Collaborate with data architects, analysts, and application developers to define data requirements and ensure schema consistency.
• Implement best practices for data governance, data validation, and data quality monitoring.
• Troubleshoot performance issues in ETL pipelines and database operations.
• Document data models, transformation logic, and metadata for ongoing maintenance and knowledge sharing

Skills

SQL

Data modeling

Communication

Agile

Govt exposure

SDLC

Python

Code optimization

Education

B.S. in Computer Science or related field

Tools

Tableau

ArcGIS

PowerBI

Azure Development Framework

Job description

Tenacious Solutions, LLC is seeking skilled Database Engineers with strong ETL experience to design, implement and maintain enterprise-level data solutions in the DC Metropolitan area.

The ideal candidate has seven+ years designing and implementing ETL for large-scale analytics, with U.S. citizenship and ability to obtain Public Trust clearance. Strong data modeling, SQL, SDLC, and governance experience are expected.