Sr Data Product Engineer

Your Job:  

• Understand the business case and translate to a holistic solution involving AWS Cloud Services , PySpark, EMR, Python, Data Ingestion and  Cloud DB Redshift / Postgres 
• PL/SQL development for high volume data sets. 
• Proven experience with large, complex database or data lake projects in environments producing high-volume data  
• Demonstrated problem solving skills; familiarity with various root cause analysis methods; experience in documenting identified problems and determined resolutions. 
• Communication with stakeholders and business partners across all worldwide locations. 
• Understanding and aligning business partners across locations doing requirements engineering and business case mapping. 
• Leading projects: Working on complex, cross-functional projects, and acting as a subject matter expert  
• Designing data platforms: Creating secure, stable, and scalable data collection, storage, access, and analytics platforms  
• Developing documentation: Creating functional and technical documentation that supports best practices  
• Experience in preparing data warehouse design artifacts based on given requirements (ETL framework design, data modeling, source-target-mapping), 
• Interaction with Data Governance teams – aligning on data models, lineage and relationships. 
• Data Analysis & Engineering for data aggregation and curation 
• Interfacing with architecture team, cloud engineering teams and vendors on designing state of the art solutions. 
• Makes recommendations regarding enhancements and/or improvements 
• Provides appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization. 
• Performance issues analysis and tuning, optimization opportunities 
• Data Warehouse design and development, including logical and physical schema design. 

Other Responsibilities:  

• Customer/stakeholder focus. Ability to build strong relationships with Application teams, cross functional IT and global/local IT teams –as well as interfacing with vendors (e.g. AWS) 
• Advising junior engineers & Build Team: Providing guidance to junior engineers and ETL Build team and BI/Analytics teams 

Required Qualifications:

• Bachelor or master's degree. Preferably in information technology or electrical engineering – but since job focus on business interaction also background in other fields is welcome. 
• Proven experience (10 year minimum) with data engineering, analytics, design and optimization. 
• Very good knowledge of data architecture approaches and trends, and high interest to apply and further develop that knowledge, including understanding of OLAP/OLTP, ML, genAI, modelling, statistics. 
• Problem solving experience & analytics skills – e.g. with L6S curriculum (green/black belt) 
• Good experience in AWS Services, Big data, PySpark, EMR,Python, Cloud DB RedShift  
• Proven experience with large, complex data projects in environments producing high-volume data, 
• Proficiency in SQL and PL/SQL  
• Excellent conceptual abilities pared with very good technical documentation skills, e.g. ability to understand and document complex data flows as part of business / production processes, 
• Familiarity with SDLC concepts and processes 
• Translate business requirements into technical specifications. This involves critical thinking, problem-solving, and the capacity to work with large datasets.