DSHS FTAA Epic Senior Business Intelligent Analyst

DSHS FTAA IT Data Management - Senior Specialist

We are seeking an experienced Epic Senior Business Intelligent Analyst to join our team at the Finance Technology Analytics and Accounting Administration (FTAA) and Division of Enterprise Technology (DIT). This is an amazing opportunity for you to utilize your Epic Caboodle Cogito Slicer Dicer and/or Clarity experience and certificates.

In this role you will be a subject matter expert in Electronic Health Records (EHR) clinical operational workflow context EHR data models coding terminology and standards data privacy and compliance integration and downstream system context and have Epic specific reporting knowledge. You will also support the reporting and integration of the DSHS EHR product and ensure it aligns with the vision and needs of the Health and Human Services (HHS) Coalition organizations its staff business partners community partners and the 2.9 million Washingtonians served by these coalition organizations statewide.

Some of what you will do:

• Review and analyze incoming clinical data requests from DSHS and Health Care Management and Coordination Systems (HCMACS) business partners using objective scoring metrics to estimate development effort and prioritize the data backlog for sprint execution
• Translate ambiguous healthcare business requirements into clear technically sound User Stories Epics and Themes within Jira
• Perform quantitative analyses on EHR system usage data using database auditing tools to discover operational workflow bottlenecks resulting in data-backed feature recommendations for the software development roadmap
• Conceptualize design and build automated data visualizations and clinical dashboards
• Conduct rapid-response ad-hoc statistical analyses on raw EHR datasets during public health emergencies or legislative inquiries
• Write and optimize complex multi-table SQL queries
• Configure and deploy embedded Epic Cogito reporting tools to deliver real-time data to healthcare workers
• Subject all custom SQL code and dashboards to rigid peer reviews and data validation testing prior to live production deployment
• Evaluate data extraction patterns and user report access lists against HIPAA regulations and state data privacy policies
• Map and audit database schemas against standardized healthcare coding terminologies

Who should apply

• Epic & Healthcare Context (minimum two to three years): Direct hands-on experience working in a healthcare delivery setting (such as a hospital state health authority or corrections infirmary) with specific experience utilizing Epics backend database architecture
• Data Engineering & SQL: A proven track record of writing tuning and optimizing multi-table SQL queries against relational or dimensional database schemas
• Agile Framework Delivery: At least 2 years of experience operating directly within an Agile/Scrum software development lifecycle including experience writing structured user stories epics and acceptance criteria in tools like Jira or Azure DevOps
• Data and Reporting Visualization: Proficiency in designing publishing and securing production-tier enterprise dashboards using tools like Power BI or Tableau

What were looking for:

• Epic Cogito Fundamentals / Tools Admin: Verifies mastery over Epics front-end reporting suite including Radar dashboards Reporting Workbench and SlicerDicer
• Epic Caboodle Data Model: Verifies the technical ability to query and customize Epics pre-aggregated dimensional data warehouse
• Epic Clarity Data Model (Clinical and/or Revenue modules): Verifies deep structural knowledge of Epics massive relational SQL backend databases
• Business Analysis Professional Certification: Certified Business Analysis Professional (CBAP) or Certification of Capability in Business Analysis (CCBA) to validate Agile requirements gathering skills
• BI Platform Certifications: Microsoft Certified: Power BI Data Analyst Associate or Tableau Desktop Certified Professional

Please include the following:

• Current chronological resume
• A cover letter explaining why you are interested in the job your skills and experience that makes you the best person for the job
• Three professional references with current contact information

Prior to a new hire a background check including criminal record history may be conducted. Information from the background check will not necessarily preclude employment but will be considered in determining the applicants suitability and competence to perform in the job. This announcement may be used to fill multiple vacancies. Employees driving on state business must have a valid drivers license. Employees driving a privately owned vehicle on state business must have liability insurance on the privately owned vehicle.

Washington State Department of Social and Health Services is an equal opportunity employer and does not discriminate in any area of employment its programs or services on the basis of age sex sexual orientation gender gender identity/expression marital status race creed color national origin religion or beliefs political affiliation military status honorably discharged veteran Vietnam Era recently separated or other protected veteran status the presence of any sensory mental physical disability or the use of a trained dog guide or service animal by a person with a disability equal pay or genetic information. Persons requiring accommodation in the application process or this job announcement in an alternative format may contact the Recruiter at . Applicants who are deaf or hard of hearing may call through Washington Relay Service by dialing 7-1-1 or 1-.

Relationship and Reporting Structure (Nepotism) Disclosure: If you are selected for hire you must disclose whether you have a relative household member close friend or romantic partner within your potential supervisory chain of command. DSHS has a Relationships and the Reporting Structure policy that prohibits nepotism and can be reviewed Applicants whose appointment would result in a prohibited reporting relationship are not eligible for appointment to that position.