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

tools such as Talend, Informatica, Matillion, Pentaho, MuleSoft, Boomi, or scripting languages (Python, PySpark, SQL). Understanding of data warehousing and data modelling techniques (Star Schema, Snowflake Schema). Familiarity with security frameworks (GDPR, HIPAA, ISO 27001, NIST, SOX, PII) and AWS security features (IAM, KMS, RBAC ...

Data architecture (Data Lakes, Data Warehouses) and distributed processing concepts (e.g., MapReduce). ETL/ELT Basic knowledge of ETL principles and data modeling (star schema, snowflake schema). Version Control Practical experience with Git (branching, merging, pull requests). Preferred Qualifications (A Plus) Experience with ...

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

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

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

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

skills and database understanding.Experience with ETL processes and data integration.Ability to analyze business requirements and translate them into technical solutions.Knowledge of data modeling techniques (star schema, snowflake Preferred Qualifications Experience with Azure Data tools (Data Factory, Synapse, SQL DatabaseExperience in building enterprise BI solutions.Knowledge of Python ...

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

data platforms such as Snowflake, Databricks, and AWS (e.g., S3, Glue, Redshift, Lambda, Secrets Manager Solid knowledge of data warehousing principles, including dimensional modeling, star schemas, slowly changing dimensions, and aggregate strategies. Experience working with unstructured and semi-structured data (e.g., JSON, APIs, NoSQL databases Skilled in using workflow ...

Power BI (report building, dashboards, DAX, data modelling) Proficiency in SQL for querying, validating, and analysing data Solid understanding of data modelling concepts (e.g. star schema, facts and dimensions) Experience working with data warehouses and/or data lakes Ability to create and maintain data dictionaries and metrics ...

visually engaging reports. Advanced proficiency with Power BI, including data modelling and DAX. Solid understanding of relational databases and data warehouse concepts (dimensions, facts, star schemas) and associated technologies (e.g., Databricks). Experience with Python (including Pandas/PySpark). Familiarity with software development and source control, in particular ...

visually engaging reports. Advanced proficiency with Power BI, including data modelling and DAX. Solid understanding of relational databases and data warehouse concepts (dimensions, facts, star schemas) and associated technologies (e.g., Databricks). Experience with Python (including Pandas/PySpark). Familiarity with software development and source control, in particular ...

visually engaging reports. Advanced proficiency with Power BI, including data modelling and DAX. Solid understanding of relational databases and data warehouse concepts (dimensions, facts, star schemas) and associated technologies (e.g., Databricks). Experience with Python (including Pandas/PySpark). Familiarity with software development and source control, in particular ...

ADDM, ASH. Administer and optimize Oracle 19c/23ai, including development of procedures, triggers, packages, and indexes. Collaborate on the design of data warehouses, star schemas, and normalization. Administer Oracle RAC, ASM, and ACFS on RedHat Linux (RHEL 7/8) systems. Support implementation and maintenance of Oracle GoldenGate … Oracle RAC/ASM/ACFS Integration & DevOps: Oracle GoldenGate, UDeploy, Autosys, ServiceNow, Client Project Security: TPAM, CyberArk Data Modeling: Entity-Relationship Modeling, Star Schema, Normalization Performance Tuning: AWR, ADDM, ASH reports, Index tuning Strong understanding of SDLC, Release on Demand, and Change Control Management Qualifications: 12+ years ...

practices. A degree in a related field, such as Computer Science, Mathematics, or Statistics. Nice to have: Technical skills: Snowflake Scheme Design, Kimball Methodology, Star Schemas Programmes: Snowflake Job Offer A generous base salary and great flexibility with your working schedule, we offer training, development and progression opportunities. ...

data focused role such as Analytics, Business Intelligence, or Data Analysis. Proven ability to write complex, efficient queries and design analytical data models (e.g., star schemas). Strong understanding of how the business currently uses spreadsheets, with the ability to bridge manual analysis and scalable BI solutions. Hands ...

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