Data Warehouse Consultant

Profile

Aon is looking for a Data Warehouse Consultant/Senior Consultant - Health Solutions Analytics As 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 based on Data & Analytics working out of either our Chicago, IL or Atlanta, GA office with flexibility to consider remote or other Aon offices in the US. 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.  Your impact as a Data Warehouse Consultant- Health Solutions Analytics Overview This position is part of our broader Commercial Analytics team within Aon Health Solutions. Our team of individuals excel at assessing customers’ data-based needs and ensuring customers (internal and external) receive a high value return. The team is a mix of data managers, data scientists, reporting data analysts, SQL/MS Office/Tableau/PowerBI/Python/R programming experts, statisticians, actuaries, and custom solution architects. Our group delivers and supports a wide array of reporting tools, special projects, and methodology development to address the analytic needs of our data-driven clients. What a Day Will Look Like:Support Aon’s national data warehouse team: Work with Aon clients, national Commercial Analytics team members, client team members, and Aon’s data warehouse vendor partners to support clients’ investments in data warehousing including supporting client implementations, data quality assurance, analytic content creation, ad hoc requests, and user support.Actively engage in peer review; have documents reviewed and review others to ensure high quality.Assist in coordination and creation of team process documentation.Using a keen eye for detail, ensure trackers and issue logs are maintained and up to date. Coordinate with vendor partners and internal partners to facilitate start to finish issue resolution.Support analytic consulting team as required by querying data and building reports and analytic content that support clients and internal team member reporting requests and requests for deeper dive review.Create analytic content visualizations leveraging our data warehouse tools. Other duties as assigned.You Bring Knowledge and Expertise:Required Experience:3 plus years of experience manipulating large sets of health-related dataExperience with employer plan designs -- medical, pharmacy, enrollment, behavioral health, lost time, care management, population health programs, etc.Experience with analytic deliverable creation, review and financial reporting validation, quality control and reconciliationPreferred Experience:Experience using data warehouse decision support tools such as Merative/IBM/Truven, Cotiviti, HDMS, Artemis, Springbuk or other similar vendorsExperience with Medical, Eligibility and Pharmacy claim coding patterns including CPT, DRG, ICD10 and other industry standard classificationsExperience implementing health data feeds and troubleshooting data quality issuesExperience with analytic methodologies such as episode of care groupers, health risk scores, service categories, provider attribution and other industry standard analytic practicesExperience handling multiple prioritiesExperience building data-based reports/models/tools/processes and experience with any mix of the following:MS Excel and Power PivotSQL/SQL ServerReporting template developmentOther business intelligence/data visualization tools – Tableau, Power BIEducation:Bachelor’s degree in relevant discipline or equivalent years of industry experience We offer youIn 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.  The salary range for this position is $100,000-$120,000 per year. The actual salary will vary based on applicant’s education, experience, skills, and abilities. The salary may also be adjusted based on applicant’s geographic location. This position is eligible to participate in one of Aon’s annual incentive plans to receive an annual 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.   2523397,qualifications:UNAVAILABLE,responsibilities:Aon is looking for a Data Warehouse Consultant/Senior Consultant - Health Solutions Analytics As 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 based on Data & Analytics working out of either our Chicago, IL or Atlanta, GA office with flexibility to consider remote or other Aon offices in the US. 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.  Your impact as a Data Warehouse Consultant- Health Solutions Analytics Overview This position is part of our broader Commercial Analytics team within Aon Health Solutions. Our team of individuals excel at assessing customers’ data-based needs and ensuring customers (internal and external) receive a high value return. The team is a mix of data managers, data scientists, reporting data analysts, SQL/MS Office/Tableau/PowerBI/Python/R programming experts, statisticians, actuaries, and custom solution architects. Our group delivers and supports a wide array of reporting tools, special projects, and methodology development to address the analytic needs of our data-driven clients. What a Day Will Look Like:Support Aon’s national data warehouse team: Work with Aon clients, national Commercial Analytics team members, client team members, and Aon’s data warehouse vendor partners to support clients’ investments in data warehousing including supporting client implementations, data quality assurance, analytic content creation, ad hoc requests, and user support.Actively engage in peer review; have documents reviewed and review others to ensure high quality.Assist in coordination and creation of team process documentation.Using a keen eye for detail, ensure trackers and issue logs are maintained and up to date. Coordinate with vendor partners and internal partners to facilitate start to finish issue resolution.Support analytic consulting team as required by querying data and building reports and analytic content that support clients and internal team member reporting requests and requests for deeper dive review.Create analytic content visualizations leveraging our data warehouse tools. Other duties as assigned.You Bring Knowledge and Expertise:Required Experience:3 plus years of experience manipulating large sets of health-related dataExperience with employer plan designs -- medical, pharmacy, enrollment, behavioral health, lost time, care management, population health programs, etc.Experience with analytic deliverable creation, review and financial reporting validation, quality control and reconciliationPreferred Experience:Experience using data warehouse decision support tools such as Merative/IBM/Truven, Cotiviti, HDMS, Artemis, Springbuk or other similar vendorsExperience with Medical, Eligibility and Pharmacy claim coding patterns including CPT, DRG, ICD10 and other industry standard classificationsExperience implementing health data feeds and troubleshooting data quality issuesExperience with analytic methodologies such as episode of care groupers, health risk scores, service categories, provider attribution and other industry standard analytic practicesExperience handling multiple prioritiesExperience building data-based reports/models/tools/processes and experience with any mix of the following:MS Excel and Power PivotSQL/SQL ServerReporting template developmentOther business intelligence/data visualization tools – Tableau, Power BIEducation:Bachelor’s degree in relevant discipline or equivalent years of industry experience We offer youIn 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.  The salary range for this position is $100,000-$120,000 per year. The actual salary will vary based on applicant’s education, experience, skills, and abilities. The salary may also be adjusted based on applicant’s geographic location. This position is eligible to participate in one of Aon’s annual incentive plans to receive an annual 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.  ,skills:UNAVAILABLE,workHours:UNAVAILABLE,jobBenefits:UNAVAILABLE,datePosted:2023-01-26T17:50: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-01-26T17:51:56.000Z,industry:UNAVAILABLE,hiringOrganization:{@type:Organization,name:Aon Corporation,sameAs:****E Randolph,postalCode:60601,addressCountry:United States}}}

Company info

Sign Up Now - WashingtondcCrossing.com