What are the responsibilities and job description for the Database Architect (Expert) Enterprise Data Warehousing, Application Design, System Requirements, Data Curation position at MVP Consulting Plus?
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.
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.