ERwin Structured Query Language SQL OLAP ROLAPMOLAP Data Mapping Data Quality Cons   Requirement id 73571 Job title Consultant Job location in LAS VEGAS, NV Skills required Dimensional Modeling, Data Warehouse, Data Modeling, ERwin Structured Query Language SQL OLAP Open Date 19-Sep-2018 Close Date Job type Contract to Hire Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Consultant: Dimensional Modeling, Data Warehouse, Data Modeling, ERwin Structured Query Language SQL OLAP Job Description: Data Modeler works directly with the data architects and data governance teams to translate business requirements into conceptual, logical, and physical data models to meet the needs of the organization. The candidate should be proficient with data warehousing principles, relational database management systems, and logical and physical data models. The candidate maintains metadata profiles in adherence to sound data modeling principles and standards for all data brought into the operational data store and enterprise data warehouse. Demonstrate strong fundamental knowledge and experience using data integration tools and Structured Query language (SQL). Responsibilities include, but may not be limited to the following: Develop and maintain enterprise and system/application-level conceptual, logical, and physical data models and dictionaries. Review and employ database schemas to document Physical Data Models and develop logical data model, and dictionaries. Document, develop, and maintain data models in ERWIN or ER Studio or equivalent modeling tools. Demonstrate clear, concise, accurate, and timely communication to management, peers, and customers; in written and oral form Manage and establish standards for naming and abbreviation conventions, data definitions, ownership, documentation, procedures, and techniques Support the development of integrated data models and artifacts identifying as-is, planned, and to-be mission data and supporting metadata. Work with business, process teams, and leaders, to understand their business information requirements and to classify, organize, make available and govern the data needed to meet those requirements Develop and employ guidelines, standards, Standard Operating Procedures (SOPs), and recommended practices for maintaining and developing data models and data dictionaries. Employ data modeling tools and associated graphical methods to depict and analyze current and proposed conceptual, logical, and physical data schema. Required 4+ years work experience in physical and logical relational database modeling is required. 4+ years work experience in dimensional modeling is required. 4+ years work experience with data warehousing is required. 4+ years work experience with a data modeling tool such as ERWIN or equivalent modeling tools is required. Expert level ability to understand and write Structured Query Language (SQL) is required. Understanding of OLAP, ROLAP, and MOLAP concepts is required. Experience with data mapping, data profiling, and data quality Self-starter, well organized, extremely detail-oriented and an assertive team player, willing to take ownership of responsibilities, and possess a high level of positive energy and drive Ability to manage multiple priorities, work well under pressure and effectively handle concurrent demands to prioritize responsibilities. Excellent time management and organizational skills Preferred Familiarity with Azure Data Lake and Azure Data warehouse is highly preferred. Experience with Business Intelligence tools such as Power BI, MicroStrategy, Cognos, and Tableau is preferred. Experience with Teradata and Teradata Utilities is preferred. Soft Skills An inquisitive mindset Ability to abstract general principles from specific requirements Strong communication skills Rarely requires guidance, even on most complex systems analysis   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 73571 while calling.   Other jobs in NV:    Dimensional Modeling job openings in other states Jobs List NC - CoR - Technical Specialist - Senior - Normal (689112) Create date: 02-Aug-2022 Start date :09/05/2022 End Date :01/31/2023 Submission deadline :08/08/2022 Client Info :CoR-IT Description : PLEASE NOTE: This position is hybrid and requires 3 days per week onsite in Raleigh, NC at the start of the engagement. This requirement is non-negotiable. This position wil.... (This job is for - job Jobs in NC Raleigh Specialist - (in Raleigh, NC)) VDOT Data Modeler/Architect (630550) Create date: 05-Jun-2020 Start Date :7/1/2020 End Date :06/30/2021 Submission Deadline:06/12/2020 Client Info:VDOT Note: * Agency Interview Type:Web Cam Interview Only * Local candidates strongly preferred * Interviews will be conducted via Skype or Google Hangout. * Candidates w.... (This job is for - job Jobs in VA Richmond Architect - (in Richmond, VA)) Data Warehouse Engineer - J-11-413-775 Create date: 31-May-2019 start date:6/3/2019 End date:12/31/2019 submission deadline:5/31/2019 Description: Our Client in Washington, DC is in need of a Data Warehouse Engineer for an 8 month plus contract. Phone and In Person Interview are required. Works together with IT management in.... (This job is for - job Jobs in DC Washington Engineer - (in Washington, DC)) Java Developer - Web Service - 51669 Create date: 13-Feb-2018 Start Date :02/26/2018 End Date :04/30/2018 Submission Deadline :02/16/2018 Description : Title : Java Developer - Web Service - DOH - Center for Health Data and Informatics - IT + The bid window for this posting closes on Friday @ 3:00PM Utah Time (2/16/2018) + Qualified b.... (This job is for - job Jobs in UT SaltLakeCity Developer - (in Salt Lake City, UT)) Database Administrator - 49958 Create date: 17-Nov-2017 Start Date :01/02/2018 End Date :04/30/2018 Submission Deadline :11/21/2017 Description : This position will develop and populate relational/dimensional database models to support a Prescribe-rs dashboard. Skill required include; DB modeling, ETL coding, and other DBA skills. + This.... (This job is for - job Jobs in UT SaltLakeCity Administrator - (in Salt Lake City, UT))     (Consultant: Dimensional Modeling, Data Warehouse, Data Modeling, ERwin Structured Query Language SQL OLAP in LAS VEGAS, NV)

Featured Jobs Java Kafka Microservices Developer (Jobs in Orange County, California) Software Analyst (Jobs in Richmond, Virginia) Business Analyst (Jobs in Bismark, North Dakota) QA Analyst (Jobs in Madison, Wisconsin) Consultant (Jobs in Bismarck, North Dakota) - Consultant (Jobs in Greeneville, Tennessee) SCCM PowerShell Specialist (Jobs in Raleigh, North Carolina) ASP.Net UI Developer (Jobs in Madison, Wisconsin) - Consultant (Jobs in Bismarck, North Dakota) Help Desk Consultant (Jobs in Madison, Wisconsin)