Data Modeler

Sonata Software Overview

In today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers. As a leading Modernization Engineering company, we aim to deliver modernization-driven hypergrowth for our clients based on the deep differentiation we have created in Modernization Engineering, powered by our Lightening suite and 16‑step Platformation™ playbook.

In addition, we bring agility and systems thinking to accelerate time to market for our clients. Headquartered in Bengaluru, India, Sonata has a strong global presence, including key regions in the US, UK, Europe, APAC, and ANZ. We are a trusted partner of world-leading companies in BFSI (Banking, Financial Services, and Insurance), HLS (Healthcare and Lifesciences), TMT (Telecom, Media, and Technology), Retail & CPG, and Manufacturing space.

Our bouquet of Modernization Engineering Services cuts across Cloud, Data, Dynamics, Contact Centres, and around newer technologies like Generative AI, MS Fabric, and other modernization platforms.

• Deliver a world‑class data architecture to an enterprise that establishes robust data governance and enforces best practices, policies, and procedures across the entire data landscape on cloud or premises.
• 10+ years of experience in designing data assets for extremely performant Operational Data Stores and near real‑time Data Warehouses. Well versed with industry‑standard Kimball and Inmon practices.
• Expertise in creating ER, Logical, Physical, and Conceptual data models for an enterprise. At least 10 years hands‑on experience with Data Modeling tools such as Erwin. Data modeling experience in financial industry is highly preferred.
• Drive reuse of data and data models at all levels and establish standards to enforce and preserve single version of truth across the data landscape.
• Solid communication skills and be able to facilitate / lead Data Modeling sessions with partners including Business, IT (engineers and developers), BI (Business Intelligence), System of Record (SOR) SMEs etc. to assess business requirements and deliver design prototypes and models.
• Experience in event streaming and event‑based data warehousing methodologies.
• Experience in modern data design methodologies such as DDD (Domain‑Driven Design), Microservices‑Based Architecture, Bounded Contexts, and Data Mesh building data warehouses for agility, scalability, and autonomy.
• 10+ years of data analysis and profiling experience in financial services development, including account, card, payment, or digital processing.
• Expert SQL development, analysis, design, and performance skills in database technologies such as Mongo
  
  DB and Oracle EXADATA to build highly performant physical data models.
• Expert hands‑on development, and performance tuning experience in Snowflake including writing pipelines, coding stored procedures, and establishing data share.
• Well versed in PowerPoint and be able to design complex dashboards in Power BI.
• Expert in Excel and Splunk with experience in writing complex macros to expedite data analysis.
• Experience in reverse/forward engineering analysis for complex data flows and be able to develop source‑to‑target and process mappings.
• Strong scripting experience in Python to create alerts and monitoring, build ingestion and interfaces to move data between systems and automate data governance.
• Experience in building and maintaining an evergreen Data Catalogue for an enterprise with robust metadata and end‑to‑end lineage. Experience with Alation, Collibra etc. is nice to have.
• Experience in tools such as Matillion, Snap Logic, or DBT is nice to have to be able to build data pipelines for on‑cloud / on‑premises databases such as Snowflake.
• Experience with industry reference frameworks such as BIAN (Banking Industry Architecture Network), IBM Banking & Financial Markets Model, ISO
  20022 is a plus.

• Excellent interpersonal, written,…