DDL Data Profiling Support Excellent Oral And Written Communication Skills SQL Quer   Requirement id 104872 Job title Consultant Job location in Menands, NY Skills required Data Modelling, DDL, Data Analysis, Data Profiling Support Excellent Oral An Open Date 16-Mar-2020 Close Date Job type Contract Duration 24 Months Compensation DOE Status requirement --- Job interview type Phone Screening Apply    Email Recruiter: coolsoft Job Description Consultant: Data Modelling, DDL, Data Analysis, Data Profiling Support Excellent Oral An Note: * Please be advised responses are due no later than 3/25/20. Responsibilities Are you a tech & IT geek? We have a 24-month project with our client in Albany, NY that requires a Senior Data Modeler This position serves as EIM/Data Warehouse & BI – Data Modeler for the Office of Mental Health. Day-to-Day Tasks include, but not limited to: Review existing data model and recommend changes to support new and existing data requirements. Analyze source system data to uncover data redundancy and duplication. Maintain conceptual, logical and physical data models along with corresponding metadata. Perform data analysis, discovery, profiling and identify cause of data issues and work with business team to resolve challenges Review models created by peer data modelers for ensuring implementation of standards. Create physical models by either reverse engineering the model from database or from DDL scripts; create bitmap index and b-tree indexes wherever necessary in the model, check for the owner of the schema, data types, constraints, metadata etc. Identify tables that need row level security and create fine grain policies in the models using ER/Studio for those entities that need row level security, table level security and tables that follows HIPAA standards. Develop SQL queries for the analysis of source and target systems by connecting to Oracle database using toad and analyze each field, data type and the corresponding data across different source and target systems. Work with business owners by identifying the data discrepancies and improve the overall data quality of enterprise systems. Create data lineage documentation capturing and documenting system flow and other pertinent technical information about data, database design, or systems. Mandatory Qualifications: Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a largescale software system. 60-84 months-Candidate able to work independently, without assistance and provides guidance to others. May have an advanced education. Preferred Qualifications: 84 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. 84 Months experience in a data modeling tool (e.g., ErWin, ER/Studio). 84 Months experience in relational data management disciplines and design and development experience using Oracle technologies. 84 Months experience with SQL programming. 60 Months experience working with business intelligence tools (e.g., OBIEE 11G). 60 Months experience working with ETL tools (e.g. Informatica). 60 Months experience with designing, creating applications and health care Data Warehouse and business intelligence reporting solutions. 48 Months experience working with HIPAA requirements or similar standards and NYS Accessibility Standards. 48 Months experience with reviewing the data modeling of others for compliance and accepted standards of development. Languages Must have English Native or bilingual proficiency Additional vendor information Candidates need to meet 60% of the Preferred Qualifications to qualify for the position.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 104872 while calling.   Other jobs in NY: Albany (4), Bethpage (6), BUFALLO (1), Buffalo (6), Commack (4), Commack Long (1), Jericho (5), Long Island (4), Long Island City (2), Manhattan (5), Midtown NYC (1), New York (41), New York City (8), NYC (2),    Data Modelling job openings in other states Jobs List Systems Analyst - RFS 65129 Create date: 26-Nov-2025 Start date :12/15/2025 End Date :03/31/2028 Submission deadline :12/04/2025 by 8:00 A.M. CST Client info: Tennessee Department of Health (TN-DOH) Note: * Position Location: Onsite * In-person, with the potential for remote work upon completion of training and demonstrated proficiency 66.... (This job is for - SQL Jobs in TN Nashville Analyst - (in Nashville, TN)) Database Administrator - Consultant - 8891 Create date: 25-Nov-2025 Start date : 12/29/2025 End Date : 12 Months from projected start date Submission deadline : 12/3/2025 5:00:00 PM Client Info : SCDMV Note: * Interview Process: Interviews will take place on-site at the Blythewood Headquarters at 10311 Blythewood Rd. Blythewood, SC 29016. * D.... (This job is for - SQL Jobs in SC BLYTHEWOOD Administrator - (in Blythewood, SC)) Data Warehouse Architect 5 - 151381 Create date: 20-Nov-2025 Start date :12/15/2025 End Date : At least 1 Years from projected start date Submission deadline :11/26 at 10:00 am EST. Client Info : DHHS Note: * Remote or On-site: Accepting local candidates within 2 hours of Lansing ONLY. Position will be hybrid, in office 2 days a week upon start and ther.... (This job is for - job Jobs in MI Lansing Architect - (in Lansing, MI)) Database Administrator - Consultant - 8247 Create date: 24-Sep-2025 Start Date: 10/27/2025 End Date: 10/26/2026 Submission Deadline : 10/1/2025 5:00 PM EST. Client Info : SCDMV Note: * Work Location: 100% On-site in Blythewood SC. * Interview Process: Interviews will take place in person on site at the Blythewood Headquarters at 10311 BLYTHEWOOD RD BLY T.... (This job is for - ERwin Oracle DBA Jobs in SC BLYTHEWOOD Consultant - (in Blythewood, SC)) Systems Analyst - RFS 64394 Create date: 28-May-2025 Start Date :6/23/2025 End Date :06/30/2026 Submission Deadline :05/30/2025 by 8:00 A.M. CST Client Info: TN- Tennessee Department of Health (DOH) Note: * Position Location: * On-Site. In-person, with the potential for remote work upon completion of training a.... (This job is for - SQL Jobs in TN Nashville Analyst - (in Nashville, TN))    Data Modelling job openings in NY Jobs List PL/SQL Developer - 5376 Create date: 16-Aug-2021 Description: Day-to-Day Tasks include, but not limited to: Analysis and design of database objects and data collection systems, including the transformation of legislative requirements into system functionality. Data modelling. Responsible for software development tasks including coding, testing, and impl.... (This job is for - AnalysisImplementation Jobs in NY Albany Developer - (in Albany, NY)) RFP 05282019-DM IT Consulting Services -Data Modeler -SPO Create date: 08-May-2019 Note: Email Submission Note: Vendors may only submit a total of one (1) candidate Submission Deadline: 5/28/2019 5:00 PM EST Start Date: 8/1/2019 End Date: 7/31/2022 Client: New York City Employees Retirement System (NYCERS) Description: Justification: The Data Modelers role is to cre.... (This job is for - job Jobs in NY Brooklyn Modeler - (in Brooklyn, NY)) (Consultant: Data Modelling, DDL, Data Analysis, Data Profiling Support Excellent Oral An in Menands, NY)

Featured Jobs COTS SASS Communication Analyst (Jobs in Henrico, Virginia) IBM Active Consultant (Jobs in Des Moines, Iowa) - - Engineer (Jobs in Austin, Texas) Consultant (Jobs in Richmond, Virginia) ITIL Engineer (Jobs in Columbia, South Carolina) DB2 Jira Analyst (Jobs in Atlanta, Georgia) Figma UI/UX Sketch Analyst (Jobs in Lansing, Michigan) GAAP Security Architect (Jobs in Atlanta, Georgia) GIT APEX SOQL Architect (Jobs in Madison, Wisconsin) ADO.NET Developer (Jobs in Hartford, Connecticut)