ColumbusRecruiter
the smart solution for Columbus jobs

Technical Specialist 4 (Data Modeler)

Company: GLOBAL DATA SOLUTIONS INC
Location: Columbus
Posted on: December 9, 2018

Job Description:

Job description: Client is looking for a TS4 to support designing Data Models for Operational Data Store and Data Marts used for operational and analytical business reporting. The data sources will include a variety of normalized relational data/semi-structured data on both a Data Lake(Hadoop) and a Relational Database(Vertica Data modeling will encompass normalized(Inmon), dimensional(Kimball), and others designs to support broad agency centric use cases. The candidate must be proficient with data modeling/designing star schema structures and use of modeling tools like Erwin in a data warehouse environment. During a given day, this position will be expected to: Work with Business Analysts and potentially business customers to verify requirements Design/model tables to meet architectural requirements for dimensional/star schema and other modeling approaches Construct mapping documents involving source and destination and extract/transform/load rules for the ETL team Work with an agile BI Team to facilitate ETL development and reporting for BI Tools (Cognos/Tableau, etc) Mandatory Skills: 10 or more years of experience working as a data modeler in business intelligence, analytics and Enterprise Data Warehousing environments 10 or more years of experience developing with SQL Minimum 5 years Experience with Kimball (Dimensional Modeling) and Inmon methodologies Minimum 5 years Experience analyzing data profiling, data mining, data cleansing, data content, scrubbing data, and translating data via rules from one database to another Minimum 5 years Experience with STAR Schema structures, theories, principles, and best practices, Data Governance, Data Quality Management, Metadata Management, and Conceptual and Logical Data Design. Minimum 5 years Strong Data Modeling skills to include data quality, source systems analysis (DB2, Oracle, VSAM , etc), business rules validation, source to target mapping design, prepare sample data example and data validation with ETL team (SCD 1, SCD 2 types tables and Fact tables) Minimum 5 years experience with the Erwin modeling tool, including Model Mart Repository advanced features (e.g. check in/out, complete compare, naming standards and reverse engineering) Desired Skills Experience designing for Hadoop/Spark Experience with MPP Databases (Vertica, TerraData, Netezza) Knowledge of property and casualty insurance systems Knowledge of Ohio business model and processes Experience using SQL Development Tools Skill in the use of organizational tools & methods (MS Excel, MS Word, MS Outlook, VISIO, Clarity) Ability to quickly adapt to changes, enhancements, and new technologies

Keywords: GLOBAL DATA SOLUTIONS INC, Columbus , Technical Specialist 4 (Data Modeler), IT / Software / Systems , Columbus, Ohio

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Business Analyst 5 /BA5 (58109)
Description: IDEALFORCE has a CONTRACT position available immediately for a Business Analyst 5/BA5 to join our customer in Columbus, OH. This is an ONSITE position. Please find below additional details about this (more...)
Company: Idealforce
Location: Columbus
Posted on: 12/13/2018

Mortgage Origination BSA @ Columbus, OH // Sur
Description: Job Title : Business Systems Analyst Job Location: Columbus, OH Duration : 6 month Note : Looking for BSA Who has worked on mortgage origination project. Experience
Company: Activesoft, Inc
Location: Columbus
Posted on: 12/13/2018

Oracle for 6+months (W2 / 1099)
Description: REQUIREMENT: Job Title: Senior IT Architect - Oracle SOALocation: Columbus, OHDuration: 6 months Job Description: --- Examine and evaluate current business processes and tasks, and develop ideas for (more...)
Company: V.L.S. Systems, Inc
Location: Columbus
Posted on: 12/13/2018


Urgent need for Oracle HCM Program Manager
Description: Our client is looking for Lead Oracle HCM Program Manager for 6 Months position in Columbus,
Company: Tek Tree LLC
Location: Columbus
Posted on: 12/13/2018

Java Full Stack Developer
Description: Position: Java Full Stack Developer Location:
Company: Technocraft solutions
Location: Columbus
Posted on: 12/13/2018

UI Developer
Description: We are looking for UI Lead / Developer at Columbus, OH Role: UI Lead / Developer Location: Columbus, OHDuration -Long term contract Experience level: 8 YearsNO OPT's EAD Please
Company: BestOp Consulting
Location: Columbus
Posted on: 12/13/2018

Entry Level Programmer - Dayton
Description: Revature is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. Our Software Engineers design, analyze and build (more...)
Company: Revature
Location: Dayton
Posted on: 12/13/2018

Provider Database Specialist
Description: Role and Responsibility: Responsible for the integrity of the data in the provider database system Accurately load provider records for all products and markets into the provider database for use (more...)
Company: CareSource
Location: Dayton
Posted on: 12/13/2018

Changes Columbus Springs - PHP Therapist
Description: Academic/Faculty/Research opening in Columbus, Ohio. This and other counseling/therapy jobs brought to you by AlliedHealthJobCafe.com DESCRIPTION/RESPONSIBILITIES: DO YOU HAVE WHAT IT TAKES Ask Us Why (more...)
Company: Springstone, Inc
Location: Columbus
Posted on: 12/13/2018

SQL DBA
Description: SQL Server DBA Columbus, oh 12 Months Skills Required: Skills Number of years' experience Last used 7 years participating in database selection and maintaining
Company: Logic Soft Inc
Location: Columbus
Posted on: 12/13/2018

Log In or Create An Account

Get the latest Ohio jobs by following @recnetOH on Twitter!

Columbus RSS job feeds