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
05/08/2024
Récapitulatif
Dans n’importe quelle carrière, il est facile d’avoir une vision étroite et d’accorder une plus grande importance au perfectionnement des compétences techniques. Ce que beaucoup ne reconnaissen
Watch: Featured video content
Accroche
CanadaType de contenu
BlogsDate de publication
05/08/2024
Récapitulatif
Dans n’importe quelle carrière, il est facile d’avoir une vision étroite et d’accorder une plus grande importance au perfectionnement des compétences techniques. Ce que beaucoup ne reconnaissen
Watch: Featured video content
Related job roles
Salaire
Localisation
Burnaby
Job Type
Full Time
Career Area
Project controls
Category
Permanent
Location
Burnaby
Description
Junior Estimator*Graduate development program*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 o
Référence
R-113999
Date d’expiration
01/01/0001
Salaire
Localisation
Lima
Job Type
Full Time
Career Area
Health & safety
Marché
Mines et métallurgie
Category
Contrat à durée déterminée
Location
Lima
Description
Actualmente se ha generado una oportunidad para integrarse a SNC-Lavalin Perú S.A. como Supervisor HSE en la División de Minería y Metalurgia.Propósito del cargo:Liderar, formular, dirigir y controlar
Référence
R-113998
Date d’expiration
01/01/0001
Salaire
Localisation
Denver
Job Type
Full Time
Career Area
Project management
Category
Permanent
Location
Denver
Description
Why join us? It’s an exciting time at AtkinsRéalis! We are rapidly growing in the US. Our company purpose is to build a better world for our planet and its people. We recognize the importance of maki
Référence
R-113997
Date d’expiration
01/01/0001
Salaire
Localisation
Montréal
Job Type
Full Time
Career Area
Information technology
Marché
Entreprise
Category
Permanent
Location
Toronto
Montréal
Description
Architecte de solutions ServiceNowNous recherchons un architecte de solutions ServiceNow talentueux et innovant pour diriger nos efforts d'amélioration de l'expérience utilisateur et des capacités de
Référence
R-113993
Date d’expiration
01/01/0001
Salaire
Localisation
Montréal
Job Type
Full Time
Career Area
Civil engineering
Category
Permanent
Location
Montréal
Description
**Programme de développement pour nouveaux gradués / Graduate development program** CPI en ponts et ouvrages d'artRejoignez-nous pour remodeler l'avenir avec AtkinsRéalis. AtkinsRéalis se consacre à l
Référence
R-113991
Date d’expiration
01/01/0001
Salaire
Localisation
Lima
Job Type
Full Time
Career Area
Construction
Marché
Mines et métallurgie
Category
Contrat à durée déterminée
Location
Lima
Description
Descripción de puestoActualmente se ha generado una oportunidad para integrarse a AtkinsRéalis como Supervisor de Precomisionado y Comisionado en la División de Minería y MetalurgiaPropósito del cargo
Référence
R-113990
Date d’expiration
01/01/0001
Salaire
Localisation
Montréal
Job Type
Full Time
Career Area
Structural engineering
Category
Permanent
Location
Montréal
Description
AtkinsRéalis est actuellement à la recherche d’une technicienne-dessinatrice ou d’un technicien-dessinateur en structure. Alors si vous êtes à la recherche d’un employeur qui a des projets majeurs en
Référence
R-113982
Date d’expiration
01/01/0001
Salaire
Localisation
Alexandria
Job Type
Full Time
Career Area
Engineering (Other)
Category
Permanent
Location
Orlando
Tampa
Atlanta
Calverton
Alexandria
Description
Why join us? We are hiring! AtkinsRéalis is seeking a Resilience Planner to join our Alexandria, VA. office.The selected candidate will reside within the Water Engineering Technical Professional Organ
Référence
R-113980
Date d’expiration
01/01/0001
Salaire
Localisation
Chennai
Job Type
Full Time
Career Area
Linxon - NewCo
Category
Permanent
Location
Chennai
Description
Job Title: Secondary Project Engineer (Traction) Location: Chennai, IndiaJoin Us! We combine AtkinsRéalis project management expertise and Hitachi Energy’s deep technological knowledge to create a com
Référence
R-113976
Date d’expiration
01/01/0001
Salaire
Localisation
Alexandria
Job Type
Full Time
Career Area
Architecture
Marché
Water
Category
Permanent
Location
Calverton
Alexandria
Description
Why join us? We are hiring! AtkinsRéalis is seeking a Water Hazard Resilience Program Manager to join our Alexandria, VA. office. Position can also be based out of our Austin, Dallas, Houston, Tampa,
Référence
R-113975
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