State Of New York New York City , NY 10017
Posted 1 week ago
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 06/14/24
Applications Due09/12/24
Vacancy ID161012
Basics
Schedule
Location
Job Specifics
Contact
NY HELPNo
AgencyEmpire State Development, NYS
TitleData Warehouse Architect
Occupational CategoryOther Professional Careers
Salary GradeNS
Bargaining UnitNone listed
Salary RangeFrom $90000 to $100000 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 New York
Street Address 655 Third Avenue
City New York
StateNY
Zip Code10017
Minimum Qualifications Education 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.
Experience required:
Extensive experience in Systems Analysis, Data Architecture, Data Mining, 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 2016+ and higher, industry leading BI, Data Analytic, Mining 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 Applicants MUST submit a cover letter with resume to be considered.
This position will require in-office presence.
Hybrid work schedules may be possible based on specific job duties and consistent with ESD policy.*
BASIC FUNCTION:
Design and build Data Warehouse structures to support ESD's reporting and analytic needs. Work closely with Data Architects 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, data mining, 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
Utilize industry best Data Mining techniques to analyze large datasets for discernable trends and patterns in support of organizational business process and goals
Author functional specifications for Data Warehouse structures
Aid in capturing and maintaining the organizations master data
Document Data Warehouse designs, infrastructure, interfaces, processes, workflows 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
Some positions may require additional credentials or a background check to verify your identity.
Name Joyel Abdul
Telephone
Fax
Email Address resumes@esd.ny.gov
Address
Street 655 Third Avenue
City New York
State NY
Zip Code 10017
Notes on ApplyingExternal Candidates: Please attach cover letter and resume. To apply copy & paste URL in browser: https://bit.ly/3APr8cp
Internal Candidates: Please apply through ADP using the Myself/Talent menu and submit your cover letter and resume for consideration
WE ARE AN EQUAL OPPORTUNITY EMPLOYER COMMITTED TO DIVERSITY
State Of New York