Data Solutions Architect 8/26/2016

Health & Beauty Company Detroit, MI

Company
Health & Beauty Company
Job Classification
Full Time
Company Ref #
29312549
AJE Ref #
575988651
Location
Detroit, MI
Job Type
Regular

JOB DESCRIPTION

APPLY
Data Solutions Architect

Detroit, MI

12 + months project

Must be on W-2

GC/USC/ (We CAN CONSIDER H1B TRANSFER if someone has great skills)

TECHNOLOGY STACK: HADOOP/HDFS (HORTON WORKS), INFORMATICA BDE, MDM, POWER EXCHANGE, ERWIN, DATA MODELING, ARCHITECTURE IN ENTERPRISE DATA WAREHOUSE ENVIRONMENT.

SKILLS & EXPERIENCE:

1) 6+ YEARS OF EXPERIENCE WITHIN HEALTH CARE ANALYZING HEALTH PLAN DATA (MEMBERSHIP, CLAIMS, PROVIDER, CLINICAL, ETC.), AND KNOWLEDGE OF THE BUSINESS PROCESSES AND SUPPORTING METRICS/KPI

2) 10+ YEARS EXPERIENCE ARCHITECTING AND MODELING AN ENTERPRISE USE LAYER (DIMENSIONS/FACTS), DEPENDENT DATA MARTS AND BI/REPORTING SOLUTIONS AGAINST A VERY LARGE ENTERPRISE-WIDE DATA WAREHOUSE (10+ TERABYTES) ACCORDING TO INDUSTRY STANDARD DATA MODELS

EXTENSIVE KNOWLEDGE AND EXPERIENCE ARCHITECTING AND MODELING ENTERPRISE LEVEL SOLUTIONS SUPPORTING BIG DATA PLATFORM IMPLEMENTATIONS IN ADDITION TO INCORPORATING MASTER DATA MANAGEMENT STANDARDS AND ABILITY TO ALIGN DATA MODELS WITH GUIDELINES AND STANDARDS STIPULATED BY THE ENTERPRISE DATA GOVERNANCE COMMITTEE

3) 6+ years experience in superior communication (written, verbal, and presentation), resource will be the primary interface between operational and analytical areas in the business, enterprise architecture, and technical resources developing information management solutions

REQUIRED SKILLS/EXPERIENCE

* EXTENSIVE KNOWLEDGE OF DATA MODELING CONCEPTS AND BEST PRACTICES BOTH IN A MULTI-LAYER DATA WAREHOUSE (NORMALIZED / INMON) AND DATA MART (DIMENSIONAL / KIMBALL)
* Experience with DATA MODELING AND METADATA SOLUTIONS INCLUDING ERWIN, SYSTEM ARCHITECT, INFORMATICA METADATA MANAGER, AND LEVERAGING THOSE SOLUTIONS TO PRODUCE DATA DICTIONARIES AND ENTERPRISE DATA LINEAGE DOCUMENTATION
* Experience with data governance working with data stewards and business stakeholders to understand the impacts of data model changes, gain consensus on data definition and business rules, and communicating to all consuming systems
* DEMONSTRATED ABILITY TO LEAD AND MENTOR DATA MODELERS AND DATA ANALYSTS
* KNOWLEDGE OF TRANSACTION STANDARDS (834, NCPDP, HL7, ETC.)
* EXPERIENCE WITH MASTER DATA MANAGEMENT SOLUTIONS, INFORMATICA MDM AND INITIATE PREFERRED
* EXPERIENCE WITH DATA PROFILING/QUALITY SOLUTION, INFORMATICA DATA QUALITY (IDQ) PREFERRED
* EXPERIENCE MODELING ENTERPRISE LEVEL DATA MODELS FOR HADOOP (PREFERABLY) BASED BIG DATA PLATFORMS
* DEMONSTRATED EXPERTISE IN WRITING AND ANALYZING COMPLEX SQL QUERIES IN A VERY LARGE DATABASE (VLDB) ENVIRONMENT IS REQUIRED
* Ability to work on multiple projects simultaneously and deliver within tight timelines while being flexible in adapting to new roles
* Ability to work with multiple areas within organization to get business objectives, data requirements etc.
* Ability to interpret data that is not well defined or documented and develop recommendations based on findings

PREFERRED SKILLS/EXPERIENCE

* Experience architecting big data / hadoop solutions in an enterprise data warehouse environment
* Experience with Cognos 10.2reporting tool (frame work / Studios/ reporting)
* KNOWLEDGE OF INFORMATICA (MDM, BDE), ABILITY TO READ / ANALYZE EXISTING CODE AND BE ABLE TO PROPOSE INNOVATIVE SOLUTIONS AND MODIFICATIONS

EDUCATIONAL REQUIREMENTS

* Bachelor's Degree in related field required. Master's Degree in related field preferred