Job Description

About Modular Solutions

Founded in 2015, Modular Solutions delivers innovative technology to the insurance industry. Our modular, fully integrated platform enables insurers, mutuals, MGAs and brokers with programs with the ability to manage their entire operations seamlessly through a single software solution. Designed to be affordable and configurable, our platform empowers businesses to innovate, adapt and thrive in an evolving and competitive market.

Position Summary

We are seeking a Data Engineer to design, build, and scale data systems that fuel insights and innovation across our platform. This role combines expertise in data engineering, ensuring robust, reliable data pipelines and architecture, with data analytics capabilities to extract actionable insights and support business intelligence initiatives. You will collaborate with product, development, and business teams to enable smarter decision-making and unlock new opportunities for our clients.

Key Responsibilities

Continuously collaborate with the Development team to design and enhance scalable data infrastructure and pipelines. Develop conceptual and logical data models to support enterprise data marts and analytics initiatives. Build and maintain robust ETL processes and data warehouses optimized for reporting and business intelligence. Define and track KPIs, creating reports and dashboards that inform strategic decisions. Conduct ad-hoc reports and data requests across business units to support analysis of portfolio assessments. Apply data migration techniques to convert data from various legacy systems to the current platform. Prepare, cleanse, and transform data for statistical analysis and reporting. Use problem-solving skills to troubleshoot, validate, and resolve data issues. Deliver insights through interactive dashboards and visualizations using business intelligence reporting tools, with preference given to Power BI. Identify and resolve data inconsistencies, ensuring data integrity across systems. Stay up to date with emerging data technologies to continuously improve architecture and analytics capabilities. Use and learn all organizational technology systems as defined by Modular Solutions Inc. Perform other duties as required or requested to support data-driven initiatives.

Required Qualifications

A degree in Computer Science, Data Science, Engineering, Statistics, Mathematics, or a related field, or equivalent professional experience. Minimum of 3-5 years of hands-on experience in data engineering, data analytics, or related fields. Advanced knowledge of SQL languages such as T-SQL, Postgres SQL, and SnowSQL. Experience using Visual Studio, Visual Studio Code, and database management tools Basic understanding of cloud-hosted services such Azure SQL Database, Postgres, and Snowflake. Strong understanding of data warehousing concepts and ETL procedures (extract, transform, load). Proven success in data migrations, ensuring data integrity and minimal disruption. Experience developing interactive reports and dashboards in Power BI (or equivalent BI tools). Proficiency with the Microsoft Office suite for documentation and presentation. High level of attention to detail with strong organizational, prioritization, and time-management skills. Ability to follow directions while also taking initiative to drive projects forward. Creativity, resourcefulness, and problem-solving ability in dynamic environments.

Why Join Modular Solutions?

We're more than just a workplace - we're a supportive, growth-minded community. We are a fully remote company that still values real human connection. We collaborate virtually day-to-day and come together periodically for in-person team meetings and events. You'll be joining a passionate and knowledgeable team where you can be yourself, work on projects you're passionate about, and grow your career with colleagues who have your back no matter where you're located.



Some of the benefits and perks of working with us include:


Be part of a rapidly expanding company with a cutting-edge platform that's transforming how insurance is done. Work alongside a dedicated, passionate team of insurance and technology experts. Regular team building events and virtual/in-person meet-ups. Extended health, dental, and vision benefits to keep you and your family well. Access to an Employee and Family Assistance Program (EFAP) for wellness and personal support. Annual professional development allowance to support your learning and career growth. Extra time off is provided beyond the standard statutory holidays and vacation. Recognition and rewards for accomplishments and career milestones. Share Appreciation Rights program giving you a stake in the company's success. A team that values connection, both online and in-person, with a flexible, remote work environment.

To Apply:

Please submit your resume and a brief cover letter outlining your relevant experience and what excites you about this opportunity. We thank all applicants for their interest; only those selected for an interview will be contacted.