1 to 25 of 32 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 ...

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 ...

exactly-once processing Dead-letter queues (DLQs) and failure recovery Implement CDC pipelines from Aurora PostgreSQL into Kafka and the lakehouse. Event Contracts & Schema Management Define and govern event contracts using Avro or Protobuf . Manage schema evolution through Schema Registry , including: Compatibility rules Versioning strategies Backward … modeling (ER diagrams, normalization up to 3NF/BCNF) Physical data modeling: Partitioning strategies Indexing SCD types Strong understanding of: Transactional vs analytical schemas Star schema, Data Vault, and 3NF trade-offs Practical experience with: CQRS and event sourcing Event-driven architecture Domain-driven design (bounded contexts, aggregates ...

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 ...

dashboards and self-service analytics tools. Qualifications Essential: Competent in SQL and Python for data transformation and analytics. Understanding of data modelling concepts (e.g., star schema, dimensional modelling). Experience (1+ year) working with relational databases and designing optimized schemas. Ability to debug and optimize slow queries ...

dashboards and self-service analytics tools. Qualifications Essential: Competent in SQL and Python for data transformation and analytics. Understanding of data modelling concepts (e.g., star schema, dimensional modelling). Experience (1+ year) working with relational databases and designing optimized schemas. Ability to debug and optimize slow queries ...

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 ...

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 ...

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 ...

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 ...

experience with business intelligence tools, data modelling, data staging, and data extraction processes, including data warehouse and cloud infrastructure. Experience with multi-dimensional design, star schemas, facts and dimensions. Experience and demonstrated competencies in ETL development techniques. Experience in data warehouse performance optimization. Experience on projects across a variety ...

streams Develop PySpark/Spark SQL notebooks for advanced data cleansing, transformation, and business logic Create production-ready semantic models for Power BI, including star schemas and Direct Lake optimisation Implement governance and security controls (RLS, OLS, service principals) Drive CI/CD best practices using Azure DevOps ...

design/implementation - showing a strong understanding of relational database design/entity relationship Data warehouse design/implementation – showing a strong understanding of star schema/Kimball Whilst not essential, skills in SSRS, Power BI, Power Query, C# and DAX would be helpful. This will ...

post-release reviews to ensure solutions continue to support business goals. About you: Proficiency in PowerBI (including DAX) and SQL querying. Strong experience with star schema data modelling. Familiarity with tools like SQL Server Management Studio and Azure DevOps. Excellent understanding of database design, table joins, views ...