Data Engineer

Posted 14hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Data Engineer building Microsoft Fabric pipelines and Ed-Fi integrations. Supporting Rackner’s mission-critical U.S. government and national security systems.

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 student information, HR/personnel, financial, logistics, IT service management, and operational systems
  • Develop ETL and ELT pipelines into the Microsoft Fabric Lakehouse
  • Build and maintain data integration pipelines, API connections, and automated synchronization processes
  • Develop Ed-Fi REST API integrations and Aspen-to-Ed-Fi mappings, descriptor customization, transformation logic, and synchronization
  • Perform source-system data profiling, mapping, cleansing, transformation, reconciliation testing, and validation
  • Troubleshoot and resolve data quality, pipeline, and integration issues
  • Develop SQL queries, Python or PySpark processing logic, and reusable transformation components
  • Support data population, migration, and Ed-Fi Data Management Service migration planning
  • Produce and maintain technical documentation
  • Collaborate with data architects, analysts, governance specialists, application teams, and source-system owners
  • Support knowledge transfer and operational transition activities

Requirements:

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

Benefits:

  • 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
  • Modern perks, including team events