1 to 25 of 75 Star Schema Jobs

list of the day to day tasks to be performed by the Selected Candidate: Perform Data profiling on the source systems Design and review star schema dimensional model to support data warehouse and data marts Perform Source to Target Mapping between source system database and data warehouse target … tool 2. 36 months experience in analytics and operational reporting using Tableau and SQL Server Reporting Services (SSRS 3. 36 months experience in Star Schema/Dimensional Modeling to support data warehouse environments as well as OLTP environments. 4. 48 months experience developing and tuning complex ...

Redshift, Athena, S3, Lambda, Step Functions, CloudWatch. Proficiency in Python and PySpark for ETL, transformation, and automation. Strong experience in SQL and data modeling (star schema, snowflake schema, dimensional models Experience building scalable, high-performance data pipelines in cloud environments. Knowledge of data governance, data quality frameworks ...

Redshift, Athena, S3, Lambda, Step Functions, CloudWatch. Proficiency in Python and PySpark for ETL, transformation, and automation. Strong experience in SQL and data modeling (star schema, snowflake schema, dimensional models Experience building scalable, high-performance data pipelines in cloud environments. Knowledge of data governance, data quality frameworks ...

Boomi, Informatica, Talend, SSIS, or custom scripting languages (Python, PySpark, SQL) for data extraction and transformation. Prior experience with Data warehousing and Data modelling (Star Schema or Snowflake Schema). Skilled in security frameworks such as GDPR, HIPAA, ISO 27001, NIST, SOX, and PII, with expertise ...

Boomi, Informatica, Talend, SSIS, or custom scripting languages (Python, PySpark, SQL) for data extraction and transformation. Prior experience with Data warehousing and Data modelling (Star Schema or Snowflake Schema). Skilled in security frameworks such as GDPR, HIPAA, ISO 27001, NIST, SOX, and PII, with expertise ...

processes and tools (Talend, Informatica, Matillion, Pentaho, MuleSoft, Boomi) or scripting using Python, PySpark, and SQL. Solid understanding of data warehousing and modelling techniques (Star Schema, Snowflake Schema). Familiarity with security frameworks such as GDPR, HIPAA, ISO 27001, NIST, SOX, and PII, as well ...

processes and tools (Talend, Informatica, Matillion, Pentaho, MuleSoft, Boomi) or scripting using Python, PySpark, and SQL. Solid understanding of data warehousing and modelling techniques (Star Schema, Snowflake Schema). Familiarity with security frameworks such as GDPR, HIPAA, ISO 27001, NIST, SOX, and PII, as well ...

Storage solutions. Familiarity with programming languages such as Python or C# for scripting and automation. Proven experience in designing data warehouses, data lakes, and star schema models. Proficient in implementing DevOps practices using Azure DevOps, GitHub, and CI/CD pipelines. Strong understanding of big data architectures, data ...

Months experience with developing and maintaining logical and physical dimensional data models, building data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc. 84 Months experience in a data modeling tool (e.g., ErWin, ER/Studio). 84 Months experience in relational ...

Automate and other Power Platform tools Contribute to Compass’ wider Data Democratisation and Digital Transformation programmes Technical Leadership Define best-practice data modelling approaches (star schema, aggregations, calculation groups) Mentor junior developers and support citizen development Manage Power BI Premium/Fabric capacity and performance Drive continuous improvement ...

practices Skills & Experience Required Experience delivering enterprise-grade Power BI solutions, ideally within a legal or professional services environment Strong understanding of data modelling, star schema design, and ETL processes Experience with Microsoft Fabric, Synapse, Azure SQL or Data Lake Familiarity with Azure DevOps/GIT for source ...

analytics roles. Experience working within a Medallion Architecture, ideally with direct responsibility for Gold layer curation. Expertise in Power BI, including: Intermediate DAX Star schema modelling and semantic model design Report UX/UI best practices Performance optimisation Hands-on experience with Microsoft Fabric features such as Lakehouse ...

analytics roles. Experience working within a Medallion Architecture, ideally with direct responsibility for Gold layer curation. Expertise in Power BI, including: Intermediate DAX Star schema modelling and semantic model design Report UX/UI best practices Performance optimisation Hands-on experience with Microsoft Fabric features such as Lakehouse ...

analytics roles. Experience working within a Medallion Architecture, ideally with direct responsibility for Gold layer curation. Expertise in Power BI, including: Intermediate DAX Star schema modelling and semantic model design Report UX/UI best practices Performance optimisation Hands-on experience with Microsoft Fabric features such as Lakehouse ...

SSRS, SSIS, SSAS, and Power BI Advanced SQL Server capabilities: T-SQL, stored procedures, and performance tuning Experience designing and building data warehouses and star schemas Strong ETL experience using SQL Server SSIS Proficiency with Power BI, including DAX and Power Query Experience with Visual Studio and Microsoft ...

Lakeflow Declarative Pipelines expectations. Curated Layers & Data Modelling Develop clean and conforming Silver & Gold layers aligned to enterprise subject areas. Contribute to dimensional modelling (star schemas), harmonisation logic, SCDs and business marts powering Power BI datasets. Apply governance, lineage and permissioning through Unity Catalog. Orchestration & Observability Use Lakeflow Workflows ...

Lakeflow Declarative Pipelines expectations. Curated Layers & Data Modelling Develop clean and conforming Silver & Gold layers aligned to enterprise subject areas. Contribute to dimensional modelling (star schemas), harmonisation logic, SCDs and business marts powering Power BI datasets. Apply governance, lineage and permissioning through Unity Catalog. Orchestration & Observability Use Lakeflow Workflows ...

proven experience in Power BI development within an Asset Management environment Strong, proven experience in advanced data modelling , DAX , and data transformation Expertise with star schemas , dimensional modelling semantic models , and dataflows Solid understanding of data security, access controls, and distribution practices Experience with data sources such as Snowflake ...

proven experience in Power BI development within an Asset Management environment Strong, proven experience in advanced data modelling , DAX , and data transformation Expertise with star schemas , dimensional modelling semantic models , and dataflows Solid understanding of data security, access controls, and distribution practices Experience with data sources such as Snowflake ...

complex, data-rich environment. Deep knowledge of Power BI Desktop & Service, DAX, and Power Query, with a solid grounding in data modelling and star schema design. Experience working with cloud-based data platforms (eg Microsoft Fabric, Synapse, Azure SQL, Data Lake or similar). Comfortable supporting ...

complex, data-rich environment. Deep knowledge of Power BI Desktop & Service , DAX , and Power Query , with a solid grounding in data modelling and star schema design. Experience working with cloud-based data platforms (e.g. Microsoft Fabric, Synapse, Azure SQL, Data Lake or similar). Comfortable supporting ...

Version control (Git) Bonus points for: Airflow, Prefect, dbt, or cloud-native orchestration CI/CD and deployment automation Data warehousing fundamentals (star schema, staging patterns) Plus: Ability to explain complex engineering concepts without losing people You genuinely enjoy working with people and get energy from helping others ...

Version control (Git) Bonus points for: Airflow, Prefect, dbt, or cloud-native orchestration CI/CD and deployment automation Data warehousing fundamentals (star schema, staging patterns) Plus: Ability to explain complex engineering concepts without losing people You genuinely enjoy working with people and get energy from helping others ...

Version control (Git) Bonus points for: Airflow, Prefect, dbt, or cloud-native orchestration CI/CD and deployment automation Data warehousing fundamentals (star schema, staging patterns) Plus: Ability to explain complex engineering concepts without losing people You genuinely enjoy working with people and get energy from helping others ...

Version control (Git) Bonus points for: Airflow, Prefect, dbt, or cloud-native orchestration CI/CD and deployment automation Data warehousing fundamentals (star schema, staging patterns) Plus: Ability to explain complex engineering concepts without losing people You genuinely enjoy working with people and get energy from helping others ...