Senior Data Engineer

Acrisure Innovation

Austin, TX (Onsite 4 days per week)

Note: This is a full-time role and we do not offer C2C or C2H employment and are not able to sponsor visas for this position.

Why Choose Acrisure?

Acrisure Innovation is where human expertise meets advanced technology.

Acrisure Innovation is a fast paced, AI-driven team building innovative software to disrupt the $6T+ insurance industry.  Our mission is to help the world share its risk more intelligently to power a more vibrant economy. To do this, we are transforming insurance distribution and underwriting into a science. 

At the core of our operating model is our technology: we’re building a digital marketplace for risk and applying it at the center of Acrisure, a privately held company recognized as one of the world's top 10 insurance brokerages and the fastest growing insurance brokerage globally. By leveraging technology to push the boundaries of understanding and transferring risk, we are systematically converting data into predictions, insights, and choices, and we believe we can remove the constraints associated with scale, scope, and learning that have existed in the insurance industry for centuries.

Our culture is strong. We are a collaborative company of entrepreneurial, innovative, and talented people who believe in our future. We outthink and out work the competition. We look outside our walls and are energized by our fast-paced trajectory.

Our vision for the future is clear. We have limitless potential to achieve unprecedented success in the insurance industry. To achieve our opportunity, a best-in-class Team must support us.

Learn more about Acrisure Innovation: https://builtin.com/company/acrisure-innovation

Position Overview: 

The Innovation team’s mission is to unify data across the enterprise to optimize business decisions made at the strategic, tactical, and operational levels of the organization. We accomplish this by building a data lakehouse that powers analytics and reporting platforms, and business processes that provide quality data, in a timely fashion, from any channel of the company and present them in such a manner as to maximize the value of that data for both internal and external customers.  

The Senior Data Engineer is responsible for designing and developing complex ELT processes required to populate our data lakehouse which supplies data for the Product, AI & Data Intelligence teams.  Responsibility includes hands-on contributions in data engineering and data architecture working with a team of full time and contracted developers as well as coaching and mentoring junior and mid-level developers. Ensuring high quality and best practices are maintained through the development cycle is key to this position.  

Responsibilities:  

• Leverage established guidelines and custom designs to create complex ELT processes to meet the needs of the business.  

• Onboard and curate data sources including data preparation/ELT and modeling to enable data consumption by analytics and AI teams 

• Act as a Solution Architect and Technology Leader – ability to make decisions in the face of ambiguity and solve difficult technical problems.  

• Lead discovery, requirements, level of effort estimation and project planning for strategic company initiatives.  

• Independently determine methods and procedures for new or existing requirements and functionality.  

• Onboard, Lead, and Mentor junior and mid-level developers. 

• Work closely with Data Source contacts, Analysts, Product and Data Intelligence teams to identify opportunities and assess improvements of our products and services.  

• Contribute to workshops with the business user community to further their knowledge and use of the data ecosystem.  

• Produce and maintain accurate project documentation, project planning and presentations.  

• Collaborate with various data providers to resolve dashboard, reporting and data related issues.  

• Perform Data benchmarking, enhancements, optimizations, and platform analytics.  

• Participate in the research, development, and adoption of trends in technology, data and analytics 

Qualifications & Requirements:  

Bachelor's degree preferred or equivalent experience along with a demonstrated desire for continuing education and improvement.  

Experience:  

• Minimum 8-10 years in Data Engineering, preferably with expertise in an Azure environment with Data Bricks, Azure Data Factory, Azure Data Lake.   

• Minimum 8-10 years architecting and designing data warehouses, data modeling, and end-to-end ELT processes  

• Successfully delivered 5+ end to end projects – from Inception to Execution - in Data Engineering / Data Science / Data Integration as a Tech Lead/Principal 

• Strong hands-on experience with Data Lake & Delta Lake Concepts. 

• Strong hands-on experience with Databricks Unity Catalog and usage in dealing with Delta tables. 

• Ability to Analyze, summarize, and characterize large or small data sets with varying degrees of fidelity or quality, and identify and explain any insights or patterns within them. 

• Experience with multi-source data warehouses    

• Experience with other cloud environments (GCP) a definite plus.   

• Experience in data analytics and reporting, particularly with Power BI a plus 

• Hands on experience building logical data models and physical data models  

• Write SQL fluently, recognize and correct inefficient or error-prone SQL, and perform test-driven validation of SQL queries and their results. 

• Create and share standards, best practices, documentation and reference examples for data warehouse, integration/ELT systems, and end user reporting 

• Apply disciplined approach to testing software and data, identifying data anomalies, and correcting both data errors and their root causes 

• Should be well versed with Key Vault \ create & maintenance and usage of secrets in both Databricks & ADF 

• Should be knowledgeable in Stored procedures \ functions and be able to use them by ADF & Databricks as this is a widely used Practice in Acrisure. 

• Should be familiar with DevOps process for Azure artifacts and database artifacts.  

• Should be well versed with ADF concepts like chaining pipelines, passing parameters, using APIs for ADF & Databricks to perform various activities. 

• Should be well versed with Agile and Scrum principles and procedures, and working with Jira 

Additional Qualifications: 

• Excellent organizational skills with the ability to prioritize, communicate and execute tasks across multiple projects with tight deadlines and aggressive goals.  

• Expert working knowledge of SQL, Python and Spark, and demonstrated ability to create ad-hoc SQL queries to analyze data, create prototypes, etc.  

• Ability to understand complex issues and clearly articulate complex ideas.  

• Demonstrated ability to champion change, influence, and drive results in a complex organization.  

• Ability to mentor junior developers and contribute to the growth of the team.  

• Excellent verbal and written communication skills.  

• Experience working in a Multi-Cloud Environment a Plus 

• Experience working with dbt a Plus 

• Knowledge of the Insurance Industry or FinTech a Plus 

Acrisure is equally committed to supporting social issues. In its home of Grand Rapids, Acrisure provided $15 million to create the Acrisure Center for Innovation in Children’s Health at Helen DeVos Children’s Hospital.

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.

We are interested in every qualified candidate who is eligible to work in the United States. We are not able to sponsor visas for this position.

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.

https://www.acrisure.com/acrisureacastaffprivacynotice/

#BI-Hybrid

#LI-Hybrid