Back to jobs
New

Data Engineer

Remote

Data Engineer

Location: Remote
Clearance Level: Active Secret

Overview

Rackner is seeking a Data Engineer to design, develop, and maintain data ingestion, transformation, integration, and data quality processes supporting modern cloud-based data platforms.

The Data Engineer will work primarily within the Microsoft Fabric environment, developing scalable data pipelines and implementing Bronze, Silver, and Gold medallion architecture layers across assigned data domains. This role will support the ingestion and transformation of data from student information systems, HR/personnel systems, financial systems, operational databases, and other enterprise data sources.

The Data Engineer will also support education data integration using the Ed-Fi Data Standard and REST APIs, including source-to-Ed-Fi mapping, descriptor customization, synchronization, validation, and future migration activities.

Responsibilities

  • Develop and maintain data ingestion pipelines, transformation logic, and data quality processes within Microsoft Fabric
  • Implement and maintain Bronze, Silver, and Gold medallion architecture layers for assigned data domains
  • Extract, transform, and load data from enterprise source systems, including:
    • Student information systems
    • HR and personnel systems
    • Financial systems
    • Logistics systems
    • IT service management platforms
    • Operational databases
  • Develop ETL and ELT pipelines that ingest source-system data into the Microsoft Fabric Lakehouse
  • Build and maintain data integration pipelines, API connections, and automated synchronization processes
  • Develop Ed-Fi REST API integrations supporting education data workstreams
  • Implement Aspen-to-Ed-Fi export mappings, descriptor customization, transformation logic, and API-based data synchronization
  • Develop non-education data ingestion pipelines supporting HR/DCPDS, finance, logistics, and IT service management domains
  • Perform source-system data profiling, mapping, cleansing, and transformation
  • Conduct reconciliation testing and validate data completeness, accuracy, and consistency across source and target systems
  • Identify, troubleshoot, and resolve data quality, pipeline, and integration issues
  • Develop SQL queries, Python or PySpark processing logic, and reusable data transformation components
  • Support data population and migration activities across cloud and enterprise data environments
  • Produce and maintain technical documentation for data pipelines, interfaces, mappings, transformation logic, and operational processes
  • Collaborate with data architects, analysts, governance specialists, application teams, and source-system owners to define and implement data integration requirements
  • Support Ed-Fi Data Management Service (DMS) migration planning as the DMS reaches production readiness
  • Support knowledge transfer and operational transition activities for implemented pipelines and data services

Qualifications

  • Experience developing data pipelines, ETL/ELT processes, and data integrations
  • Experience with Microsoft Fabric, Azure Data Factory, or comparable cloud data platforms
  • Strong SQL proficiency, including querying, transformation, validation, and troubleshooting
  • Experience with Python and/or PySpark for data engineering workloads
  • Experience working with structured and semi-structured enterprise data
  • Understanding of cloud-based data lake, lakehouse, or data warehouse architectures
  • Experience with data mapping, data profiling, reconciliation testing, and data quality processes
  • Experience integrating systems through REST APIs or similar application interfaces
  • Ability to document data flows, pipeline configurations, mappings, and technical processes
  • Strong troubleshooting, analytical, and communication skills
  • Active Secret clearance

Preferred Qualifications

  • Experience with Microsoft Fabric Lakehouse architecture
  • Experience implementing Bronze, Silver, and Gold medallion data architectures
  • Experience with the Ed-Fi Data Standard, Ed-Fi ODS/API, or Ed-Fi REST APIs
  • Experience performing Aspen-to-Ed-Fi mapping or integrating other student information systems with Ed-Fi
  • Experience with HR/DCPDS, financial, logistics, or IT service management data
  • Experience supporting large-scale cloud data migrations or modernization initiatives
  • Familiarity with data governance, metadata management, lineage, and enterprise data quality practices

About Rackner
Rackner is a software consultancy focused on building mission-critical systems for the U.S. government. Our teams work across cloud platforms, DevSecOps, AI/ML, distributed systems, and modern software engineering initiatives supporting federal agencies and national security missions. Rackner engineers and technical teams collaborate closely with leadership, program teams, and mission stakeholders to design, demonstrate, and improve software systems that address complex operational challenges.

 

Benefits & Perks
At Rackner, we believe that when our people grow, our company grows with them, and we are committed to supporting their growth, development and success. We are proud to offer a creative and forward-thinking environment that includes:
• Company-supported certifications aligned to current and future program work, 
including cloud, Kubernetes, DevSecOps, security, AI/ML, project management, and 
related technical areas
• Clear advancement tracks and future leadership opportunities
• 401(k) with 100% match up to 6%
• Comprehensive medical, dental, vision, life, and disability coverage
• Generous PTO and paid holidays
• Home-office equipment plan and remote work support
• Fitness and wellness reimbursement
• Weekly pay schedule and modern perks, including team events

 

Equal Opportunity
Rackner is an equal opportunity employer and considers all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or other protected characteristics.

Create a Job Alert

Interested in building your career at Rackner? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter*

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...
Select...
Select...
Select...
Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Rackner’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 07/31/2029

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.