Data Analyst/ Report Writer (Peoplesoft Knowledge)

Data Analyst/ Report Writer

6 months – 990 hours

Austin, TX (working 2 days at the office and 3 days from home.)

DESCRIPTION OF SERVICES:

We requests the services of one Data Quality Analyst personnel, hereafter referred to as Worker, who meets the general qualifications of a Data Quality Analyst and the specifications outlined in this document.

General Description:

Responsible for analyzing, assessing, and documenting diverse data from its source through many complex transformations to all applications that consume the data to assist the Data Management and Support (DMS) Team with continuous improvement in its mission to the agency. Additionally the individual will identify the issues from the profiling, follow up with the business, document the business rules, and assist with the processes involved around continuous improvement of the quality of the data and other capabilities of the DMS Team. Strong skills to identify and resolve data issues and effectively apply the broad range of professional concepts, practices, and methods in moderately complex and diverse circumstances. Work is perform under moderate supervision of the Data Management and Support Team Lead with moderate latitude for the use of initiative and independent judgement.

Duties and Responsibilities

• Essential Functions:Expand and continuously refine the data quality program.
• Ensures adherence to the data quality programs and standards.
• Ensures that the data quality corrective action plan is thoroughly documented.
• Promote the importance and awareness of an enterprise data quality program.
• Leverages data management knowledge to define and maintain data quality, reference data,and meta-data processes.
• Participates in the development of data quality rules, thresholds, and standard/quality expectations for data elements that support critical business processes.
• Continuously execute and monitor the Data Quality Lifecycle on a daily basis.
• Profiles data for statistical analysis and assessment of data to document the effectiveness of data quality controls and identifies improvement opportunities.
• Identifies and implements best practices and tools based on the business needs.
• Implement controls to mitigate data quality risks including continuously monitoring data quality results, reports and dashboards.
• Impeccable oral and written communication skills are essential for effectively interacting with data users, managers, and other stakeholders.
• Complies with all applicable agency policies and procedures, including safety and standards of conduct.
• Performs other duties as assigned

• Essential Work Behaviors:Communicates respectfully and works harmoniously with all co-workers, customers, and vendors.
• Provides exceptional customer service.
• Is flexible; able to work under pressure and; able to adapt to change; and able to work on multiple problems and tasks.
• Takes initiative to prevent and solve problems.

Qualification Requirements

Education/Special Requirements:

Bachelor’s degree in computer science, engineering, statistics, economics, finance, library science, or related business field.

Experience and Training

3 years of experience creating functional and technical documentation, business glossaries, and diagrams, that communicates the desired message to business and technical audiences.

3 years of experience working with enterprise grade databases – preferably SQL Server and Oracle.

3 years of experience developing and writing complex SQL scripts/queries – preferably Oracle and SQL Server.

2 years of experience, within the last 5 years, developing data quality rules, thresholds, and standard metrics/quality-expectations for data elements that support critical business

processes.

2 years of experience, within the last 5 years, with an enterprise grade data quality tool such as Informatica Data Quality, SAS Data Quality, Omni-Gen Data Quality, etc.

2 years of experience, within in the last 5 years, in the Data Quality field developing and implementing best practices and tools based on the business needs.

Leads and participates in discussions with cross-functional teams.

Preferred Qualifications

• 3 years of experience working with complex Excel functions, including but not limited to VLookUp, Macros, Pivot Tables, etc.
• 2 years of experience with the Microsoft SQL Server BI Stack (RDMS, SSIS, SSRS)
• Experience or familiarity with Alteryx & Tableau.
• Experience or familiarity with Benefits Administration, Pension Administration, and Payroll oriented data in the PeopleSoft HRMS package or similar package.

Knowledge, Skills and Abilities

Uses all knowledge, skills, and abilities to apply critical thinking to all aspects of the job. Critical thinking is a process of forming reasoned opinions through observation, information collection, interpretation, analysis, inference, evaluation, and other skills necessary to successfully meet performance standards of the job.

• Strong analytical and product management skills, including a thorough understanding of how to interpret customer business needs and translate them into application and operational requirements.
• Demonstrated problem solving skills in a technical environment
• Strong written and verbal communication skills; Editing and proofing skills for complex and technical documents. Ability to understand and clearly communicate technical information to non-IT personnel
• Strong organizational skills and the ability to prioritize assignments.
• General knowledge of legislature and legislative process.
• Familiarity with HIPAA and other data security and confidentiality requirements.
• Ability to work independently on difficult, complex tasks.
• Ability to use discretion on matters of a confidential or sensitive nature.
• Knowledge of health care claims data.

Connect Tech+Talent