APPLY NOW!
Job title: Information Technology Specialist 3 (Systems Programming)
Company: Department of Homeland Security
Job description: Minimum Qualifications Appointment method:
List Appointment: Candidates must be reachable on the Civil Service eligible list for 26-376 or 37-675.
Transfer: Candidates must have one year of permanent competitive service in a title eligible for transfer via Sections 70.1 or 52.6 of the Civil Service Law. Information regarding transfer eligibility may be available on the Civil Service Career Mobility Office website at http://careermobilityoffice.cs.ny.gov/cmo/.
Please Note that under Civil Service Law, an employee cannot have two consecutive upward 70.1 or 52.6 transfers without an intervening eligible list appointment if such transfers would exceed two salary grades.
Duties Description The Department of Financial Services (DFS) is seeking to fill the position of Information Technology Specialist 3 to function as a Data Warehouse Engineer in our Information Technology Unit to be responsible for designing and implementing staging, operational data stores (ODS) and data warehouse environments using data from multiple sources through data normalization, de-normalization, flattening and enrichment for the development of the infrastructure of a data warehouse.
The incumbent will advise policy makers on issues related to databases implementation and provide expertise as to what data is needed to support policy decisions. The incumbent will be involved in confidential discussions about acquisition, publication and security of data related to DFS databases . Duties include, but are not limited to, the following:
- In consultation with policymakers, develops complex data transformations using ETL and ETL approach for Business Intelligence (BI) Data Warehouse/Data Mart models.
- Manages Oracle/SQL server databases throughout the Database Development Lifecycle ( DBLC), Planning, Requirements gathering, Design, Implementation, Testing & Performance tuning, Operation and Maintenance.
- Performs Extracting, Transforming, Loading (ETL) design, development, testing, and deployment activities effectively and efficiently;
- Imports, exports and moves data in different formats (such as, .cvs, .xml and .xlsx) between a variety of systems (such as, Relational Databases, Customer Relationship Management (CRM) systems, 3rd party systems and Application Program Interfaces (APIs);
- Designs and implements the architecture and infrastructure of enterprise systems;
- Maintains thorough understanding of the environment to ensure adherence to standards and utilizing accepted practices for enterprise design;
- Reviews current and proposed architectures to meet acceptable enterprise system practices;
- Provides technical advice and guidance for infrastructure improvements and deploying and maintaining systems in accordance with established guidelines;
- Implements enterprise information security, procedures and protocols and participating in security risk reviews and remediation activities including producing written technical reports;
- Participates in the testing of applications, such as developing test plans, test conditions, and validation testing;
- Designs, develops, and maintains logical/physical data models, entity relationship diagrams and a common data dictionary;
Preferred Qualifications
- At least 5 years of experience with Data Warehouse ETL design, development and maintenance with successful implementation of Enterprise BI solutions;
- Hands-on experience implementing data migration and data processing using Azure services.
- Experience in working with RDBMS mainly SQL Server 2008/2012 and Oracle 12c;
- Strong technical experience in designing and implementing data-intensive Data Warehouse solutions;
- High proficiency writing SQL/ T-SQL;
- Strong Knowledge of logical and physical data modeling (relational, dimensional data modeling); and
- Experience with data visualization tools (e.g. PowerBI).
Additional Comments Appointment to this position is pending Division of Budget approval to fill.
Some positions may require additional credentials or a background check to verify your identity.
Expected salary: $73284 – 92693 per year
Location: Albany, NY
Job date: Sat, 10 Jul 2021 06:18:26 GMT
APPLY NOW!
[ad_2]
