SQL Data Engineer

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

• Bachelors 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.

Required Experience:

Senior IC