Senior Analyst - Data Engineer

Main Purpose:

▪Collaborate with data scientists and business stakeholders to design, develop, and maintain efficient data pipelines feeding into the organization's data lake. ▪ Maintain the integrity and quality of the data lake, enabling accurate and actionable insights for data scientists and informed decision-making for business stakeholders. ▪Utilize extensive knowledge of data engineering and cloud technologies to enhance the organization’s data infrastructure, promoting a culture of data-driven decision-making. ▪ Apply data engineering expertise to define and optimize data pipelines using advanced concepts to improve the efficiency and accessibility of data storage. ▪Own the development of an extensive data catalog, ensuring robust data governance and facilitating effective data access and utilization across the organization. Knowledge Skills and Abilities, Key Responsibilities:

Key Responsibilities

•Contribute to the development of scalable and performant data pipelines on Databricks, leveraging Delta Lake, Delta Live Tables (DLT), and other core Databricks components.

•Develop data lakes/warehouses designed for optimized storage, querying, and real-time updates using Delta Lake.

•Implement effective data ingestion strategies from various sources (streaming, batch, API-based), ensuring seamless integration with Databricks.

•Ensure the integrity, security, quality, and governance of data across our Databricks-centric platforms.

•Collaborate with stakeholders (data scientists, analysts, product teams) to translate business requirements into Databricks-native data solutions.

•Build and maintain ETL/ELT processes, heavily utilizing Databricks, Spark (Scala or Python), SQL, and Delta Lake for transformations. Page

•Experience with CI/CD and DevOps practices specifically tailored for the Databricks environment.

•Monitor and optimize the cost-efficiency of data operations on Databricks, ensuring optimal resource utilization.

•Utilize a range of Databricks tools, including the Databricks CLI and REST API, alongside Apache Spark™, to develop, manage, and optimize data engineering solutions.

Key Relationships and Department Overview:

Key Relationships •Internal – Data Engineering Manager •Developers across various departments, Managers of Departments in other regional hubs of Puma Energy •External – Platform providers