Logo
CNA

Sr. Data Engineer

CNA, Chicago, Illinois, United States, 60290

Save Job

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. Participates in the building of large-scale data processing systems (On-premise and Cloud), optimize data pipeline performance as needed to meet the data loads SLA’s. Applies technical knowledge on data modeling and best engineering practices.May lead or sub-lead 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.May lead or sub-lead the design of complex physical data models, projects (On-premise and Cloud) including SQL 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.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.Need to play a SME role in resolving high priority data quality issues & production incidents and getting them addressed as per defined SLA’s.*May perform additional duties as assigned.*Strong knowledge of relational database concepts, ETL/ELT, star schema, data modeling. Strong data integration design and development, ensuring accuracy and ease of consumption. Strong troubleshooting and problem solving skills. Preferred experience in building data analytics solutions using On-premise Oracle EXADATA, Google Cloud Platform services such as Google BigQuery, Cloud Storage, Dataflow, DataProc, Pub/Sub, Cloud Composer, or DataPrep.

Preferred experience with the insurance industry, its products and services. Working knowledge of Data Analytics, Business Intelligence tools like Power BI preferred. Bachelor’s degree with Master’s preferred in Computer Science, Information Technology, related discipline or equivalent work experience.

5+ years of experience in 2+ years of coding proficiency in at least one programming language Python Unix Shell Script Preferred, Unix Shell Script, SQL, PLSQL Required.

* Informatica Power Center / IDMC Required* Oracle / Big Query/ Postgres Preferred* Control-M / Airflow Preferred* Experience using Agile methods preferred.* Applicable certifications preferred (GCP, Data Engineering).* Experience in the commercial insurance industry will be a huge plus.n certain jurisdictions, CNA is legally required to include a reasonable estimate of the compensation for this role. In District of Columbia, California, Colorado, Connecticut, *the national base pay range for this job level is $72,000 to $141,000 annually. Salary 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 CNA’s benefits, please visit .* #J-18808-Ljbffr