Consumer Health Data Engineer/Data Analyst

Profile

Consumer Health - Data Engineer / Data Analyst As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions supporting our Health Solutions practice. As a Data Engineer / Data Analyst, you will be a member of Aon’s Consumer Health team, supporting advanced analytics and reporting in the servicing of existing clients and prospects.  Aon is in the business of better decisions At Aon, we shape decisions for the better to protect and enrich the lives of people around the world. As an organization, we are united through trust as one inclusive, diverse team, and we are passionate about helping our colleagues and clients succeed. Aon’s Consumer Solutions practice is an integral component of Aon Health Solutions, helping clients promote and protect financial wellbeing by extending their benefits portfolios to support a variety of benefits and enrollment and communications strategies. We deliver quality services with a deep focus on the employee experience. We touch over 3 million consumers educating and helping them enroll in benefits accounting for over $200 million in premiums. What the day will look like Responsibilities  Analytics and Insights DevelopmentManage data requirements, gather information on client requirements, analyze and report on data.Effectively communicate data presentation to end-users through documentation and training.Understand and document data structures, data definitions, process flowsDevelop and maintain on-premises and cloud-based data warehouse/data lakes such as Snowflake and Databricks.Wrangle data to develop & present meaningful and insightful data visualizations.Develop and maintain SQL databases, Entity diagrams (ED), including ETL, SSIS and SQL Jobs.Implement automation and efficiencies wherever possible to streamline the process, minimizing the need for manual interventionCommunication and CollaborationLeverage our relationships with Carriers and Clients to understand market trends and identify revenue generating opportunities through data-driven analytics Maintain an up-to-date knowledge of the group benefits industry, systems, products, trends, and emerging technology, while having a thorough understanding of how these relate to group insurance consulting; andBuild strong working relationships and collaborate effectively on cross functional teams with colleagues, clients and carriersCollaborate and liaise with Global Aon Analytics team to understand current capabilities for delivery.  How this opportunity is differentYou’ll be directly impacting the Value Proposition to carrier and client partners through advanced custom health analytics. You’ll have the opportunity to share expertise and value in this complex and continually evolving space. Skills and experience that will lead to successRequired:5 years’ experience as a Data Analyst/ Data Engineer or in similar roles.Technical Experience -5 years with following:Writing complex data queries (SQL) and strong understanding of ETL Processes (Data in/Data OutData wrangling tool sets (e.g., Trifacta, Alteryx)Data visualization tool sets (e.g., PowerBI, Tableau,)Statistical analysis and computing, machine and deep learningWorking with Big data and Data modeling through tool sets (e.g., Databricks, Snowflake)Interpersonal Skills:Excellent communication skills to present complex data analysis in a simple actionable wayStrong business acumen in Health Insurance and BenefitsExcellent analytical and critical thinking skillsEducation:Bachelor’s degree in Statistics, Mathematics, Actuarial Science, Computer Science or related discipline, or equivalent years of industry experience  Salary range for the position  The salary range for this position (intended for U.S. applicants) is $105,000.00 - $130,000.00 annually. The actual salary will vary based on applicant’s education, experience, skills, and abilities, as well as internal equity and alignment with market data.  The salary may also be adjusted based on applicant’s geographic location.The salary range reflected is based on a primary work location of Chicago, IL.  The actual salary may vary for applicants in a different geographic location.    This position is eligible to participate in one of Aon’s annual incentive plans to receive an annual discretionary bonus in addition to base salary.  The amount of any bonus varies and is subject to the terms and conditions of the applicable incentive plan.  How we support our colleagues  In addition to our comprehensive benefits package, we encourage a diverse workforce. Plus, our agile, inclusive environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging you to take time to focus on yourself.  We offer a variety of working style solutions, but we also recognize that flexibility goes beyond just the place of work... and we are all for it. We call this Smart Working! Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued. Aon values an innovative, diverse workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace.   Aon provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status.  Aon is committed to a diverse workforce and is an affirmative action employer. People with criminal histories are encouraged to apply.  We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation on **** Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.   Aon offers a comprehensive package of benefits for full-time and regular part-time colleagues, including, but not limited to: a 401(k) savings plan with employer contributions; an employee stock purchase plan; consideration for long-term incentive awards at Aon’s discretion; medical, dental and vision insurance, various types of leaves of absence, paid time off, including 12 paid holidays throughout the calendar year, 15 days of paid vacation per year, paid sick leave as provided under state and local paid sick leave laws, short-term disability and optional long-term disability, health savings account, health care and dependent care reimbursement accounts, employee and dependent life insurance and supplemental life and AD&D insurance; optional personal insurance policies, adoption assistance, tuition assistance, commuter benefits, and an employee assistance program that includes free counseling sessions.  Eligibility for benefits is governed by the applicable plan documents and policies.  #LI-LR1#LI-REMOTE  2523259,qualifications:UNAVAILABLE,responsibilities:Consumer Health - Data Engineer / Data Analyst As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions supporting our Health Solutions practice. As a Data Engineer / Data Analyst, you will be a member of Aon’s Consumer Health team, supporting advanced analytics and reporting in the servicing of existing clients and prospects.  Aon is in the business of better decisions At Aon, we shape decisions for the better to protect and enrich the lives of people around the world. As an organization, we are united through trust as one inclusive, diverse team, and we are passionate about helping our colleagues and clients succeed. Aon’s Consumer Solutions practice is an integral component of Aon Health Solutions, helping clients promote and protect financial wellbeing by extending their benefits portfolios to support a variety of benefits and enrollment and communications strategies. We deliver quality services with a deep focus on the employee experience. We touch over 3 million consumers educating and helping them enroll in benefits accounting for over $200 million in premiums. What the day will look like Responsibilities  Analytics and Insights DevelopmentManage data requirements, gather information on client requirements, analyze and report on data.Effectively communicate data presentation to end-users through documentation and training.Understand and document data structures, data definitions, process flowsDevelop and maintain on-premises and cloud-based data warehouse/data lakes such as Snowflake and Databricks.Wrangle data to develop & present meaningful and insightful data visualizations.Develop and maintain SQL databases, Entity diagrams (ED), including ETL, SSIS and SQL Jobs.Implement automation and efficiencies wherever possible to streamline the process, minimizing the need for manual interventionCommunication and CollaborationLeverage our relationships with Carriers and Clients to understand market trends and identify revenue generating opportunities through data-driven analytics Maintain an up-to-date knowledge of the group benefits industry, systems, products, trends, and emerging technology, while having a thorough understanding of how these relate to group insurance consulting; andBuild strong working relationships and collaborate effectively on cross functional teams with colleagues, clients and carriersCollaborate and liaise with Global Aon Analytics team to understand current capabilities for delivery.  How this opportunity is differentYou’ll be directly impacting the Value Proposition to carrier and client partners through advanced custom health analytics. You’ll have the opportunity to share expertise and value in this complex and continually evolving space. Skills and experience that will lead to successRequired:5 years’ experience as a Data Analyst/ Data Engineer or in similar roles.Technical Experience -5 years with following:Writing complex data queries (SQL) and strong understanding of ETL Processes (Data in/Data OutData wrangling tool sets (e.g., Trifacta, Alteryx)Data visualization tool sets (e.g., PowerBI, Tableau,)Statistical analysis and computing, machine and deep learningWorking with Big data and Data modeling through tool sets (e.g., Databricks, Snowflake)Interpersonal Skills:Excellent communication skills to present complex data analysis in a simple actionable wayStrong business acumen in Health Insurance and BenefitsExcellent analytical and critical thinking skillsEducation:Bachelor’s degree in Statistics, Mathematics, Actuarial Science, Computer Science or related discipline, or equivalent years of industry experience  Salary range for the position  The salary range for this position (intended for U.S. applicants) is $105,000.00 - $130,000.00 annually. The actual salary will vary based on applicant’s education, experience, skills, and abilities, as well as internal equity and alignment with market data.  The salary may also be adjusted based on applicant’s geographic location.The salary range reflected is based on a primary work location of Chicago, IL.  The actual salary may vary for applicants in a different geographic location.    This position is eligible to participate in one of Aon’s annual incentive plans to receive an annual discretionary bonus in addition to base salary.  The amount of any bonus varies and is subject to the terms and conditions of the applicable incentive plan.  How we support our colleagues  In addition to our comprehensive benefits package, we encourage a diverse workforce. Plus, our agile, inclusive environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging you to take time to focus on yourself.  We offer a variety of working style solutions, but we also recognize that flexibility goes beyond just the place of work... and we are all for it. We call this Smart Working! Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued. Aon values an innovative, diverse workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace.   Aon provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status.  Aon is committed to a diverse workforce and is an affirmative action employer. People with criminal histories are encouraged to apply.  We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation on **** Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.   Aon offers a comprehensive package of benefits for full-time and regular part-time colleagues, including, but not limited to: a 401(k) savings plan with employer contributions; an employee stock purchase plan; consideration for long-term incentive awards at Aon’s discretion; medical, dental and vision insurance, various types of leaves of absence, paid time off, including 12 paid holidays throughout the calendar year, 15 days of paid vacation per year, paid sick leave as provided under state and local paid sick leave laws, short-term disability and optional long-term disability, health savings account, health care and dependent care reimbursement accounts, employee and dependent life insurance and supplemental life and AD&D insurance; optional personal insurance policies, adoption assistance, tuition assistance, commuter benefits, and an employee assistance program that includes free counseling sessions.  Eligibility for benefits is governed by the applicable plan documents and policies.  #LI-LR1#LI-REMOTE ,skills:UNAVAILABLE,workHours:UNAVAILABLE,jobBenefits:,datePosted:2023-04-20T15:36: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:2024-04-20T16:34:14.000Z,industry:UNAVAILABLE,hiringOrganization:{@type:Organization,name:Aon Corporation,sameAs:****States}}}

Company info

Sign Up Now - WashingtondcCrossing.com