Database Architect; Expert Enterprise Data Warehousing,Design,System Job Albany area,City of Albany New York USA,IT/Tech

Position: Database Architect (Expert) Enterprise Data Warehousing, Application Design, System Requirement[...]
Location: City of Albany

Contract Details

Duration: 30 months
Interview Process: Virtual Interview
Work Model: Hybrid (50% telecommuting, 50% office per week)

Project Description

Act as an Expert Database Architect working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below.

Day-to-Day Tasks

Interact with Agency/business subject matter experts to understand business needs/requirements, Vendors of Commercial Off the Shelf (COTS) products, and IT teams to determine and design application and system requirements.

Design and implement Enterprise data warehouse and curate data for authorized individuals to access.

Identify internal and external data sources, collaborating with business subject matter experts to determine their data storage and organizational needs and use the information to create and maintain data infrastructure.

Participate in the entire Secure Software Development Life Cycle (SSDLC) including debugging and configuring solution.

Identify, recommend and implement ODI/ELT and ETL process and architecture improvements.

Manage build phase and quality assured code to ensure fulfilling requirements and adhering to ODI/ELT and ETL architecture.

Resolve complex design and development issues.

Identifying areas for improvement in current systems.

Coordinate with business, vendor and IT team members to reach project milestones and deadlines.

Create processes to maintain data quality and high accessibility.

Design and document all components of approved application solutions including system integrations.

Write readable, testable code using advanced analytical functions.

Test and debug including, but not limited to: perform system testing and development of testing plans.

Review and refactor code including, but not limited to: performance tuning of existing code, code reviews, and suggest changes that will best fit the Agency/business needs.

Use a ticketing system to track and manage incidents, service requests, problems, changes, and release/deployment.

Required Qualifications

84 months of experience working with State Agency/business subject matter experts to understand business needs/requirements, Vendors of Commercial Off the Shelf (COTS) products, and ITS teams to determine and design data warehouse, application and system requirements, architecting, designing, documenting, and implementing data warehousing, enterprise application integration, and master data management.
84 months of experience designing, developing, and implementing enterprise data warehouse solutions, including normalized data models, ETL/ELT processes, automated data ingestion and transformation workflows, workflow orchestration and scheduling, and data integration automation to improve operational efficiency, reliability, and scalability.
84 months of experience developing data integrations for heterogeneous systems and business intelligence using SQL (Structured Query Language) in a State agency.

Equal Opportunity Employer

MVP Consulting Plus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Reasonable accommodations are available for qualified individuals with disabilities during the application process.

#J-18808-Ljbffr

Database Architect; Expert Enterprise Data Warehousing, Design, System