Data Modeling Developer with Erwin or Unisys || Albany, NY 12203 (Hybrid) (Relocation will work)
About The Position
The Data Modeling Developer will review business and technical artifacts to understand data modeling requirements, collaborate with business subject matter experts, business analysts, and technology teams, and translate requirements into data solutions. The role involves analyzing, designing, developing, deploying, verifying, and maintaining conceptual, logical, and physical data models in accordance with agency standards and best practices. The developer will contribute to data analysis, validation, access, modeling, transformation, reporting, and documentation; develop data modeling and migration strategies and plans; and help ensure solutions meet confidentiality, integrity, accessibility, availability, and security requirements. The role also serves as a technical liaison to resolve issues affecting performance, monitors databases for data quality problems, and coordinates with development team members across projects.
Requirements
- More than seven years of experience working on complex projects, including at least two years in a leadership role as a Developer.
- More than ten years of hands-on experience designing, developing, and implementing entity relational diagrams; conceptual, logical, and physical relational data models in third normal form; and canonical data models.
- More than ten years of hands-on experience using data modeling software such as Erwin Data Modeler to design models, forward engineer DDL, reverse engineer physical databases, and identify and reconcile differences across data models.
- Experience creating subject areas, data models, naming standards, model templates, domains, macros, constraints, relationships, repository reports, or importing COBOL Copybook files into data modeling software.
- Ten or more years of experience designing third-normal-form data models for data migration, conversion, or consolidation projects in staging and OLTP environments, following modeling standards and best practices.
- Seven or more years of hands-on experience designing data models based on legacy mainframe systems such as Unisys and transforming them to third normal form in modern relational database management systems such as Oracle.
- Seven or more years of hands-on experience developing complex SQL queries, PL/SQL packages, stored procedures, functions, views, complex joins, indexes, triggers, external tables, roles, grants, permissions, DDL, and DML.
- Seven or more years of experience tuning SQL scripts, complex PL/SQL, complex joins, database objects, and indexes for optimal database performance.
- Seven or more years of hands-on experience creating technical documentation, including data dictionaries, data lineage, data mapping, data flow diagrams, and fit-gap analysis.
- Seven or more years of experience transforming functional, non-functional, and technical requirements into data requirements.
- Five or more years of experience performing data analysis and metadata cataloging.
Nice To Haves
- Knowledge and experience in health and human services, especially Integrated Eligibility System programs such as PA, TA, SNAP, HEAP, and TANF.
- Experience implementing data modeling solutions for medium- to large-scale, high-volume OLTP systems, particularly case management, enrollment and eligibility, financial management, child support, appointment and scheduling, or similar party data model systems.
- Knowledge and experience applying data management concepts such as data architecture, data quality, metadata management, data integrity, data integration, data governance, data security, and master data management.
Responsibilities
- Review business and technical artifacts and documentation to understand data and data modeling requirements.
- Participate in meetings and work with business subject matter experts, 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 that adhere to data confidentiality, data integrity, data accessibility and availability, and data security standards and requirements.
- Act as the primary technical liaison with technical teams to resolve problems and implement solutions to technical issues impacting performance.
- Monitor databases to identify data quality issues, determine resolutions, and revise incorrect operational processes.
- Communicate and coordinate with development team members across multiple projects.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
