Data Modeller
India - Bangalore
Capco
Capco is a global management and technology consultancy dedicated to the financial services and energy industries.Responsibilities:
- Responsibilities Translate Business Requirements to Conceptual, Logical and Pysical Data Models
- Recognize the need for a specific relational design – OLTP, OLAP, Data Warehouse – from a set of requirements and/or from a Logical Data Model
- Participate in mapping of Logical to Physical Data Models and vice versa
- Perform model creation for large set of data which are being sourced to Big Data
Role Requirements
- Strong Data Modeller with Financial Services experience
- Knowledge of and experience using data models and data dictionaries in a Banking and Financial Markets context
"Knowledge of one or more of the following domains (including market data vendors):
o Party/Client
o Trade
o Settlements
o Payments
o Instrument and pricing
o Market and/or Credit Risk"
- Demonstrate a continual desire to implement “strategic” or “optimal” solutions and where possible, avoid workarounds or short term tactical solutions
- Working with stakeholders to ensure that negative customer and business impacts are avoided
- Manage stakeholder expectations and ensure that robust communication and escalation mechanisms are in place across the project portfolio
- Good understanding of the control requirements surrounding data handling
Experience/Skillset
- Excellent analytical skills and commercial acumen
- Experience in ETL/ELT as well as Entity Relationship (ER) data modelling
- Understanding of slowly moving dimensional Datawarehouse (star schema, kimball dimensional data modelling)
- Good knowledge of SDLC and formal Agile processes as well as testing experience
- Can write SQL (NoDQL) and Python queries, Scala knowledge preferable and navigate data bases especially Hive, CMD, Putty, Note++
- Strong self-starter with strong change delivery skills who enjoys the challenge of delivering change within tight deadlines
- Strong verbal and written communication skills
- Ability to manage multiple priorities
- Knowledge of and experience using data models and data dictionaries in a Banking and Financial Markets context
- Preferable knowledge and experience in Data Quality & Governance
- Understanding of on-prem and Cloud Data Lakes as well as data warehouses architecture
- Enthusiastic and energetic problem solver to join an ambitious team
- Business analysis skills, defining and understanding requirements
- Attention to detail
- Ability to communicate effectively in a multi-programme environment across a range of stakeholders
- Knowledge of Hadoop of Google Big Query is a plus
Tags: Agile Architecture Banking Big Data BigQuery Credit risk Data quality Data warehouse ELT ETL Hadoop OLAP Python Scala SDLC SQL Testing
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open AI Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Sr Data Engineer jobs
- Open Data Engineer II jobs
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Power BI Developer jobs
- Open Junior Data Scientist jobs
- Open Product Data Analyst jobs
- Open Data Scientist II jobs
- Open Senior Data Architect jobs
- Open Business Intelligence Developer jobs
- Open Sr. Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Big Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Business Data Analyst jobs
- Open Data Quality Analyst jobs
- Open Data Product Manager jobs
- Open Junior Data Engineer jobs
- Open ETL Developer jobs
- Open Principal Data Scientist jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open GCP-related jobs
- Open ML models-related jobs
- Open Privacy-related jobs
- Open Data management-related jobs
- Open Java-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open APIs-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open Consulting-related jobs
- Open TensorFlow-related jobs
- Open Snowflake-related jobs
- Open PhD-related jobs
- Open NLP-related jobs
- Open CI/CD-related jobs
- Open Kubernetes-related jobs
- Open Airflow-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Hadoop-related jobs
- Open LLMs-related jobs
- Open Data warehouse-related jobs