Note: The job is a remote job and is open to candidates in USA. Mark43 is committed to empowering communities and their governments with innovative technologies. They are seeking a Data Migration Engineer to design and execute complex data migrations, ensuring that agencies can confidently adopt their systems. The role involves collaborating with internal teams and external partners to deliver high-quality data into Mark43 products.
Responsibilities
- Designed and executed a SQL-based ETL process to migrate decades of public safety data from a legacy system into the Mark43 platform
- Collaborated with our data migration contractors, reviewing technical deliverables and providing guidance to help them succeed
- Met with a customer’s records management team to understand their legacy data structure and translate it to the Mark43 schema
- Dug into a uniquely formatted source database to uncover edge cases and ensure data fidelity
- Worked alongside Mark43 deployment, engineering, and product teams to iterate on and improve our migration tooling and process
- Balanced project timelines and quality standards while maintaining strong relationships with both internal and external stakeholders
Skills
- 2+ years of experience in a data migration, ETL development, or SQL development role
- Deep understanding of SQL and relational database design
- Demonstrated experience writing complex SQL scripts
- Ability to analyze and translate legacy data models into new schemas
- Experience managing contractor deliverables is a plus
- Interest in public safety data and the impact of high-quality migrations on customer success
- Prior work with public safety or government systems is a bonus
Benefits
- Bonus opportunity
- Company stock options
- A full benefits package, including health insurance, paid time off, and a 401k with a company match
Company Overview