Data Architect - Data Warehousing

Department: Development

Location: Pune, India

Description

ParentPay Group is Europe's leading software product company and the UK's largest education technology business. We are on a mission to bring next-generation innovation to positively impact on the lives of millions of parents, teachers, and students every day in over 49 countries.

Our market leading products use cutting edge cloud-based technology to streamline school processes, including secure web and mobile apps that enable secure online payments for school items such as meals, trips, clubs and uniform, improve parental engagement, simplify meal management and - through our product SIMS - collect and manage a database of student information and core school operations.

ParentPay Group's new offices in Pune are a fantastic tech hub for those looking to boost their careers in software product development.

Our bright team FastTrack their career with international exposure and ways of working based on agile development best practices from globally renowned technology consultancies.

Key Responsibilities

Responsibilities: Data Architect

• Creating data models that specify how data is formatted, stored, and retrieved inside an organisation. This comprises data models that are conceptual, logical, and physical.


• Creating and optimising databases, including the selection of appropriate database management systems (DBMS) and the standardisation and indexing of data.


• Creating and maintaining data integration processes, ETL (Extract, Transform, Load) workflows, and data pipelines to seamlessly transport data between systems.


• Collaborating with business analysts, data scientists, and other stakeholders to understand data requirements and align architecture with business objectives.


• Stay current with industry trends, best practices, and advancements in data management through continuous learning and professional development.


• Establishing processes for monitoring and improving the quality of data within the organisation.


• Implement data quality tools and practices to detect and resolve data issues.

Requirements and Skills: Data Architect

• Prior experience in designing Data Warehouse, data modelling, database design, and data administration is required.


• Database Expertise: Knowledge of data warehousing ideas and proficiency in various database systems (e.g., SQL).


• Knowledge of data modelling tools such as Visual Paradigm is required.


• Knowledge of ETL methods and technologies (for example, Azure ADF, Events).


• Expertise writing complex stored procedures.


• Good understanding of Data Modelling Concepts like Star Schema ,SnowFlake etc


• Strong problem-solving and analytical skills are required to build effective data solutions.


• Excellent communication skills are required to work with cross-functional teams and convert business objectives into technical solutions.


• Knowledge of Data Governance: Understanding data governance principles, data security, and regulatory compliance.


• Knowledge of programming languages such as .net can be advantageous.