Data Warehouse / BI Developer 4

Job Description

ABOUT THE ROLE

Supplement division staff by executing existing metric procedures for statutory and ad hoc reporting as well as data discrepancy assessment and resolution. Develop end-to-end automation framework and documentation to load data and query results to SQL Server tables using standard Microsoft products. Build, validate, document, and implement end-to-end process using automation framework to load vendor-provided data and other division data, to calculate regulatory and division metrics, and to perform data quality checks and address geographies coding. Train division staff on use and maintenance of automation framework.

Requirements

Skill

Required / Desired

Amount

of Experience

BS / MS degree in Computer Science, Engineering or a related subject

Required

Years

Proven work experience in software development / programming

Required

Years

Proven work experience in using SQL, SQL Server, and related Microsoft products

Required

Years

Proven work experience in developing ETL and using Microsoft Visual Studio

Required

Years

Experience in using Python and one or more business intelligence tools

Required

Years

Experience in leading a project

Required

Years

Experience in writing clear, concise, and comprehensive documentation

Required

Years

Experience in training team members with different experience levels on processes

Required

Years

Experience in creating data quality checks

Required

Years

Experience in developing a high level plan with estimates

Required

Years

Strong analytical skills and attention to detail

Required

Years

Strong communication skills to effectively collaborate with team members and other agency employees

Required

Years

Ability to analyze data, identify issues, and validate data accuracy

Required

Years

Ability to work under pressure and adhere to tight deadlines while maintaining high-quality work

Required

Years

Experience using Census Geocoder

Desired

Years

Experience using APIs

Desired

Years

Requirements

Qualifications Type Category Qualification Description Competency Required Skills Others Help desk support Help desk Novice (1-3 Years) No Skills Others Communication skills both verbal and written Novice (1-3 Years) No