KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
N #2927
Applications open Full-Time Job

Senior Data Engineer

Siemens

  • Pune, India
  • Competitive Package (Best in Industry)
  • 4-7 Yrs
  • Posted Yesterday
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

You'll make a difference by: Providing technical support to teams adopting analytics platforms such as Adobe Analytics, Hotjar, and Moesif. Validating analytics implementations and troubleshooting tracking, integration, and data-quality issues. Integrating and processing analytics data through REST APIs.

Developing complex SQL queries and working with Snowflake data platforms. Designing, developing, and maintaining Power BI dashboards, reports, and semantic models. Translating product measurement requirements into meaningful metrics, data models, and reporting solutions.

Integrating data from multiple analytics and product sources to generate actionable business insights. Monitoring and improving data quality, reliability, and consistency across reporting systems. Collaborating with cross-functional teams to enable data-driven product and business decisions.

Contributing to scalable analytics and reporting solutions aligned with Building X objectives. You'll win us over by: Holding a Bachelor's or Master's degree in Computer Science, Information Technology, Electronics, Data Science, or a related engineering discipline. Bringing strong experience in data analytics, reporting, and software development.

Demonstrating hands-on expertise in SQL and Snowflake. Possessing strong knowledge of Power BI, data modeling, and data visualization best practices. Having experience integrating and supporting usage-tracking and analytics solutions such as Adobe Analytics, Hotjar, Moesif, or similar platforms.

Being proficient in JavaScript and/or TypeScript development. Having practical experience working with REST APIs and data integrations. Understanding analytics instrumentation, event tracking, and product measurement frameworks.

Being experienced with Git-based development workflows and CI/CD practices. Demonstrating strong troubleshooting, problem-solving, and software engineering capabilities. Nice to Have Experience with the Google HEART framework for product analytics.

Python programming skills. Experience in Cloud and SaaS-based application development. Knowledge of API monitoring, observability, and operational analytics.

Exposure to modern data engineering and analytics best practices.

Eligibility & process

Who can apply

Experience: 4-7 Yrs. Open to matching qualifications.

Skills & stack

Snowflake SQL Data Scripting Data Engineering Snowflake Sql Python JavaScript

Selection process

  1. Online Assessment / Technical Interview Rounds / HR Review

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (Snowflake, SQL, Data, Scripting, Data Engineering, Snowflake Sql, Python, JavaScript) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion Siemens Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join Siemens as a Senior Data Engineer?
Highlight Siemens's market reputation, recent tech innovations, and how your skills in Snowflake directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Siemens Competitive Package (Best in Industry)
Recruiter Resume Apply
Chat Chat with Kashii