Data Reporting and Analytics Consultant III - SQL, TSQL, Python, DataBricks, Medicaid, Medicare[...]

Kaiser Permanente; Oakland (CA); Remote; USD 80,000 - 110,000; Full time

Job summary

An established industry player in healthcare is seeking a Data Reporting and Analytics Consultant to drive innovative data analytic strategies. In this role, you will leverage your expertise in SQL, TSQL, and Python to extract and analyze data from various sources, ensuring accuracy in Medicare and Medicaid claim submissions. Collaborating with cross-functional teams, you will develop reports and dashboards that empower data-informed decisions. This position offers a unique opportunity to contribute to impactful healthcare solutions while working remotely from any KP location in California. If you're passionate about data and analytics, this role is perfect for you!

Benefits

Health Insurance

Retirement Plan

Flexible Working Hours

Professional Development Opportunities

Remote Work Options

Qualifications

• 3+ years of experience in data analytics or related field.
• Strong knowledge of statistical programming and data visualization tools.

Responsibilities

• Support data-informed decisions by preparing and analyzing data.
• Develop and automate reporting solutions for stakeholders.

Skills

Data Extraction

Data Mining

Data Visualization Tools

Statistical Programming Language

Relational Database Management

Project Management

Business Planning

Education

Bachelor's degree in Mathematics

Bachelor's degree in Statistics

Bachelor's degree in Engineering

Bachelor's degree in Social/Physical/Life Science

Bachelor's degree in Business

Tools

SQL

TSQL

Python

DataBricks

Power BI

Job description

Remote from any KP location in CA, OR, CO, WA, GA, MD, VA, HI or D.C. Only.

** PLEASE NOTE: Salary ranges are geographically based and the posted range reflects the Northen CA region. Lower salary ranges will apply for other labor markets outside of NCAL

Overview:

This position will help drive creative data analytic approaches that lead to actionable strategies for ensuring that Medicare, ACA, and Medicaid claim submissions are complete and accurate by extracting and linking data from various data sources (e.g., Clarity, Membership, Submission, others) and systems (e.g. Synapse, Databricks) for analyses; preparing data for analyses, whether by the incumbent or other team members, using appropriate programming languages (e.g., SQL, TSQL, Python, other); developing reports and dashboards via Power BI, using automation, building quality checks and validation; support other members of the team on various data analytic projects.

Job Summary:

This individual contributor is primarily responsible for supporting data-informed decisions, gathering data and information on targeted variables in an established systematic fashion, and preparing data for analytic efforts. This position supports the execution of creative data analytic approaches leading to actionable outcomes, develops, implements, and automates business and reporting solutions, supports data analysis interpretation, and supports and develops analytical and/or statistical models enabling informed business decisions.

Essential Responsibilities:

+ Pursues self-development and effective relationships with others by proactively providing resources, information, advice, and expertise with coworkers and customers; influencing others through technical explanations and examples; providing occasional mentoring to team members; listening and responding to, seeking, and addressing performance feedback; creating plans to capitalize on strengths and develop weaknesses; anticipating and responding to the needs of others; and adapting to and learning from change, difficulties, and feedback.

+ Completes work assignments by applying up-to-date expertise in subject area to generate creative solutions; ensuring all procedures and policies are followed; leveraging an understanding of data, and resources to support projects or initiatives; collaborating cross-functionally to solve business problems; identifying and monitoring priorities, deadlines, and expectations; communicating progress and information; identifying, recommending, and implementing ways to address improvement opportunities; and escalating issues or risks as appropriate.

+ Supports and develops analytical and/or statistical models enabling informed business decisions by determining data and analytical requirements; creating models leading to actionable insights; and testing, refining, and validating models.

+ Gathers data and information on targeted variables in an established systematic fashion by validating data sources; querying, merging, and extracting data across sources; completing routine data refresh and update; developing and/or delivering tools for electronic data collection; and providing user training, support, and documentation.

+ Supports data analysis interpretation by applying findings to contextual settings under the guidance of more senior employees; and developing reports and presentations telling a compelling story to stakeholders to enable and influence decision making.

+ Develops, implements, and automates business and reporting solutions by working with stakeholders in their design, planning, and implementation while ensuring consistency and coherency; summarizing data and results; creating summary statistics; organizing data reports, visualizations, and/or interactive Business Intelligence (BI) reports; identifying needs for the development and implementation of additional reporting solutions; and preparing documentation as appropriate.

+ Prepares data for analytic efforts by consolidating data; reviewing data for quality and accuracy; profiling data inaccuracies; and cleaning and creating final data set(s) for analysis.

+ Supports data-informed decisions by consulting with clients to identify and clarify key business needs; developing outcomes and process measures; translating business requirements; determining data/information needs and data collection methods; developing analysis plans; measuring the impact of business decisions on clients, customers, and/or members; working with clients and staff to identify opportunities and methods to improve efficiencies with analysis; supporting and training end-users; and documenting processes and deliverables.

+ Supports the execution of creative data analytic approaches leading to actionable outcomes by identifying metrics to be analyzed; calculating algorithms; and conducting analyses under the guidance of more senior employees, including descriptive, correlational, inferential, and/or predictive statistics.

Minimum Qualifications:

+ Bachelors degree in Mathematics, Statistics, Engineering, Social/Physical/Life Science, Business, or related field and Minimum three (3) years experience in data analytics or a directly related field. Additional equivalent work experience in a directly related field may be substituted for the degree requirement.

Additional Requirements:

+ Knowledge, Skills, and Abilities (KSAs): Written Communication; Data Extraction; Data Mining; Data Visualization Tools; Statistical Programming Language; Relational Database Management; Project Management; Business Planning

COMPANY: KAISER

TITLE: Data Reporting and Analytics Consultant III - SQL, TSQL, Python, DataBricks, Medicaid, Medicare, Claims

LOCATION: Oakland, California

REQNUMBER: 1351453

External hires must pass a background check/drug screen. Qualified applicants with arrest and/or conviction records will be considered for employment in a manner consistent with Federal, state and local laws, including but not limited to the San Francisco Fair Chance Ordinance. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran, or disability status.