Lead Data Architect

About Acrisure

A global fintech leader, Acrisure empowers millions of ambitious businesses and individuals with the right solutions to grow boldly forward. Bringing cutting-edge technology and top-tier human support together, we connect clients with customized solutions across a range of insurance, reinsurance, payroll, benefits, cybersecurity, mortgage services – and more.

In the last eleven years, Acrisure has grown in revenue from $38 million to almost $5 billion and employs over 19,000 colleagues in more than 20 countries. Our culture is defined by our entrepreneurial spirit and all that comes with it: innovation, client centricity and an indomitable will to win.

Job Summary:

As a Senior Data Architect within Acrisure’s Business Information team, you will lead the design and development of enterprise data models, high-performance ETL frameworks, and architectural strategies to support data warehousing, reporting, and analytics across the organization. Leveraging your deep expertise in dimensional modeling, SQL Server, and automation via PowerShell, you will play a central role in transforming Acrisure’s data architecture to drive business insight and efficiency.

You’ll collaborate with developers, analysts, and business stakeholders to unify and modernize our data ecosystem—laying the groundwork for scalable and sustainable growth across our business domains.

Responsibilities:

• Architect, model, and maintain enterprise data solutions using best practices in dimensional modeling (Ralph Kimball methodology) and OLAP/OLTP optimization.
• Lead the design of conceptual, logical, and physical data models to support core enterprise systems, reporting, and analytics.
• Develop high-efficiency, scalable ETL frameworks using SQL Server, SSIS, and PowerShell across legacy and modern data platforms.
• Partner with BI and reporting teams to support complex SSRS and Power BI report development, including performance tuning and query optimization.
• Evaluate and implement storage optimization strategies such as partitioning, compression (Row/Page/Columnstore), and indexing (including Columnstore and Indexed Views).
• Drive architectural initiatives such as data quality frameworks, error-handling strategies, metadata management, and documentation standards.
• Lead discussions with cross-functional teams, including engineers and non-technical stakeholders, to gather requirements and recommend data solutions.
• Serve as a mentor and technical leader for junior engineers and BI developers, supporting knowledge sharing and best practices across the team.
• Contribute to the ongoing evolution of Acrisure’s data warehouse strategy and roadmap through proactive research and experimentation with new technologies and tools.

Requirements:

• Bachelor’s degree or equivalent experience in Information Systems, Computer Science, Engineering, or a related field.
• 8+ years of experience in data architecture, ETL development, and performance tuning—preferably within insurance, fintech, or data-intensive environments.
• Expert-level SQL development skills, including T-SQL, window functions, CTEs, advanced subqueries, and dynamic SQL.
• Proficiency in SQL Server versions 2008–2022, including hands-on experience with SSIS, SSRS, and SSAS.
• Significant experience with PowerShell scripting for ETL, automation, and deployment workflows.
• Strong dimensional modeling expertise and demonstrated ability to build and optimize fact/dimension schemas.
• Familiarity with JSON processing (e.g., OPENJSON, FOR JSON) and integrating semi-structured data into structured storage.
• Working knowledge of performance monitoring tools (e.g., Query Store) and ability to diagnose and resolve database bottlenecks.
• Experience working with Snowflake, Azure SQL Database, or similar cloud data platforms is a plus.

Desired Skills:

• Experience mentoring teams on database best practices and guiding solution architecture decisions.
• Strong documentation skills using tools like Confluence, Visio, and Erwin Data Modeler.
• Familiarity with Agile development environments and source control (e.g., Bitbucket, Git).
• Exposure to insurance and financial services systems or regulatory data requirements is a bonus.

Candidates should be comfortable with an on-site presence to support collaboration, team leadership, and cross-functional partnership.

Benefits and Perks:

• Competitive compensation
• Flexible vacation policy and paid holidays, plus paid sick time off
• Medical Insurance, Dental Insurance, Vision Insurance, Disability insurance (short-term and long-term), Pet Insurance
• Employee-paid supplemental insurance options
• Company-paid group life insurance
• Employee Assistance Program (EAP) and Calm App subscription
• Vested 401(k) with company match and financial wellness programs
• FSA, HSA and commuter benefits options
• Paid maternity leave, paid paternity leave, and fertility benefits
• Career growth and learning
• …and so much more!

Not reflective of all benefits. Enrollment waiting periods or eligibility criteria may apply to certain benefits. Benefit details and offerings may vary for subsidiary entities or in specific geographic locations

Making a lasting impact on the communities it serves, Acrisure has pledged more than $22 million through its partnerships with Corewell Health Helen DeVos Children's Hospital in Grand Rapids, Michigan, UPMC Children's Hospital in Pittsburgh, Pennsylvania and Blythedale Children's Hospital in Valhalla, New York.

​Welcome, your new opportunity awaits you.

Acrisure is committed to employing a diverse workforce. All applicants will be considered for employment without attention to race, color, religion, age, sex, sexual orientation, gender identity, national origin, veteran, or disability status.  California residents can learn more about our privacy practices for applicants by visiting the Acrisure California Applicant Privacy Policy available at www.Acrisure.com/privacy/caapplicant.
 

To Executive Search Firms & Staffing Agencies: Acrisure does not accept unsolicited resumes from any agencies that have not signed a mutual service agreement. All unsolicited resumes will be considered Acrisure’s property, and Acrisure will not be obligated to pay a referral fee. This includes resumes submitted directly to Hiring Managers without contacting Acrisure’s Human Resources Talent Department.