Please note: State agencies that contact job applicants do not usually request personal or financial information via text message or over the phone in connection with your response to a job posting. If you are contacted for such information by these methods, or any other method, please verify the identity of the individual before transmitting such information to that person.
Note: For questions about the job posting, please contact the agency that posted this position by using the contact information provided on the "Contact" tab for the position.

Review Vacancy

Date Posted 10/21/16

Applications Due12/21/16

Vacancy ID33959

AgencyEmpire State Development, NYS

TitleData Warehouse Architect

Occupational CategoryI.T. Engineering, Sciences

Salary GradeNS

Bargaining UnitNone listed

Salary RangeFrom $80000 to $80000 Annually

Employment Type Full-Time

Appointment Type Permanent

Jurisdictional Class Non-competitive Class

Travel Percentage 0%

Workweek Mon-Fri

Hours Per Week 37.5

Workday

From 9 AM

To 5:30 PM

Flextime allowed? No

Mandatory overtime? No

Compressed workweek allowed? No

Telecommuting allowed? No

County Albany

Street Address 625 Broadway

City Albany

StateNY

Zip Code12207

Minimum Qualifications EDUCATION & REQUIREMENTS:
Education Level required:
Bachelor’s degree in an IT related discipline with minimum of 3 years’ experience in related field; Or a 2 year degree with a minimum of 5 years’ experience; Or, any equivalent combination of experience and/or education from which comparable knowledge, skills and abilities have been achieved.

Relevant Experience required: Extensive experience in Systems Analysis, Data Architecture, Data Warehouse and Data Mart design, development of ETL processes, SQL SSAS and various storage models

Knowledge required:
Strong proficiency with Microsoft Data Management and Reporting tools, MS SQL Server 2008 and higher, industry leading BI and reporting tools.
Experience in the development of dashboard and report development utilizing BI tools such as PowerBI, Tableau or others, knowledge of CRM Dynamics, system design principles;
Ability to work with a diverse group of people at both a functional and technical level and communicate at a level appropriate to audience;
Ability to work both independently and as part of a team;
Strong written and verbal communication skills

Duties Description BASIC FUNCTION:
Design and build Data Warehouse structures to support the organizations reporting and analytic needs. Work closely with the Data Architect to develop a thorough understanding of the organizations data needs, ensure that all data points are correctly identified and develop processes for capturing and storing this data. Duties will include: surveying existing business functionality, designing data warehousing structures, data mapping, transformation and loading, performance monitoring, end user support, system disaster recovery, Quality of Service (QoS) testing and documentation as well as to provide technical assistance in any other area of IT as directed by department managers.

WORK PERFORMED:
•Develop Data Warehouse structures conducive to sourcing reports and analytics
•Develop ETL (Extract, Transform, Load) processes for importing data into the warehouse
•Author functional specifications for Data Warehouse structures
•Aid in capturing and maintaining the organizations master data
•Document Data Warehouse designs, infrastructure, interfaces, processes, work flows and security requirements
•Provide Data Analysis, establish mapping and Ad Hoc reporting as required by application users and ESD Management
•Aid in maintaining the organizations master Data Dictionary
•Manage multiple projects concurrently, meet established guidelines
•Assist in IT Disaster Recovery efforts and perform other related duties as required

Additional Comments salary up to specified amount

Some positions may require additional credentials or a background check to verify your identity.

Name Maria Gately

Telephone N/A

Fax N/A

Email Address Resumes@esd.ny.gov

Address

Street 633 Third Avenue

City New York

State NY

Zip Code 10017

 

Notes on Applyingplease announce job title in subject line of email

Printable Version