Data Analyst / Data Modeler

Exusia; Johannesburg; Remote; ZAR 600,000 - 800,000; Full time

Job summary

A global technology consulting company is seeking a Senior Data Analyst to work with Banking & Financial Services clients. This full-time role involves delivering data-driven solutions and performing data analysis and modeling. Candidates must have over 4 years of experience, strong SQL skills, and familiarity with data modeling tools. Remote work is possible, and competitive compensation is offered.

Qualifications

• Minimum of 4 years of experience working as a Data Analyst and Data Modeler.
• Experience working in an agile software delivery model.
• Prior data modeling experience for DWH / Data marts is mandatory.

Responsibilities

• Deliver data-driven solutions by performing business and data analysis.
• Create logical and conceptual data models for users.
• Discuss and document data and analytics requirements with stakeholders.

Skills

Data modeling

SQL

Python

Data validation

Visualization tools - PowerBI

Education

Master of Science in Computer Science or Engineering degree

Tools

Erwin

ER Studio

InfoSphere Data Architect

Job description

About The Position

Department : Sales and Delivery Team - Empower

Industry : Information Technology & Services, Computer Software, Management Consulting

Location : South Africa (Remote)

Experience Range : 4+ years

Basic Qualification : Masters / Bachelor of Engineering or Equivalent

Travel Requirements : Not required

Website :

Exusia, a cutting-edge digital transformation Company is looking for Senior Data Analysts who will work for our Banking & Financial Services clients focused on Data Engineering & Data Analytics projects

What’s the Role?

Full-time job to work with Exusia's global (Americas, Europe, Africa, Asia) clients to deliver bleeding-edge data-driven solutions by performing business and data analysis, data modelling, data mapping and translating functional requirements into technical specifications. Work with Client Product Owners & Business SMEs, Exusia Solution Architects and Senior Application Designers / Developers.

Qualifications & Role Responsibilities

• Have a minimum of 4 years of experience working as a Data Analyst and Data Modeler
• Master of Science (preferably in Computer and Information Sciences or Business Information Technology) or an Engineering degree in the above areas.
• Experience working in an agile software delivery model is required.
• Prior data modelling experience is mandatory preferably for DWH / Data marts
• Self-motivated and proactive in a fast-paced environment.
• Excellent communication, creative problem solver, flexible, proactive, attitude to learn newer tools / technologies
• Own and Lead Data Analysis and data modeling activities
• Discuss & document data and analytics requirements with cross functional teams and business stakeholders.
• Analyze requirements and come up with technical specifications, source-to-target mapping, data and data models
• Data profiling and cleaning data for data analysis. Interpret data, analyze results, prepare data analysis reports.
• Perform Data validation and testing to certify data
• Collect, analyze and disseminate significant amounts of information to project team & business stakeholders.
• Manage changing priorities during the software development lifecycle (SDLC)

Requirements

Mandatory Skills :

Able to create Logical and Conceptual data models for business and functional users

Understanding of ER and Dimensional modeling techniques like Star, Snowflake or Constellation

Hands on experience in implementing Star Schema and Relational (Normalized including 3NF) models is mandatory

Should have implemented physical data models for a variety of RDBMS and cloud hosted databases

Strong understanding of different types of facts and dimensions

Hands on experience with data modeling tools like Erwin, ER Studio, InfoSphere Data Architect (IDA)

Strong SQL or python skills for carrying out data analysis and data profiling

Transforming business / functional requirements into technical specifications.

Capturing data mapping / data transformation and business rules logic using source to target mapping templates

Hands-on exposure to SQL and NoSQL databases and able to write pseudo-code for ETL requirements.

Data validation and testing using SQL or any tool-based testing methods

Reporting / Visualization tool experience - PowerBI

Azure Certification relevant for Data Engineering / Analytics

Experience and knowledge of one or more domains within Banking and Financial Services

Nice-to-Have Skills :

Exposure to scrum master or product owner role will be desirable

Knowledge of data processing / ETL using Ab Initio / SAS / ADF / Azure Databricks

Exposure to one or more Cloud platforms – Amazon Web Services (AWS), Microsoft Azure, Google Cloud Platform

Exposure to Data Governance projects including Metadata Management, Data Dictionary, Data Glossary, Data Lineage and Data Quality aspects.

About Exusia

Exusia () is a global technology consulting company that empowers its clients to gain a competitive edge by accelerating business objectives and providing strategy and solutions in data management and analytics. The company has established its leadership position by solving some of the world's largest and most complex data problems in the financial, healthcare, telecommunications and high technology industries.

Exusia’s mission is to transform the world through the innovative use of information.

Exusia was recognized by Inc. 5000 and by Crain’s publications as one of the fastest growing privately held companies in the world. Since the company’s founding in 2012, Exusia has experienced an impressive seven years of revenue growth and has expanded its operations in the Americas, Asia, Africa and UK. Exusia has recently also been recognized by publications such as the CIO Review, Industry Era, Insight Success and the CIO Bulletin for the company’s innovation in IT Services, the Telecommunications and Healthcare industries and its entrepreneurship. The company is headquartered in Miami city of Florida, United States with development centers in Pune, Hyderabad, Bengaluru and Gurugram, India.

Interested applicants should apply by forwarding their CV to :