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.