Data Engineer- Health Solutions Actuarial and Analytics Consulting

Profile

Aon is looking for a Data Engineer- Health Solutions Analytics and ActuarialAs part of an industry-leading team, you will help empower results for our clients by supporting our health solutions practice in delivering innovative and effective solutions growing our Analytics & Actuarial team in Atlanta, GA, Chicago IL, or in close proximity to any Aon office in the US. Your impact as a Data Engineer - Health Solutions AnalyticsOverviewThis position is a key part of our Health Analytics team at Aon. Our practice focuses on developing, delivering and scaling cutting-edge analytics solutions focused on client needs. Our team of colleagues excel at assessing customers’ business and health needs and enabling better data-driven decisions for their programs. The team is a mix of analytics experts, data scientists, analysts, data engineers, actuaries, and solution and innovation architects. Our group delivers or supports a wide array of reporting tools, special projects, and methodology development to address the complex analytic needs of our data-driven clients.Job Responsibilities:Collaborate with a team of experienced actuaries, data scientists, developers and business experts to build flexible and scalable data management and delivery tools to support Aon’s data, analytics and reporting capabilitiesDesign, build and maintain scalable ETL/ELT pipelines from raw data ingestion through final data consumption by diverse applicationsDevelop and integrate an automated data validation and quality control mechanism throughout the pipelineAdhere to design philosophy emphasizing agile, efficient/simple/sophisticated and robust development to meet complex and highly dynamic business needsContribute to the design of our data lake and the development of all data assets and downstream warehouses/martsDiscover and develop opportunities for automation to minimize the need for manual intervention and streamline processingAssist in data security, permission management and de-identification processingMaintain up-to-date technical and operational documentationManage/run/improve existing SQL Server based reports and processesParticipate in migration of data from existing SQL server based processes into big data/cloud based platformsAssist with performance tuning and data lifecycle managementRequired Experience:3 years of experience in a ETL or data engineering capacityExperience with Python and R data pipelines and data automationConstruction of data pipelines ingesting large tabular datasets (insurance claims, medical, pharmacy, eligibility and human capital data) into database or data lake and populating a structured warehouse or data martStrong working knowledge with a relational database system (e.g. SQL Server) including stored procedures, SSIS, SQL Agent, etc.Experience with AWS, Snowflake, Databricks/Apache Spark, Redshift, technologiesKnowledge of data security and privacy practices and regulations, including data access controls and de-identification and protection of sensitive dataDemonstrable ability to convey technical information successfully to a wide variety of stakeholdersDemonstrable ability to pick up new technology and solutions requiredNice to haveExperience with data visualization tools (e.g. Tableau, Power BI)Experience working with medical and prescription drug claims dataFamiliarity with benefits or health administrative data including procedure coding, diagnostic coding, financial fields, etc. is a plusKnowledge of Agile Scrum and Continuous Delivery practices is desirableExperience with version control systems (e.g. Git)Education:BS or MS degree in Computer Science, Information Technology or equivalentWe offer youA competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.We Offer You:A competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.Our Colleague Experience:From helping clients gain access to capital after natural disasters, to creating access to health care and retirement for millions, Aon colleagues empower results for our clients, communities, and each other every day. They make a difference, work with the best, own their potential, and value one another. This is the Aon Colleague Experience, defining what it means to work at Aon and realizing our vision of empowering human and economic possibility. To learn more visit Aon Colleague Experience.About Aon:Aon plc (NYSE:AON) is the leading global provider of risk management, insurance and reinsurance brokerage, and human resources solutions and outsourcing services. Our more than 72,000 colleagues worldwide empower results for clients in over 120 countries with innovative and effective risk and people solutions and through industry-leading global resources and technical expertise. To learn more visit aon.com. By applying for a position with Aon, you understand that, should you be made an offer, it will be contingent on your undergoing and successfully completing a background check consistent with Aon's employment policies.Background checks may include some or all of the following based on the nature of the position: SSN/SIN validation, education verification, employment verification, and criminal check, search against global sanctions and government watch lists, fingerprint verification, credit check, and/or drug test. You will be advised during the hiring process which checks are required by the position.  DISCLAIMER: Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation. 2506146,qualifications:UNAVAILABLE,responsibilities:Aon is looking for a Data Engineer- Health Solutions Analytics and ActuarialAs part of an industry-leading team, you will help empower results for our clients by supporting our health solutions practice in delivering innovative and effective solutions growing our Analytics & Actuarial team in Atlanta, GA, Chicago IL, or in close proximity to any Aon office in the US. Your impact as a Data Engineer - Health Solutions AnalyticsOverviewThis position is a key part of our Health Analytics team at Aon. Our practice focuses on developing, delivering and scaling cutting-edge analytics solutions focused on client needs. Our team of colleagues excel at assessing customers’ business and health needs and enabling better data-driven decisions for their programs. The team is a mix of analytics experts, data scientists, analysts, data engineers, actuaries, and solution and innovation architects. Our group delivers or supports a wide array of reporting tools, special projects, and methodology development to address the complex analytic needs of our data-driven clients.Job Responsibilities:Collaborate with a team of experienced actuaries, data scientists, developers and business experts to build flexible and scalable data management and delivery tools to support Aon’s data, analytics and reporting capabilitiesDesign, build and maintain scalable ETL/ELT pipelines from raw data ingestion through final data consumption by diverse applicationsDevelop and integrate an automated data validation and quality control mechanism throughout the pipelineAdhere to design philosophy emphasizing agile, efficient/simple/sophisticated and robust development to meet complex and highly dynamic business needsContribute to the design of our data lake and the development of all data assets and downstream warehouses/martsDiscover and develop opportunities for automation to minimize the need for manual intervention and streamline processingAssist in data security, permission management and de-identification processingMaintain up-to-date technical and operational documentationManage/run/improve existing SQL Server based reports and processesParticipate in migration of data from existing SQL server based processes into big data/cloud based platformsAssist with performance tuning and data lifecycle managementRequired Experience:3 years of experience in a ETL or data engineering capacityExperience with Python and R data pipelines and data automationConstruction of data pipelines ingesting large tabular datasets (insurance claims, medical, pharmacy, eligibility and human capital data) into database or data lake and populating a structured warehouse or data martStrong working knowledge with a relational database system (e.g. SQL Server) including stored procedures, SSIS, SQL Agent, etc.Experience with AWS, Snowflake, Databricks/Apache Spark, Redshift, technologiesKnowledge of data security and privacy practices and regulations, including data access controls and de-identification and protection of sensitive dataDemonstrable ability to convey technical information successfully to a wide variety of stakeholdersDemonstrable ability to pick up new technology and solutions requiredNice to haveExperience with data visualization tools (e.g. Tableau, Power BI)Experience working with medical and prescription drug claims dataFamiliarity with benefits or health administrative data including procedure coding, diagnostic coding, financial fields, etc. is a plusKnowledge of Agile Scrum and Continuous Delivery practices is desirableExperience with version control systems (e.g. Git)Education:BS or MS degree in Computer Science, Information Technology or equivalentWe offer youA competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.We Offer You:A competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.Our Colleague Experience:From helping clients gain access to capital after natural disasters, to creating access to health care and retirement for millions, Aon colleagues empower results for our clients, communities, and each other every day. They make a difference, work with the best, own their potential, and value one another. This is the Aon Colleague Experience, defining what it means to work at Aon and realizing our vision of empowering human and economic possibility. To learn more visit Aon Colleague Experience.About Aon:Aon plc (NYSE:AON) is the leading global provider of risk management, insurance and reinsurance brokerage, and human resources solutions and outsourcing services. Our more than 72,000 colleagues worldwide empower results for clients in over 120 countries with innovative and effective risk and people solutions and through industry-leading global resources and technical expertise. To learn more visit aon.com. By applying for a position with Aon, you understand that, should you be made an offer, it will be contingent on your undergoing and successfully completing a background check consistent with Aon's employment policies.Background checks may include some or all of the following based on the nature of the position: SSN/SIN validation, education verification, employment verification, and criminal check, search against global sanctions and government watch lists, fingerprint verification, credit check, and/or drug test. You will be advised during the hiring process which checks are required by the position.  DISCLAIMER: Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.,skills:UNAVAILABLE,workHours:UNAVAILABLE,jobBenefits:UNAVAILABLE,datePosted:2022-03-24T14:55:00 0000,employmentType:FULL_TIME,educationRequirements:UNAVAILABLE,salaryCurrency:USD,baseSalary:{@type:MonetaryAmount,currency:USD,value:{@type:QuantitativeValue,value:0,minValue:0,maxValue:0,unitText:YEAR}},validThrough:2023-03-24T14:56:21.000Z,industry:UNAVAILABLE,hiringOrganization:{@type:Organization,name:Aon Corporation,sameAs:https://jobs.aon.com,logo:https://assets.jibecdn.com/prod/aon/0.0.44/assets/brands/https://aon.icims.com/icims2/servlet/icims2?module=AppInert&action=download&id=1134557&hashed=154379},jobLocation:{@type:Place,address:{@type:PostalAddress,addressLocality:Chicago,addressRegion:Illinois,streetAddress:200 E Randolph,postalCode:60601,addressCountry:United States}}}

Company info

Aon PLC.
Website : http://www.aon.com