Data Engineer - Snowflake

O roli

Lokalita
India
Haryana
Remote vs. Office
Hybrid (Remote/Office)
Společnost
Siemens Energy Industrial Turbomachinery India Private Limited
Organizace
EVP Global Functions
Obchodní jednotka
Enterprise Data & Advanced Analytics
Plný/Částečný úvazek
Na plný úvazek
Úroveň praxe
Zkušený profesionál

A Snapshot of Your Days

Our team have designed and implemented a portal for the customer on base of SAP Fiori which comprises of different SAC dashboards and AFO reports that allows to monitor the aggregated financial situation of a business unit based on data from a multitude of sources. This data is loaded on daily based and financial figures are calculated based on business logic. You monitor the data loads from different ERP systems within Snowflake to ensure the successful completeness of the jobs.

You then become aware that within another SAC or AFO solution some issues arose leading to inconsistent figures. As our backend is based on Snowflake you analyze the whole chain from the data model in Snowflake over the SAP BW data providers which is being used as middleware towards the reporting solution. You also analysis if there is a need to remediate business logic with customer input for correctness of the figures. Having identified and fixed the issue, you close the corresponding ticket, document the solution, and inform the customer.

Now it’s time to start with a bigger implementation task: A new demand has been issued by the customer. You use the rest of the day to understand the required technical details and make a first draft of the design of the required new solution together with the team you are working in.

With your deep understanding of the capabilities of the technology stack you need to facilitate engagements with key stakeholders and helping to solve impediments to deliver data use cases to achieve business value and our vision to become a data driven company.

Passionate about the environment and climate change? Ready to be part of the future of the energy transition? The Siemens Energy Data Analytics & AI team plays a significant role in driving the energy transformation.

Honestly, we don’t have all the answers. Given the scale of the challenge we need many types of perspectives to help reimagine the future and we can’t do it alone. Our team is looking for innovative, enthusiastic, versatile data enthusiast and AI professionals that will drive us forward on this exciting venture.

How You’ll Make an Impact / Responsibilities

  • ·        Service Operation and end to end delivery responsible.
  • ·        Good functional business-oriented mindset as for this role the level of interactions with business users and key users.
  • ·        Experience in DevOps and Familiar with Jenkins, docker and Gitlab for CI/CD
  • ·        Think always with self-help and self-administered perspective of new tool.
  • ·        Build up deep knowledge within DAsh with Snowflake model.
  • ·        Accommodating change requirements and new mapping
  • ·        Setting up an agile way of data replication and strong data service models.
  • ·        Establish and promote DaaS- Data as a Service culture with ease of user experience. 
  • ·        Exhibit proactiveness in getting involved in other organizational management discussions and initiatives.
  • ·        Excellent management and coaching skills.
  • ·        Organizational/planning skills with the ability to coordinate and manage multiple complex projects and organize workloads in a structured way within tight deadlines.
  • ·        Cross Function Collaboration.
  • ·        Flexibility to work with people in different time zones, e.g., Europe.
  • ·        Critical thinking skills and ability to work under pressure.
  • ·        Organized approach to solve problem with good decision-making skills.
  • ·        Multi-tasking skills and ability to meet deadlines.
  • Agile Practitioner.

What You Bring / Skills, Capabilities

Mandatory skills:

  • ·        Total 4-6 years of Intensive working knowledge of Snowflake SQL Scripting.
  • ·        Working knowledge of PL/SQL and JavaScript with good knowledge of creating Stored Procedures, Functions and Views
  • ·        Good knowledge in Snowflake architecture concepts - Cloud Services, Virtual Warehouse, Storage
  • ·        Good exposure in performance tuning, optimization on snowflake.
  • Expert in Data modeling skills on relational databases especially for data warehousing
  • Basic knowledge of SAP BW Info providers/ADSOs/Composite Providers/DTPs
  • ·        Knowledge in building end-to-end data pipeline.
  • ·        Experience in data migration.
  • Knowledge of Snowflake skills like Snowpipe and Snowflake task.
  • ·        Masters/bachelor’s degree in computer science or IT.
  • ·        Very good English skills.
  • ·        Very good intercultural communication and collaboration skills with minimum 2 years of experience in international collaboration.
  • Good understand on Data warehousing modeling.

Good to have added advantage:

·        Exposure to AWS services like AWS S3, AWS Glue, AWS Lambda.

  • SnowPro Certified.
  • Certified AWS Data Strategist.
  • AWS Certified Dev-Associate Level.
  • Exposure to frontend tools like SAC, Power BI, AFO.
  • Technical and Functional knowledge on SAP ERP. mainly in Finance, Project systems module.
  • S4 HANA embedded Analytics, Exposure to ABAP CDS views.
  • SAP Fiori.

LET’S TALK ABOUT US

"Let’s make tomorrow different today" is our genuine commitment at Siemens Energy to all customers and employees on the way to a sustainable future.

In our Business Functions we enable our organization to reach their targets by providing best-in class services and solutions in the areas of IT, HR, Finance, Real Estate, Strategy & Technology and more.

[Department Information]

MORE INSIGHTS

Be Energized. Be you.

Lucky for us, we are not all the same. Through diversity we generate power. We run on inclusion and compassion. Our combined creative energy is fueled by at least 130 nationalities. Siemens Energy celebrates character – no matter what ethnic background, gender, age, religion, identity, or disability. We energize society. All of society. 

Jobs & Careers: https://www.siemens-energy.com/global/en/company/jobs.html