Job Details
Job DescriptionThe Principal Engineer will provide data pipeline expertise and business intelligence leadership to guide the development and implementation of data products and reporting solutions within the Verisk Claims Solutions division The successful candidate has experience developing data pipelines using cloud services and designing data structures that support data products and reporting systems In this hands-on role, he/she will be responsible for transitioning a large SQL Server data warehouse implementation to Snowflake, collaborating with other technical leads to tackle technical problems and expand the Data Engineering footprint and expertise in our offshore location In addition, the candidate will develop new dimensional models and help create innovative solutions to satisfy the growing needs of internal and external customersAbout the Day-to-Day Responsibilities of the Role .
Pipeline Development - Design and develop data pipelines using AWS services like Glue, Step Functions, Lambda, SNS, SQS and S3 in conjunction with computing platforms like Snowflake and Databricks Data Table Design - Design, review, and build Kimball style data models for data products and business intelligence reporting systems like Power BI and ThoughtSpot Collaboration - Work closely with product owners and other technical leads to understand and refine new feature requests.
Work closely with data engineering team to design, review, and develop new data pipelines Communication - Ability to communicate technical ideas in terms product owners and non-technical users can understand Best Practice - Ensure standard practices are followed for logging, monitoring, alerting and data security.
Data Security - Understand Verisk data security policies and controls and design and implement ways to comply with the policiesQualificationsAbout You and How You Can Excel in This Role BS or MS degree in Computer Science, Information Technology, or related field .
5+ years of experience designing and developing cloud data pipelines (ETL/ELT solutions) 3+ years of Data Warehousing experience Proficient in writing SQL for aggregating and transforming data as part of a data pipeline.
Experience using Python for automating processes, working with APIs, and/or transforming data Working knowledge of dimensional modeling methods used to support business intelligence tools (Tableau, Power BI, ThoughtSpot) .
Experience building data pipelines using a variety of data sources (RDBMs, NoSQL, REST API's, AWS SQS, and files) Experience working with Snowflake (or equivalent) Experience working with AWS serverless technologies (S3, Lambda, Glue, Step Functions).
Experience working with Databricks is a plus Experience working with tokenized PII is a plus .
Working knowledge of development standards/best practices with the ability to follow established design patterns Proficiency with version control systems (GIT) Proficiency with database modeling tools (SqlDBM, etc) .
Experience building/working with CI/CD pipelines is a plus Insurance industry experience is a plusAdditional InformationIn 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 areasToday, the insurance industry relies on Verisk to be, and to make the world, more productive, resilient, and sustainableVerisk 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 boundariesVerisk Businesses - provides underwriting and rating solutions for auto and property, general liability, and excess and surplus to assess and price risk with speed and precision - supports end-to-end claims handling with analytic and automation tools that streamline workflow, improve claims management, and support better customer experiences - 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 - provides risk modeling solutions to help individuals, businesses, and society become more resilient to extreme events - 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 - delivers data and insights to improve the reach, timing, relevance, and compliance of every consumer engagement - offers end-to-end, data insight-driven core capabilities for carriers, distribution, and direct customers across the entire policy lifecycle of life and annuities for both individual and group - provides intelligence on sustainability, resilience, and ESG, helping people, business, and societies become strongerVerisk 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 disabilityUnsolicited 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