Data Engineer III - SME

ADP, Inc.; Norfolk (VA); On-site; USD 175,000 - 185,000; Full time

Job summary

NCC is seeking a Senior Data Engineer to design, develop, and maintain scalable data pipelines, databases, analytics platforms, and reporting solutions that support operational and strategic decision-making.

The ideal candidate will bring deep PostgreSQL DBA expertise, SQL development, Python, Qlik Sense, data architecture, and ETL/ELT capabilities, with a focus on data governance, security, and performance. This is an on-site role based in Norfolk, VA requiring an active security clearance.

Qualifications

• Bachelor's degree in a related technical field.
• Active Secret clearance or higher.
• Minimum of 9 years of experience in data engineering, database administration, BI, or enterprise analytics environments.
• Strong PostgreSQL DBA experience including backup/recovery, security management, and performance tuning.
• Advanced SQL development including complex queries, stored procedures, views, indexing, and data transformation logic.
• Strong proficiency in Python development 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.
• Experience with Qlik Sense 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 QA best practices.
• Ability to troubleshoot and resolve data pipeline and reporting issues in production.
• Experience gathering 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 stakeholders.

Responsibilities

• Design, build, and maintain scalable data pipelines and automated ETL/ELT processes.
• Integrate and transform data from multiple structured and unstructured sources.
• Serve as the primary PostgreSQL DBA for installation, configuration, maintenance, security, backup/recovery, monitoring, and performance optimization.
• Develop, optimize, and maintain PostgreSQL databases, SQL queries, stored procedures, views, and indexes.
• Perform database performance tuning, capacity planning, and query optimization.
• Develop Python-based solutions for data ingestion, transformation, automation, validation, and reporting.
• Design and maintain enterprise data models and schemas for reporting and BI.
• Develop, administer, and support Qlik Sense dashboards, data models, and reporting solutions.
• Manage Qlik Sense data connections, reload schedules, security rules, and performance.
• Support Power BI, Tableau, Qlik Sense, and other enterprise reporting environments.
• Monitor data quality and troubleshoot inconsistencies; collaborate with stakeholders to gather requirements.
• Translate business needs into technical specs and actionable reporting capabilities.
• Implement data governance, security controls, and backup strategies for enterprise data management.
• Troubleshoot and resolve issues in data pipelines, databases, and reporting environments.
• Support production deployments and maintenance activities.
• Lead technical initiatives and mentor junior engineers and analysts.
• Document data architectures, data flows, ETL processes, and reporting procedures.

Skills

PostgreSQL DBA

SQL development

Python

Qlik Sense

Data modeling

ETL/ELT

Data governance

Data security

Performance tuning

Mentoring

Education

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

Tools

PostgreSQL

Python

ETL/ELT tooling

Qlik Sense

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time Norfolk, VA, Norfolk, VA, US

THIS IS AN ON-SITE POSITION

Position Overview

NCC is seeking a skilled Senior Data Engineer to support enterprise-level data initiatives within a fast-paced and mission-driven environment.This individual will be responsible for designing, developing, optimizing, and maintaining scalable data pipelines, databases, analytics platforms, and reporting solutions that support operational and strategic decision-making.

The ideal candidate brings deep expertise in PostgreSQL database administration, SQL development, Python programming, Qlik Sense development and administration, data architecture, and ETL/ELT processes. This role requires a proactive professional who can translate complex business requirements into efficient, scalable data solutions while ensuring data integrity, governance, security, and performance.

Essential Duties and Responsibilities

• Design, build, and maintain scalable data pipelines and automated ETL/ELT processes.
• Integrate and transform data from multiple structured and unstructured data sources.
• Serve as the primary PostgreSQL Database Administrator (DBA) responsible for database installation, configuration, maintenance, security, backup/recovery, monitoring, and performance optimization.
• Develop, optimize, and maintain PostgreSQL databases, SQL queries, stored procedures, views, indexes, and database objects.
• Perform database performance tuning, capacity planning, indexing strategies, query optimization, and troubleshooting.
• Develop and maintain Python-based solutions for data ingestion, transformation, automation, validation, and reporting processes.
• Design and maintain enterprise data models and schemas supporting operational reporting, analytics, and business intelligence 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 data 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 related to data pipelines, databases, Qlik Sense environments, and reporting failures.
• Support production deployments, system enhancements, upgrades, and ongoing maintenance activities.
• Lead technical initiatives and provide mentorship to 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 related to enterprise data environments.
• Other duties as assigned.
• Active Secret clearance or higher at the time of application.
• Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or related technical field.
• Minimum of 9 years of experience in data engineering, database administration, business intelligence, or enterprise analytics environments.
• Strong hands-on PostgreSQL DBA experience, including database administration, backup/recovery, performance tuning, security management, and system optimization.
• Advanced SQL development expertise, including complex queries, stored procedures, views, indexing strategies, query optimization, and data transformation logic.
• Strong proficiency in Python development 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.
• Experience with Qlik Sense 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 quality assurance best practices.
• Ability to troubleshoot and resolve database, data pipeline, reporting, and analytics platform issues in production environments.
• 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 with the ability to interact effectively with technical and non-technical stakeholders.

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

The compensation range listed for this position is provided as a good-faith estimate of what the company intends to offer for this role. Actual compensation may vary based on factors such as job responsibilities, education, experience, skills, internal equity, budget, market data, and relevant laws.

NCC provides reasonable accommodations to qualified individuals with disabilities. If you are an applicant that requires a reasonable accommodation, please email us. Please reference the position in your email.

NCC is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, ethnicity, ancestry, color, sex, religion, creed, age, national origin, citizenship status, disability, medical condition, military and veteran status, marital status, sexual orientation or perceived sexual orientation, gender, gender identity, and gender expression, familial status, political affiliation, genetic information, or any other legally protected status or characteristic. E-Verify Employer. VEVRAA Federal Contractor.