Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of transforming the public sector’s IT environment. Our team is on the forefront of helping to solve the government's most complex IT challenges. If you are seeking a role that offers the opportunity to work on rewarding projects, consider a career with Cloud and Things. Overview
We are seeking a ETL Developer - Data Warehouse/Reporting for a large-scale modernization project. The Worker’s Compensation Board (WCB) is going through a large-scale modernization of many of its core application systems. These applications and data are being consolidated and will be hosted as one application system in the Microsoft Azure cloud. The modernization effort (OnBoard) and the associated software delivery will occur incrementally. The OnBoard program roadmap will consist of multiple, discrete projects leading to the final, to-be WCB enterprise-wide software solution hosted in Azure, resulting in the sunsetting of all legacy systems.
Responsibilities
- Review the reporting and BI requirements and as needed, communicate with the business SMEs to clarify, finalize, and document the business rules.
- Review the source (OLTP) system and as needed, communicate with business application services SMEs to understand the technical business rules
- Assist in developing OLAP (DW / reporting) model and conduct necessary reviews with the ITS EIM team.
- Profile the source data and refine the OLAP model, as needed.
- Create ETL specification document.
- Develop the ETL / SQL solution.
- Perform UAT: Refactor ETL from business feedback.
- Integrate the ETL job with the master job.
- Prepare maintenance plan for the production support.
Mandatory Skills/ Qualifications
- Must have between four (4) and seven (7) years of experience as a Developer.
- Proven experience in reviewing and documenting reporting and BI requirements.
- Experience working with business SMEs to clarify and finalize business rules.
- Experience reviewing source (OLTP) systems and understanding technical business rules.
- Experience in developing OLAP (DW/reporting) models and working with EIM teams.
Desirable Skills/ Qualifications
- Experience with Informatica, Pentaho, Tableau, Sybase and SQLServer MI
- Prior government experience
Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws. Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws.