Need for Data Modeler/ Data Analyst on W2 @ Columbus, OH

Need for Data Modeler/ Data Analyst on W2 @ Columbus, OH

• Contract

Job Title: Data Analyst / Data Modeler
Location: Columbus, OH 43215
Duration: 12+ Months

COMPLETE SKILL MATRIX:

1. Data Analysis
2. Data Modeling - Hybrid, Dimensional and Relational
3. Data Visualization
4. Source to Target Mapping
5. Data Profiling
6. Hadoop plus

Responsibilities:

1. Critically evaluates information gathered from multiple sources, reconciles conflicts, and classifies the information in logical categories.
2. Uses different visualization techniques and presents the results of data exploration exercises.
3. Understands the flow of data, business processes/technical interfaces that would be created or impacted.
4. Documents the source to target mappings for both data integration as well as web services (consumer/provider mappings) that can be easily understood by the project team members with data quality and transformation rules.
5. Identifies and documents sources of existing data as well as the new data. Understands the use of master and reference data including sources and contributors.
6. Collaborates with data scientists and business partners and conducts data profiling and predictive analysis using a variety of standard tools.
7. Creates conceptual, logical, and physical data models and determines the most appropriate method to represent the data for business consumption. This includes all forms of physical representation of data, such as relational, dimensional, object, key-value (such as column families), and graph.
8. Has joint accountability with data stewards and data architects on the projects to ensure conformance to enterprise data governance policies around information risk and data protection guidelines. Data analysts should be familiar with common policies around data masking and protection schemes.
9. Data source identification, data profiling, interpretation of patterns and trends, assessment of and improvement of data quality, versatility with visualization tools and techniques to share analysis findings.

It is beneficial for individuals to have worked as a data analyst in any of the following types of projects:

1. Analytically Intensive – Intended to draw/develop insights from data that is collected.
2. Operationally Data Intensive – Intended to create authoritative data sources that are essential to core transactional processing.
3. Data Integration Intensive – Requires the merging of many data types to satisfy business requirements.

Required Skills:

1. Data Analysis
2. Data Modeling - Hybrid, Dimensional and Relational
3. Data Visualization
4. Source to Target Mapping
5. Data Profiling
6. Hadoop plus