Senior Data Engineer(SSIS, SQL Server,Data Warehouse, Azure Tech Stack)

We’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.com or 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’.

Roles and Requirements:

• Develop ETL using SSIS.
• Design and develop SQL Server stored procedures, functions, views, and triggers to be used during the ETL process.
• Develop complex SQL queries for small to large sets of data, lead query optimization efforts.
• Design and architect artifacts using Data Modelling concepts.
• Designing databases and some data sourcing/ETL requirements for efficient use in reporting and BI.
• Builds data transformations with SSIS including importing data from files, moving data from one database platform to another.
• Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data.
• Design, implement and maintain database objects (tables, views, indexes) considering database security.
• Experience working with SSIS packages.
• Analyse and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations.
• Test and prepare ETL processes for deployment to production and non-production environments.
• Support system and acceptance testing including the development or refinement of test plans.
• Administer all requirements and design various functional specifications for data.
• Evaluate all codes and ensure the quality of all project deliverables.
• Managing resources for the team
• Knowledge on Azure Tech Stack is added advantage. Mainly on ADF, Data Bricks, Python
• Good team player
• Able to work on a project on Individual contributor role.
• Good communication skills

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 individual’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)