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 cuttingedge technology and toptier 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 19000 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 Acrisures Business Information team you will lead the design and development of enterprise data models highperformance 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 Acrisures data architecture to drive business insight and efficiency.

Youll collaborate with developers analysts and business stakeholders to unify and modernize our data ecosystemlaying 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 highefficiency 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 errorhandling strategies metadata management and documentation standards.
• Lead discussions with crossfunctional teams including engineers and nontechnical 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 Acrisures data warehouse strategy and roadmap through proactive research and experimentation with new technologies and tools.

Requirements:

• Bachelors 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 tuningpreferably within insurance fintech or dataintensive environments.
• Expertlevel SQL development skills including TSQL window functions CTEs advanced subqueries and dynamic SQL.
• Proficiency in SQL Server versionsincluding handson 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 semistructured 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 onsite presence to support collaboration team leadership and crossfunctional 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 (shortterm and longterm) Pet Insurance
• Employeepaid supplemental insurance options
• Companypaid 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 Childrens Hospital in Grand Rapids Michigan UPMC Childrens Hospital in Pittsburgh Pennsylvania and Blythedale Childrens Hospital in Valhalla New York.

Welcome your new opportunity awaits you.

Acrisure is committed to employing a diverse workforce. All applicants will be considered foremploymentwithout 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 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 Acrisures property and Acrisure will not be obligated to pay a referral fee. This includes resumes submitted directly to Hiring Managers without contacting Acrisures Human Resources Talent Department.