Senior Data Analyst

Job description

**Job Purpose** Responsible for analyzing, transforming, and deriving insights from large-scale data using Databricks and modern data stack technologies. Designs and executes data pipelines using SQL and PySpark on Databricks, leveraging Unity Catalog for data governance and management. Collaborates with cross-functional teams to build data models, perform exploratory analysis, and deliver actionable insights. Optimizes queries on SQL Warehouses, integrates external APIs where needed, and ensures data quality and reliability across workflows **Duties and Responsibilities** - Develop, maintain, and optimize scalable data pipelines using Databricks (PySpark and SQL). - Perform data extraction, transformation, and loading (ETL/ELT) for large and complex datasets. - Analyse data to generate actionable insights supporting business decision-making. - Design and manage data models and curated datasets within Unity Catalog. - Ensure data quality, consistency, and reliability through validation and monitoring frameworks. - Optimize query performance on SQL Warehouses for faster analytics and reporting. - Collaborate with business stakeholders to understand requirements and translate them into data solutions. **Key Decisions / Dimensions** - Selection of appropriate data models, pipeline design, and transformation logic to meet business requirements efficiently. - Optimization strategies for query performance, compute usage, and cost on Databricks SQL Warehouses and Spark workloads. - Choice of data sources, integration approaches, and data quality rules to ensure reliable and governed datasets **Major Challenges** - Handling large-scale, distributed datasets in Databricks while maintaining performance and cost efficiency of pipelines and queries. - Ensuring data quality and consistency across multiple sources, evolving schemas, and governed environments like Unity Catalog. - Translating ambiguous business requirements into scalable data models and actionable insights within tight timelines **Required Qualifications and Experience** Educational Qualifications: - Graduate or PostGraduate in Computer Science, Information Technology, or Data Science/Technologies. Work Experience: - 0.62 years of handson data engineering/analyst experience. Technical Expertise / Skills Keywords: Data Platforms & Tools: Databricks, Delta Lake, Unity Catalog, SQL Warehouses Programming & Querying: Python, PySpark, SQL, Spark SQL Data Engineering & Processing: ETL/ELT Pipelines, Data Modeling, Data Warehousing, Data Transformation, Big Data Processing, Apache Spark, Distributed Computing Cloud & Integration: Azure Data Services, Azure Data Lake Storage (ADLS), Azure Key Vault, REST API Integration DevOps & Workflow: Git, Azure DevOps, CI/CD Git Workflow Orchestration Analytics & Visualization: Exploratory Data Analysis (EDA), Dashboarding & Reporting (Power BI/Tableau)