CNA Insurance · 4 hours ago
Sr. Data Engineer
Chicago, IL
Full-time
Onsite
Mid, Senior Level
$72K/yr - $141K/yr
7+ years expCNA Insurance is committed to fostering a culture where employees feel valued and can realize their career aspirations. The Sr. Data Engineer will play a crucial role in designing, developing, and integrating high-priority data applications, while also providing guidance in building complex technical capabilities within an Agile environment.
FinanceFinancial ServicesInformation ServicesInformation TechnologyInsuranceProperty ManagementReal EstateRisk Management
Responsibilities
Performs a combination of duties in accordance with departmental guidelines: 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
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 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 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 (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
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
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
Qualification
Required
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
Proficient in Python or advanced SQL in a business environment with large-scale, complex datasets
Strong communication and interpersonal skills and the ability to work effectively with peers and team members in a highly matrixed environment
Bachelor's degree with Master's preferred in Computer Science, Information Technology, related discipline or equivalent work experience
Typically 7+ years of experience in data, analytics or application development
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
Preferred
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
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
Benefits
Comprehensive and competitive benefits package
Company
CNA Insurance
CNA is one of the largest U.S. commercial property and casualty insurance companies.
5001-10000 employees
H1B Sponsorship
CNA Insurance has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (23)
2024 (32)
2023 (25)
2022 (43)
2021 (32)
2020 (14)
Funding
Current Stage
Public CompanyTotal Funding
$0.88M2016-09-12Post Ipo Equity· $0.88M
1978-01-13IPO
Leadership Team
Luke Mellors
Vice President, Technology
Daniel Franzetti
EVP of Worldwide Claim
Recent News
2025-11-03
MarketScreener
2025-11-03
Company data provided by crunchbase