Data Modeler

1 week ago


Albany, United States InfoPeople Corporation Full time
Mandatory Qualifications:
1.Level III- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a Developer

2. More than ten (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.

3. More than ten (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.

Desirable Qualifications:
1. Ten (10) years or more of experience designing data models in third normalization form for data migration, data conversion, or consolidation projects in staging and OLTP environments, adhering to data modeling standards and best practices.

2. Seven (7) years or more of demonstrated hands-on experience in designing data models based on legacy mainframe systems (e.g., Client) and transforming them to third normalization form in modern relational database management systems (e.g., Oracle).

3. Seven (7) years or more 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.

4. Seven (7) years or more of experience in performance tuning SQL scripts, complex PL/SQL, complex joins, database objects (procedures, functions, triggers, packages, tables, views), and leveraging indexes for optimal database performance.

5.Seven (7) years or more of demonstrated hands-on experience in creating comprehensive technical documentation such as data dictionaries, data lineage, data mapping, data flow diagrams, and fit-gap analysis.

6.Seven (7) years or more of experience in transforming functional, non-functional, and technical requirements into data requirements.

7. Five (5) years or more of experience in performing data analysis and metadata cataloging.

8. Knowledge and experience in health and human services, especially in Integrated Eligibility System programs such as PA, TA, SNAP, HEAP, TANF, etc.

9.Experience with implementing data modeling solutions for medium to large scale, high volume OLTP systems especially for Case Management systems, Enrollment and Eligibility systems, Financial Management systems, Child Support systems, Appointment / Scheduling systems, or similar Party Data Model like systems.

10.Knowledge and experience in applying data management concepts such as data architecture, data quality, metadata management, data integrity, data integration, data governance, data security and master data management.

  • Albany, United States SYSTEM EDGE (USA) L.L.C. Full time

    Hello,We are urgently hiring for the below role with our Direct client State of New York (NYS):Note: We are the direct and prime vendors with the State Of New York.JOB TITLE: Data Architect | Data Modeler with Python & TIBCO spotfire Job ID: HBITS-06-13685Location: 199 Church Street, New York, NY 10007 (Hybrid)Duration: 30 monthsRate: open on C2CClient /...

  • Data Architect

    4 weeks ago


    Albany, New York, United States VISTRADA Full time

    Vistrada is seeking a highly skilled Data Architect to support key clients in their Business Intelligence needs.This role involves designing, developing, and testing analytics data warehouse architectures, implementing ETL environments, and creating reports and dashboards using leading visualization technology platforms.The ideal candidate will have at least...

  • Data Architect

    4 weeks ago


    Albany, New York, United States VISTRADA Full time

    About the Role:Vistrada is seeking a highly motivated and experienced candidate to serve as a Data Architect on our Business Intelligence (BI) team supporting key clients.As a Data Architect, you will help address operational challenges associated with data modeling, system architectures, data warehousing, integration, and other BI/analytics needs by...

  • Data Analyst

    4 weeks ago


    Albany, New York, United States CHICKASAW NATION INDUSTRIES INC Full time

    Job SummaryThe Data Scientist position at Chickasaw Nation Industries Inc. is a challenging and rewarding opportunity for a skilled professional to join our team. As a Data Scientist, you will be responsible for analyzing complex datasets to extract valuable insights and drive informed decision-making. You will utilize statistical techniques, machine...


  • Albany, United States Manpower Group Inc. Full time

    Data Warehouse Software Developer We are seeking a hardworking and motivated Data Warehouse Software Developer. Don’t wait—apply today! What's in it for you? Role : Data Warehouse Software Developer Albany, NY (Hybrid: 2 days one week, 3 the following week) 12+ Month Contract role. Pay Range : $50hr (W2). Job Overview: We are seeking a Data Warehouse...

  • Data Architect

    4 weeks ago


    Albany, New York, United States CHICKASAW NATION INDUSTRIES INC Full time

    Job SummaryThe Data Architect will play a crucial role in developing and maintaining the overall data architecture strategy and roadmap for CHICKASAW NATION INDUSTRIES INC. This includes designing data infrastructure strategies, data security, and compliance.Key ResponsibilitiesAssist stakeholders in developing and maintaining the overall data architecture...


  • Albany, New York, United States New York State Civil Service Full time

    Job Summary:The New York State Civil Service is seeking a highly skilled Data Analyst/SQL Analyst to join our team in the Office of Public Health's Vital Records in the Data Management and Analytics Unit. As a Data Analyst/SQL Analyst, you will be responsible for using analytical programming languages and statistical and mathematical computations, and...


  • Albany, New York, United States New York State Civil Service Full time

    Job Summary:Under the direction of the Head of the Epidemiology and Needs Assessment Unit, the Treatment Data Analysis and Reporting Unit, or the Recovery, Harm Reduction, and Addiction Treatment Center (ATC) Information Management and Reporting Unit, the Data Analyst 2 will be responsible for analyzing and interpreting complex data sets to inform business...

  • Data Entry Specialist

    4 weeks ago


    Albany, New York, United States Manpower Group Inc. Full time

    Job Title: Data Entry OperatorAbout the Role:We are seeking a detail-oriented Data Entry Operator to join our team in the insurance industry. As a Data Entry Operator, you will be responsible for accurately and efficiently entering data into our systems.Key Responsibilities:- Accurately and efficiently enter data into our systems- Create and use Excel...


  • Albany, United States Manpower Group Inc. Full time

    There is government form to be complete – So resume is due no later than 11/29/2024 to be considered MDM Architect Designated Work Location: 40 N Pearl Street, Albany, NY Anticipated Duration of the Engagement: 27 months Consultant must be based in Albany, NY, or the surrounding states. Client is willing to do Webex but must work on site- 1 week on site...


  • Albany, United States InterSources Inc. Full time

    Data Migration Specialist Location: Albany, NY 12226 Duration: 2- 3 years Contract Position Requirements Bachelor's Degree 84 months experience performing end-to-end data migration activities using standards-based web services for a government entity. 60 months experience developing web-based applications using Oracle PL/SQL stored...


  • Albany, United States InterSources Inc. Full time

    Data Migration SpecialistLocation: Albany, NY 12226Duration: 2- 3 years Contract Position Requirements Bachelor's Degree 84 months experience performing end-to-end data migration activities using standards-based web services for a government entity. 60 months experience developing web-based applications using Oracle PL/SQL stored procedures. 84 months...

  • Data Analyst 2

    4 weeks ago


    Albany, New York, United States StateJobsNY Full time

    Job SummaryWe are seeking a highly skilled Data Analyst 2 to join our team at StateJobsNY. The successful candidate will be responsible for analyzing and interpreting complex data sets to inform business decisions.Key Responsibilities:Respond to requests from agency staff and external stakeholders.Gather data from various sources, including databases,...


  • Albany, United States Staffing Solutions Organization LLC Full time

    Healthcare Data Analyst Corning Tower, Albany, 100 S Mall Arterial, Albany, New York, United States of America Req #458 Friday, November 15, 2024 Staffing Solutions Organization LLC (SSO), an affiliate of Public Consulting Group LLC (PCG), is focused on delighting clients with world-class managed staffing and talent consulting services. SSO is committed to a...


  • Albany, United States Staffing Solutions Organization LLC Full time

    Healthcare Data Analyst Corning Tower, Albany, 100 S Mall Arterial, Albany, New York, United States of America Req #458 Sunday, November 24, 2024 Staffing Solutions Organization LLC (SSO), an affiliate of Public Consulting Group LLC (PCG), is focused on delighting clients with world-class managed staffing and talent consulting services. SSO is committed to a...


  • Albany, New York, United States New York State Civil Service Full time

    Data Analyst 2 Job DescriptionThe New York State Civil Service is seeking a highly skilled Data Analyst 2 to join our team. As a Data Analyst 2, you will be responsible for developing and implementing evaluative and analytical methods and strategies to evaluate, analyze, and report vital events data for the Bureau of Vital Records.Key...


  • New Albany, United States PCR Staffing Full time

    Job DescriptionJob DescriptionData Center TechnicianWe are looking for Data Center Technicians in the New Albany OH area to start ASAP at a major data center (Meta/Facebook) and 10 Data Center Techs in the Plain City / Hilliard and Dublin OH (AWS) area to start for another major data center.New Albany – 100% onsite at 1 New Albany LocationPlain...


  • New Albany, United States Amazon Data Services, Inc. Full time

    The Data Center Engineering Operations Technician (EOT) are Amazon’s front line responders for hands-on electrical and mechanical equipment troubleshooting and operation. This equipment includes, but is not limited to, stand-by diesel generators, switchboards/switchgears, UPSs, PDUs, AHUs, pumps, motors, VFDs, and building automation systems. They provide...

  • Report Developer

    1 month ago


    Albany, United States Tri-Force Consulting Services, Inc. Full time

    Title: Report Developer Duration: 30 MonthsLocation: Albany NYNote: This is an Onsite Role.Job Description:66 Months experience with developing and maintaining logical and physical dimensional data models building data migration strategies utilizing sound concepts of data modeling including star schema snowflake schema etc. 66 Months...

  • Report Developer

    4 weeks ago


    Albany, United States Tri-Force Consulting Services, Inc. Full time

    Title: Report Developer Duration: 30 MonthsLocation: Albany NYNote: This is an Onsite Role.Job Description:66 Months experience with developing and maintaining logical and physical dimensional data models building data migration strategies utilizing sound concepts of data modeling including star schema snowflake schema etc. 66 Months...