1 to 25 of 104 Star Schema Jobs

data ownership and stewardship roles across data sets. Conduct regular data audits and drive continuous improvement initiatives. Establish data model management in line with star schema principles. Organizing data into fact and dimension tables. Work with key business stakeholders to define new data sets for incorporation into the … they align to the required data model, data governance and data quality requirements Ensure that data from various sources is accurately integrated into the star schema. This includes designing ETL (Extract, Transform, Load) processes to move data into the fact and dimension tables. Ensuring that the data model is … optimized for performance, working with the Development team to ensure any performance issues are resolved. Document the schema design, data sources, ETL processes, and any changes made to the schema. Provide training to team members on how to use and maintain the star schema. Work closely with stakeholders More ❯

communication style based on the audience. Data Modeling and Warehousing: • Design and implement data models optimized for analytical workloads, using dimensional modeling techniques (e.g., star schema, snowflake schema). • Participate in the design, implementation, and maintenance of data warehouses ensuring data integrity, performance, and scalability. BASIC QUALIFICATIONS … R or Python for analytics, data manipulation, and algorithm development. • Data Warehousing Knowledge: In-depth knowledge of data warehousing principles, dimensional modeling techniques (e.g., star schema, snowflake schema), and data quality management. • Communication and Collaboration Abilities: Excellent verbal and written communication skills, with the ability to effectively More ❯

communication style based on the audience. Data Modeling and Warehousing: •Design and implement data models optimized for analytical workloads, using dimensional modeling techniques (e.g., star schema, snowflake schema). •Participate in the design, implementation, and maintenance of data warehouses ensuring data integrity, performance, and scalability. BASIC QUALIFICATIONS … R or Python for analytics, data manipulation, and algorithm development. •Data Warehousing Knowledge: In-depth knowledge of data warehousing principles, dimensional modeling techniques (e.g., star schema, snowflake schema), and data quality management. •Communication and Collaboration Abilities: Excellent verbal and written communication skills, with the ability to effectively More ❯

high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata … high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata More ❯

high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata … high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata More ❯

high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata … high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata More ❯

API management tools including IBM API Connect and AWS API Gateway. Understanding of canonical messaging, corporate information modeling, and general data modeling techniques (3NF, Star schema, Extended Star Schema, Data Vault, and relational database design). Understanding and application of different development styles, e.g., agile (XP More ❯

data solutions. In this position, you'll be responsible for designing, building, and optimizing data warehouses using best practices in dimensional modelling, Kimball methodologies, star schema design, and Data Vault principles, ensuring adherence to sound data architecture practices. Based in Avonmouth on a hybrid working basis – 2 days … focusing on stored procedures, indexing, partitioning, and load performance. A proven track record in designing and building data warehouses using Kimball methodologies, dimensional modeling, star schema design, and Data Vault techniques is essential. You should be well-versed in applying data architecture principles to create robust, scalable solutions More ❯

our products and across the organisation. You should have in-depth knowledge of SQL databases (Microsoft or Postgres), and be familiar with dimensional modelling, star schema design and ETL processes. You will have the opportunity to be part of our strategic plan to incorporate machine learning and artificial … environment ◦ Experience of SQL database systems and data warehousing, focusing on stored procedures, indexing, partitioning and load performance ◦ Experience of ETL, dimensional modelling and star schema solutions ◦ Technical expertise with data models, data mining, and segmentation techniques ◦ Have a strong understanding of data security and multi-tenancy ◦ Excellent More ❯

regulatory requirements. Develop monitoring and alerting solutions for proactive data pipeline maintenance and incident prevention. Own the technical delivery of our Lakehouse following a Star Schema approach. Stakeholder Collaboration & Business Impact Work closely with business stakeholders, including Product and Data Analysts to deliver data solutions that drive business … Extensive experience designing and implementing scalable, metadata-driven data solutions, optimised for analytical consumption and operational robustness. Deep expertise in data modelling, specifically using star schema methodology, and building performant dimensional models to support high-velocity datasets. Strong experience with Google Cloud Platform (GCP), including BigQuery, Dataflow, Composer More ❯

BI Service in a commercial environment. Advanced knowledge and real-world application of DAX, including performance tuning. Strong understanding of data modelling techniques, including star schema and normalisation. Proficient in Power Query (M) and shaping data from varied sources. Demonstrated understanding of data visualisation principles and UI/… BI Service in a commercial environment. Advanced knowledge and real-world application of DAX, including performance tuning. Strong understanding of data modelling techniques, including star schema and normalisation. Proficient in Power Query (M) and shaping data from varied sources. Demonstrated understanding of data visualisation principles and UI/ More ❯

for building scalable data systems. Knowledge of version control systems (e.g., Git) and collaboration tools (e.g., Jira, Confluence). Understanding data modeling concepts (e.g., star schema, snowflake schema) and how they relate to data warehousing and analytics. Knowledge of data lakes, data warehousing architecture, and how to More ❯

You’ll work closely with our clients to design the correct data models to support their analytic requirements following best practices such as Kimball star schemas and snowflake schemas, ensuring performance and ease of use for the client. You’ll manage the delivery of ETL/ELT processes using … with ETL/ELT tools (e.g. Matillion, Informatica, Talend) and cloud data platforms (e.g., Snowflake, Databricks, BigQuery). Expertise in data modelling techniques (e.g., star schema, snowflake schema) and optimising models for analytics and reporting. Familiarity with version control, CI/CD pipelines, and containerisation tools (e.g. More ❯

Azure SQL Database, Azure Data Factory, Azure Data Lake, and related Azure data services. Expertise in designing and optimizing relational and dimensional data models (star schema, snowflake schema). Experience with ETL tools and data integration techniques. Proficient in SQL and other data querying languages. Understanding of More ❯

You'll work closely with our clients to design the correct data models to support their analytic requirements following best practices such as Kimball star schemas and snowflake schemas, ensuring performance and ease of use for the client. You'll manage the delivery of ETL/ELT processes using … with ETL/ELT tools (e.g. Matillion, Informatica, Talend) and cloud data platforms (e.g., Snowflake, Databricks, BigQuery). Expertise in data modelling techniques (e.g., star schema, snowflake schema) and optimising models for analytics and reporting. Familiarity with version control, CI/CD pipelines, and containerisation tools (e.g. More ❯

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 in More ❯

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 in More ❯

technical and business domains. ✅ Key technical skills: Strong SQL and ELT/data pipeline development experience Expertise in Data Warehouse & Data Lake design (including Star Schema, Snowflake Schema, Data Vault) Hands-on experience with enterprise databases: Oracle, Snowflake, Teradata, or SQL Server Solid understanding of AWS (S3 More ❯

technical and business domains. ✅ Key technical skills: Strong SQL and ELT/data pipeline development experience Expertise in Data Warehouse & Data Lake design (including Star Schema, Snowflake Schema, Data Vault) Hands-on experience with enterprise databases: Oracle, Snowflake, Teradata, or SQL Server Solid understanding of AWS (S3 More ❯

Data Modeler in designing Enterprise Data Products. Understand Data Model terminology (Conceptual, Logical, Physical Data Models). Apply enterprise data modelling techniques such as star schema, snowflake schema, etc. Utilize data de-normalization and normalization techniques. Key skills/knowledge/experience: Experience in Advanced SQL, SSIS More ❯

models that align with business goals and technical standards. You will work at the intersection of data engineering, data governance, and product to drive schema standardization, semantic consistency, and cross-domain scalability in Google Cloud Platform (GCP). Key Responsibilities Design conceptual, logical, and physical data models across Raw … schemas. Develop shared dimensional models, canonical entities, and fact-dimension frameworks. Partner with Product and Analytics teams to define business-friendly data structures. Lead schema reviews, ICD (Interface Control Document) creation, and metadata documentation. Support data contract design between source systems and the OneData platform. Define schema evolution … modeling or enterprise data architecture roles. Hands-on experience with cloud data platforms, preferably GCP (BigQuery). Expertise in dimensional modeling techniques, including 3NF, star schema, and snowflake schema designs. Familiarity with modeling tools like dbt. Proficient in SQL and understanding of ELT/ETL orchestration in More ❯

the warehouse. Develop and maintain documentation on data models, processes, and business rules. SKILLS AND QUALIFICATIONS Data Warehousing: Strong knowledge of the Kimball methodology (star schema, fact & dimension tables). Experience in designing and implementing data models for analytical reporting. ETL/ELT & Data Integration: Hands-on experience More ❯

and business rules. **Please note that the responsibilities listed above are not exhaustive. SKILLS AND QUALIFICATIONS Data Warehousing: Strong knowledge of the Kimball methodology (star schema, fact & dimension tables). Experience in designing and implementing data models for analytical reporting. ETL/ELT & Data Integration: Hands-on experience More ❯

Snowflake architecture, features, and best practices. · Experience with CI/CD pipelines using Git and Git Actions. · Knowledge of various data modeling techniques, including Star Schema, Dimensional models, and Data Vault. · Hands-on experience with: · Developing data pipelines (Snowflake), writing complex SQL queries. · Building ETL/ELT/ More ❯

Snowflake architecture, features, and best practices. · Experience with CI/CD pipelines using Git and Git Actions. · Knowledge of various data modeling techniques, including Star Schema, Dimensional models, and Data Vault. · Hands-on experience with: · Developing data pipelines (Snowflake), writing complex SQL queries. · Building ETL/ELT/ More ❯