Database Architect (Expert) Enterprise Data Warehousing, Application Design, System Requirements, Data Curation

MVP Consulting

50 Wolf Rd. Albany, NY

Apply

JOB DETAILS

SKILLS

Analysis Skills, Automation, Build Management, Code Reviews, Commercial Off-the-Shelf (COTS), Consulting, Data Modeling, Data Processing, Data Quality, Data Storage, Data Warehousing, Data Warehousing Applications, Database Architecture, Database Extract Transform and Load (ETL), Debugging Skills, Design Document, Master Data Management (MDM), Needs Assessment, Process Development, Quality Management, Refactoring, Software Design, Software Development Lifecycle (SDLC), System Integration (SI), System Test, Test Plan/Schedule, Testing, Time Management

LOCATION

50 Wolf Rd. Albany, NY

POSTED

6 days ago

HBITS: HBITS-07-14807

Expert, Database Architect

30 month contract

Interview: Virtual Interview

Work model: 50% telecommuting, 50% Office per week

--- Project Description ---
Act as 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 ---
1. 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.
2. Design and implement Enterprise datawarehouse and curate data for
authorized individuals to access.
3. 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.
4. Participate in the entire Secure Software Development Life Cycle
(SSDLC) including debugging and configuring solution.
5. Identify, recommend and implement ODI/ELT and ETL process and
architecture improvements.
6. Manage build phase and quality assured code to ensure fulfilling
requirements and adhering to ODI/ELT and ETL architecture.
7. Resolve complex design and development issues.
8. Identifying areas for improvement in current systems
9. Coordinate with business, vendor and IT team members to reach
project milestones and deadlines
10. Create processes to maintain data quality and high accessibility
11. Design and document all components of approved application
solutions including system integrations.
12. Write readable, testable code using advanced analytical functions.
13. Test and debug including, but not limited to: perform system testing
and development of testing plans.
14. 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.
15. 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.

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.

About the Company

MVP Consulting

Resume Resources

Free Resume Templates Free Resume Builder