Data Architect

KPI Digital Solutions; Mumbai; Hybrid; INR 900,000 - 1,300,000; Full time

Benefits offered by this job

Hybrid work arrangement

Competitive salary and bonus

Group insurance plan

Retirement savings plan with matching

Casual work environment

Gym access

Catering subsidies / free snacks

Job summary

KPI Digital Solutions in Mumbai is seeking a Data Architect with BI and AI expertise to provide consulting services to our clients, shaping data governance, conceptual and physical data models, and metadata layers for visualization and APIs.

You will lead sessions with business stakeholders, translate requirements into scalable data architectures, and work across clouds, data pipelines, and governance structures to enable modern analytics and AI initiatives.

Qualifications

• Must have built conceptual data models from scratch and implemented them in production.
• Experience creating governance programs with policies and processes.
• Strong communication skills to align business requirements with data architecture.
• Experience with data lakes, warehousing, and metadata management.
• Familiarity with COBIT and regulatory frameworks is a plus.

Responsibilities

• Work with our customers’ stakeholders to identify opportunities for leveraging data to produce insights and optimize business processes.
• Assess the effectiveness and accuracy of new data sources and data gathering techniques.
• Provide recommendations to move toward a modern D&A platform for AI scaling.
• Ensure models (conceptual to physical) are complete, coherent, and consistent.
• Guide data engineers from data ingestion to transformation toward the Data Lake.
• Assist sales efforts as SME from the D&A practice in client meetings and SOWs.
• Deliverables started by VP D&A practice for internal and external projects.
• Direct teams from architectural and governance perspectives.

Skills

Data modeling

BI architecture

Cloud technologies

Governance

SQL

Stakeholder communication

Whiteboarding

French/English bilingual

Education

Bachelor's degree in Computer Science or related field

Tools

Collibra

Cloudera EDH

Watson Knowledge Catalog

PowerDesigner

ErWin

Sparx

CaseWise

BizzDesign

Aris

Unicom System Architect

Orbus I-Server

Job description

The Data & Analytics group is looking for a Data Architect with, BI and AI expertise who will be providing consulting services to our customers.

The candidate

• Is a senior Data architect that can develop detailed and comprehensive conceptual data model
• Is at ease defining business processes map, SIPOC, and business capabilities models
• Can put a governance program in place with appropriate structure, committees and supporting processes and tools. And can define policies and enforce them for the full life cycle of data
• Is a senior BI architect that can transpose the conceptual data model in dimensional models an ideally can go further by taking the dimensional models and physicalizing them on traditional and modern D&A platform.
• The BI architect is also expected to create the dimensional metadata layer to be consumed by visualization software and/or thru API
• Master one or more Cloud environments and has been involved in AI projects

Requirements

• Has defined either ‘home grown’ DG solution or use tools such as Collibra, Cloudera EDH, Watson Knowledge Catalog or others
• Must have a great experience in creating conceptual data models from scratch and have them physically implemented. This clearly is not only the ability to identify and define the right concepts but also the ability to have the concepts physically implemented and used in applications and dashboards
• Can translate and animate sessions with businesspeople and other SMEs to either complete a started model or do one from scratch
• Has done multiple snowflake and STAR model from a conceptual data model and/or directly
• Has used and created multiple data layers including the use of metadata for exposing datamarts to visualisation tools
• Can define the access rights management solution
• Has implemented various regulations such as PIPED Act, GDPR, IFRS, SOX or others
• Has used multiple Data Modeling tools and Enterprise Architecture tools (PowerDesigner, ErWin, Embarcadero, Sparx, CaseWise, BizzDesign, Aris, Alfabet AEM, Unicom System Architect, Orbus I-Server, etc.)
• Possesses excellent written and verbal communication skills for coordinating across teams
• Is driven to learn and master new technologies and techniques
• Can understand rapidly the patterns and directions taken by the Practice Lead (former chief architect)
• Can zero-in on ambiguous concepts and made them crystal clear rapidly
• Is pragmatic (consider constraints) but not to the expense of faulty designs/concepts
• Can discern fundamental and key aspects worth ‘fighting for’ versus the less ‘important’ ones
• Is great at whiteboarding with customers and prospects. Excellent understanding of SQL (DDL and DML)
• Understands asynchronous architecture using ‘queue mechanisms’ such as Event Hub/Kakfa
• Has implemented the Data aspect related to COBIT
• Is bilingual (French and English) preferred

Responsibilities

• Work with our customers’ stakeholders to identify opportunities for leveraging their data to produce insights allowing them to improve business processes or even innovate by changing the industry. The same assessment could also be used to identify constraints allowing to optimize (DO) business processes
• Assess the effectiveness and accuracy of new data sources and data gathering techniques
• Assess, audit, and provide recommendations to help our customers move toward a modern D&A platform allowing them to scale their AI
• Ensure that all models (conceptual to physical) are complete, coherent, and consistent
• Help the data engineers from getting the data to the transformation toward the DataLake
• Help the BA to have business requirements align with the data architecture and vice-versa. Data architects create generic to specific data concepts and they need to tie back to the business requirements. On the other hand, many times business requirements describe the how versus the what which is a constraint in itself
• Assist sales efforts as SME from the D&A practice by meeting prospects and customers presenting the D&A offerings from KPI Digitals and participating in SOW
• Handle and complete the deliverables started by the VP of D&A practice for internal and external projects
• Guide and direct teams from architectural and governance perspective

What will make you successful here?

• A desire to be accountable for owning problems from design to implementation
• An understanding of the difference between data and useful insights
• A bias for action and pragmatic solutions
• A low ego and humility; an ability to gain trust through effective communication and doing what you say you will do
• A talent for operating effectively at various levels of abstraction
• An aptness to distill complex, technical topics articulately to a non-technical audience
• Adaptability, flexibility and an ability to navigate ambiguity
• Who is KPI Digital?:

KPI Digital has been helping clients meet their revenue goals for over 25 years. We specialize in Digital Transformation, Analytics & AI and Performance Management business solutions/services. More specifically Analytics, Digital Marketing, Big Data, Insights, Customer 360, Artificial Intelligence (AI), Machine Learning and Internet of Things (IOT). In addition, we offer Consulting Services, Managed Services, Packaged Services, Education and Training.

Benefits

• The opportunity to join and grow an ever-expanding professional network of high-profile clients and reputable colleagues.
• Permanent, full-time job (40 hours a week).
• Hybrid (work from home and/or office) and flexible schedule.
• Competitive salary and bonus structure.
• Attractive group insurance plan.
• Retirement savings plan with matching.
• Family company culture.
• Flex-Fridays in the summertime.
• Free use of the gym within building.
• Subsidized catering service & free snacks at the office.
• Vacation days plus 6 personal days per year.
• Casual work environment: jeans-friendly!

Proudly a Great Place to Work!

As you bring your experience and skills to KPI Digital, you’ll get a unique experience, ambitious growth, and limitless learning in return. As we continue to build our diverse and inclusive culture, we become even more innovative and creative, helping us better serve our clients and our communities.