Data Engineer III - SME

National Capitol Contracting LLC; Norfolk (VA); On-site; USD 175,000 - 185,000; Full time

Job summary

National Capitol Contracting LLC seeks a Senior Data Engineer to design, build, and sustain scalable data pipelines and analytics capabilities in an onsite Norfolk, VA role. You will own enterprise ETL/ELT, PostgreSQL DBA duties, and reporting support across Qlik Sense, Power BI, and Tableau.

You will collaborate with analysts and stakeholders to translate business needs into robust data solutions, ensure data quality, and oversee security and governance practices for enterprise reporting

Qualifications

• Active Secret clearance or higher at the time of application.
• Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or a related technical field.
• Minimum of 9 years of experience in data engineering, database administration, BI, or enterprise analytics.
• Hands-on PostgreSQL DBA experience, including administration, backup/recovery, performance tuning, security management, and optimization.
• Advanced SQL development experience and data transformation logic.

Responsibilities

• Design, build, and maintain scalable data pipelines and automated ETL/ELT processes.
• Integrate and transform data from multiple structured and unstructured sources.
• Act as the primary PostgreSQL DBA, covering installation, configuration, maintenance, security, and backup/recovery.
• Develop and maintain PostgreSQL databases, SQL queries, stored procedures, views, indexes, and related objects.
• Perform performance tuning and troubleshooting, including capacity planning and query optimization.
• Build and maintain Python-based solutions for ingestion, validation, and reporting processes.
• Create and maintain enterprise data models and schemas for reporting and BI initiatives.
• Develop, administer, and support Qlik Sense applications, dashboards, data models, and reporting.
• Manage Qlik Sense data connections, reload schedules, security rules, and application performance.
• Support and enhance Power BI, Tableau, Qlik Sense and other enterprise reporting environments.
• Monitor data quality, validate data integrity, and troubleshoot inconsistencies.
• Collaborate with stakeholders to gather requirements and deliver scalable solutions.

Skills

Python programming

SQL development

ETL/ELT

PostgreSQL DBA

Qlik Sense

Power BI

Tableau

Data modeling

Data governance

Mentoring

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or a related technical field

Tools

PostgreSQL

Qlik Sense

Power BI

Tableau

Job description

National Capitol Contracting LLC (NCC) is seeking a Senior Data Engineer to build and sustain scalable data pipelines and mission-supporting analytics capabilities. This onsite role in Norfolk, VA centers on enterprise ETL/ELT, PostgreSQL database administration, and support for reporting platforms including Qlik Sense and other BI tools, with an active Secret clearance required.

You will be responsible for designing data workflows, ensuring data quality and integrity, and maintaining the database and reporting environments that teams rely on for operational reporting, analytics, and business intelligence.

Key Responsibilities

• Design, build, and maintain scalable data pipelines and automated ETL/ELT processes.
• Integrate and transform data from multiple structured and unstructured sources.
• Act as the primary PostgreSQL DBA, covering installation, configuration, maintenance, security, and backup/recovery.
• Develop and maintain PostgreSQL databases, SQL queries, stored procedures, views, indexes, and related database objects.
• Perform performance tuning and troubleshooting, including capacity planning, indexing strategies, and query optimization.
• Build and maintain Python-based solutions for ingestion, transformation, automation, validation, and reporting processes.
• Create and maintain enterprise data models and schemas for operational reporting, analytics, and BI initiatives.
• Develop, administer, and support Qlik Sense applications, dashboards, data models, and reporting solutions.
• Manage Qlik Sense data connections, reload schedules, security rules, and application performance.
• Support and enhance Power BI, Tableau, Qlik Sense, and other enterprise reporting environments as needed.
• Monitor data quality, validate data integrity, and troubleshoot inconsistencies across systems.
• Collaborate with business stakeholders, analysts, and technical teams to gather requirements and deliver scalable solutions.
• Translate business needs into technical specifications and actionable reporting capabilities.
• Implement data governance standards, security controls, backup strategies, and best practices for enterprise data management.
• Troubleshoot and resolve issues across data pipelines, databases, Qlik Sense environments, and reporting failures.
• Support production deployments, system enhancements, upgrades, and ongoing maintenance activities.
• Lead technical initiatives and mentor junior engineers and analysts.
• Participate in project planning, prioritization, and continuous process improvement efforts.
• Document database architectures, data flows, ETL processes, system configurations, and reporting procedures.
• Ensure compliance with organizational, contractual, and security requirements for enterprise data environments.
• Other duties as assigned.

Requirements

• Active Secret clearance or higher at the time of application.
• Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or a related technical field.
• Minimum of 9 years of experience in data engineering, database administration, business intelligence, or enterprise analytics environments.
• Hands-on PostgreSQL DBA experience, including administration, backup/recovery, performance tuning, security management, and system optimization.
• Advanced SQL development experience, including complex queries, stored procedures, views, indexing strategies, query optimization, and data transformation logic.
• Strong Python proficiency for data engineering, automation, scripting, ETL processing, and data validation.
• Experience designing, developing, and maintaining ETL/ELT pipelines and automated data workflows.
• Hands-on experience developing and administering Qlik Sense dashboards, applications, and reporting solutions.
• Qlik Sense experience including data modeling, scripting, reload management, and security administration.
• Experience integrating data from multiple enterprise systems and data sources.
• Experience with relational database design, data modeling, and enterprise reporting architectures.
• Strong understanding of data governance, data validation, database security, and data quality assurance best practices.
• Ability to troubleshoot and resolve production issues across databases, data pipelines, reporting, and analytics platforms.
• Experience gathering business requirements and translating them into scalable technical solutions.
• Demonstrated ability to lead technical efforts, manage priorities, and mentor junior team members.
• Strong written and verbal communication skills for working with technical and non-technical stakeholders.

Technologies

• PostgreSQL, SQL, Python
• Qlik Sense
• Power BI, Tableau

Preferred Qualifications

• Experience with cloud-based data platforms and modern analytics architectures.
• Experience with Agile methodologies and DevOps/DataOps practices.
• Knowledge of enterprise data security, access management, and compliance processes.

Compensation

• $175,000 - $185,000 per year
• The compensation range is a good-faith estimate and may vary based on responsibilities, education, experience, skills, internal equity, budget, market data, and applicable laws.