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    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 NJ DOL - App Systems Analysis/Programming Mgr 4 (693014) Create date: 03-Nov-2022 start date: 10/01/2022 End date: 09/30/2023 submission deadline: 11/8/2022 client info : LWD - Information Technology Note : * Hybrid * Either iLinc Web Cam or In Person interview Description: The Sr. Oracle Develop.... (This job is for - Oracle Jobs in NJ Trenton Analyst - (in Trenton, NJ)) Enterprise Architect IV - 108635 - SP Create date: 31-Aug-2022 start date:9/26/2022 End date:At least 1 Years from projected start date submission deadline:9/02 at 4:00PM CST. client info : ETF Note: * Interview Process: 1 or 2 rounds via Microsoft Teams. Interviews will be scheduled 7/6-7. * Duration: 1 year likely to extend. * Can be .... (This job is for - job Jobs in WI Madison Architect - (in Madison, WI)) Data Base Programmer/Analyst - 22-1001-PDR-02 Create date: 17-Aug-2022 start date:8/29/2022 End date:06/30/2023 submission deadline:08/23/2022 client info : CO CDE Note: * Position Location: Remote Description: The Colorado Department of Education (hereafter referred to as “CDE” or “the Department”).... (This job is for - Tableau Jobs in CO Denver Analyst - (in Denver, CO)) Data Base Programmer/Analyst - 22-1001-PDR-01 Create date: 11-Aug-2022 start date:8/29/2022 End date:06/30/2023 submission deadline:08/23/2022 client info : CO CDE Note: * Position Location: Remote Description: The Departments Project Manager for this project is Kevin Smith (Business Intelligence an.... (This job is for - Azure Jobs in CO Denver Analyst - (in Denver, CO)) Database Administrator 3 - 58553 Create date: 05-Aug-2022 start date:8/1/2022 End date:07/31/2024 submission deadline:08/12/2022 client info : TN DOL Note: * Position Location: Hybrid Description: Job Code 75507 Summary: Under general supervision, is responsible for implementing methods.... (This job is for - Data Warehousing Jobs in TN NASHVILLE Administrator - (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 Developer (Jobs in Atlanta, Georgia) Data Architect ETL Specialist (Jobs in Raleigh, North Carolina) SQL Architect (Jobs in Richmond, Virginia) Business Analyst Financial Analyst (Jobs in Fredericksburg, Virginia) Cyber Architect (Jobs in Columbia, South Carolina) VxRails Consultant (Jobs in Boise, Idaho) Project Manager Microsoft Manager (Jobs in Raleigh, North Carolina) Agile Jira UAT Manager (Jobs in Atlanta, Georgia) - - Analyst (Jobs in Portland, Oregon) HTMLCSSJavaScript Developer (Jobs in Lincoln, Nebraska)