Database Architect

Total Required Experience in Years:Minimum 7%2B Years

Mode of Work:Hybrid (50% Telecommuting | Minimum 2 Days Onsite Weekly | Albany, NY)

Job Description: Seeking an experienced Database Architect to design, develop, and support enterprise data warehouse, integration, and modernization initiatives supporting strategic transportation and enterprise data programs. The ideal candidate should possess strong expertise in data warehouse architecture, ETL/ELT frameworks, Oracle Data Integrator (ODI), enterprise data modeling, SQL development, and large-scale data integration environments. This role requires designing scalable data solutions, supporting governance and quality initiatives, and driving enterprise data management strategies across mission-critical systems.

Key Responsibilities:

• Design and implement enterprise data warehouse and large-scale data integration solutions
• Develop data integration frameworks, ETL/ELT pipelines, and workflow automation solutions
• Design logical and physical data models and enterprise database architectures
• Implement scalable ETL and ELT solutions supporting enterprise reporting and analytics initiatives
• Coordinate with business stakeholders, vendors, and technical teams to support enterprise data initiatives
• Develop data quality, governance, and master data management processes
• Participate in Secure Software Development Life Cycle (SSDLC) activities and compliance initiatives
• Design enterprise system integrations and workflow automation processes
• Perform database performance tuning, optimization, and query enhancement activities
• Support architecture planning and modernization efforts for enterprise data systems

Additional Responsibilities:

• Manage incidents, service requests, and change management activities
• Develop testing, validation, and system quality assurance plans
• Refactor, optimize, and improve existing database code and ETL processes
• Produce architecture documentation, technical specifications, and system designs
• Support milestone planning, project execution, and enterprise delivery initiatives

Required Skills:

• Strong expertise in SQL and enterprise database architecture
• Experience with enterprise data warehouse architecture, ETL, and ELT frameworks
• Oracle Data Integrator (ODI) implementation and administration experience
• Data modeling and enterprise data integration expertise
• Strong understanding of database performance tuning and optimization
• Experience supporting enterprise-scale reporting and analytics environments
• Strong technical documentation and stakeholder collaboration skills

Preferred Skills:

• Master Data Management (MDM) experience
• Workflow automation and process optimization experience
• Data governance and data quality management expertise
• SSDLC and enterprise compliance framework knowledge
• Enterprise reporting and analytics support experience

Qualifications:

• Experience implementing enterprise data warehouse solutions required
• Experience collaborating with State agencies preferred
• Experience designing enterprise data integration frameworks required
• Experience working with business and technical teams across enterprise environments preferred