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.
The Sr Data Engineer will design and manage data systems, pipelines, and management tools. They will oversee junior data engineers, recommend and deploy data models, and lead projects involving data collection and storage systems. This role will design, build, document, test, and maintain critical data pipelines from large volumes of data from internal and external data sources cross different platforms.
PRIMARY RESPONSIBILITIES:
- Collaborate with data architect, analysts, and stakeholders to identify and document needs/requirements for data pipelines and process automation
- Design, build, document, test, and maintain data pipelines using industry best practices
- Performs ETL, ELT operations in accordance with enterprise data governance and security standards
- Develop data quality and governance process to ensure the accuracy and quality of the data through inspection, validation, processing, anomaly detection
KNOWLEDGE, SKILLS & ABILITIES:
- Detail oriented and proactive in taking measures to avoid or mitigate issues.
- Excellent understanding of computer systems, integrations, databases, and data storage systems.
- Understanding of agile data engineering concepts and processes
- Ability to capture and document business processes and requirements and work with colleagues to create functional requirements.
- Ability to work with clients to translate business needs to technical solutions
- Ability to provide guidance, mentoring, and training for peers
- Exceptional interpersonal skills and ability to effectively communicate with teams across the entire organization.
- Demonstrates the organization’s core values, exuding behavior that is aligned with the firm’s culture
- Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint, Outlook)
- Ability to learn any other appropriate program or software system used by the firm as necessary.
EDUCATION & EXPERIENCE:
- 5-7 years of relevant experience required
- BA/BS in relevant discipline required
- Vast experience with multiple development methodologies
- Experience of building large, complicated data pipelines cross different platforms, data sources, data structures
- Experience of working with relational databases such as SQL Server, Oracle, etc., and SQL scripting
- Experience with Power BI
- Experience of cloud platforms (like AWS, Azure, GCP) and its ETL tools and techniques of sourcing, maintaining, and updating data, data warehousing, data cleansing & transformation, etc.
- Programming experience in Python, Spark, and other similar languages
- Advanced programming knowledge and experience with large-scale processing engines are required, as well as a deeper understanding of database security and compliance tools.
- Travel to a nearby office for onboarding, training, and team collaboration as needed may be required.
#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
- 5-7 years of relevant experience
- BA/BS in a relevant discipline
- Experience with multiple development methodologies
- Experience building large, complex data pipelines across platforms, data sources, and data structures
- Experience with relational databases such as SQL Server and Oracle
- SQL scripting experience
- Experience with Power BI
- Experience with cloud platforms such as AWS, Azure, or GCP
- Experience with cloud ETL tools and data sourcing, maintenance, warehousing, cleansing, and transformation
- Programming experience in Python and Spark
- Advanced programming knowledge and experience with large-scale processing engines
- Understanding of database security and compliance tools
- Proficiency in Microsoft Office Suite
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
Similar Jobs
.png)
.png)
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℠.
