Data Modeler Job at V Group Inc., Albany, NY

NGtnaWtDUVpSbHBUd2tlRlRHWGxITjUyZ3c9PQ==
  • V Group Inc.
  • Albany, NY

Job Description

For more details, please connect with Afra Aleem at 609-371-5400 Ext 112 or email her at [email protected]

Job Title: Data Modeler

Duration: 30 Months

Start Date: 20/06/2025

Location: Three Empire State Plaza, 2nd Floor, Albany, NY 12223

Position Type: Contract

Interview Type: In Person

Ceipal ID: SNY_DATA068_AF

Required Skills:

  • 84 months experience developing logical and physical relational data models for OLTP databases.
  • 60 months experience using Erwin OR toad Data Modeler to create and maintain logical and physical data models.
  • 84 months experience in complex PL\SQL, T-SQL and SQL development against SQL Server.
  • 60 months experience identifying and troubleshooting data quality issues.
  • 12 months experience developing and managing ELT/ETL processes.
  • 36 months of experience in development using Agile/Scrum
  • 36 months experience using source control and release technologies such as Git and Azure DevOps.
  • Masters Degree in computer related field
  • Résumé
  • Copy of Candidate Identification(i.e., Driver’s License/Green Card/Visa and Passport if applicable)
  • Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)

Description:

The Department of Public Services requires assistance with implementation of new and existing .Net applications including but not limited to Utility Assessment Project, 753 Project, Pipeline Audit Safety (PAS),Water Master (WMast), Document and Matter Management (DMM), Power To Choose (PTC), Regulatory Calculator and other systems.

The Department has identified a list of new initiatives and enhancements to improve the systems efficiency related to their business process which require a contractor’s assistance.

Working as part of a Business Solutions environment, the position will be responsible for the development and maintenance of data models, ETL/ELT pipelines and/or data migration processes, PL/SQL, T-SQL and SQL scripts. In addition, the resource will review business requirements documents, analyze and profile source data, maintain scripts in source control repository, performance tune scripts, review and troubleshoot data quality alerts, prepare source to target mapping documents and execute data manipulation language (DML) scripts. The duties will be performed against both cloud-based and on-premises databases.

The consultants will serve Data Modeler and developer in the .Net Developer Team implementing:-

Responsibilities:

  • Analyzing and translating business needs into long-term solution data models.
  • Evaluating existing data systems.
  • Working with the development team to create conceptual data models and data flows.
  • Developing best practices for data coding to ensure consistency within the system.
  • Reviewing modifications of existing systems for cross-compatibility.
  • Implementing data strategies and developing physical data models.
  • Updating and optimizing local and metadata models.
  • Evaluating implemented data systems for variances, discrepancies, and efficiency.
  • Troubleshooting and optimizing data systems.
  • Generate and publish data definition language (DDL) from physical data model to Oracle and SQL Server databases.
  • Design and develop ELT/ETL processes for the migration of data.
  • Develop and execute complex queries and procedures using T-SQL and SQL.
  • Manage and maintain scripts and code in source control repository.
  • Document data models, data migration and data quality requirements and solutions.
  • Provide knowledge transfer to other data management team members.
  • Assistance in development of software/hardware requirements for Development, User Acceptance Testing (UAT), and Production environment.

V Group Inc. is an IT Services company that supplies IT staffing, project management, and delivery services in software, network, help desk, and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: CA, FL, GA, MD, MI, NC, NY, OH, OR, PA, SC, VA, and WA, CT, TN. If you are considering applying for a position with V Group or partnering with us on a position, please feel free to contact me with any questions you may have regarding our services and the advantages we can offer you as a consultant.

Website:

LinkedIn:

Facebook:

Twitter:

Job Tags

Contract work, For contractors, Local area,

Similar Jobs

Wealth Recruitment, LLC

Phlebotomist Job at Wealth Recruitment, LLC

 ...We are seeking a skilled and compassionate Phlebotomist to join our team. This role plays a critical part in patient care by expertly performing venipunctures and other specimen collections, ensuring the quality and accuracy of samples, and supporting the smooth operation... 

FirstFleet Inc

CDL A Local Truck Driver - Home Daily Job at FirstFleet Inc

 ...Truck Driver - Home Daily FirstFleet in St Joseph, MO is a dedicated operation delivering Essential Corrugated Paper. PAY ~$1100 Weekly Average ~ Safety & Fuel Bonus Program JOB Home Daily - 1st Shift and 2nd Shift Sunday - Thursday No Touch... 

Lake Area Discovery Center

Assistant Teacher-PreK (TL) Job at Lake Area Discovery Center

 ...preschool students. Position is Year Round, with 64* Hours PTO (prorated), eight paid Holidays, and paid training and continuing education. Hourly Rate of $18.00-$20.00 per hour, depending on education and experience. The Lake Area Discovery Center at Trinity's... 

CHRISTUS Health

Occupational Therapist - Physical Therapy - PRN Job at CHRISTUS Health

 ...Responsible for the utilization and supervision of volunteers, students, support staff, and assistants relating to the provision of occupational...  ..., economic use of time/resources, and creation of a positive work/therapy environment. Performs other diverse duties as requested.... 

MD Staff Pointe

Credentialing Coordinator Job at MD Staff Pointe

 ...healthcare staffing firm seeking a Credentialing and Logistics Coordinator to work in their Irving, TX office. This role will support the...  ...CRM Assist with confirmation letters and booking candidate travel as needed Credential candidates generated from the...