Lead Consultant, Data Engineer (SAP + Databricks)

Lovelytics is a consulting firm that specializes in modernizing data for enterprises across various sectors. The Lead Consultant will be responsible for client engagements involving data warehousing, ETL development, and data modeling, with a focus on utilizing partner technologies like Databricks and AWS.

Responsibilities:

• Utilize consulting and technical skills to be able to work in a client-facing project environment independently
• Be responsible for your own execution and sometimes lead individual work streams on client engagements as assigned and under supervision of engagement lead
• Collaborate with other team members to successfully deliver on projects
• Work effectively and directly communicate with both internal and client and/or partner teams
• Develop full ownership of your execution on client engagements, you'll become involved in the project planning and solution stages of engagements as well
• Design and implement complex ETL/ELT pipelines with evidence of improved data processing times
• Successfully lead small data warehousing projects with measurable performance enhancements under the management of an engagement lead
• Contribute to real-time data processing solutions and managed streaming data
• Implement security and compliance measures for data pipelines
• Design and implement version control and branching strategies and integrate them into CI/CD for promoting and testing in higher environments
• Hands on experience working with SAP data at the table level
• Strong understanding of SAP data structures and relationships, beyond ETL tooling
• Ability to interpret SAP data in the context of underlying business processes
• Deep understanding of SAP ERP (ECC or S/4HANA) data architecture, specifically utilizing it as a source system with strong knowledge of its underlying tables and business processes
• Strong background in SAP data and integration technologies, specifically with at least one of the following: SAP Datasphere, SAP BW, SAP HANA, or SAP BDC

Requirements:

• Utilize consulting and technical skills to be able to work in a client-facing project environment independently
• Be responsible for your own execution and sometimes lead individual work streams on client engagements as assigned and under supervision of engagement lead
• Collaborate with other team members to successfully deliver on projects
• Work effectively and directly communicate with both internal and client and/or partner teams
• Develop full ownership of your execution on client engagements, you'll become involved in the project planning and solution stages of engagements as well
• Design and implement complex ETL/ELT pipelines with evidence of improved data processing times
• Successfully lead small data warehousing projects with measurable performance enhancements under the management of an engagement lead
• Contribute to real-time data processing solutions and managed streaming data
• Implement security and compliance measures for data pipelines
• Design and implement version control and branching strategies and integrate them into CI/CD for promoting and testing in higher environments
• Hands on experience working with SAP data at the table level
• Strong understanding of SAP data structures and relationships, beyond ETL tooling
• Ability to interpret SAP data in the context of underlying business processes
• Deep understanding of SAP ERP (ECC or S/4HANA) data architecture, specifically utilizing it as a source system with strong knowledge of its underlying tables and business processes
• Strong background in SAP data and integration technologies, specifically with at least one of the following: SAP Datasphere, SAP BW, SAP HANA, or SAP BDC
• B.S. in Computer Science or equivalent
• 3-5 years' experience in data engineering and big data. At least 2 years working directly with clients and external stakeholders
• Extensive knowledge of data warehousing concepts and hands-on experience deploying pipelines using Databricks
• Data modeling and database design skills and knowledge of version control
• Excellent verbal and written communication skills
• Is able to apply technical skills to engagement needs
• Works with engagement leads and directors to gain exposure in the design and architecture of solutions
• Understands and utilizes Lovelytics tools and client tools