Intermountain Health
Data Analyst -Technical - Senior
Intermountain Health, Salt Lake City, Utah, United States, 84193
Job Description:
Employer: SelectHealth, Inc.
Job Title:
Data Analyst - Technical - Senior
Degree Required:
Master's degree or equivalent foreign education
Academic Discipline(s):
Business Analytics, Information System, Data Analytics, Statistics, or Mathematics
Experience Required:
2 years of experience
Alternate Occupations
Accepted:
Business Analytics, Information System Data Analytics, Statistics, or Mathematics
Job Description:
Advanced Data Analysis: Analyze and interpret large, complex datasets to extract actionable insights that inform strategic decision-making and enhance pharmacy operations; Design and develop predictive models using advanced statistical techniques and machine learning algorithms to forecast future trends and patterns in prescription drug usage, operational metrics, pharmacy operations, drug price, and cusmoter outcomes; Continuously monitor the performance of predictive models in production, making adjustments as necessary to maintain accuracy and relevance.
Advanced Report: Create report templates that answer multiple related questions as well as reports with linked content, drilldown, and nested parameters formatted in such a way that leads the user through the report in a well-organized, easy to understand fashion; Create autmoated/ self-service report to allow analytic customers to request and modify their customized report; Collaborating with corporate and region resources to design, create, test, and implement analytic tools such as databases, reports, web applications, and dashboards that support enterprise/region needs to improve data collection and reporting strategies to minimize duplication, and redundancy.
Cloud Service and automation: Design, develop, and maintain cloud-based data pipelines and ETL processes to ensure efficient data flow and integration from various sources; Develop scalable data storage solutions using cloud technologies to handle large volumes of pharmacy data and support advanced analytics; Implement robust security measures and compliance protocols to protect sensitive pharmacy data stored in the cloud.
Data Collection and Cleaning: Collect, clean, and analyze pharmacy data, including prescription records, patient data, and drug information.
Descriptive Report Generation: Generate reports to communicate key insights to pharmacy staff, management, and other departments.
Ad-hoc query in SQL: including basic selects, joins, use of Where clause, and simple functions including Trunc, Sum, Min, Max, Avg, and Concat
Quality Assurance: Implement and perform regular quality checks to ensure data accuracy and integrity for area in charge; Lead initiatives to enhance data quality processes and train team members on best practices.
Performance Metrics: Develop and track key performance indicators (KPIs) to measure the effectiveness of pharmacy operations; Create detailed reports and visualizations to communicate performance metrics and findings to stakeholders, ensuring clarity and actionable insights.
Regulatory Reporting: Ensure compliance with industry regulations and standards by monitoring data accuracy and integrity.Prepare and submit detailed reports to regulatory agencies, ensuring compliance with all relevant laws and guidelines.
Project Management: Lead and manage all pharmacy data analysis projects in RFP related area, ensuring timely and accurate delivery of results; Coordinate with cross-functional teams to allocate resources effectively and ensure that project tasks are completed on time; Track project performance using appropriate tools and techniques, and report on progress, challenges, and achievements to stakeholders.
Stakeholder Collaboration: Work closely with stakeholders to gather detailed business requirements, ensuring that data projects align with business needs and objectives; Maintain regular communication with stakeholders to provide updates on project progress, gather feedback, and make necessary adjustments.
Mentorship and Training: Provide ongoing training and development opportunities for junior analysts to enhance their technical skills and analytical capabilities. Providing consultation, data analysis, and project management for clinical and business stakeholders across the organization.
Document: Document work and projects per enterprise-wide standards such as reports, project tracking, databases.
This is a hybrid position requiring in-person presence three times per month. Position may telecommute within reasonable commuting distance of Murray, UT.
Minimum Qualifications:
Knowledge of SQL, including complex joins, union, window function, CTE, pivoting, recursive queries, string manipulation, external query filter, and query optimization.
Knowledge of data architecture, including database designing, data modeling, data pipeline, and standardizing data structures.
Knowledge of descriptive and predictive data analysis.
Knowledge of data visualizations including charts, workbook, and dashboard.
Knowledge of Microsoft Azure Platform.
Knowledge of Microsoft Power Automation.
Knowledge of scaled agile teams (SAFe®) product and project management.
Knowledge of Power Automate or equivalent automation tool.
Knowledge of processing PHI and PII data.
Knowledge of pharmacy benefit management (PBM), including request for pricing (RFP), rebate, Medi-Span's therapeutic catgory and MONY codes, drug alternative, and disruptions.
Upon hire, all applicants will be subject to drug testing/screening and background checks.
Salary (Annual): $97,386.00 - $107,386.00
Work Location: 5381 Green Street, Murray, UT 84123; This is a hybrid position requiring in-person presence three times per month. Position may telecommute within reasonable commuting distance of Murray, UT.
Hours of work: Usually 8:00 a.m. to 5:00 p.m., Monday through Friday
Applicants interested in applying for this position should go to https://imh.wd5.myworkdayjobs.com/IntermountainCareers and search for the job title above or search for Job Number R150956 or email resume to Mary Hansen at mary.hansen@imail.org. Applicants who fail to provide a resume and pre-screening question responses will not be considered. This position is for permanent direct hire only; applications for contract labor will not be considered.
Physical Requirements:
Location:
SelectHealth - Murray
Work City:
Murray
Work State:
Utah
Scheduled Weekly Hours:
40
The hourly range for this position is listed below. Actual hourly rate dependent upon experience.
$43.92 - $69.16
We care about your well-being - mind, body, and spirit - which is why we provide our caregivers a generous benefits package that covers a wide range of programs to foster a sustainable culture of wellness that encompasses living healthy, happy, secure, connected, and engaged.
Learn more about our comprehensive benefits package here (https://intermountainhealthcare.org/careers/benefits) .
Intermountain Health is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
At Intermountain Health, we use the artificial intelligence ("AI") platform, HiredScore to improve your job application experience. HiredScore helps match your skills and experiences to the best jobs for you. While HiredScore assists in reviewing applications, all final decisions are made by Intermountain personnel to ensure fairness. We protect your privacy and follow strict data protection rules. Your information is safe and used only for recruitment. Thank you for considering a career with us and experiencing our AI-enhanced recruitment process.
All positions subject to close without notice.
Employer: SelectHealth, Inc.
Job Title:
Data Analyst - Technical - Senior
Degree Required:
Master's degree or equivalent foreign education
Academic Discipline(s):
Business Analytics, Information System, Data Analytics, Statistics, or Mathematics
Experience Required:
2 years of experience
Alternate Occupations
Accepted:
Business Analytics, Information System Data Analytics, Statistics, or Mathematics
Job Description:
Advanced Data Analysis: Analyze and interpret large, complex datasets to extract actionable insights that inform strategic decision-making and enhance pharmacy operations; Design and develop predictive models using advanced statistical techniques and machine learning algorithms to forecast future trends and patterns in prescription drug usage, operational metrics, pharmacy operations, drug price, and cusmoter outcomes; Continuously monitor the performance of predictive models in production, making adjustments as necessary to maintain accuracy and relevance.
Advanced Report: Create report templates that answer multiple related questions as well as reports with linked content, drilldown, and nested parameters formatted in such a way that leads the user through the report in a well-organized, easy to understand fashion; Create autmoated/ self-service report to allow analytic customers to request and modify their customized report; Collaborating with corporate and region resources to design, create, test, and implement analytic tools such as databases, reports, web applications, and dashboards that support enterprise/region needs to improve data collection and reporting strategies to minimize duplication, and redundancy.
Cloud Service and automation: Design, develop, and maintain cloud-based data pipelines and ETL processes to ensure efficient data flow and integration from various sources; Develop scalable data storage solutions using cloud technologies to handle large volumes of pharmacy data and support advanced analytics; Implement robust security measures and compliance protocols to protect sensitive pharmacy data stored in the cloud.
Data Collection and Cleaning: Collect, clean, and analyze pharmacy data, including prescription records, patient data, and drug information.
Descriptive Report Generation: Generate reports to communicate key insights to pharmacy staff, management, and other departments.
Ad-hoc query in SQL: including basic selects, joins, use of Where clause, and simple functions including Trunc, Sum, Min, Max, Avg, and Concat
Quality Assurance: Implement and perform regular quality checks to ensure data accuracy and integrity for area in charge; Lead initiatives to enhance data quality processes and train team members on best practices.
Performance Metrics: Develop and track key performance indicators (KPIs) to measure the effectiveness of pharmacy operations; Create detailed reports and visualizations to communicate performance metrics and findings to stakeholders, ensuring clarity and actionable insights.
Regulatory Reporting: Ensure compliance with industry regulations and standards by monitoring data accuracy and integrity.Prepare and submit detailed reports to regulatory agencies, ensuring compliance with all relevant laws and guidelines.
Project Management: Lead and manage all pharmacy data analysis projects in RFP related area, ensuring timely and accurate delivery of results; Coordinate with cross-functional teams to allocate resources effectively and ensure that project tasks are completed on time; Track project performance using appropriate tools and techniques, and report on progress, challenges, and achievements to stakeholders.
Stakeholder Collaboration: Work closely with stakeholders to gather detailed business requirements, ensuring that data projects align with business needs and objectives; Maintain regular communication with stakeholders to provide updates on project progress, gather feedback, and make necessary adjustments.
Mentorship and Training: Provide ongoing training and development opportunities for junior analysts to enhance their technical skills and analytical capabilities. Providing consultation, data analysis, and project management for clinical and business stakeholders across the organization.
Document: Document work and projects per enterprise-wide standards such as reports, project tracking, databases.
This is a hybrid position requiring in-person presence three times per month. Position may telecommute within reasonable commuting distance of Murray, UT.
Minimum Qualifications:
Knowledge of SQL, including complex joins, union, window function, CTE, pivoting, recursive queries, string manipulation, external query filter, and query optimization.
Knowledge of data architecture, including database designing, data modeling, data pipeline, and standardizing data structures.
Knowledge of descriptive and predictive data analysis.
Knowledge of data visualizations including charts, workbook, and dashboard.
Knowledge of Microsoft Azure Platform.
Knowledge of Microsoft Power Automation.
Knowledge of scaled agile teams (SAFe®) product and project management.
Knowledge of Power Automate or equivalent automation tool.
Knowledge of processing PHI and PII data.
Knowledge of pharmacy benefit management (PBM), including request for pricing (RFP), rebate, Medi-Span's therapeutic catgory and MONY codes, drug alternative, and disruptions.
Upon hire, all applicants will be subject to drug testing/screening and background checks.
Salary (Annual): $97,386.00 - $107,386.00
Work Location: 5381 Green Street, Murray, UT 84123; This is a hybrid position requiring in-person presence three times per month. Position may telecommute within reasonable commuting distance of Murray, UT.
Hours of work: Usually 8:00 a.m. to 5:00 p.m., Monday through Friday
Applicants interested in applying for this position should go to https://imh.wd5.myworkdayjobs.com/IntermountainCareers and search for the job title above or search for Job Number R150956 or email resume to Mary Hansen at mary.hansen@imail.org. Applicants who fail to provide a resume and pre-screening question responses will not be considered. This position is for permanent direct hire only; applications for contract labor will not be considered.
Physical Requirements:
Location:
SelectHealth - Murray
Work City:
Murray
Work State:
Utah
Scheduled Weekly Hours:
40
The hourly range for this position is listed below. Actual hourly rate dependent upon experience.
$43.92 - $69.16
We care about your well-being - mind, body, and spirit - which is why we provide our caregivers a generous benefits package that covers a wide range of programs to foster a sustainable culture of wellness that encompasses living healthy, happy, secure, connected, and engaged.
Learn more about our comprehensive benefits package here (https://intermountainhealthcare.org/careers/benefits) .
Intermountain Health is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
At Intermountain Health, we use the artificial intelligence ("AI") platform, HiredScore to improve your job application experience. HiredScore helps match your skills and experiences to the best jobs for you. While HiredScore assists in reviewing applications, all final decisions are made by Intermountain personnel to ensure fairness. We protect your privacy and follow strict data protection rules. Your information is safe and used only for recruitment. Thank you for considering a career with us and experiencing our AI-enhanced recruitment process.
All positions subject to close without notice.