Job Title: Data Analyst / Data Modeler
Location: Columbus, OH 43215
Duration: 12+ Months
1. 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, classifies the information in logical categories.
2. Uses different visualization techniques and present 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 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. Please note this list is not all inclusive.
8. Have 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 e – 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.
Skills Required
- Data analysis experience and skills
- Hybrid, dimensional, and relational data modeling
- Data visualization
- Source-to-target mapping
- Data profiling
- Hadoop Plus
What We Do
XpertTech is an IT and business-process outsourcing company that helps businesses operate and scale through staffing, managed IT services, mobile and other application development, digital marketing, finance and accounting, and HR and payroll solutions. It provides remote professionals and dedicated support across operational functions, combining technology services with back-office outsourcing to reduce overhead and streamline day-to-day business processes for growing organizations.
