Lead ETL Data Engineer
- Full-time
- Salary - Max.: $120,000.00
- Disclaimer: Annualized base pay may vary depending on geographic location, job-related knowledge, skills, and experience.
- Salary - Min.: $110,000.00
- Verisk Business: Underwriting Solutions
- U.S. State: New Jersey
Company Description
We help the world see new possibilities and inspire change for better tomorrows. Our analytic solutions bridge content, data, and analytics to help business, people, and society become stronger, more resilient, and sustainable.
Job Description
The Data Engineering and Analytics Lab (DEAL) is a team of technical actuaries responsible for the design and implementation of our core statistical data-systems including data ingestion, data integration, data transformation, data analysis, and analytic dataset construction. We’re an innovation group that is charged with visualizing the future of our organization’s operations and leveraging our expertise in data, technology, P&C insurance, and process optimization to provide a first-class analytics environment to our data-collection, data-management, actuarial, and data-analytics colleagues.
The DEAL team is looking to hire an experienced Lead Data Engineer, ideally having a good combination of an analytical/innovative mindset, technical aptitude, business accumen, communication skills, and a passion for mentoring. For internal candidates, this position is open to grade level 17a.
This is a hybrid role that will combine insurance knowledge and data engineering skills and will be expected to manage a team of Jr actuarial/data engineers supporting multiple work-streams and a wide array of internal customers. We are looking for a team lead that can support the development of our technical business staff in modern data applications including database architectures, efficient data pipelines, effective use of data visualization in organizing workflows, and other data related best-practices.
About the Day to Day Responsibilities of the Role
- Design business critical services, code and own what you build architecturally and operationally.
- Mentor and assist in the career development of junior engineers.
- Assist with recruiting and hiring.
- Decompose complex problems into simple, straight-forward solutions.
- Partner with technical and non-technical colleagues to understand data and reporting requirements.
- Work with engineering teams to collect required data from internal and external systems.
- Design table structures and ETL strategy to build performant Data solutions that are reliable and scalable in a fast growing data ecosystem.
- Document and publish Metadata and table designs to facilitate data adoption.
- Perform ad hoc analysis as necessary.
- Perform SQL and ETL tuning as necessary.
- Develop Data Quality checks for source and target data sets.
- Coach and mentor team members to improve their designs and ETL processes
- Create and conduct project/architecture design review
- Create POC when necessary to test new approaches
- Design and build modern data management solutions
- Enforce common data design pattern to increase code maintainability
- Conduct peers code review and provide constructive feedback
- Partner with team leads to identify, design and implement internal process improvements
- Automate manual processes, optimize data delivery, understand when to re-design architecture for greater scalability
You will be part of a culture that embraces learning and innovation, values teamwork, recognizes and rewards achievements and excellence, and provides personal and professional enrichment opportunities.
#LI-SM1
Qualifications
About You and How You Can Excel in this Role
- University degree in Math, Computer Science, or Engineering
- 7+ years of relevant Professional experience.
- 5+ years’ work experience implementing and reporting on business key performance indicators in data warehousing environments. Strong understanding of data modeling principles including Dimensional modeling, data normalization principles etc.
- 4+ years’ experience using analytic SQL, working with traditional relational databases and/or distributed systems such as Greenplum, Redshift, Snowflake.
- 3+ Years of experience programming languages (e.g. Python, bash).
- Expert level understanding of SQL Engines and able to conduct advanced performance tuning
- Familiarity with data exploration / data visualization tools like Tableau, PowerBI, etc.
- Ability to think strategically, analyze and interpret market and consumer information.
- Strong communication skills – written and verbal presentations.
- Excellent conceptual and analytical reasoning competencies.
- Comfortable working in a fast-paced and highly collaborative environment. A great team player who embraces collaborations also work well individually while supporting multiple projects in parallel
- Expereince in the Property & Casualty insuance industr is preferred
Additional Information
In 2022, Verisk received Great Place to Work® Certification for our outstanding workplace culture for the sixth year in a row and second-time certification in the UK, Spain, and India. We’re also one of the 38 companies on the UK’s Best Workplaces™ list and one of 18 companies on Spain’s Best Workplaces™ list.
For over fifty years and through innovation, interpretation, and professional insight, Verisk has replaced uncertainty with precision to unlock opportunities that deliver significant and demonstrable impact. From our historic roots in risk assessment, we’ve grown to provide analytic insights that help transform industries focused on some of the world’s most critical areas. Today, the insurance industry relies on Verisk to be, and to make the world, more productive, resilient, and sustainable.
Verisk works in collaboration with our customers and at the intersection of people, data, and advanced technologies. Through proprietary platformed analytics, advanced modeling, and interpretation, we deliver immediate and sustained value to our customers and through them, to the individuals and societies they serve, with greater speed, precision, and scale.
We’re 9,000 people strong, committed to translating big data into big ideas. We help others see new possibilities and empower certainty into big decisions that impact individuals and societies. And we relentlessly and ethically pursue innovation to help move our customers, and the world, toward better tomorrows.
Everyone at Verisk—from our chief executive officer to our newest employee—is guided by The Verisk Way, to Be Remarkable, Add Value, and Innovate.
• Be Remarkable by doing something better each day in service to our customers and each other
• Add Value by delivering immediate and sustained results that drive positive outcomes
• Innovate by redefining what’s possible, embracing challenges, and pushing boundaries
Verisk Businesses
Underwriting Solutions — provides underwriting and rating solutions for auto and property, general liability, and excess and surplus to assess and price risk with speed and precision
Claims Solutions — supports end-to-end claims handling with analytic and automation tools that streamline workflow, improve claims management, and support better customer experiences
Property Estimating Solutions — offers property estimation software and tools for professionals in estimating all phases of building and repair to make day-to-day workflows the most efficient
Extreme Event Solutions — provides risk modeling solutions to help individuals, businesses, and society become more resilient to extreme events.
Specialty Business Solutions — provides an integrated suite of software for full end-to-end management of insurance and reinsurance business, helping companies manage their businesses through efficiency, flexibility, and data governance
Marketing Solutions — delivers data and insights to improve the reach, timing, relevance, and compliance of every consumer engagement
Verisk Maplecroft — provides intelligence on sustainability, resilience, and ESG, helping people, business, and societies become stronger
At Verisk you can build an exciting career with meaningful work; create positive and lasting impact on business; and find the support, coaching, and training you need to advance your career. We have received the Great Place to Work® Certification for the 7th consecutive year. We’ve been recognized by Forbes as a World’s Best Employer and a Best Employer for Women, testaments to our culture of engagement and the value we place on an inclusive and diverse workforce. Verisk’s Statement on Racial Equity and Diversity supports our commitment to these values and affecting positive and lasting change in the communities where we live and work.
Verisk Analytics is an equal opportunity employer.
All members of the Verisk Analytics family of companies are equal opportunity employers. We consider all qualified applicants for employment without regard to race, religion, color, national origin, citizenship, sex, gender identity and/or expression, sexual orientation, veteran's status, age or disability.
http://www.verisk.com/careers.html
Unsolicited resumes sent to Verisk, including unsolicited resumes sent to a Verisk business mailing address, fax machine or email address, or directly to Verisk employees, will be considered Verisk property. Verisk will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume.
At Verisk, the health and safety of our people is our number one priority. Effective November 15, 2021, and subject to applicable law, all prospective hires for office based roles or roles that support any of our businesses’ government contracts will be required to demonstrate that they are fully vaccinated against COVID-19 by their start date, or qualify for a legally-required medical or religious accommodation to this vaccination requirement, as a condition of employment. Hired candidates who do not demonstrate that they are fully vaccinated against COVID-19 by their start date, and who have not been approved for a legally-required medical or religious accommodation will no longer meet the requirements for employment and their offers of employment will be immediately rescinded, in accordance with applicable law.