Data Architect

Job Title- Data Architect Position type- Full Time Work Location- Bangalore/Noida/Gurgaon Working style- Hybrid Cab Facility- Yes Shift Time - 10am-7pm pm IST People Manager role: No Required education and certifications critical for the role- Any Graduate or Post-Graduate (full-time) Required years of experience – 11-15 years of experience AON IS IN THE BUSINESS OF BETTER DECISIONS At Aon, we shape decisions for the better to protect and enrich the lives of people around the world. As an organization, we are committed as one firm to our purpose, united through trust as one inclusive, diverse team and we are passionate about helping our colleagues and clients succeed. Aon's breadth of product offerings and global reach give us massive access to data and information, providing a unique opportunity to innovate and build differentiating solutions for clients. The Aon Centre for Innovation and Analytics (ACIA) is heavily investing in these opportunities, requiring a globally coordinated effort. Role Overview: We are seeking a Data Architect who will lead the design and implementation of data architectures that support our data-driven initiatives. This role is perfect for someone who is a team player, keen to learn new skills, and has a meticulous eye for data. You will work with a team of experienced actuarial analysts, architects, developers, and business resources to build databases, warehouses, and ETL/ELT pipelines to fuel modern web applications and visualizations.Responsibilities:•Collaborate with teams of experienced actuaries, data analysts, architects, data engineers, and business experts to deliver projects.•Design and implement scalable data architectures that align with business objectives, including data models, metadata management, and database schemas.•Lead the selection of suitable technologies for data storage, integration, and analytics.•Establish data governance policies to ensure data quality, security, and compliance.•Perform data analysis to troubleshoot and resolve data-related issues.•Implement data warehouse and lake house solutions to support data and analytics initiatives.•Assist in the support and enhancement of existing data pipelines and databases and troubleshoot performance issues.•Participate in database design and modeling.•Provide technical leadership and guidance to the data engineering team in implementing architectural designs.•Work closely with cross-functional teams to understand business requirements and translate them into scalable and efficient data solutions.•Stay current with industry trends and emerging technologies to drive continuous improvement in data architecture strategies and best practices. Requirements:•8+ years of total experience working with data integration teams.•5+ years of experience in data architecture, database design, and data management.•3+ years of working experience in Databricks.•4+ years of in-depth experience developing data pipelines within an Apache Spark environment (preferably Databricks).•Good proficiency in Python and SQL.•Strong knowledge of data modeling, database technologies, and data warehousing.•Experience with ETL/ELT processes and tools.•Knowledge of cloud platforms (AWS or Azure) and big data technologies (Hadoop, Spark, etc.).•Understanding of data governance, security, and privacy frameworks.•Experience with BI and analytics tools like Power BI or Tableau.•Excellent communication skills, with the ability to convey complex technical concepts to both technical and non-technical stakeholders. Nice to haves:•ExperienceExperience integrating AI into data engineering.Certifications in Databricks, cloud computing, or database management.•Experience developing data solutions using native IaaS and PaaS solutions on AWS (RDS, S3).•Experience in any object-oriented programming language.

Aon is in the business of better decisions. As an organization, we are committed as one firm to our purpose, united through trust as one inclusive, diverse team and we are passionate about helping our colleagues and clients succeed. Aon's breadth of product offerings and global reach give us massive access to data and information, providing a unique opportunity to innovate and build differentiating solutions for clients. The Aon Centre for Innovation and Analytics (ACIA) is heavily investing in these opportunities, requiring a globally coordinated effort.