About the role
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.
Originally posted on Himalayas