Data Integration Specialist – Contract-to-Hire

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

📋 Description

• Conduct thorough data mapping and implement transformations to create a cohesive data model for a higher education product.

• Engage extensively with higher education system schemas and databases, primarily from educational technology platforms.

• Assess, prioritize, and analyze data columns from Student Information Systems (SIS) and Learning Management Systems (LMS) for integration into the comprehensive data model.

• Review and validate data mappings and transformations utilizing higher education data to guarantee accuracy and consistency.

• Participate in advanced data transformation processes, which include splitting or merging fields and applying filtering along with if-then logic.

• Assist in ensuring data quality through the use of dbt and Great Expectations.

• Collaborate with cross-functional team members and external stakeholders to comprehend data requirements and confirm that the final data model fulfills operational needs.

• Attend calls and video meetings as necessary.

⛳️ Requirements

• Strong alignment with DataKind's mission and values, alongside a demonstrated commitment to educational equity and data-driven social impact.

• Capability to convert data from one format to another, including identifying partial matches, lost meaning, and fields that need to be split or merged.

• Proficiency in crafting data dictionaries and mapping specifications, while tracking data lineage to ensure transformations are traceable and repeatable.

• Experience in data architecture and governance.

• Direct experience with higher education data schemas and databases, including SIS, LMS, and related ed-tech platforms.

• In-depth understanding of data transformations and quality assurance checks.

• Proven track record in reviewing and prioritizing data columns across various systems for integration.

• Familiarity with SQL and Python.

• Strong project and time management skills, including estimating task durations, monitoring deadlines, and communicating deliverables effectively.

• Knowledge of Agile methodologies (preferred).

• Ability to utilize Git for version control (preferred).

• Proficiency in Python and SQL (preferred).

• Experience with dbt and Great Expectations (preferred).

• Previous experience in higher education data environments or data integration firms (preferred).

• Applicants must possess a permanent address based in the U.S. and be authorized to work in the United States indefinitely without employer visa sponsorship.

🏝️ Benefits

• Shared time off.

• Organization-wide recharge days.

• Bi-weekly meeting-free days.

• Flexible PTO, with a minimum of 20 vacation days encouraged each year.

• 100% employer-paid medical, vision, and dental benefits for employees; 72% for dependents (benefits applicable only to full-time staff).

• Wellness reimbursement program (benefits applicable only to full-time staff).

• 12 weeks of paid parental leave (benefits applicable only to full-time staff).

• Annual funding for professional development (benefits applicable only to full-time staff).

• Mentorship and advancement opportunities (benefits applicable only to full-time staff).

• 401(k) plan with 5% employer matching (benefits applicable only to full-time staff).

• Opportunities for in-person gatherings for conferences, strategic planning, and the annual staff retreat.

• A diverse, equitable, and inclusive work environment.