Why MSI? We thrive on solving challenges. As a leading MGA, MSI combines deep underwriting expertise with insurer risk capacity to create specialized insurance solutions that empower distribution partners to meet customers’ unique needs. We have a passion for crafting solutions for the important risks facing individuals and businesses. We offer an expanding suite of products – from fully-digital embedded renters coverage to high-value homeowners insurance to sophisticated commercial coverages, such as cyber liability and habitational property – delivered through agents, brokers, wholesalers and other brand partners.
Our partners and customers count on us to deliver exceptional service through a dedicated team that makes rapid resolutions a priority. We simplify the insurance experience through our advanced technology platform that supports every phase of the policy lifecycle. Bring on your challenges and let us show you how we build insurance better.
Position Summary:
The Data Architect is responsible for the design of MSI enterprise data and data management within the MSI ecosystem. As a member of the Data Services team, you will partner with Solution Architects, DBA’s, Business Intelligence teams and our product and business leaders to design Lakehouses and Data Warehouses that support the continued expansion of our analytics needs. You will contribute to the development of our data strategy and implement a maintenance program focused on ensuring the ongoing alignment of our operating environment with the needs of our business.
Principal Responsibilities:
- Continuously evaluate the firm’s data architecture to ensure structures continue to meet its evolving requirements.
- Evaluate data requirements and demands aligning those needs with new system and product designs.
- Partner with key stakeholders (e.g., Business Intelligence, DBA’s, Solution Architect, Product, Operations) to design and implement contemporary data architectures to support data integration, advanced analytics, and data science capabilities.
- Optimize data lake, data warehouse, and data orchestration processes and practices.
- Develop enterprise data migration and integration philosophies and plans.
- Collaborate and aid in documenting conceptual and logical data models.
- Collaborate with the Business Intelligence on designs for semi-structured and unstructured data.
- Own and manage data migration/integration initiatives between business operational systems.
- Contribute to the design of data management processes and protocols.
- Assist with the definition of data security and backup processes and protocols.
- Optimize all data related functions.
Education, Experience, Skills and Abilities Requirements:
- Ten or more years in the data architecture and systems engineering arenas including ten years in a senior position, responsible for owning the corporate data security protocols.
- Deep technical expertise in database/dataset management with at least ten years managing data integrations across multiple platforms.
- Experience with cloud-based data architecture, databases, and orchestration tools required.
- Knowledge of Big Data technologies such as Spark / Hadoop.
- Experience with languages: PySpark, SparkSQL.
- Knowledge of semi structured and unstructured data architectures and schema on read techniques.
- Deep experience with MS Azure SQL databases
- Deep experience with MS Azure Environment, Microsoft Fabric, and services.
- Functional expertise with a major cloud-based database platform including developing and maintaining code.
- Experience analyzing current environments and developing and implementing plans to optimize both performance as well as the user experience.
- Experience managing enterprise data in multiple unique, and cloud-based environments.
- Detail oriented and proactive in taking measures to avoid or mitigate issues.
- Basic understanding of project management philosophies.
- Ability to make decisions with the best interest of the firm and end-users in mind.
- Ability to demonstrate the firm’s core values, exuding behavior that is aligned with the corporate culture.
- Bachelor’s degree in a technology related field required. Master’s degree preferred.
- Demonstrates the organization’s core values, exuding behavior that is aligned with the firm’s culture.
#LI-JW2
#LI-REMOTE
Click here for some insight into our culture!
The Baldwin Group will not accept unsolicited resumes from any source other than directly from a candidate who applies on our career site. Any unsolicited resumes sent to The Baldwin Group, including unsolicited resumes sent via any source from an Agency, will not be considered and are not subject to any fees for any placement resulting from the receipt of an unsolicited resume.
Skills Required
- Ten or more years of experience in data architecture and systems engineering
- Ten years in a senior position owning corporate data security protocols
- At least ten years managing data integrations across multiple platforms
- Experience with cloud-based data architecture, databases, and orchestration tools
- Knowledge of Big Data technologies such as Spark and Hadoop
- Experience with PySpark and SparkSQL
- Knowledge of semi-structured and unstructured data architectures and schema-on-read techniques
- Deep experience with Azure SQL databases
- Deep experience with Microsoft Azure environment and services
- Experience with Microsoft Fabric
- Functional expertise with a major cloud-based database platform, including developing and maintaining code
- Experience optimizing data environment performance and user experience
- Experience managing enterprise data across multiple cloud-based environments
- Basic understanding of project management philosophies
- Bachelor’s degree in a technology-related field
- Master’s degree
The Baldwin Group Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about The Baldwin Group and has not been reviewed or approved by The Baldwin Group.
-
Healthcare Strength — Health coverage includes flexible medical options, 24/7 telemedicine, mental health support, company‑paid life and disability, plus dental and vision. Feedback suggests these comprehensive offerings contribute meaningfully to total rewards.
-
Leave & Time Off Breadth — Time‑off programs span parental leave, paid holidays, paid sick days, and flexible PTO, with some teams citing unlimited PTO. Feedback suggests flexible PTO depth is a valued element of the package.
-
Equity Value & Accessibility — Equity grants are provided to all new hires. Feedback suggests broad‑based equity can enhance perceived fairness and long‑term value.
The Baldwin Group Insights
What We Do
BRP is now The Baldwin Group! We’ve updated our name to reflect our unified group of talented teams across the country. The Baldwin Group is a cohesive group of experts in business insurance, employee benefits, retirement planning, and all areas of private and personal insurance. Since our founding in 2011, we’ve evolved from a local business into a national firm with a vast network of specializations and industry practices for the benefit of our more than two million clients across the country. In addition, we have built excellent relationships with a wide range of insurance company partners. These relationships, coupled with our entrepreneurial and family-oriented culture, and deep expertise enable us to seamlessly deliver a breadth of innovative solutions to clients. At The Baldwin Group, we help provide the solutions our clients need to have confidence and gain peace of mind as they pursue what’s possible for themselves, their families, and their businesses. Whether they are renting their first apartment or buying a larger home, opening a small business or taking their company public, we offer solutions to support them on every step of their journey. This has been our story since the beginning—we provide the indispensable expertise and quality insights that give our clients peace of mind to pursue their purpose, passion, and dreams. And that’s what The Baldwin Group will continue to do for years to come: we Protect the Possible℠.
