{"schemaVersion":"jobsearcher.job.v1","id":"a3cb4befb9f96eb862712e39","url":"https://jobsearcher.com/jobs/a3cb4befb9f96eb862712e39","canonicalUrl":"https://jobsearcher.com/jobs/a3cb4befb9f96eb862712e39","title":"Data Architect","description":"Provide a short description of the Position: Expert Data Modeler working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below.Provide a list of the day-to-day tasks to be performed by the Selected Candidate: • 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 data infrastructure to extract and organize 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. • Design BigQuery DWH for Data Analytics • Assist and verify design of solution and production of all design phase deliverables. • Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ODI/ELT and ETL architecture. • Resolve difficult design and develop issues. • Identify bugs when developers are not able to do so. • Identify installation solutions for new databases • Determine the requirements for new databases • Design data model to support Self Service Reporting requirements • Publish and/or present design reports • Identifying areas for improvement in current systems • Coordinate with business, vendor and IT team members to reach project milestones and deadlines • Audit database regularly to maintain quality • Create systems to keep data secure • Design and document all components of approved application solutions including system integrations. • Write clean, 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. • Deploy fully functional applications. • Use a ticketing system to track and manage incidents, service requests, problems, changes, and release/deployment.Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.","company":"Mindlance","rawCompany":"mindlance","city":"Albany","state":"NY","isRemote":false,"isActive":false,"createdAt":"2026-07-24T00:37:48.123Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Data Architect","description":"Provide a short description of the Position: Expert Data Modeler working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below.Provide a list of the day-to-day tasks to be performed by the Selected Candidate: • 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 data infrastructure to extract and organize 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. • Design BigQuery DWH for Data Analytics • Assist and verify design of solution and production of all design phase deliverables. • Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ODI/ELT and ETL architecture. • Resolve difficult design and develop issues. • Identify bugs when developers are not able to do so. • Identify installation solutions for new databases • Determine the requirements for new databases • Design data model to support Self Service Reporting requirements • Publish and/or present design reports • Identifying areas for improvement in current systems • Coordinate with business, vendor and IT team members to reach project milestones and deadlines • Audit database regularly to maintain quality • Create systems to keep data secure • Design and document all components of approved application solutions including system integrations. • Write clean, 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. • Deploy fully functional applications. • Use a ticketing system to track and manage incidents, service requests, problems, changes, and release/deployment.Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.","datePosted":"2026-07-24T00:37:48.123Z","dateModified":"2026-07-24T00:37:48.123Z","hiringOrganization":{"@type":"Organization","name":"Mindlance","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Albany","addressRegion":"NY","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"a3cb4befb9f96eb862712e39"},"url":"https://jobsearcher.com/jobs/a3cb4befb9f96eb862712e39"}}