Data Migration & Automation Developer

About Modular Solutions Founded in 2015, Modular Solutions delivers enterprise-grade technology to the insurance industry. Our configurable platform helps insurers, mutuals, MGAs, and brokers manage core operations through a single system designed for flexibility, long-term growth, and complex regulated environments. Position Summary Modular Solutions is seeking a Data Migration & Automation Developer to support client data migration, conversion, BI, and implementation projects. This developer-oriented role sits within our Data team and focuses on moving data from source platforms, files, spreadsheets, and custom systems into one clean target state in Modular’s platform. The ideal candidate is strong with SQL, ETL/ELT, BI, semantic models, scripting, data quality, and migration patterns. They should know how to clean, transform, validate, reconcile, and document data effectively while helping improve and extend our existing migration system. Strong AI capability is a core requirement. We are looking for someone who understands modern AI-assisted and agentic development workflows and can apply them responsibly to migration and BI work, including source analysis, semantic modeling, report/data-model review, mapping, scripting, validation, documentation, and automation. This role is well suited for someone who enjoys working with data, solving technical problems, identifying inconsistencies, and collaborating with both technical and business teams. Key Responsibilities - Support client data migration, conversion, BI, and implementation projects as a developer-oriented member of the Data team. - Extract, clean, transform, map, reconcile, and load data from multiple source platforms, spreadsheets, files, and custom systems into a single, consistent target model. - Analyze source data to identify gaps, inconsistencies, duplicates, missing relationships, formatting issues, and other data quality concerns. - Write and maintain SQL queries, scripts, migration utilities, data mapping documentation, conversion rules, validation logic, migration notes, and runbooks. - Improve and extend our existing migration system, including ETL/ELT patterns, conversion tools, templates, validation checks, semantic-model patterns, BI workflows, and quality-control processes. - Use AI-assisted and agentic development workflows to accelerate source analysis, semantic-model design, BI/reporting review, SQL/script generation, documentation, validation, and internal automation while maintaining strong human review. - Support test conversions, mock migrations, production migration activities, reporting, reconciliation, and post-migration validation against source systems, business requirements, and expected platform outcomes. - Collaborate with Data, Development, Product, Implementation, and business stakeholders to understand data requirements, clarify business rules, resolve defects or conversion gaps, and communicate progress, risks, and dependencies. Required Qualifications - A degree, diploma, or certificate in Computer Science, Data Science, Software Development, Information Systems, or a related field, or equivalent professional experience. - 3+ years of experience with data migration, data conversion, BI/reporting, semantic models, ETL/ELT, database development, data analysis, implementation projects, or software development. - Strong SQL skills and experience with PostgreSQL and analytical data platforms such as Snowflake. - Strong understanding of data cleansing, transformation, mapping, validation, reconciliation, and migration from many source platforms and data formats into a clean, reusable target state. - Experience using scripting or programming languages such as C#, Python, PowerShell, TypeScript, or similar tools to automate data, reporting, semantic-layer, or migration workflows. - Hands-on experience with BI tooling, semantic models, governed metrics, reusable reporting models, and reporting assets that can be reviewed, versioned, tested,…