Sr Reporting Analyst (ROPS)
DavitaPosting Date
09/14/20262000 16th St, Denver, Colorado, 80202-5117, United States of AmericaWould you like to work for a company with Core Values such as TEAM and FUN? Do you want your work to make a difference? Are you looking to build your career in healthcare? Then, join our growing team, which offers abundant opportunities to develop your professional and personal skills, advance your career, and positively impact our patients' lives.
At DaVita, our mission is to be the provider, partner, and employer of choice! As a key member of our team of analysts, you will play a critical role in collaboration with teams across our Revenue Operations department, for developing analysis and managing projects to resolve revenue issues quickly, improving yield, and supporting our insurance and internal partners. This includes but is not limited to developing strategic recommendations across the team and department in key focus areas, such as revenue strategy, process improvements, and operations innovations. You will work directly with internal partners to resolve and manage high impact revenue issues. Much of the role will be focused in identifying opportunities with reimbursement, root causing and sizing these opportunities, and working with various internal and external partners to arrive at a solution to completion. The role has a high level of visibility with leadership given as our team supports this highest impact issues, and the requirement to work cross-functionally, and overall ability to impact the bottom line. The right candidate will be expected to: 1) perform data analyses and identify trends 2) effectively create and communicate key messages from analysis and propose and drive efficiencies 3) drive and lead projects start to finish.
This position is responsible for leading and demonstrating expertise in the report building process including partnering with business stakeholders to understand their requirements, identifying and aggregating data, building & automating using analytical tools and distributing to end users in order to drive action and identify opportunities across one or more business teams within Revenue Operations.
Essential Duties and Responsibilities:
Analysis & Technical
- Subject matter expert for understanding where to get data, how to pull it and how to use it across multiple databases (ex. EDW, SQL) in order to integrate into another database or report; assists others in finding the right data & correctly aggregating
- Writes requirements, designs, builds and automates highly complex reports utilizing advanced skills in tools such as Excel, SQL and Tableau (ex. Utilizing multiple different complex data sources, representing data capture at multiple points in time, designed in most efficient way to allow greater usability & minimizes production time)
- Assists others in building reports
- Continuously learns new technical capabilities & recommends how they can be leveraged
- Acts as a team resource for troubleshooting issues and QC’ing errors
- Utilizes technical skills to automate processes in addition to recurring reports (ex. Automates email distribution, creating automatic payment requests, automating QC processes, building temporary data capture needs for pilot processes)
Problem Solving:
- Understands how metrics across multiple reports and business lanes are interrelated and impact business outcomes
- Proactively raises awareness for how proposed changes may impact report accuracy & functionality including reports outside of their direct responsibility
- Translates data into actionable knowledge for the business; through building of complex reports; identifies opportunities and recommends actions to business leader using data within reports
- Leverages thorough understanding of source data to identify root cause of report issues & proposes solutions/fixes
Project & Stakeholder management:
- Develops report requirements by collecting input from business partners; makes recommendations to support more efficient or visually representative report build
- Effectively leads working sessions across multiple stakeholders; mentors others on building relationships with key stakeholders
- Directs & executes on next steps within projects for which they are responsible
- Prioritizes time according to value & business need
- Influences change and drives results
- Articulates technical issues to diverse audiences; provides the key takeaways, recommendations & gains alignment on next steps
Mentorship:
- Provides direction and help with others work; viewed as a mentor and expert across the team
- Other duties as assigned.
Travel 5-10% of time (1-2 onsite meetings a year)
The above statements describe the general nature and level of work being performed by individuals employed in this position. This job description is not intended to be an exhaustive list of all duties and responsibilities required in this position. This job description does not constitute an employment contract.
Qualifications:
Required:
- Bachelor's degree in a related field of study
- 6-8+ years of data analysis and Excel pivot table and query building experience; Ability to analyze complex data to be proactive in business decisions
- Advanced skills in one of more analytical or report building tools such as Excel, SQL, Tableau, Python, VBA, and/or Power BI
- Expert in computer proficiency in Microsoft Office tools with an emphasis on Microsoft Excel, Access, Outlook, Word, PowerPoint, Visio, SharePoint and Teams
- Strong analytical and report building skills
- Ability to communicate complex ideas in a simple, easily digestible manner to a range of audiences
- Ability to work independently, multi-task, and meet deadlines in a fast-paced, deadline driven environment
- Fluent in the written and verbal skills necessary to successfully perform the essential functions, duties, and responsibilities of the position
- Commitment to DaVita’s Core Values
Preferred:
- Master’s Degree
- Experience in healthcare or revenue cycle
- Demonstrated strengths in organization, attention-to-detail, follow-through, reasoning, critical thinking, and problem-solving skills
- Experience working in and coding in SQL and/or Python, VBA, Power BI, Microsoft Access, Excel Macros, and Tableau, Netezza, Google Cloud
- Relative coding and Excel certifications
Additional Success Factors
- Demonstrated drive, ambition, and strong sense of accountability
- Team player
- Ambitious and proactive
- Experience with various data analytics tools and processes (including SQL, database development and management, Tableau, Google Cloud, and data visualization)
Here is what you can expect when you join our Village:
- A "Community first, Company second" culture based on Core Values that really matter.
- Clinical outcomes consistently ranked above the national average.
- Award-winning education and training across multiple career paths to help you reach your potential.
- Performance-based rewards based on stellar individual and team contributions.
- A comprehensive benefits package designed to enhance your health, your financial well-being and your future.
- Dedication, above all, to caring for patients suffering from chronic kidney failure around the world. • High school diploma or equivalent required
- Minimum of three (3) years' healthcare reimbursement experience preferred ; experience with admissions, billing, and collections preferred
- Demonstrated knowledge of insurance rules, regulations and Coordination of Benefits for federal, state, and managed care payors in multiple states preferred
- Basic computer skills and proficiency in MS Word, Excel, and Outlook required
- Join us as we pursue our vision "To Build the Greatest Healthcare Community the World has Ever Seen."
What We’ll Provide:
More than just pay, our DaVita Rewards package connects teammates to what matters most. Teammates are eligible to begin receiving benefits on the first day of the month following or coinciding with one month of continuous employment. Below are some of our benefit offerings.
- Comprehensive benefits: Medical, dental, vision, 401(k) match, paid time off, PTO cash out
- Support for you and your family: Family resources, EAP counseling sessions, access Headspace®, backup child and elder care, maternity/paternity leave and more
- Professional development programs: DaVita offers a variety of programs to help strong performers grow within their career and also offers on-demand virtual leadership and development courses through DaVita’s online training platform StarLearning.
ADA:
DaVita provides reasonable accommodations to enable otherwise qualified individuals with disabilities to perform the essential Physical and/or Mental functions of a position.
Why wait? Explore a career with DaVita today.
Go to http://careers.davita.com to learn more or apply.
#LI-JH4
At DaVita, we strive to be a community first and a company second. We want all teammates to experience DaVita as "a place where I belong." Our goal is to embed belonging into everything we do in our Village, so that it becomes part of who we are. We are proud to be an equal opportunity workplace and comply with state and federal affirmative action requirements. Individuals are recruited, hired, assigned and promoted without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, protected veteran status, or any other protected characteristic.
This position will be open for a minimum of three days.
The Salary Range for the role is $70,000.00 - $106,000.00 per year.
If a candidate is hired, they will be paid at least the minimum wage according to their geographical jurisdiction and the exemption status for the position.New York Exempt: New York City and Long Island: $66,300.00/year, Nassau, Suffolk, and Westchester counties: $66,300.00/year, Remainder of New York state: $62,353.20/year New York Non-exempt: New York City and Long Island: $17.00/hour, Nassau, Suffolk, and Westchester counties: $17.00/hour, Remainder of New York state: $16.00/hourWashington Exempt: $80,168.40/year Washington Non-exempt: Bellingham: $19.13/hour, Burien: $21.71/hour, Everette: $20.77/hour, Unincorporated King County: $20.82/hour, Renton: $21.57/hour, Seattle: $21.30/hour, Tukwila: $21.65/hour, Remainder of Washington state: $17.13/hour
For location-specific minimum wage details, see the following link: DaVita.jobs/WageRates
Compensation for the role will depend on a number of factors, including a candidate’s qualifications, skills, competencies and experience. DaVita offers a competitive total rewards package, which includes a 401k match, healthcare coverage and a broad range of other benefits. Learn more at https://careers.davita.com/benefits
Colorado Residents: Please do not respond to any questions in this initial application that may seek age-identifying information such as age, date of birth, or dates of school attendance or graduation. You may also redact this information from any materials you submit during the application process. You will not be penalized for redacting or removing this information.