Database Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, construct, and maintain enriched datasets utilizing the medallion architecture (bronze, silver, gold layers) within Databricks.

• Develop, orchestrate, and oversee Databricks jobs and pipelines.

• Write efficient and well-structured SQL for transforming and modeling healthcare data.

• Prepare and optimize gold-layer datasets for integration with Power BI semantic models.

• Manage code and version control through GitHub, adhering to team branching and review practices.

• Log, track, and update work items using JIRA.

• Collaborate directly with clients and stakeholders to gather requirements, clarify data definitions, and validate outputs.

• Troubleshoot data quality issues to ensure accuracy and consistency across pipelines.

• Craft ad hoc queries to support client requests, investigations, and one-off analyses.

• Conduct data validation and quality assurance checks on pipelines and enriched datasets.

• Document data lineage, transformation logic, and business rules for enriched datasets.

• Work alongside Power BI developers and data scientists to ensure datasets fulfill downstream reporting and analytical requirements.

• Assist multiple offices and programs within the Department of Veterans Affairs by creating enriched, analytics-ready datasets for clinical and operational decision-making in the Veterans Health Administration.

⛳️ Requirements

• Bachelor's degree and 12+ years of experience (or equivalent experience).

• Hands-on experience in building data pipelines and transformations using Databricks (PySpark and/or SQL).

• Proficient SQL skills, including complex joins, aggregations, and performance tuning.

• Experience with Power BI, particularly in preparing data for semantic models.

• Familiarity with GitHub for version control and collaborative development.

• Experience utilizing JIRA or similar tools for work tracking and management.

• Excellent communication skills and the ability to work directly with clients/stakeholders.

• Understanding of medallion (bronze/silver/gold) data architecture principles.

• Prior experience within the VA or VHA is preferred.

• In-depth knowledge of the VA Corporate Data Warehouse (CDW) is preferred.

• Familiarity with VistA/CPRS is preferred.

• Familiarity with the Federal EHR (Oracle Health) is preferred.

• Experience in healthcare data domains is preferred.

• Ability to independently tackle complex data problems, communicate effectively with non-technical clients, and take ownership of datasets from raw sources to polished, analytics-ready products.

• Experience in healthcare and federal data is a significant advantage.

🏝️ Benefits

• Competitive salary and comprehensive benefits package.

• Opportunities for professional development and career advancement.

• Collaborative and supportive work environment.

• Flexible work arrangements to promote work-life balance.