Data Engineer (SQL & Azure)

A Snapshot of Your Day

As a Senior Professional Data Engineer within Siemens Energy's Application Development team, you will play a crucial role in designing, building, and managing the database infrastructure that supports our external-facing fleet management applications. This position is vital for ensuring business continuity and empowering data-driven capabilities across our digital products. Your responsibilities will focus on two key areas: creating robust data architectures and optimizing data systems for performance. This includes developing scalable ETL/ELT pipelines for advanced analytics using the Azure data stack, with a strong emphasis on handling large data volumes. Additionally, you will be responsible for the continuous performance tuning of complex analytical queries, ensuring the reliability, integrity, and efficiency of our SQL-based data platforms. The ideal candidate is a seasoned data professional with a passion for performance optimization and an analytical mindset. Advanced expertise in SQL, data modeling, and the Microsoft Azure ecosystem is essential. This senior role requires the ability to work independently on complex challenges, contribute to the evolution of our data architecture, and mentor other team members on best practices in database engineering and performance.

How You'll Make an Impact

• Design and implement logical and physical data models that support new application features and advanced analytics, ensuring alignment with business needs.
• Develop, test, and maintain robust, scalable ETL/ELT pipelines for large data volumes using Azure Data Factory and related services, enhancing data accessibility and usability.
• Contribute to the evolution of a modern cloud-based data architecture, ensuring it meets functional and analytical requirements while supporting future growth.
• Implement processes and controls to guarantee high data quality, integrity, and efficiency throughout the data lifecycle, fostering trust in data-driven decisions.
• Collaborate closely with software developers and product managers to seamlessly integrate data solutions into the broader application ecosystem, enhancing overall product functionality.
• Analyze, optimize, and performance-tune complex SQL queries, focusing on analytical use cases to improve response times and system efficiency.

What You Bring

● A Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent practical experience, providing a solid foundation for technical expertise.

● Over 5 years of professional experience in data engineering or database development, with a strong emphasis on SQL performance tuning and analytical query optimization, showcasing your depth of knowledge.

● Advanced expertise in designing and managing data solutions within the Microsoft Azure ecosystem, including services like Azure Data Factory, Azure Synapse, and SQL Databases, ensuring effective cloud-based operations.

● Proficiency in data engineering and architecture, including skills in SQL programming, data modeling, and data warehousing, enabling you to create efficient data structures.

● Familiarity with development and operations practices, including performance tuning, CI/CD, Agile methodology, and version control systems like Git, ensuring streamlined workflows.

● Strong analytical thinking and problem-solving skills, complemented by experience in troubleshooting and debugging, allowing you to address complex challenges effectively.