Job Description
SENIOR DATA ENGINEER (MERLIN)-INF0001ZV
JOB SUMMARY
An individual contributor role that provides a high level of expertise in the design, development, integration and quality control of strategic, high-priority data applications, in an Agile development environment. This role will also monitor data application development/support activities performed by external (and offshore) resources, to ensure timely delivery.
ESSENTIAL DUTIES & RESPONSIBILITIES
Performs a combination of duties in accordance with departmental guidelines:
- Participates in the building of large-scale data processing systems in on premise (Oracle) and cloud platform(Google), optimized for both computational and storage efficiency. Applies technical knowledge on data modeling and best engineering practices.
- Working as a key team member, delivers results, creating value for the CNA brand, customers, and key internal stakeholders. Works with external (and offshore) resources as required.
- May lead or sub-lead the design, implementation and automation of data integration with internal and external systems, transforming the data for the optimal needs of various systems and business requirements.
- May lead or sub-lead robust unit testing to ensure deliverables match the design and provides expertise to support subsequent release testing.
- Actively adheres to established quality and reliability standards, and ensures team adheres to the same quality and standards working in an Agile development environment.
- May lead or sub-lead the design of complex physical data models, projects and cloud-based data lake constructs including SQL/NoSQL database systems. May lead or sub-lead the creation of integrated data views based on business or analytics requirements.
- Researches, identifies and implements process improvements that address complex technology gaps. Builds strong knowledge of technology enablers.
- May lead or sub-lead the design and building of data solutions and applications that enable reporting, analytics, data science, and data management.
- Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies. Drives the evolution of CNA application development processes and standards.
- Knowledgeable on machine learning concepts and applies to work as applicable.
May perform additional duties as assigned.
REPORTING RELATIONSHIP
Typically Director or above
SKILLS, KNOWLEDGE & ABILITIES
- Strong knowledge of advanced SQL and ETL/ELT/integration tools like Informatica’s Power center, IICS, Striim in a business environment with large-scale, complex datasets.
- Strong knowledge of on premise (Oracle) and cloud (BigQuery) database concepts, including design (data modeling), performance tuning and management.
- Demonstrates ability to quickly learn and provide guidance in troubleshooting critical issues.
- Strong communication and interpersonal skills and the ability to work effectively with peers and team members in a highly matrixed environment.
- Experience in building data analytics solutions using Google Cloud Platform services such as Google BigQuery, Cloud Storage, Dataflow, DataProc, Pub/Sub, Cloud Composer, or DataPrep. AWS, including, Amazon Redshift, Postgres, Elastic MapReduce a plus.
- Preferred experience with the insurance industry, its products and services.
- Preferred knowledge of cloud and on premise Business Intelligence tools.
- Preferred experience in programming using Python and/or Java
EDUCATION & EXPERIENCE
- Bachelor’s degree with Master’s preferred in Computer Science, Information Technology, related discipline or equivalent work experience.
- 5+ years of experience in data, analytics and application development in data warehouse.
- 2+ years of coding proficiency in ETL tools.
- 2+ years of work experience in an Agile environment.
- Applicable certifications preferred (GCP, Data Engineering).
PRINCIPAL DATA ENGINEER (CLOUD)-INF0001ZZ
Description
JOB SUMMARY
An individual contributor role that provides the highest level of leadership in the design, development, and integration of strategic, high-priority business applications across the entire software development lifecycle (Agile). This role also provides guidance to others to support the building of complex technical capabilities.
ESSENTIAL DUTIES & RESPONSIBILITIES
Performs a combination of duties in accordance with departmental guidelines:
- Acts as the principal builder of large-scale data processing systems and data lakes, optimized for both computational and storage efficiency on Google Cloud Platform. Applies deep technical knowledge on data modeling and best engineering practices.
- Independently delivers results, creating value for the CNA brand, customers, and key internal stakeholders. Works with external (and offshore) resources as required.
- Leads the design, implementation and automation of data pipelines sourcing data from internal and external systems, transforming the data for the optimal needs of various systems and business requirements.
- Leads robust unit testing to ensure deliverables match the design and provides expertise to support subsequent release testing.
- Actively adheres to established quality and reliability standards, and ensures team adheres to the same quality and standards working in an Agile development environment.
- Leads the design of complex physical data models, projects and cloud-based data lake constructs including SQL/NoSQL database systems. Leads the creation of integrated data views based on business or analytics requirements.
- Researches and leads the identification and implementation of process improvements that address complex technology gaps. Builds strong knowledge of technology enablers.
- Leads the design and building of data solutions and applications that enable reporting, analytics, data science, and data management.
- Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies. Drives the evolution of CNA application development processes and standards.
- Applies machine learning to work as applicable.
May perform additional duties as assigned.
REPORTING RELATIONSHIP
Typically Director or above
SKILLS, KNOWLEDGE & ABILITIES
- Expert knowledge of relational database concepts, data modeling and ETL/ELT.
- Expert knowledge of data integration design and development, ensuring accuracy and ease of consumption. Strong troubleshooting and problem solving skills.
- Proficient in Python or advanced SQL in a business environment with large-scale, complex datasets.
- Excellent communication and interpersonal skills and the ability to work effectively with peers and team members in a highly matrixed environment.
- Strong experience in building data analytics solutions using Google Cloud Platform services such as Google BigQuery, Cloud Storage, Dataflow, DataProc, Pub/Sub, Cloud Composer, or DataPrep. AWS, including, Amazon Redshift, Postgres, Elastic MapReduce a plus.
- Preferred experience with the insurance industry, its products and services.
- Strong experience in implementing big data processing technology. Apache Spark preferred.
- Working knowledge of Business Intelligence tools.
EDUCATION & EXPERIENCE
- Bachelor’s degree with Master’s preferred in Computer Science, Information Technology, related discipline or equivalent work experience.
- 7+ years of experience in data, analytics or application development.
- 3+ years of coding proficiency in at least one programming language (Python, Java, SQL).
- Experience using Agile methods preferred.
- Previous project leadership experience preferred.
- Applicable certifications preferred (GCP, Data Engineering).
Company Description
Since 1897, when CNA entered the insurance market, we’ve been there for our customers and evolved to meet the needs of our times. Today, we focus on what we do best — providing insurance solutions for businesses and professionals in the U.S., Canada, Europe and Asia, complemented by our broad range of products and world-class Risk Control and Claim customer services.
#WeAreCNA