Previous Job
Previous
Data Analyst IV
Ref No.: 18-03811
Location: Cincinnati, Ohio
Senior Data Analyst

This is a unique opportunity to work directly with a person on the line of business to deliver maximum value to the organization. You will be working side by side manipulating large data sets across all our financial institution clients to develop the ideal data sets and structures to be used as the backbone in future UI Tool integrations. You will be assisting to add maximum value in the most advanced looks into our valuable data points.

Candidate should have an inquisitive nature and be a fast learner. You will be working in a team of two to push the limits of our data and create unique business insights.

Your main tasks will be to analyze data, help to define optimal table structures, scheduled rollup processes and aggregation, with the key goal of delivering easily repeatable aggregation routines to build out a custom data mart of advanced metrics.

Job Duties:
  • Utilizes a hypothesis-driven problem-solving approach to design, construct, and rapidly test/iterate exploratory data-mining analyses to reveal insight across the company's portfolio.
  • Interprets and communicates insights to product, service and business management.
  • Works with business leaders to identify and develop metrics and visualizations that will track performance and highlight potential inefficiencies.
  • Develop functional understanding of the business and apply towards building business facing marts
  • Partners with business teams to gather, document and maintain business requirements that will inform data modeling decisions.
  • Compiles data from various sources into a single, consumable, data set, including design and implementation of data cubes.
  • Required strong analytical acumen with the ability to uncover insights and create stories by seamlessly integrating a variety of data sources
  • Ability to work in a fast-paced and dynamic environment
  • Ability to work with large, complex data sets across multiple platforms and design efficient processes to provide accurate and timely information.

Required Skills:
  • In-depth understanding of underlying data, data structures, and business uses of data.
  • ETL Tools like DataStage, Informatica etc and procedures including PL/SQL.
  • Experience in data mining and root cause analysis preferred
  • Bachelor's degree in Data Analytics, Computer Science, Information Systems or Business; prior work experience in Business Intelligence preferred.
  • Typically requires a minimum of 5 years of related experience with a Bachelor's degree; or 3 years and a Master's degree; or a PhD without experience; or equivalent work experience.

Desired Skills:
  • Working Experience of Big Data landscape as demonstrated through experience or certification. Eg., Hadoop, Spark, Hive, Pig, Impala.
  • Proficiency with sophisticated analytics tools and programming languages (e.g., R, Python, SQL, HiveQL)
  • Experience with relational databases, and data warehousing (Oracle, DB2, Hadoop)