Sr. Data Engineer
Share
Job Location:
Chicago, IL - USA
Yearly Salary:
$ 72000 - 141000
Posted on:
19 hours ago
Vacancies:
1 Vacancy
Job Summary
You have a clear vision of where your career can go. And we have the leadership to help you get there.At CNA we strive to create a culture in which people know they matter and are part of something important ensuring the abilities of all employees are used to their fullest potential.
An individual contributor role that provides a high level of expertise in the design development and integration of strategic high-priority data applications across the entire software development lifecycle (Agile). This role may also provide guidance to others to support the building of complex technical capabilities.JOB DESCRIPTION:
Essential Duties & Responsibilities
Performs a combination of duties in accordance with departmental guidelines:
Participates in the building of large-scale data processing systems(On-premiseand Cloud)optimizedata pipeline performance as needed to meet the dataloadsSLAs. Applies technical knowledge on data modeling and best engineering practices.
Working as a key teammemberdelivers results creating value for the CNA brand customers and key internal stakeholders. Works with external (and offshore) resources as.
May lead or sub-lead the designimplementationand automation of data pipelines sourcing data from internal and external systems transforming the data for theoptimalneeds of various systems and business requirements.
May lead or sub-lead robust unit testing to ensure deliverables match the design andprovidesexpertiseto supportsubsequentrelease 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(On-premiseand Cloud)including SQL database systems. May lead or sub-lead the creation of integrated data views based on business or analytics requirements.
Researchesidentifiesand 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;establishingpersonal networks;participatingin professional societies. Drives the evolution of CNA application development processes and standards.
Need to play a SME role in resolving high priority data quality issues &productionincidents and getting them addressed as per definedSLAs.
May performadditionalduties as assigned.
Reporting Relationship
Typically Director or above
Skills Knowledge & Abilities
Strong knowledge of relational database conceptsETL/ELT star schema datamodeling.
Strong data integration design and development ensuring accuracy and ease of consumption. Strong troubleshooting andproblem solvingskills.
Proficient in Python or advanced SQL in a business environment with large-scale complex datasets.
Strong communicationand interpersonal skills and the ability to work effectively with peers and team members in a highly matrixed environment.
Preferred experience in building data analytics solutions usingOn-premiseOracleEXADATAGoogle Cloud Platform services such as GoogleBigQuery Cloud Storage DataflowDataProc Pub/Sub Cloud Composer orDataPrep.
Preferred experience with the insurance industry itsproductsand services.
Working knowledge ofData AnalyticsBusiness Intelligence toolslike Power BIpreferred.
Education & Experience
Bachelors degree with Masters preferred in Computer Science Information Technology relateddisciplineor equivalent work experience.
Typically5 years of experience indataanalyticsor application development.
2 years of codingproficiencyin at least one programming language PythonUnix Shell ScriptPreferredUnix Shell ScriptSQL PLSQLRequired.
Informatica Power Center/IDMCRequired
Oracle/Big Query/ Postgres Preferred
Control-M / Airflow Preferred
Experience using Agile methods preferred.
Applicable certifications preferred (GCP Data Engineering).
Experience in thecommercial insurance industrywill be a huge plus.
#LI-ED1
#LI-Hybrid
In certain jurisdictions CNA is legally required to include a reasonable estimate of the compensation for this District of Columbia California Colorado Connecticut Illinois Maryland Massachusetts New York and Washington the national base pay range for this job level is $72000 to $141000 determinations are based on various factors including but not limited to relevant work experience skills certifications and location. CNA offers a comprehensive and competitive benefits package to help our employees and their family members achieve their physical financial emotional and social wellbeing goals. For a detailed look at CNAs benefits please visit.
CNA is committed to providing reasonable accommodations to qualified individuals with disabilities in the recruitment process. To request an accommodation please contact.
Required Experience:
Senior IC
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
CNA provides insurance solutions to more than 1 million businesses and professionals worldwide. With more than 100 years of industry experience, CNA has earned a reputation as one of the most trusted commercial insurance companies in the business. We’re a powerful legacy built on expe ... View more
