The Role
Design, develop, optimize, and troubleshoot scalable data pipelines, models, and analytics datasets using SQL and Databricks. Integrate diverse data sources, implement testing and quality controls, translate SQL across platforms, and support secure, high-performing solutions. Collaborate with engineers, analysts, developers, scientists, and stakeholders while communicating risks and recommendations. The role requires extensive SQL experience, Databricks expertise, Python, data modeling, warehousing, and federal Public Trust eligibility.
Summary Generated by Built In
Parra Consulting Group (PCG) is seeking a SQL Data Engineer to support federal health programs, regulatory science, and other high-impact missions. This position designs, develops, and optimizes scalable data solutions using advanced SQL and Databricks to deliver reliable insights that support mission-critical decisions.
This successful candidate will be responsible for the following:
- Design, develop, and optimize scalable data pipelines, data models, and analytics-ready datasets using advanced SQL and Databricks.
- Develop, tune, and troubleshoot complex SQL solutions, including queries, stored procedures, views, and functions, across Oracle SQL, PostgreSQL, and Databricks SQL.
- Integrate data from databases, cloud data platforms, APIs, JSON, XML, and flat files.
- Implement automated testing, data validation, data reconciliation, and data-quality processes.
- Translate solutions across different SQL dialects and database environments.
- Collaborate with data engineers, analysts, software developers, data scientists, and client stakeholders to deliver secure, high-performing solutions.
- Communicate technical concepts to technical and non-technical audiences, and raise questions, risks, and recommended actions to management early.
Required Qualifications
- Bachelor’s degree in Computer Science, Data Science, Engineering, Statistics, Biostatistics, or Mathematics.
- 5+ years of experience developing, optimizing, and troubleshooting complex SQL solutions.
- Ability to obtain and maintain a Public Trust or Suitability/Fitness determination based on client requirements.
- S. citizenship required to support this federal contract.
Required Experience
- Experience developing, optimizing, and troubleshooting complex SQL solutions, including queries, stored procedures, views, functions, and data transformations, in Oracle SQL, PostgreSQL, and Databricks SQL.
- 2+ years of experience with Databricks, including Databricks Workspace, notebooks, jobs, workflows, Apache Spark, Delta Lake, and cluster configuration.
- Experience with relational databases, data modeling, dimensional modeling, data warehousing, and designing and implementing medallion architecture patterns.
- Experience integrating data from databases, cloud data platforms, APIs, JSON, XML, and flat files.
- Experience developing data engineering solutions in Python and managing code through Git or comparable source-control tools.
- Experience implementing automated testing, data validation, data reconciliation, and data-quality processes.
- Ability to work independently in an Agile, collaborative, and client-focused environment and troubleshoot complex issues.
Preferred Qualifications
- Experience with advanced Databricks capabilities, including Delta Live Tables, Workflows, and Unity Catalog.
- Experience developing and optimizing ETL and ELT transformation workflows supporting reporting, analytics, or operational systems.
- Experience with Pentaho or equivalent data integration and ETL tools.
- Experience implementing CI/CD pipelines, automated deployments, and software development practices for data solutions.
- Experience applying AI-enabled tools or techniques to improve data engineering workflows, pipeline performance, or developer productivity.
- Experience with data governance, metadata management, data lineage, privacy, security, and access controls.
- Experience supporting federal health data systems, regulatory science, or other regulated data environments.
- Databricks, AWS Cloud, or data engineering technical certification.
Skills Required
- Bachelor's degree in Computer Science, Data Science, Engineering, Statistics, Biostatistics, or Mathematics
- 5+ years of experience developing, optimizing, and troubleshooting complex SQL solutions
- Ability to obtain and maintain a Public Trust or Suitability/Fitness determination
- U.S. citizenship
- Experience with Oracle SQL, PostgreSQL, and Databricks SQL, including queries, stored procedures, views, functions, and data transformations
- 2+ years of experience with Databricks, including Workspace, notebooks, jobs, workflows, Apache Spark, Delta Lake, and cluster configuration
- Experience with relational databases, data modeling, dimensional modeling, data warehousing, and medallion architecture
- Experience integrating databases, cloud data platforms, APIs, JSON, XML, and flat files
- Experience developing data engineering solutions in Python and using Git or comparable source-control tools
- Experience implementing automated testing, data validation, data reconciliation, and data-quality processes
- Ability to work independently in an Agile, collaborative, and client-focused environment
- Experience with advanced Databricks capabilities, including Delta Live Tables, Workflows, and Unity Catalog
- Experience developing and optimizing ETL and ELT transformation workflows
- Experience with Pentaho or equivalent data integration and ETL tools
- Experience implementing CI/CD pipelines, automated deployments, and software development practices for data solutions
- Experience applying AI-enabled tools or techniques to data engineering workflows
- Experience with data governance, metadata management, data lineage, privacy, security, and access controls
- Experience supporting federal health data systems, regulatory science, or regulated data environments
- Databricks, AWS Cloud, or data engineering technical certification
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Parra Consulting Group is a service-disabled veteran-owned federal contractor providing subject-matter expertise to the Warfighter, Intelligence Community, and government agencies. It helps customers bridge program strategy and mission success by supporting complex programs with technology-focused solutions. Its capabilities span emerging-technology integration, mission and technical support, administrative and human-resources services, cyberspace operations, engineering and intelligence support, and technical advisory services for national security missions.
