Database Engineer (Remote)

GovCIO; City of Albany (NY); Remote; USD 130,000 - 160,000; Full time

Benefits offered by this job

Employee Assistance Program (EAP)

Corporate Discounts

Learning & Development platform

Certification Assistance

Referral Bonus Program

Internal Mobility Program

Pet Insurance

Flexible Work Environment

Job summary

GovCIO is hiring a Data Engineer to design and build enriched datasets using medallion architecture in Databricks, sourcing data from VA CDW and internal systems. You will feed Power BI semantic models and work directly with clients to gather requirements, track work in JIRA, and deliver robust data pipelines.

Ideal candidates have 12+ years of data engineering experience, strong SQL, Databricks, and Power BI skills, with effective communication for stakeholder collaboration in a fully remote

Qualifications

• Bachelor's degree and 12+ years of experience or commensurate experience
• Hands-on experience building data pipelines in Databricks (PySpark and/or SQL)
• Strong SQL skills including complex joins, aggregations, and tuning
• Experience with Power BI and preparing data for semantic models
• Familiarity with GitHub for version control and collaboration
• Experience using JIRA to track work
• Strong communication skills with clients/stakeholders
• Understanding of medallion (bronze/silver/gold) data architecture principles

Responsibilities

• Design, build, and maintain enriched datasets following medallion architecture in Databricks
• Develop, orchestrate, and monitor Databricks jobs and pipelines
• Write efficient, well-structured SQL to transform and model healthcare data
• Prepare and optimize gold-layer datasets for Power BI semantic models
• Manage code and version control through GitHub with standard branching/review practices
• Log, track, and update work items in JIRA
• Collaborate with clients to understand requirements and validate outputs
• Troubleshoot data quality issues and ensure accuracy across pipelines
• Document data lineage, transformation logic, and business rules
• Collaborate with Power BI developers and data scientists to meet downstream needs

Skills

PySpark

SQL

Power BI

Databricks

GitHub

JIRA

Client communication

Medallion architecture

Education

Bachelor's degree

Tools

Databricks

Power BI

GitHub

JIRA

Job description

United States

Suitability/Public Trust

Fully remote

IT Infrastructure & Network Engineering & Operations

Overview

GovCIO is currently hiring for Data Engineer to design and build enriched datasets using medallion architecture (bronze/silver/gold) in Databricks, sourcing data from the VA Corporate Data Warehouse (CDW) and other internal and external systems. The datasets you build will feed directly into Power BI semantic models used by stakeholders across the organization. This role works closely with clients to gather requirements, track work in JIRA, and deliver high-quality, well-documented data pipelines. This is a fully remote position.

Responsibilities

Our Data Engineering team supports multiple offices and programs across the Department of Veterans Affairs by building enriched, analytics-ready datasets that power clinical and operational decision-making across the Veterans Health Administration (VHA). We work at the intersection of enterprise data warehousing and modern cloud analytics, turning complex healthcare data into reliable, reusable data products.

What You'll Do

• Design, build, and maintain enriched datasets following medallion architecture (bronze, silver, gold layers) in Databricks
• Develop, orchestrate, and monitor Databricks jobs and pipelines
• Write efficient, well-structured SQL to transform and model healthcare data
• Prepare and optimize gold-layer datasets for consumption by Power BI semantic models
• Manage code and version control through GitHub, following team branching and review practices
• Log, track, and update work items in JIRA
• Partner directly with clients and stakeholders to understand requirements, clarify data definitions, and validate outputs
• Troubleshoot data quality issues and ensure accuracy and consistency across pipelines
• Write ad hoc queries to support client requests, investigations, and one-off analyses
• Perform data validation and quality assurance checks on pipelines and enriched datasets to ensure accuracy, completeness, and consistency
• Document data lineage, transformation logic, and business rules for enriched datasets
• Collaborate with Power BI developers and data scientists on the broader team to ensure datasets meet downstream reporting and analytical needs

Qualifications

Required Skills and Experience

• Bachelors degree and 12+ yrs of experience (or commensurate experience)
• Hands-on experience building data pipelines and transformations in Databricks (PySpark and/or SQL)
• Strong SQL skills, including complex joins, aggregations, and performance tuning
• Experience working with Power BI, including preparing data for semantic models
• Familiarity with GitHub for version control and collaborative development
• Experience using JIRA or similar tools to track and manage work
• Strong communication skills and comfort working directly with clients/stakeholders
• Understanding of medallion (bronze/silver/gold) data architecture principles

Preferred Skills and Experience

• Prior experience working within the VA or VHA
• Deep understanding of the VA Corporate Data Warehouse (CDW)
• Familiarity with VistA/CPRS
• Familiarity with the Federal EHR (Oracle Health)
• Experience with healthcare data domains (e.g., appointments, consults/referrals, orders, TIU notes, visits)

What We’re Looking For

Someone who can work independently on complex data problems, communicate clearly with non-technical clients, and take ownership of datasets from raw source through to a polished, analytics-ready product. Healthcare and federal data experience is a strong plus given the sensitivity and complexity of the data we work with.

Posted Salary Range

USD $130,000.00 - USD $160,000.00 /Yr.

Company Overview

GovCIO is a team of transformers--people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens.

But we can’t do it alone. We need great people to help us do great things - for our customers, our culture, and our ability to attract other great people. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer?

What You Can Expect

Interview & Hiring Process

If you are selected to move forward through the process, here’s what you can expect:

• During the Interview Process
• Virtual video interview conducted via video with the hiring manager and/or team
• Camera must be on
• A valid photo ID must be presented during each interview
• During the Hiring Process
• Enhanced Biometrics ID verification screening
• Background check, to include:
• Criminal history (past 7 years)
• Verification of your highest level of education
• Verification of your employment history (past 7 years), based on information provided in your application

Employee Perks

At GovCIO, we consistently hear that meaningful work and a collaborative team environment are two of the top reasons our employees enjoy working here. In addition, our employees have access to a range of perks and benefits to support their personal and professional well-being, beyond the standard company offered health benefits, including:

• Employee Assistance Program (EAP)
• Corporate Discounts
• Learning & Development platform, to include certification preparation content
• Training, Education and Certification Assistance*
• Referral Bonus Program
• Internal Mobility Program
• Pet Insurance
• Flexible Work Environment

*Available to full-time employees

Our employees’ unique talents and contributions are the driving force behind our success in supporting our customers, which ultimately fuels the success of our company. Join us and be a part of a culture that invests in its people and prioritizes continuous enhancement of the employee experience.

We are an Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or status as a protected veteran. EOE, including disability/vets.

Posted Pay Range

The posted pay range, if referenced, reflects the range expected for this position at the commencement of employment, however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, education, experience, and internal equity. The total compensation package for this position may also include other compensation elements, to be discussed during the hiring process. If hired, employee will be in an “at-will position” and the GovCIO reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, GovCIO or individual department/team performance, and market factors.