Database Engineer (Pipeline)

Tenacious Solutions, LLC; Washington (District of Columbia); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

health insurance

dental insurance

vision insurance

401(k) program with matching

3 weeks paid time off

paid federal holidays

employee referral bonuses

parental leave

tuition reimbursement

masterclass subscription

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.

We are building a network of qualified candidates to help meet current and future openings. U.S. Citizenship is required with the ability to obtain a U.S. Clearance.

Qualifications

• BS degree in Computer Science or related field.
• At least seven years of ETL design, development, testing and implementation for enterprise analytics environments.
• US Citizenship with the ability to obtain a Public Trust clearance or higher.
• Experience with government environments is preferred.
• Strong SQL programming skills and performance tuning experience.
• Familiarity with JSON/XML and semi-structured data for data integration.

Responsibilities

• Design, develop, and optimize ETL processes for large-scale data integration.
• Develop and maintain relational and dimensional data models for BI, reporting, and analytics.
• Work with JSON, XML, and semi-structured data formats.
• Transform raw data into structured datasets ensuring data integrity and quality.
• Collaborate with data architects, analysts, and developers to define data requirements and ensure schema consistency.
• Implement data governance, data validation, and data quality monitoring best practices.
• Troubleshoot ETL pipeline and database performance issues.
• Document data models, transformation logic, and metadata for maintenance.

Skills

ETL design

Data modeling

SQL development

Agile

Data governance

Communication

JSON/XML processing

Python/Java scripting

Education

BS degree in Computer Science or related field

Tools

SQL Server

Oracle

PostgreSQL

MySQL

Tableau

PowerBI

ArcGIS

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.

We are building a network of qualified candidates to help meet current and future openings. Although this posting may not result in an immediate hire, applicants will be considered for upcoming opportunities that match their qualifications and business demand.

• U.S. Citizenship is required with the ability to obtain a U.S. Clearance

Primary Job Duties And 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

The Ideal Candidates Will Have

• 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.

About Tenacious Solutions, LLC

Tenacious Solutions, LLC is a small business interested in taking on the toughest challenges and producing long-lasting, quality results. Our goal is to support federal clients by providing top-notch quality professionals. We Have a Strong Belief That Our Employees Are Our Greatest Asset, And We Treat Them As Such. In Addition To Offering a Competitive Salary We Also Offer

• health insurance
• dental insurance
• vision insurance
• 401(k) program with matching
• 3 weeks paid time off
• paid federal holidays
• employee referral bonuses
• parental leave
• tuition reimbursement
• masterclass subscription
• wellhub membership

Tenacious Solutions, LLC is an Equal Opportunity Employer, and we value workplace diversity. We invite resumes from all interested parties and consider applicants for all positions without regard to race, color, religion, sex, national origin, age, marital status, sexual preference, personal appearance, family responsibility, the presence of a non-job-related medical condition or physical disability, political affiliation, veteran status, or any other legally protected status.