Database Engineer (Pipeline)

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

Career Opportunities with Tenacious Solutions

A great place to work.

To work at Tenacious Solutions is to work in a fun, results driven, collaborative, engaging, innovative, and high energy environment with talented and bright colleagues who are passionate about our work, our clients, and our firm.

Working for a smaller company offers unique advantages such having the opportunity to shape our firm as we continue to grow. When we grow, you grow. You’ll have close interaction with company leadership with plenty of opportunities for recognition of the amazing work you’re doing. You can also diversify your skill set by participating in an array of different projects and exploring your talents. You will be challenged, and you will grow and learn a lot.

Current job opportunities are posted here as they become available.

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.

Anticipated salary range is $100,000 - $160,000. Individual pay is determined by factors including job-related skills, experience, clearance level, and relevant education or training.

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