Contract

Length: 25 Months (~March 2027)

Hybrid Location: Remote and Onsite in Albany, NY

Level III position 

Responsibilities:

• Review business and technical artifacts and documentation to understand data and data modeling requirements.
• Participate in meetings and work with Business
• SMEs, Business Analysts and Technology teams to extract data requirements from functional, non-functional, and technical requirements.
• Perform analysis, design, development, and implementation, including data analysis, data validation, data access, data modeling, data transformation, data reporting solutions and documentation.
• Design, develop, deploy, verify, and maintain logical, conceptual, and physical data models based on requirements while adhering to agency standards, best practices, and conventions.
• Create and maintain technical documentation such as data dictionaries, data lineage, data mapping, data flow diagrams, and fit-gap analysis.
• Develop data modeling and data migration strategies, plans, schedules, tasks, and activities.
• Develop solutions adhering to data confidentiality, data integrity, data accessibility / availability, and data security standards and requirements.
• Act as the primary technical liaison working with technical teams to resolve problems and implement solutions to technical issues impacting performance.
• Monitor database to identify data quality issues and determine the resolution and revise the incorrect operational processes.
• Communicate and coordinate with members of the development team to work across multiple projects.

Requirements:

• 7+ years of experience working on complex projects with 2 or more years in a leadership role as a Developer
• 10+ years of hands-on experience in designing, developing, and implementing entity relational diagrams, conceptual, logical, and physical relational data models in third normalization form and canonical data models. This includes but not limited to creating new transactional tables, association tables, code tables, enterprise shared tables, domain specific tables, and transforming existing industry and/or enterprise data models to meet business requirements.
• 10+ years of demonstrated hands-on experience using data modeling software (e.g., Erwin Data Modeler) for designing models, forward engineering to generate data definition language (DDL), reverse engineering physical databases, and identifying / reconciling differences in multiple data models. This includes but not limited to creating subject areas, data models, naming standards, model templates, domains, macros, constraints, relationships, data modeling repository reports, or importing COBOL Copybook files into the data modeling software to expedite development.