Data Warehouse BI Developer
Data Warehouse BI Developer
Posted on :
14-07-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
For more details please connect with Gautmi Jain at / Phone: x 323 DID:
End Client: State of New York
Job Title: Data Warehouse BI Developer
Job Title: Data Warehouse BI Developer
Duration: 30 Months
Start Date: ASAP
Location: Harriman Campus 1220 Washington Ave Building 5 Albany NY 12226 Onsite
Position Type: Contract
No. of Hours- 40/hrs
No. of Hours- 40/hrs
Interview Type: Inperson
Requirement ID: HBITS
Ceipal ID: SNYBI166GJ
Ceipal ID: SNYBI166GJ
Department : Workers Compensation Board
Summary
These Data warehouse and business intelligence positions are required to support the continued development and maintenance of DW/BI solutions in response to critical agency requirements for the WCB. These positions will also develop and maintain Pentaho ETL solutions Pentaho BI schemas executive dashboards and analytics. Additionally these positions respond to all data warehouse and BI related ad hoc inquiry requests development of dashboard features and development of BI technical solutions for continued reporting requirements
Required Skills:
- 84 months experience in building extraction and transformation of transactional data to drive data warehouse loads and end user BI as well as reporting requirements using ETL tools like Pentaho Data Integration (PDI) or SQL Server Integration Services (SSIS)
- 84 months experience in reporting and analytics tools such as Pentaho or Tableau
- 84 months experience in complex SQL development leveraging analytics functions using in Sybase ASE or SQL Server
- 48 months experience in Pentaho Data Integration (PDI) development.
- 60 months experience in Star Schema / Dimensional Modeling to support data warehouse environments
- 60 months experience in Star Schema / Dimensional Modeling to support data
- warehouse environments
- 84 months experience in internal and external stakeholder communications and outreach including the development of presentations and other materials
Resposibilities:
- Gather and validate of BI and reporting requirements
- Document requirements & solutions
- Perform Data profiling on the source systems
- Design and review star schema dimensional model to support data warehouse and data marts
- Perform Source to Target Mapping between source system database and data warehouse target database
- Develop ETL transformations using the ETL tools like Pentaho Data Integration (PDI) or SQL Server Integration Services (SSIS)
- Develop reports and analytics using the tools like SQL Server Reporting Services (Pentaho or Tableau Power BI)
- Develop complex queries using Transact-SQL leveraging analytic functions
- Perform necessary Testing
- Complete Documentation
V Group Inc. is an IT Services company which supplies IT staffing project management and delivery services in software network help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/contracts with the following states: CA FL GA MD MI NC NY OH OR PATX VA and WA. If you are considering applying for a position with V Group or in partnering with us on a position please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Website:
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
Similar Jobs
Dr. Job is an online platform that connects employers with skilled job seekers, facilitating the search for job opportunities and top talent. Established in 2015. Dr. Job Pro has emerged as the world premier job portal, attracting thousands of job seekers every day from all over the world.
Follow Dr.Job
Dr Job FZ LLC. 2025 © All Rights Reserved