Data Modeler

Data Modeler- Insurance We are currently hiring for a Data Modeler with Azure Synapse Analytics experience to join one of our Insurance clients on a 6 month contracts. 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. Partner with DevOps teams to deploy and maintain data models in production environments. Optimizing data models from various sources such as Azure SQL databases and Azure Data Lake Storage Gen2 for usage in Power BI Ensure efficient querying of large datasets and troubleshoot any performance issues related to data retrieval or processing. Create and maintain detailed documentation and schematics of data models, metadata, and processes using suitable tools, such as Visio. 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 Experience: Insurance domain knowledge a plus, especially if experience is in Property & Casualty Knowledge of machine learning and advanced analytics within the Azure ecosystem (e.g., Azure ML). Familiarity with Data Governance practices in conjunction with Azure Purview (data lineage, data categorization, and data certification) Certifications such as Microsoft Certified: Azure Data Engineer Associate or Microsoft Certified: Azure Solutions Architect Expert. Experience: Experience in data modeling and data engineering roles, with at least 4+ years of experience working with Azure cloud services and big data technologies. If this role is of interest to you or you would like to learn more, please apply now!