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. Under technical direction, assists in building next generation data capabilities to enable superior decision support and insight generation. Supports data and processes for the pricing, underwriting, claims, operations and marketing for a mix of business insurance products. Only Chicago Based candidates will be considered JOB DESCRIPTION: Essential Duties & Responsibilities 1. Assembles large and complex data sets from disparate data sources into consumable formats that meet business requirements. 2. Creates efficient and reproducible ETL Data Pipelines using SQL, Python or big data tools such as Spark. 3. Works closely with Data Science, Development Operations and data management teams to assist with data-related technical issues and support their data infrastructure needs. 4. Builds and maintains capabilities for data quality control, identifies data quality issues and pipeline failures. 5. Builds exploratory Dashboards and tools for data scientists and business partners that can be deployed relatively quickly and require low maintenance support. 6. Creates streamlined processes for geocoding internal data for matching to external sources. 7. Collaborates with application owners to help define data collection requirements. 8. Works with Data Scientists to understand requirements and help design systems and processes to deliver business value. Researches new uses for existing data. 9. Builds infrastructure required for flexible and scalable extraction, transformation and loading of data from a wide variety of data sources. 10. Design and implement functionality, participate in team code reviews, and provides feedback on performance, logic, standard methodologies and maintenance issues to ensure code-level consistency. 11. Creates production quality code to support deployment of predictive models. 12. Produces coherent documentation, metadata, and reports. 13. Own data processing pipelines from conception to production deployment. Reporting Relationship Manager or above Skills, Knowledge and Abilities 1. Strong SQL knowledge and proven experience working with relational databases. 2. Demonstrated experience in manipulating, merging, cleaning, profiling, and preparing large datasets for analytics, from disparate sources. 3. Working knowledge of Python and experience working with XML and JSON formats. 4. Practical experience with version control, preferable git. 5. Experience implanting and maintaining ETL and CI/CD data pipelines. 6. Ability to write efficient, well documented data wrangling code. 7. Intellectual curiosity to find new and innovative ways to solve data management issues. 8. Employ an array of technologies and tools to connect systems together. 9. Strong analytical, problem solving and critical thinking skills. 10. Attention to detail and accuracy of work, ability to spot and correct issues. 11. Drive to continuously improve and learn new tools and methods. 12. Ability to work collaboratively with colleagues with diverse perspective and backgrounds. 13. Strong time management skills. 14. Capable of operating with little supervision and thinking independently and innovatively. Education and Experience 1. Bachelor's degree in Computer Science, Information Technology or related discipline, or equivalent work experience. 2. Typically a minimum of four years experience. #LI-MF1 #LI-Hybrid In certain jurisdictions, CNA is legally required to include a reasonable estimate of the compensation for this role. In District of Columbia, California, Colorado, Connecticut, Illinois, Maryland, Massachusetts, New York and Washington, the national base pay range for this job level is $54,000 to $103,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 cnabenefits.com. CNA is committed to providing reasonable accommodations to qualified individuals with disabilities in the recruitment process. To request an accommodation, please contact leaveadministration@cna.com. At CNA, we are focused on success, individually and collectively. We pride ourselves on promoting a culture that challenges and engages people. We strive to connect people, departments and business areas, to function as a team, and to serve our customers and communities with professionalism and respect. Our dedication to employee engagement, continuous learning and the open exchange of ideas is the cornerstone of our business. These ideals, combined with our focus on the customer, enable us to explore new market opportunities and build on our success. Our values, culture and financial strength are what differentiates us from other employers and make CNA the place you want to work. CNA is committed to fostering a diverse and inclusive culture grounded in equity that supports our organization, clients, and communities by prioritizing talent and programs that represent our current environment and empower all employees and partners to be active allies and advocates for equality. Globally, our Employee Resource Groups — Advocacy for Visible & Invisible Disabilities (AVID), Asian Professionals for Excellence (APEX), Empowering Black Professionals (EBP), Generational Perspectives (GP), Organization of Hispanics and Latine Americanos (¡OHLA!), Pride, Women Impacting Leadership (WIL) and Veterans — make CNA, and our communities, even stronger. At CNA, we have a long standing commitment to the diverse communities in which we live and work. We actively make a difference for the greater good through partnerships, sustainability, initiatives, and working together for a better tomorrow. Corporate Social Responsibility is not one person, or one department, it's the entire enterprise coming together to make the world a better place.
