Data Warehouse/BI Developer, Richmond, VA, US

Intellibee; Richmond; On-site; GBP 70,000 - 90,000; Full time

Job summary

A leading data solutions provider is seeking a Data Warehouse/BI Developer in Richmond. The ideal candidate will execute metric procedures, develop automation frameworks for data loading, and train team members. Applicants should have a BS/MS in Computer Science, with significant experience in SQL and software development. Comprehensive health coverage and future planning benefits are included in this long-term opportunity.

Benefits

Long-Term Stability

Comprehensive Health Coverage

Future Planning

GC Assistance

Qualifications

• Execute existing metric procedures for reporting and data discrepancy assessment.
• Develop end-to-end automation framework for data loading to SQL Server.
• Train division staff on automation framework use and maintenance.

Responsibilities

• Build, validate, and implement processes using automation framework.
• Perform data quality checks and address geographies coding.
• Manage project timelines and deliverables.

Skills

Proven work experience in software development/programming

Proven work experience using SQL, SQL Server

Experience in developing ETL

Experience in using Python

Strong analytical skills

Strong communication skills

Ability to analyze data

Ability to work under pressure

Education

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

Job description

Data Warehouse/BI Developer, Richmond, VA, US

Data Warehouse/BI Developer 4

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. Developend-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.

Skill Matrix:

• BS/MS degree in Computer Science, Engineering or a related subject Required 4 Years
• Proven work experience in software development/programming Required 8 Years
• Proven work experience in using SQL, SQL Server, and related Microsoft products Required 8 Years
• Proven work experience in developing ETL and using Microsoft Visual Studio Required 8 Years
• Experience in using Python and one or more business intelligence tools Required 8 Years
• Experience in leading a project Required 8 Years
• Experience in writing clear, concise, and comprehensive documentation Required 8 Years
• Experience in training team members with different experience levels on processes Required 8 Years
• Experience in creating data quality checks Required 8 Years
• Experience in developing a high level plan with estimates Required 8 Years
• Strong analytical skills and attention to detail Required 8 Years
• Strong communication skills to effectively collaborate with team members and other agency employees Required 8 Years
• Ability to analyze data, identify issues, and validate data accuracy Required 8 Years
• Ability to work under pressure and adhere to tight deadlines while maintaining high-quality work Required 8 Years
• Experience using Census Geocoder Desired 8 Years
• Experience using APIs Desired 8 Years

Benefits at IntelliBee

• Long-Term Stability: Join us on a multi-year opportunities with room to grow.
• Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well.
• Future Planning: Enroll in our 401(k) program and invest in your financial security.
• GC Assistance: We support immediate Green Card processing, if required.