Are you an expert in data collection, cleaning, validation, research methods, statistical models who would like to serve as a technical lead on data projects?
Would you like to be a bridge between our IT division (including GIS!) and the engineering division by providing expert data and analytic support?
Are you excited about things like customer-centric data design, predictive analytics, program evaluation, reporting, visualization, and analytic data oversight?
We are looking for a Data Quality Assurance and Analysis Manager!
What would you be doing?
As the manager of data quality assurance and analysis, you will...
- Utilize your expertise in data collection, cleaning, validation, research methods, statistical models, and business as you lead data projects and serves as a technical lead informing program and agency leadership.
- Serve as the primary bridge between the agency’s IT division (which includes GIS) and the engineering and operations division by providing expert data and analytic support through design, execution, and oversight of data products as well as quantitative and mixed methods analyses of structured and unstructured data.
- Provide customer-centric data design, predictive analytics, program evaluation (implementation, operations, and impact studies), reporting, visualization, and analytic data oversight integral to effective stewardship and equitable delivery of these programs.
- Be responsible for data and evaluation products and services, along with leading requirements development and documentation of analytic data tables/products and automation algorithms.
- Support other workstreams and technical system implementation projects, enabling data-informed decision-making, evaluation of strategic goals and performance, assessment of program usage, effective use of administrative data, and incorporation of data needs and best practices into system development.
This will require you to...
- Independently extract, integrate, and clean data from large program databases (along with other data sources) generating complex queries to extract and manage data for use in data products, analytical research, evaluation, and program operations.
- Respond to frequent requests for customized datasets to include everything from working with the requestor on functional requirements, performing complex data management and statistical calculations, optimizing for efficient data processing, performing validations, ensuring alignment with privacy guidelines, and determining the best approach for data transfer.
- Design and construct data tables and automation functions, building complex analytical files from diverse sources.
- Develop approaches to link across multiple programs' data, including probabilistic matching where direct matches aren’t feasible.
- Consult with Product and IT partners on data processes and infrastructure (e.g., information systems, administrative data lake/warehouse, applications/tools, reporting systems) and database object structures/tables.
- Make recommendations on program production database design to ensure maximum usability of administrative data for data products and evaluation analytics.
- Use statistical programming languages to develop functions and reproducible automation scripts and workflows to facilitate efficient use of data, support reporting, operations, actuarial, and program evaluation colleagues in their work.
- Lead and contribute to analytic data documentation (e.g., data dictionaries).
- Maintain clear documentation to ensure reproducibility and transparency of reporting processes, database objects, calculated fields, customized data sets, and program data.
- Lead and develop quantitative program reports and dashboards for program and agency leadership, legislative staff and government officials, and the public, using database tools, statistical languages (e.g., SQL, R), and visualization software (e.g., Power BI).
- Communicate about analytic research projects and results in plan or technical language, according to the intended audience.
- Write reports that include a clear description of the approach, analysis, related context, and interpretation of the findings.
- Define requirements and analytic logic models, analyze data, develop performance metrics, and conduct program evaluation for cross-functional and external partner initiatives.
- Provide data-informed recommendations on data and program challenges and develop innovative approaches to solve analytics challenges that do not have readily apparent solutions.
- Participate in division and agency portfolio projects, including advising on implementation of new technology system functionality to help ensure usability of resulting data.
- Lead project teams in creating and carrying out data and evaluation plans by conducting data collection, management, and analysis to provide data products summarizing trends and evaluation outcomes in accordance with project objectives.
What are looking for?
A successful applicant will have:
- Experience designing or supporting relational databases and enterprise reporting systems.
- Advanced proficiency in SQL and relational database management systems such as Microsoft SQL Server.
- Experience applying data modeling principles and translating business requirements into technical specifications.
- Experience designing dashboards and automated reporting solutions using enterprise business intelligence tools (e.g., Power BI, Tableau, SAP).
- Proficiency in Python, R, or comparable programming languages to support analytical system design.
- Experience implementing, testing, validating, and deploying reporting and database solutions in production environments.
- Experience developing automated data workflows and repeatable analytical processes.
- Ability to prepare technical documentation and communicate technical information to varied audiences.
- Demonstrated ability to establish and maintain effective working relationships across departments.
- Proficiency in Microsoft Office applications sufficient to support documentation and presentation of system information.
- Experience evaluating existing data or reporting systems and recommending or implementing improvements.
- Experience improving legacy processes through redesign, automation, or integration.
- Ability to analyze complex system requirements and develop sustainable technical solutions.
- Experience implementing measures to improve data quality and reliability.
We are committed to opportunity for all.
CRAB celebrates our differences and we are committed to a workplace that supports equal opportunity employment and inclusion regardless of race, creed, color, national origin, citizenship or immigration status, marital status, families with children (including pregnancy, childbirth, or related medical conditions), sex, sexual orientation, gender identity diversity, age, status as a protected veteran, honorably discharged veteran or military status, status as an individual with the presence of any sensory, mental, or physical disability or the use of a trained dog guide or service animal by a person with disabilities or other applicable legally protected characteristics. We will also consider qualified applicants with criminal histories, consistent with applicable federal, state and local laws.
You are welcome to include the name and pronoun you would like to be referred to in your materials and we will honor this as you interact with our organization.
Does this sound like a good fit? Here are your next steps:
If you or someone you know sounds like a good fit, apply on governmentjobs.com.
For questions about this recruitment or to request a reasonable accommodation in the application process, contact Angie Anderson at email jobs@des.wa.gov. Applicants who are deaf or hard of hearing may call through the Washington Relay Service by dialing 7-1-1 or 1-800-833-6388.
