Financial Decision Support Data Specialist

King County   Seattle, WA   Full-time     Accounting
Apply Now
Posted on November 17, 2020
Summary

SUMMARY

Public Health – Seattle and King County values diverse perspectives and life experiences.  The Department encourages people of all backgrounds to apply, including people of color, immigrants, refugees, women, LGBTQ, people with disabilities, and veterans.

COMMITMENT TO EQUITY AND SOCIAL JUSTICE: 
As the only Public Health jurisdiction in the world named after Dr. Martin Luther King, Jr., one of the most influential civil rights leaders in our nation's history, King County is a vibrant international community with residents that represent countries from around the world. It is a region with increasing diversity that cherishes the traditions of many cultures.
 
We have a deep commitment to equity and social justice and advancing practices, strategies and policies that promote fairness, justice and opportunity for all – in our workplaces and our communities. With this commitment, King County has adopted a pro-equity agenda to advance regional change and ensure that residents from vulnerable communities are incorporated into our emergency planning and public outreach efforts.

The selected candidate will integrate King County's Equity and Social Justice principles into the daily functions of this position.

Public Health- Seattle & King County (PHSKC) is seeking an inquisitive and dedicated Financial Decision Support Data Specialist (Functional Analyst III) to join its Community Health Services Division (CHS), Business and Revenue Unit.
 
ABOUT THE COMMUNITY HEALTH SERVICES DIVISION:
The Business and Revenue Unit manages the business processes of health care billing in order to generate revenue for direct patient care services in the Community Health Services Division and the Prevention Division.  The information developed and provided by the Business and Revenue Unit monitors process efficiencies and areas for improvement that drive financial performance.  This information assists programs in operational decision making, business planning, budget development and forecasting. The Business and Revenue Unit regularly performs internal audits to assure compliance with federal and state rules and regulations and participates in external audits with third party payors.
 
The closing date of this position is November 29, 2020 at 11:59pm. However, this posting may be extended beyond that date if necessary to garner a more competitive applicant pool. 

WHO MAY APPLY: This Career Service position is open to all applicants.
 
WORK LOCATION: This position will be required to telecommute, and occasionally be required to work onsite at the Chinook Building- located at 401 5th Ave in Seattle.

TEMPORARY TELECOMMUTING REQUIREMENT:
Some of the work associated with this position will be performed remotely, at least through July 5, 2021 in compliance with King County’s telecommuting mandate.  Employees will be provided with a County issued laptop and must maintain a workspace with an internet connection where they can reliably perform work and remain available and responsive during scheduled work hours.

Employees must reside in WA state and within a reasonable distance to their King County worksite to respond to workplace reporting requirements.  There will be situations where the employee is required to report to a County worksite.  Please note that when an employee conducts work that is likely to bring them in contact with another individual, safety precautions are required by the department in alignment with the Public Health Directive from the Seattle & King County Public Health Officer.
 
To support employees during this time King County has a robust collection of tools and resources to support working remotely. The individual selected for this opportunity will be joining an innovative and progressive team. King County is doing its part to reduce the spread of COVID-19 and remains committed to reducing our carbon footprint.
 
This position will be working with large data sets and may need a high-speed internet connection to perform its essential functions.

WORK SCHEDULE: The specific workdays and hours are flexible and subject to program approval. This position is not subject to the Fair Labor Standards Act. 


Job Duties

The primary responsibility of the job is to define, produce and maintain data and reports by developing a comprehensive understanding of the billing system (Epic), the generated data from the system, and by gathering, refining and translating business requirements from users to apply to available data. The individual will have strong analytic and query writing skills in order to maximize the value of the data by evaluating data integrity and applying concepts to further categorize and define data from the billing system. The person will help identify and scope issues and employ effective problem-solving strategies to assure all aspects of data processing and analysis meet end-user/customer needs. The successful candidate will provide a high level of support to the Business and Revenue Unit and Community Health Services (CHS) and Prevention Division program leadership, often in a time-sensitive manner. The position may provide project leadership to same or lower level staff.

Teamwork

  1. Work effectively with team members to understand work processes and downstream reporting needs.  Understand the scope of programs in CHS/Prevention divisions and standard reporting metrics used by the programs.  
  2. Lead a group of analysts with similar job duties for information sharing and consistency/ standardization of data definitions and reporting metrics.
  3. Facilitate and lead planning and process improvement teams in support of systems and participate as a key member on upgrade or new system acquisition team.
Database concepts and Epic structure
  1. Develop data mining programs to extract and reprocess data; analyze computer generated information from multiple sources to ensure data integrity across all systems 
  2. Analyze data integrity by querying and reporting on a highly complex department-wide data system within a major relational database and solving related data processing problems;
  3. Normalize data, troubleshoot and resolve the most complex information processing and reporting problems, and work with appropriate specialized IT staff and/or vendors to resolve problems.
  4. Analyze proposed changes with system upgrades and recommend strategies for implementation, ensure data integrity during/following all installs and conversion processes.
Reporting and Data Visualization
  1. Gather, define, map, refine, and translate complex report specifications.  
  2. Build complex queries to extract data to generate ad-hoc and routine reports; design, test and revise formats and analyze data to ensure information meets user needs.
  3. Conduct ad hoc data analysis for purposes of ensuring accurac­y of information.
  4. Organize and generate data reports in multiple user formats (i.e. Excel, Tableau), laying out and presenting data, producing and distributing polished reports.  
  5. Provide support to end-users to assure data integrity, version control of relevant documents, and assist with the appropriate prioritization of report development.   
  6. Train all staff on how to develop and/or use reports which include the development of training materials and report documentation; serve as an on-going resource, providing direction, training and guidance to users.
Data Analysis
  1. Perform data analysis of report information, evaluate findings to ensure accurate interpretation of mission-critical data, and work with users to design report format and content changes to accurately reflect information.
  2. Propose efficiencies and business process improvements, troubleshoot, track, resolve and document significant system problems and issues requiring advanced technical expertise.  
  3. Perform other duties as assigned.

Experience, Qualifications, Knowledge, Skills

MINIMUM QUALIFICATIONS 
·       Advanced skills in large scale relational databases, their design, and use in end-user systems
·       Knowledge, understanding and skill in the application of data conversion analyses, design, and troubleshooting applications
·       Skill in using report and query writing languages such as advanced T-SQL
·       Experience developing reports and display of data such as the production of Power BI and SSRS reports, Tableau data visualization, and Excel.  
·       Experience writing data and report documentation
·       Advanced knowledge of statistical concepts
·       Skill in financial analysis and knowledge of standard financial business metrics
·       Organization and planning skills for handling multiple competing priorities and producing quality detailed work within tight timeframes
·       Skill in analytical thinking, researching, problem solving, troubleshooting, and making recommendations and decisions
·       Skill in working effectively as a member of teams with members from diverse backgrounds, and with demonstrated ability to lead teams, facilitate meetings, and provide presentations.
·       Skill in using common desktop tools including but not limited to Microsoft Office Suite: Excel, Access, Teams and SharePoint
·       Skill in oral and written communication including conducting technical training and presentations
 
PREFERRED QUALIFICATIONS
·       Knowledge of industry standard health care billing rules and processes
·       Knowledge of Epic Practice Management applications including Resolute, Prelude and Cadence
·       Knowledge of Epic reporting tools including Reporting Workbench and the Clarity database
·       Experience using Crystal Reports to develop reports

Supplemental Information

 
SUPPLEMENTAL INFORMATION: 
Forbes recently named King County as one of Washington State's best employers. 
 
Together, with leadership and our employees, we're changing the way government delivers service and winning national recognition as a model of excellence. Are you ready to make a difference? Come join the team dedicated to serving one of the nation's best places to live, work and play. 
 
Guided by our "True North", we are making King County a welcoming community where every person can thrive. We value diversity, inclusion and belonging in our workplace and workforce. To reach this goal we are committed to workforce equity. Equitable recruiting, support, and retention is how we will obtain the highest quality workforce in our region; a workforce that shares and will help advance our guiding principles--we are one team; we solve problems; we focus on the customer; we drive for results; we are racially just; we respect all people; we lead the way; and we are responsible stewards. We encourage people of all backgrounds and identities to apply, including Native American and people of color, immigrants, refugees, women, LGBTQ+, people living with disabilities, and veterans.
 
King County is an Equal Employment Opportunity (EEO) Employer
No person is unlawfully excluded from employment opportunities based on race, color, religion, national origin, sex (including gender identity, sexual orientation and pregnancy), age, genetic information, disability, veteran status, or other protected class. Our EEO policy applies to all employment actions, including but not limited to recruitment, hiring, selection for training, promotion, transfer, demotion, layoff, termination, rates of pay or other forms of compensation.
 
To Apply
If you are interested in pursuing this position, please follow the application instructions carefully. If you need this announcement in an alternate language or format, would like to request accommodation or assistance in the application or assessment process or if you have questions please contact your recruiter listed on this job announcement.
 
APPLICATION PROCESS: 
A complete application packet will consist of the following:
  • NEOGOV/Government Jobs on-line or paper application 
  • CV or resume 
  • Responses to Supplemental Questions

You may attach multiple documents if you wish with your application:
  • Copy and paste one or more documents into the text resume section of the application. 
  • Attach multiple documents/files in the resume attachment section.

Your application may be rejected as incomplete if you do not include the relevant information in the application. Cover letters and/or resumes are not accepted in lieu of a completed application. Applications and/or Supplemental Questionnaires that state "see my resume" or "see my personnel file" are considered incomplete and will not be accepted.
  • The selection process may include but is not limited to: evaluation of application materials and supplemental questions, interviewing, and testing. For more information on our selection process, please refer to www.kingcounty.gov/depts/health/jobs/hiring. 
  • Regular and reliable attendance, effective communication skills, and development of effective working relationships are requirements of all Public Health positions. 
  • Staff may be required to play an active role in the event of a public health emergency, which may include changes in responsibilities, work location and working hours.

NECESSARY SPECIAL REQUIREMENTS:
  • The selected candidate will be required to pass a thorough background investigation.
  • Employees are required to protect the privacy and security of protected health information as defined in State and Federal Law. 
  • Employees are required to adhere to OSHA/WISHA guidelines including but not limited to completing required training on time.

CONTACT: For questions about the position, contact Cristin Burris at cristin.burris@kingcounty.gov. For questions about the application process, contact Catherine Fitzpatrick at Catherine.fitzpatrick@kingcounty.gov.

UNION AFFILIATION: This position is not represented.

King County offers a highly-competitive compensation and benefits package designed to meet the diverse needs of our employees and support our employees' health and well-being.  Eligible positions receive the following benefits and have access to the following programs:

  • Medical, dental, and vision coverage: King County pays 100% of the premiums for eligible employees and family members
  • Life and disability insurance: employees are provided basic coverage and given the opportunity to purchase additional insurance for both the employee and eligible dependents
  • Retirement: King County employees are eligible to participate in a pension plan through the Washington State Department of Retirement Systems and a 457(b) deferred-compensation plan
  • Transportation program and ORCA transit pass
  • 10 paid holidays each year (plus 2 personal holidays)
  • Generous vacation and paid sick leave
  • Paid parental leave, family and medical leaves, and volunteer leave
  • Flexible Spending Account
  • Wellness programs
  • Onsite gyms and activity centers
  • Employee giving program
  • Employee assistance programs
  • Flexible schedules and telecommuting options, depending on position
  • Training and career development programs
For additional information about employee benefits please visit our Benefits, Payroll, and Retirement Page.

This is a general description of the benefits offered to eligible King County employees, and every effort has been made to ensure its accuracy.  If any information on this document conflicts with the provisions of a collective bargaining agreement (CBA), the CBA prevails.  Also, in the event of any incorrect information in this document, applicable laws, policies, rules, CBAs, or official plan documents will prevail.
 
NOTE:  Benefits for Term Limited Temporary (TLT) or Short Term Temporary (STT) positions, including leave eligibility and/or participation in the pension plan through the Washington State Department of Retirement Systems, will vary based upon the terms and details of the position. Short Term Temporary positions are not eligible for an ORCA transit pass.
 
For inquiries about the specifics of this position, please contact the recruiter identified on this job posting.

01
Do you have advanced skill in large-scale relational databases, their design, and end-user systems?
  • Yes
  • No
02
If you answered yes to the previous question, indicate which systems and include where you got this experience. If you do not have this experience, enter n/a.
03
Do you have advanced skill in using report and query writing languages, such as advanced T-SQL?
  • Yes
  • No
04
If you answered yes to the previous question, indicate which languages, and where you obtained this experience. If you do not have this experience, enter n/a.
05
Do you have experience performing financial analysis using data sets?
  • Yes
  • No
06
If you answered yes to the previous question, please describe that experience or knowledge, including where you got it. If you do not have this experience or knowledge, enter n/a.
07
Do you have experience using Epic applications or reporting tools?
  • Yes
  • No
08
If you answered yes to the previous question, please describe that experience or knowledge, including where you got it. If you do not have this experience or knowledge, enter n/a.
09
Are you applying to this position as a Priority Placement Program Participant And Is this position the same or lower percentage of full-time when compared to the position held at the point of the notification of layoff AND Do you possess the skills and abilities to qualify for this position?
  • Yes, I was given a layoff notice from my role at King County AND I am within two years of the effective date of my layoff. AND The position I was laid off from was the same or a higher percentage of FT status when compared to this one.
  • No.
10
If you answered yes to the question above and you are applying for this position as a Priority Placement Participant, to be considered, you must provide the following three pieces of information in the space provided: 1. The title you held when you received your layoff notice 2. The department you worked in 3. The effective date of your layoff

Required Question