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.
Requirements
»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.
Job description provided by CoorB.
View the original posting