Back to search
Data Modeler
We are recruiting for a Data Modeler with Azure Synapse Analytics to join one of our Insurance clients on a 6-month contract.
Inside IR35
Remote
Responsibilities:
- Develop, maintain, and optimize semantic data models using Azure Synapse Analytics.
- Design data models that integrate data from Azure Data Lake Storage Gen2, Azure SQL databases, and other sources for consumption in Power BI and Synapse SQL pools.
- Build and maintain dimensional and relational models based on the business requirements.
- Ensure data model accuracy, scalability, and performance.
- Use PySpark within Azure Synapse notebooks to extract, transform, and load (ETL/ELT) data from raw formats (e.g., Delta, Parquet, CSV) stored in ADLS Gen2.
- Integrate data from Azure SQL databases and other sources into unified data models for analytical use.
- Implement data transformation pipelines and workflows in PySpark.
- Collaborate with Power BI developers to ensure the data models support analytical and reporting needs.
- Develop and enforce data governance and data modeling standards to ensure consistency and accuracy across all models.
- Ensure all data modeling practices adhere to security and compliance requirements, including role-based access control, encryption, and data privacy laws (e.g., GDPR).
- Applying RL/CL/OL security within the data models as defined by business use and target audience
Skills
- Proven experience with Azure Synapse Analytics (specifically serverless SQL pools) and PySpark notebooks.
- Strong knowledge of data formats such as Delta Tables, Parquet, and CSV and experience processing these formats in Azure Data Lake Storage Gen2.
- Solid experience with Azure SQL Databases, including schema design, querying, and data integration.
- Experience building semantic models that integrate with Power BI.
- Proficiency with Data Factory for data orchestration.
- Experience with Synapse Pipelines, Azure Monitor, and Azure Data Catalog is a plus.
- Familiarity with DevOps tools like Git, CI/CD pipelines, and Azure DevOps.
Carbon60, Lorien & SRG - The Impellam Group STEM Portfolio are acting as an Employment Business in relation to this vacancy.
