Data Engineer - Azure & Data Platforms(ADF, ADB, Synapse, SQL, Python, Pyspark)
__jobinformationwidget.freetext.LocationText__
Bangalore
Are you ready to take the next step in your career?
PostulezWe’re AtkinsRéalis, a world-leading Design, Engineering and Project Management organization. Created by the integration of long-standing organizations dating back to 1911, we are a world-leading professional services and project management company dedicated to engineering a better future for our planet and its people. We create sustainable solutions that connect people, data and technology to transform the world's infrastructure and energy systems. We deploy global capabilities locally to our clients and deliver unique end-to-end services across the whole life cycle of an asset including consulting, advisory & environmental services, intelligent networks & cybersecurity, design & engineering, procurement, project & construction management, operations & maintenance, decommissioning and capital. The breadth and depth of our capabilities are delivered to clients in key strategic sectors such as Engineering Services, Nuclear, Operations & Maintenance and Capital.
News and information are available at www.atkinsrealis.comor follow us on LinkedIn.
Our teams are proud to deliver on some of the most prestigious projects across the world. It's thanks to our talented people and their diverse thinking, expertise, and knowledge. Join us and you'll be part of our genuinely collaborative environment, where everyone is supported to make the most of their talents and expertise. When it comes to work-life balance, AtkinsRéalis is a great place to be. So, let's discuss how our flexible and remote working policies can support your priorities. We're passionate about are work while valuing each other equally. So, ask us about some of our recent pledges for Women's Equality and being a 'Disability Confident' and 'Inclusive Employer’.
Job Description
About the job
Job title: Data Engineer - Azure
Job Level: Senior IC Level role
Role family: Finance
Department: Finance Shared Services (GTC India) / Corporate Functions FP&A (Group)
Location: Bangalore
Purpose of the role
The Data Engineer will play a vital role for R&A CoE wherein he will contribute in terms of creating the data platform for R&A CoE, data management, data pipeline creation, ensuring data quality & integrity, support data analytics, ensure performance and scalability of current and future data models. This role will be part of R&A CoE Finance wherein The person need to closely work with group’s data architecture & data platform team, project management team to ensure we develop R&A CoE Finance data platforms in accordance with group’s best practices.
Key Responsibilities
- Responsible for Creation of ETL Pipelines.
- Responsible for designing and building new Data Models and optimizing existing data models.
- Exploit elasticity and agility of the cloud.
- Ownership of physical Data models of serving layer
- Responsible and accountable for pipelines reliability and availability.
- Responsible of Data analysis for troubleshooting and exploration
- Understand the meaning, domain and the context of the data.
Professional & Technical skills
Essential:
- Azure Technology Stack: SQL DW/Synapse- Azure Data Factory - Azure Databricks - Azure Data Lake Storage.
- Knowledge & experience working w/ Microsoft data lakes (EDL, HRDL, PSDL) or analysis services (KPI Lake, Azure cubes).
- Ability to write complex SQL scripts and stored procedures.
- Demonstrated experience in design and delivering data platforms for Business Intelligence or Data Warehouse, including data ingestion, ETL and data integration.
- Strong skills in handling and analysing complex, high volume data with excellent attention in details.
- Knowledge of data modelling and data warehousing concepts, such as Kimball or 3NF.
- Familiar with Agile methodology and Agile working environment.
- Ability to work alone with team leads, BAs, data architects, other.
- The Individual
- You are highly analytical with an ability to apply your problem-solving skills to solve complex data platform challenges.
- You are self-motivated and passionate about actively contributing to our R&A CoE objectives.
- With your technical & business know-how you should easily perform due diligence on business Data Analytics problems and quickly grasp the key process issues and data challenges.
Qualifications & Experience
Essential:
- 3 - 4 years of experience in data warehouse environment, which includes developing ETL/ELT pipelines, database designs, writing SQL transformation.
- 3 – 4 years strong hands-on experience with Microsoft Azure Data & Analytics PaaS Services, including Azure Synapse, Azure Data Factory, Azure Data Lake, Storage and other services within the Azure data analytics framework.
- Deep knowledge or expert level experience in Databricks.
- Works with Architects, Technical Leads and Business Teams and contributes to the development of technical designs.
- Secure data migrations & transformations to/from clients, customers, and vendors.
- Develops, constructs, tests, and maintains Azure Data factory flows/pipelines.
- Working experience on PySpark, Spark SQL, Serverless SQL pool, Dedicated SQL pools.
- Strong knowledge of various data structures and the ability to extract data from various data sources (such as ePBCS (Hyperion), Cognos, Informatica etc.).
- Expose data to end users for consumption such as Power BI or other data integration sources ensuring that the proper security permissions are in place.
- Experience in writing complex SQL queries, stored procedures and creating data models.
- Proven experience performing large data migration and transformation efforts would be helpful Excellent Analytical skill to understand the issues and ability to backtrack them until root cause.
- Design, implement, and continuously expand ETL pipelines by performing extraction, transformation, and loading activities.
- Candidate should be aware of Release management, Change management, CI/CD pipelines.
Desirable
- Knowledge on Data from Oracle EBS(ERP), JDE(ERP), ePBCS (EPM) would be very good.
- Experience in working for a consulting firm with strict project deadlines is advantageous.
- Project Management certification like PMP, CAPM, PMI-ACP would be a great plus.
- Experience in building predictive analytics use cases around finance and accounting information/data.
- Experience in working on AI and ML related projects to prepare the necessary data and data models.
Additional Information
Working hours: 12pm – 9.30pm (India Standard Time)
Transportation, Food & Shift allowance will be provided.
Work Location: Yelahanka, Bangalore.
What We Can Offer You
Varied, interesting and meaningful work.
A hybrid working environment with flexibility and great opportunities.
Opportunities for training and, as the team grows, career progression or sideways moves.
An opportunity to work within a large global multi-disciplinary consultancy on a mission to change the ways we approach business as usual.
Why work for AtkinsRéalis?
We at AtkinsRéalis are committed to developing its people both personally and professionally. Our colleagues have the advantage of access to a high ranging training portfolio and development activities designed to help make the best of candidate’s abilities and talents. We also actively support staff in achieving corporate membership of relevant institutions.
Meeting Your Needs
To help you get the most out of life in and outside of work, we offer employees ‘Total Reward’. Making sure you're supported is important to us. So, if you identify as having a disability, tell us ahead of your interview, and we’ll discuss any adjustments you might need. Additional Information We are an equal opportunity, drug-free employer committed to promoting a diverse and inclusive community - a place where we can all be ourselves, thrive and develop. To help embed inclusion for all, from day one, we offer a range of family friendly, inclusive employment policies, flexible working arrangements and employee networks to support staff from different backgrounds. As an Equal Opportunities Employer, we value applications from all backgrounds, cultures and ability.
We care about your privacy and are committed to protecting your privacy. Please consult our Privacy Notice on our Careers site to know more about how we collect, use and transfer your Personal Data.
Link: Equality, diversity & inclusion | Atkins India (atkinsrealis.com)
Are you ready to take the next step in your career?
PostulezAccroche
CanadaType de contenu
BlogsDate de publication
02/19/2024
Récapitulatif
Aujourd'hui, nous rencontrons Sabrina et Claudia, deux femmes extraordinaires dans le domaine de l'ingénierie. Rejoignez-nous pour découvrir leurs parcours, leurs triomphes et l'impact qu'ell
Watch: Featured video content
Accroche
CanadaType de contenu
BlogsDate de publication
02/19/2024
Récapitulatif
Aujourd'hui, nous rencontrons Sabrina et Claudia, deux femmes extraordinaires dans le domaine de l'ingénierie. Rejoignez-nous pour découvrir leurs parcours, leurs triomphes et l'impact qu'ell
Watch: Featured video content
Related job roles
Salaire
Localisation
Mississauga
Job Type
Full Time
Career Area
Engineering (Other)
Marché
Nuclear
Category
Contrat à durée déterminée
Location
Mississauga
Description
Samrt Plant Support SpecialistAtkinsRéalis is one of Canada's largest private sector nuclear engineering groups. We have been providing a wide range of services to the nuclear industry in Canada and a
Référence
R-109589
Date d’expiration
01/01/0001
Salaire
Localisation
Jonquière
Job Type
Full Time
Career Area
Engineering (Other)
Marché
Environnement et géosciences
Category
Permanent
Location
Jonquière
Description
Pourquoi rejoindre notre équipe ?Vous avez acquis ce qu’il faut en tant que professionnel en ingénierie des matériaux, en plus de posséder d’excellentes capacités en gestion de projets? Vous êtes prêt
Référence
R-089775
Date d’expiration
01/01/0001
Salaire
Localisation
Kincardine
Job Type
Full Time
Career Area
Union
Category
Contrat à durée déterminée
Location
Kincardine
Mississauga
Description
Document Control CoordinatorAtkinsRéalis is one of Canada's largest private sector nuclear engineering groups. We have been providing a wide range of services to the nuclear industry in Canada and aro
Référence
R-114540
Date d’expiration
01/01/0001
Salaire
Localisation
Vancouver
Job Type
Full Time
Career Area
Business support
Category
Permanent
Location
Vancouver
Description
Come join us in reshaping the future with AtkinsRéalis. AtkinsRéalis is dedicated in engineering a better future for our planet and its people.This role will be based in Vancouver, BC.Your role within
Référence
R-114445
Date d’expiration
01/01/0001
Salaire
Localisation
Boucherville
Job Type
Full Time
Career Area
Geotechnical engineering
Marché
Environnement et géosciences
Category
Entrepreneur / temporaire
Location
Boucherville
Description
Pourquoi rejoindre notre équipe ?La connaissance de la condition des chaussées est un élément important du processus de gestion et de détermination des besoins. Afin d’obtenir ces informations relativ
Référence
R-089618
Date d’expiration
01/01/0001
Salaire
Localisation
Québec
Job Type
Full Time
Career Area
Civil engineering
Marché
Villes et développement urbain
Category
Student
Location
Québec
Description
Stagiaire en infrastructures urbaines – Automne 2024 Rejoignez-nous pour remodeler l'avenir avec AtkinsRéalis. AtkinsRéalis se consacre à l'ingénierie d'un avenir meilleur pour notre planète et ses h
Référence
R-114679
Date d’expiration
01/01/0001
Salaire
Localisation
Mississauga
Job Type
Full Time
Career Area
Engineering (Other)
Marché
Nuclear
Category
Permanent
Location
Mississauga
Description
Are you looking for a company that works on major engineering projects all over the world? Do you want to make a difference by improving the daily lives of communities worldwide? Are you seeking to jo
Référence
R-107974
Date d’expiration
01/01/0001
Salaire
Localisation
West Midlands
Job Type
Flexible Working
Full Time
Career Area
Civil engineering
Marché
Transports
Category
Permanent
Location
West Midlands
Crewe
Manchester
Description
Engineer the rail of the future.Join our organisation, where we have a huge variety of projects on-the-go at any one time. So, when you start this role with us, it could take your career wherever your
Référence
R-114766
Date d’expiration
01/01/0001
Salaire
Localisation
Edinburgh
Job Type
Full Time
Career Area
Earth sciences
Marché
Villes et développement urbain
Category
Permanent
Location
Edinburgh
Description
Location- (Flexible across all locations in UK) AtkinsRéalis business is one of the world’s most respected design, engineering and project management consultancies and together, we have over 50,000 em
Référence
R-114663
Date d’expiration
01/01/0001
Salaire
Localisation
Riyadh
Job Type
Full Time
Career Area
Human resources
Category
Permanent
Location
Riyadh
Description
As a provider of multi-disciplined technical services to the built environment AtkinsRéalis in Saudi Arabia is committed to design excellence in the delivery of first class solutions which combine inn
Référence
R-114690
Date d’expiration
01/01/0001
AtkinsRéalis
Explorez les possibilités et voyez comment vous pouvez changer le monde en faisant ce que vous aimez chez AtkinsRéalis
Apprenez-en plus