Minimum Qualifications Non-competitive: bachelor’s degree in data or computer science, informatics, economics, statistics, mathematics, or a related field, and either: satisfactory completion of a two-year traineeship or two years of experience* in data visualization, and statistical
models and data mining tools.
*Substitution: A master’s degree in the above fields may substitute for one year of the specialized experience. A Ph.D. in the above fields may substitute for two years of the specialized experience.
The position may be filled at the Data Analyst Trainee 1 level equated to SG-14, $50,678, Data Analyst Trainee 2 level equated to SG-16, $56,550, or full performance Data Analyst 1 SG-18, $63,108, based on education and experience. Candidates hired at the trainee level will be advanced to the full performance Data Analyst 1 SG-18 following the successful completion of the traineeship.
Duties Description Under the direction of the Data Analyst 2 in the Bureau of Data Reporting and Analytics, the Data Analyst 1's will perform data extraction, aggregation, and quality checks from multiple sources and tables in support of trend identification and root cause analysis and summarize results, create written reports, and collaborate with staff in support of innovative and effective dashboards and data visualizations.
Duties include but are not limited to:
- Prepare data and draft technical requirements and data definitions for new data models and data pipelines from ingestion to consumption in several large data systems.
- Perform processes handling the download, cleaning, and structuring of data.
- Program scalable and efficient data pipelines for several large data systems in programming languages including SAS, Python, or SQL.
- Maintain integration processes required for optimal extraction, transformation, and loading of data from a wide variety of data sources in both on premise and cloud environments.
- Collaborate with staff and external partners to ensure support for all data sets and processes running in production.
- Translate program requirements to technical documentation and compile methodology/code to support for major quality, safety, and public health initiatives.
- Assess data structures of current data systems and provide suggestions for how they can be used to produce desired reports.
- Utilize cloud-based data analytics technology solutions to support both regular reports and analyses as well as research on health outcomes of interest.
- Prepare data for analysis and reporting using data wrangling techniques (joining, merging, stacking, cleansing, transposing, aggregating, transforming, etc.).
- Produce and interpret univariate analyses to identify patterns, outliers, and errors in data.
- Assist in the systems management, data management, and testing of systems used for data quality; develop scripts and data pipelines to automate these tasks.
*Note: This position is a newly classified position and is pending placement into the non-competitive jurisdictional class. Until such approval, all appointments will be made temporary, pending jurisdictional class (JC). Once placed in the non-competitive class, the appointment type will be converted to permanent.
Additional Comments • The Office for People With Developmental Disabilities (OPWDD) and it's Division of Administration is committed to creating and sustaining a culture of inclusion. We believe that we are most effective in managing and improving our service system with a
diverse team of employees. With such a large workforce, we rely on the collective individual differences, life experiences, knowledge, self-expression, ideas and talent that our employees bring to their work. This speaks to our culture, and is a key part of our successes. As we continuously recruit people for our team, we welcome the unique contributions that applicants bring in terms of their education, culture, ethnicity, race, sex, gender identity and expression, nation of origin, age, languages spoken, veteran’s status, color, religion, disability, sexual orientation and beliefs.
• Preference will be given to OPWDD employees impacted by closures. If you are being impacted by closure, please indicate this on your resume/cover letter.
• In order to be eligible for appointment and to maintain employment, you cannot be listed as an excluded individual or entity on any of the Federal and/or State Medicaid and Medicare exclusion lists (or excluded from any other Federal or Federally assisted program). If you are appointed and subsequently listed as an excluded individual or entity on any of these lists (or excluded from any other Federal or Federally assisted program), you may be terminated from your employment.
• OPWDD is an Equal Opportunity/Affirmative Action Employer.
Some positions may require additional credentials or a background check to verify your identity.