Senior Data Modeler / Analyst

Confidential Company  •  Indianapolis, IN

5 - 7 years experience  •  Business Services

Salary depends on experience
Posted on 11/03/17
Confidential Company
Indianapolis, IN
5 - 7 years experience
Business Services
Salary depends on experience
Posted on 11/03/17

Description

Kforce has a client in Indianapolis, Indiana (IN) that is seeking a Senior Data Modeler/Analyst. The senior data modeler works directly with the strategic service lines entities and data architects to translate business requirements into conceptual, logical, and physical data models to meet the needs of the organization. The candidate maintains metadata profiles in adherence to sound data modeling principles and standards for all data brought into the enterprise data warehouse. This role supports ongoing activity of those working within business intelligence and analytics teams. Essential Functions:

  • Develop and maintain logical and physical data model designs, data management standards and conventions, data naming standards and metadata (normalized, de-normalized and STAR-based structures)
  • Perform reverse engineering of physical data models from databases and SQL scripts
  • Evaluate data models and physical databases for variances and discrepancies
  • Validate business data objects for accuracy and completeness
  • Participate in higher level planning efforts; Play a role in definition of process/guidelines/standards
  • Direct support of business intelligence and analytics teams

Requirements

  • Bachelor's degree - Management Information Systems (or related field), including 5 - 7 years of related experience; Healthcare-related master's degree preferred
  • Hands-on experience with modern enterprise data architectures and data toolsets (ex: data warehouse, data marts, data lake, 3NF and dimensional models, modeling tools, profiling tools)
  • Comfortable with ambiguity; comfortable iterating toward a destination rather than knowing it ahead of time
  • Self-starter; takes advantages of all possible venues for continuous learning
  • Enjoys working with teams, both inside and outside of his/her immediate area
  • Hungry to learn/master new approaches to information management and delivery

Exposure and/or experience with the following preferred or required (as noted):

  • Data modeling: Erwin, Embarcadero, PowerDesigner, or Visio; ability to model data using appropriate notation - required
  • Metadata Management: Informatica
  • Data profiling/quality: Informatica, MicroSoft or Ataccama
  • Data integration: Exposure to ETL and ELT paradigms and platforms - PowerCenter, Ab Initio, Wherescape RED or MS SSIS - Wherescape RED/SSIS preferred
  • Master data management: IBM Initiate, MS MDS s - Microsoft-related products & platforms preferred (SSIS, PDW/APS, SQL Server, MDM, MQS)
  • Database management: Oracle, SQL Server - MS PDW/APS preferred
  • SQL: ability to write ad hoc queries as well as stored procedures - required

Leadership:

  • Comfortable engaging with personnel at all levels of leadership
  • Ability to listen to others and incorporate good ideas regardless of source
  • Professional in all communication and interaction with others

JobID: 1672395-EQG

Not the right job?
Join Ladders to find it.
With a free Ladders account, you can find the best jobs for you and be found by over 20,0000 recruiters.