Data Engineer SME

Job Description

Job Description

Position Overview

NCC is seeking a skilled Data Engineer SME 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, data models, and reporting solutions that support operational and strategic decision-making.

The ideal candidate brings strong experience in data architecture, ETL/ELT development, analytics platforms, and cross-functional collaboration, along with the ability to lead technical initiatives and mentor junior team members. This role requires a proactive professional who can translate complex business requirements into efficient, scalable data solutions while ensuring data integrity, governance, and performance.

Key Areas of Responsibility

• Design, build, and maintain scalable data pipelines and automated ETL/ELT processes.
• Integrate and transform data from multiple structured and unstructured data sources.
• Develop, optimize, and maintain PostgreSQL databases, SQL queries, stored procedures, and database objects.
• Create and maintain data models and schemas to support enterprise reporting, analytics, and operational decision-making.
• Support and enhance Power BI, Tableau, or similar dashboard and reporting environments.
• Monitor data quality, validate data integrity, and troubleshoot inconsistencies across systems.
• Optimize PostgreSQL database performance, queries, and workflows to improve scalability and efficiency.
• Collaborate with business stakeholders, analysts, and technical teams to gather requirements and deliver data solutions.
• Translate business needs into technical specifications and actionable reporting capabilities.
• Implement data governance standards, security controls, and best practices for enterprise data management.
• Troubleshoot and resolve issues related to data pipelines, database performance, and reporting failures.
• Support production deployments, system enhancements, 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 data flows, system configurations, technical processes, and reporting procedures.
• Ensure compliance with organizational, contractual, and security requirements related to enterprise data environments.
• Other duties as assigned.

Minimum Requirements

• 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 12 years of experience in data engineering, database development, business intelligence, or enterprise analytics environments.
• Strong hands-on experience with PostgreSQL, including database management, query optimization, and performance tuning.
• Advanced SQL development experience, including complex queries, stored procedures, views, and data transformation logic.
• Experience designing, developing, and maintaining ETL/ELT pipelines and automated data workflows.
• Experience integrating data from multiple enterprise systems and data sources.
• Hands-on experience with Power BI, Tableau, or similar reporting and data visualization platforms.
• Proficiency in Python or other scripting languages used for automation and data processing.
• Experience with data modeling, relational databases, and enterprise reporting architectures.
• Strong understanding of data governance, data validation, security, and quality assurance best practices.
• Ability to troubleshoot and resolve data pipeline, database, and reporting 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:

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

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.