Cloud Data Engineer

Summary

General Summary

Independently designs, develops, tests, implements, documents, and supports big data/ data fabric platforms, including big data cataloging, modeling, ingestion, streaming, processing, and storage technologies and processes. Applies a general understanding of the source systems, and leverages general knowledge of data warehouse and business intelligence technologies, as well as processes, to execute responsibilities. Must have effective communication and collaboration skills to ensure work output meets business needs.

Principle Duties

1

Creates and supports the process to ingest data from source systems and place it into the data fabric and analytics platforms

2

Performs big data pipeline design and testing, including data design, data architecture, catalog, and repository creation

3

Designs, develops, and maintains the data technologies and architectures

4

Works with business and IT stakeholders to optimize information by defining business requirements and populating the data fabric

5

Collaborate with business to develop models and transformations that meet advanced analytics needs

6

Recommends improvements and applies standards, processes, and procedures for data pipelines

7

Seeks continuous data performance improvement and ensures security of information

8

Creates and implements effective metrics and monitoring processes

9

May lead small projects with manageable risks and resource requirements

10

Acts as a resource and impacts the quality of work for colleagues with less experience

Education

Required

Bachelor s degree or equivalent education/experience

Experience

Required

• 4+ years Data warehousing methodologies and modelling techniques
• 4+ years experience with cataloging, modeling, ingestion, processing, and streaming technologies and processes
• Demonstrated ability to quickly learn new technologies
• 1+ years of Data Analysis experience
• Experience with ETL concepts and tooling
• Advanced ability to solve complex problems, drawing upon creativity, experience, and multiple sources of information
• Advanced interpersonal skills, including the ability to build consensus
• Advanced communication skills, including the ability to communicate complex or difficult information in straightforward manner
• Ability to understand assigned work from a business perspective
• Regular and predictable attendance

Preferred

• Insurance and/or reinsurance industry knowledge

Technical Requirements

Required
(make more generic)

• Expertise in SQL and database table design able to write structured and efficient queries on large data sets
• Experience working with enterprise scale data, and understanding how to efficiently work with data at scale
• Experience working in Massively Parallel Processing (MPP) Analytical Datastores such as Snowflake, Vertica, Big Query
• Awareness of data visualization tools such as Tableau, and/or Power BI

Preferred
(make more position specific)

• Experience leveraging dBT to develop data pipelines
• General understanding of Snowflake Architecture
• Basic understanding of agile process flows