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.
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
Linked-in
Google