Associate Data Engineer
Description
About Us:
Sitecore’s mission is to provide cutting-edge DXP solutions that enable the world’s greatest brands to craft truly unforgettable experiences for their customers. A highly decorated industry leader, Sitecore brings content, commerce, and data into one connected platform that delivers millions of digital experiences every day. Thousands of blue-chip companies, including American Express, Porsche, Starbucks, L’Oréal, and Volvo Cars, rely on Sitecore to provide more engaging, more personalized experiences for their customers. Under the leadership of our new product-centric CEO, we are poised to continue to push the boundaries of marketing technology and shape the future of customer engagement. Learn more at Sitecore.com.
About the Role:
As an Associate Data Engineer, you will work with Data Engineer, Lead Data Engineer and Engineering Manager to build, maintain, optimize data pipelines and workflows. You will assist in ensuring data is consistently processed from various data sources of the data ecosystem. You will work on various technologies and platforms, Databricks, Power BI, Python, SQL, etc. You will collaborate with FinOps, Data Analyst and other stakeholders from different teams.
What you will do:
- Develop, maintain and implement efficient data pipelines using Databricks to gather and transform data from various data sources.
- Perform data ingestion, transformation and delivery using Python and SQL.
- Assist to create and manage data models, schemas and tables of different sources.
- Assist in data pipelines optimization and performance tuning.
- Generate and visualize data insights using Power BI services and reports.
- Assist in R&D to evaluate new technologies, tools and methods to improve data engineering processes and solutions.
- Collaborate closely with data analysts and other stakeholders to understand data needs and support their requirements.
What you need to succeed:
Technical skills
- Proficiency in Python, SQL and other programming languages commonly used in data engineering.
- Knowledge of Databricks, Spark, cloud environments like Azure or AWS and Blob storage.
- Experience or knowledge in ETL (extract, transform, load) data processes.
- Data processing for structured or unstructured data. CSV, JSON or Parquet format.
- Knowledge in designing and developing Power BI reports or similar.
- Understanding of both relational SQL (MySQL, PostgreSQL) and NoSQL (Cosmos DB, MongoDB)
- Understanding of agile methodologies (Kanban, Scrum, SAFe, XP, Lean)
Soft skills
- Problem-solving, analytical skills and passion for solving technical challenges.
- Collaborate effectively with proper communication skills and working well in a team environment.
- Keen learner and adaptability to new technologies and processes.
What will set you apart:
- Proficient in Databricks, Python, SQL, PySpark, Power BI or other commonly used data engineering tools and platforms.
- Experience in cloud-native data platforms and services (Azure Data Lake, Blob Storage, AWS S3)
- Experience in maintaining database system and writing SQL query.
- Knowledge of ETL and data pipeline optimization techniques to handle data efficiently.
Additional Information
Sitecore is proud to be an equal-opportunity workplace. We are committed to equal employment opportunity without unlawful regard to race, color, ancestry, religion, gender, national origin, sexual orientation, age, citizenship, marital status, disability, veteran status, or any other local legally protected characteristic.