Data Analyst I

Location
Fairfax, Virginia
Salary
$60,276.11 - $100,461.09 Annually
Posted
Sep 11, 2021
Closes
Sep 24, 2021
Ref
21-01871
Function
Analyst
Hours
Full Time
Job Announcement

Fairfax County is offering a challenging opportunity to join the Informatics Department of the Fairfax-Falls Church Community Services Board. Incumbent will conduct analysis of business requirements as it relates to reporting Electronic Health Records (EHR) data driven outcomes using the best practices associated with developing and applying the use of business intelligence dashboards. Duties include data analysis, building reports, dashboards, and providing ongoing support for reporting needs. Evaluates reporting needs and requirements and creates report packages to address customer and staff requests. Must have excellent data analysis, written and verbal communication skills, and be comfortable conducting reports requirements in workgroups settings and create reports in timely and accurately.
  • Create reports and dashboards using EHR data to analyze performance and Key Performance Indicators of the for the programs and services served by the CSB.
  • Provide analysis and develop forecast models to predict future for services provided by the CSB.
  • Identify existing data sources and perform its mapping to different fields in the tool and database.
  • Analyze business processes, define reporting requirements, test report enhancements, work with end-users to acceptance test reports, train users, and provide ongoing support to the department.
  • Investigate data anomalies in report output, tracing data movement though multiple tables and processes to discover root cause.
  • Create technical requirements and conduct requirements walkthroughs with the clinical staff.
  • Develop training materials, conduct training sessions, and facilitate user acceptance testing.
  • Conduct data mining, cleaning and transformation of raw data in Excel and SQL download from various systems to translate data into actionable business intelligence.
  • Build and deliver executive dashboards and reports in a range of formats including:
    • Develop business performance, forecasting and KPIs dashboards and reports for EHR by leveraging advance features enabling data-driven decision making;
    • Perform ad-hoc analysis via segmenting, slicing and dicing the data to extract actionable insights;
    • Create and present reports and dashboards to the senior management including strategic recommendations based on research findings.
  • Support Informatics team with other duties as assigned to maintain and update Electronic Health Records.
Note: To learn more about careers that make a difference, watch our video " CSB Celebrates 50th Anniversary of Providing Care ."

Illustrative Duties

  • Assists with the development of data sets and extracts, data standards, and data models to ensure complete, correct, accessible and shareable data for information technology development projects;
  • Assists with gathering and documenting business data and information requirements;
  • Assists with preparing physical database design;
  • Assists with analyzing business forms, reports, processes, practices, and procedures;
  • Assists with the development of logical data models, including the identification of data subject areas, data entities, attributes, relationships, information types, domains, and constraints;
  • Assists with the development of structured diagrams, including data flow, entity life cycle, hierarchy, entity/relationships, conceptual schemas, and association matrix diagrams;
  • Assists with identifying physical implementation requirements such as denormalization, data types, defaults, keys, referential integrity, and screen/script mapping;
  • Assists with the development of logical data standards, definition standards, domain, and type standards;
  • Assists with creating and maintaining metadata, reporting objects, data repositories, and data dictionaries;
  • Assists with the implementation and training of data administration practices and data access tools;
  • Designs and runs basic database queries to assess or validate data;
  • Performs basic data cleansing and transformations to assess data quality;
  • Supports data testing and analysis for initiatives of higher complexity;
  • Prepares for physical database design and consolidation, standardization, cleansing, migration, or upload of data;
  • Maintains data repositories and facilitates data access for users;
  • Attends training workshops, product demonstrations, conferences, and technical briefings;
  • Stays abreast of technology changes;
  • Provides assistance to other staff, as needed.


Required Knowledge Skills and Abilities

  • Some knowledge of information systems and the components that process data;
  • Some knowledge of the principles, practices, and methods related to data administration;
  • Some knowledge data administration areas such as policies and standards, data definition, modeling and logical design, database design, and quality control;
  • Some knowledge of data concepts such as syntax, taxonomy, and hierarchy;
  • Some knowledge of relational databases (such as Oracle) and CASE tools;
  • Skill in brainstorming, presenting, sharing, discussing, and defending ideas;
  • Skill in problem-solving, with appreciation and respect for diversity of differing professional views;
  • Skill working with data modeling tools and relational databases;
  • Ability to establish and maintain effective business relationships. Ability to help stakeholders effectively resolve is sues related to cross-agency data sharing, usage conflicts, and data inconsistencies;
  • Ability to follow special formatting requirements and conventions in work products;
  • Ability to establish and maintain appropriate version control over work products;
  • Ability to communicate effectively, both orally and in writing;
  • Ability to make use of provided resources and seek guidance as needed;
  • Ability to conduct research into new information technology;
  • Ability to prepare user manuals and systems documentation;
  • Ability to translate technical terminology into simple language and concepts.


Employment Standards

MINIMUM QUALIFICATIONS:
Any combination of education, experience, and training equivalent to the following:
(Click on the aforementioned link to learn how Fairfax County interprets equivalencies for “Any combination, experience, and training equivalent to”)
Graduation from an accredited four-year college or university with a degree in information technology, information systems, computer science, business administration, or related field and coursework in analytics, biosystematics, biology, information architecture, engineering, library science, statistics, sociology, demographics, and/or marketing; plus one year classification, use, or analysis of data experience in an academic, data administration, or analytics environment.

NECESSARY SPECIAL REQUIREMENTS:
  • Must successfully complete a criminal background investigation, a Child Protective Services Registry, and a sanction screening to the satisfaction of the employer. TB screening upon hire.
  • Some positions identified by departments must execute IT Employee Agreement acknowledging obligations under information security and privacy requirements in light of broad access to systems and data in the performance of job duties.
  • All newly hired employees are required to be fully vaccinated as a condition of employment or obtain approval of a medical or religious exemption prior to their start date. Proof of an exemption or vaccination status will be required during the pre-employment onboarding process. New employees who obtain an exemption from the vaccine mandate for medical or religious reasons will still be subject to the weekly testing requirement. Otherwise, vaccinated employees will complete the attestation online in the first day of employment.

PREFERRED QUALIFICATIONS:
  • Knowledge of Welligent behavioral health platform or any certified EHR system;
  • Experience in Microsoft Power BI or other well-known BI tool;
  • Excellent analytic skills;
  • Experience in data analysis using BI tools, advanced excel functions like v-lookup, advance pivot tables, charts, excel macros, etc.
  • Strong knowledge of relational databases, advance SQL, Crystal Reports and Excel to produce dashboard, reports, charts, graphs to track quantitative data analysis trends.
  • Experience analyzing high volume EHR data for business decisions and to detect anomalies;
  • Strong working experience in developing, modifying and generating reports and dashboards to summarize business activity using BI Tools;
  • Experience in creating and developing reports and dashboards with KPIs;
  • Experience in working with data from multiple sources and in variety of formats: Excel, csv, databases, etc.
  • Experience securing and maintaining confidential client and employee data that is subject to HIPAA rules and regulations and de-identifying such data in extracts and repositories (such as data warehouses).

PHYSICAL REQUIREMENTS:
Ability to use keyboard, develop and provide presentations, and carry equipment. Duties performed with or without reasonable accommodations.

SELECTION PROCEDURE:
Panel Interview and may include a practical exercise.

Fairfax County Government prohibits discrimination on the basis of race, color, religion, national origin, sex, pregnancy, childbirth or related medical conditions, age, marital status, disability, sexual orientation, gender identity, genetics, political affiliation, or status as a veteran in the recruitment, selection, and hiring of its workforce.

Reasonable accommodations are available to persons with disabilities during application and/or interview processes per the Americans with Disabilities Act. Contact 703-324-4900 for assistance. TTY 703-222-7314. EEO/AA/TTY.

More searches like this