Cloud Data Engineer

Senior Data Engineer Job Description:


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

Benefits (employee contribution):

• Health insurance
• Health savings account
• Dental insurance
• Vision insurance
• Flexible spending accounts
• Life insurance
• Retirement plan

All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Rate of pay within the stated range will depend on the qualification of the applicant.