ABOUT
CoorB
We
build full-fledged innovative solutions with a focus on process automation,
user experience enhancement, and advanced data analytics. With our extensive
industry expertise, we help achieve operational excellence, future-proof your
IT investments, and ensure a competitive edge in the ever-evolving finance
industry.
OUR
OPPORTUNITY
We are looking
for a
Data Analyst
to work closely with the Data Architect, Technical
Data Lead, Business Analysts, ETL Developers, BI Developers, Platform
Administrators, and business stakeholders.
The Data
Analyst will play a key role in understanding business requirements, analyzing
existing data structures and processes, validating data, defining analytical
requirements, and supporting the transition toward the company’s target data
architecture.
The role
requires a strong combination of
business analysis, data analysis, SQL, data
quality, reporting, and data visualization
skills, with the ability to
translate business questions into reliable, actionable data insights.
YOU
WILL
»
Analyze business
requirements and translate them into clear data and analytical requirements.
»
Work with stakeholders
to understand business processes, KPIs, reporting requirements, and data needs.
»
Analyze existing data
sources, ODS, DWH, staging, data marts, and reporting environments.
»
Profile and assess
data to identify quality issues, duplication, inconsistencies, missing values,
and data anomalies.
»
Investigate existing
reports, dashboards, calculations, and business logic to ensure they are
correctly understood before migration or redesign.
»
Define and document
data requirements, source-to-target mappings, business rules, and
transformation logic.
»
Develop complex SQL
queries for data extraction, reconciliation, validation, and analysis.
»
Support the Data
Architect in assessing current-state data architecture and defining
requirements for the target-state platform.
»
Work with ETL/ELT
teams to validate data pipelines and transformation logic.
»
Perform
source-to-target reconciliation and data validation during migration
activities.
»
Support data migration
and coexistence activities between legacy and target platforms.
»
Analyze data from
Oracle, DWH, ODS, MDM, BI, and other enterprise data platforms.
»
Work with data
integration patterns including batch, CDC, APIs, and file-based ingestion from
an analytical and business perspective.
»
Develop and maintain
analytical datasets, data marts, and semantic-layer requirements.
»
Work with BI
developers to define and validate dashboards, reports, KPIs, and semantic
models.
»
Support Power BI and
other BI solutions by validating metrics, dimensions, measures, and business
calculations.
»
Define and document
data quality rules and support data quality monitoring.
»
Assist with metadata,
data lineage, data ownership, and business glossary activities.
»
Identify opportunities
to simplify reporting, eliminate redundant data processes, and improve data
usage.
»
Support regulatory,
management, operational, and enterprise reporting requirements.
»
Ensure analytical
requirements are aligned with data governance, security, and regulatory
requirements.
»
Support the
preparation of data for advanced analytics, machine learning, and future AI/LLM
use cases.
»
Communicate analytical
findings and data issues clearly to both technical and non-technical
stakeholders.
»
Contribute to data
standards, documentation, and best practices across the organization.
»
TO BE SUCCESSFUL IN THE ROLE YOU NEED
»
Strong experience as a Data Analyst,
BI Analyst, Business Intelligence Analyst, or similar data-focused role.
»
Strong SQL skills and experience
working with relational databases, preferably Oracle or similar enterprise
database platforms.
»
Good understanding of ODS, DWH, data
marts, lakehouse, semantic layers, ETL/ELT, and BI architectures.
»
Experience with data profiling,
reconciliation, validation, and data quality analysis.
»
Experience gathering and documenting
business and data requirements.
»
Strong understanding of data
modeling concepts, including facts, dimensions, relationships, and analytical
data structures.
»
Experience with Power BI or similar
visualization and BI platforms.
»
Understanding of enterprise data
platforms and technologies such as Informatica, GoldenGate, MDM, DQ, EDC/Axon,
or equivalent technologies is an advantage.
»
Experience working with cloud and
modern data platforms such as Microsoft Fabric, Databricks, Snowflake, Azure,
AWS, or GCP is an advantage.
»
Understanding of CDC, data
integration, metadata, lineage, data governance, and data security.
»
Ability to investigate complex data
problems and identify the root cause of inconsistencies.
»
Strong attention to detail and a
structured approach to data analysis.
»
Ability to communicate effectively
with business users, developers, architects, and senior stakeholders.
»
Experience working in financial
services, banking, insurance, or other regulated industries is a strong
advantage.

What traditionally takes years, CoorB achieves in weeks!
CoorB is a professional services company specializing in Strategy and Consulting, Technology, and Managed Services. We work with banks and non-banking financial institutions to design and implement innovative growth models; we provide highly qualified expertise spanning business strategy, advanced technology, and effective program management; we deliver future-ready technological solutions that overcome legacy limitations; we enhance organizational agility and ensure technology serves the business goals. Our swift resource mobilization across disciplines and unique approach to problem-solving enable us to achieve meaningful results with unparalleled speed.