USA Jobs, Careers and Recuitements
[x]

Contact Information

Company: ACRO STAFF
Contact Name: DAVE
Website: http://acrostaff.com

Job Details: BI programmer with pentaho & sybase experience Date: Jan 14 2021

Job Reference: 3802
Job Category: IT Jobs [ View All IT Jobs Jobs ]
Company Type Recruiter
Employment type: Full Time, Contract
Degree: Tech School
Experience: 3 years
Location: Albany, New York, 12203
Job Skills: BI programmer with pentaho & sybase experience
Share Job with Others

Job Tools

Job Description

Required Skills:
• At least 60 months experience in computer programming doing requirements gathering and documentation.
• At least 60 months experience in computer programming doing SQL and stored procedure development.
• At least 60 months experience in Sybase ASE and Sybase Stored Procedure development.
• At least 60 months experience in computer programming doing data profiling and source to target mappings.
• At least 60 months experience in computer programming doing extraction and transformation of transactional data to drive end user report development.
• At least 60 months experience in SQL doing ad hoc report development using a band-style reporting tool.
• At least 12 months experience in Pentaho Report Designer.
• At least 12 months experience in Pentaho Data Integration (PDI) development.

Description:
State of New York - Workers’ Compensation Board
The NYS Workers’ Compensation Board’s Business Process Reengineering (BPR) project has identified the need to quantify and monitor system performance. New BI components will be required to enable this analysis. This includes expanding the data and subject areas available in the WCB’s data warehouse, summarizing data into logical data marts for improved access and performance, integrating processes and technologies to improve data quality, building new and expanded analytical cubes, creating new dashboards and reports, that will enable expanded information self-service for the WCB.
Two goals of delivering self-service BI and analytics by expanding available data in the WCB’s enterprise data warehouse are (1) to provide management with a single source of all summarized data and (2) to provide the tools that allow self-service access to that data. To meet these goals, future iterations or phases of business intelligence and data warehouse development are required to include:
• Expansion of available source systems to be included in EDW
• Additional subject areas leveraging “atomic level” data
• Data marts to summarize “atomic level” data
• New and expanded BI analytical schemas (aka “cubes”)
• New executive dashboards
• New analytical reports
• Establishment of Data Quality Management processes
• Integration of Data Quality Management tools to Data Warehouse architecture

Responsibilities:
• Develop ad hoc information products using SQL and Stored Procedures
• Develop reports using Pentaho Report Designer
• Gathering and validation of business requirements
• Document requirements & solutions
• Data profiling
• Source to Target Mapping
• Pentaho Data Integration (ETL)
• Testing
• Documentation

Copyright © 2021 Jobxoom All rights reserved. Use of this site is subject to certain Terms and Conditions.