1 to 25 of 44 Remote Star Schema Jobs

through robust, scalable, and innovative 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 in office per week Compensation … premises SQL Server data warehouses, 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 Azure Cloud Proficiency: Deep understanding More ❯

data from various sources including APIs, Excel, CSV, JSON, and databases. Manage data lakes, warehouses, and lakehouses within Azure cloud environments. Apply data modelling techniques such as Kimball methodologies, star schemas, and data warehouse design principles. Build and support ETL workflows using tools like Azure Data Factory, Synapse, Delta Live Tables, dbt, SSIS, etc. Automate infrastructure deployment with Terraform … engineering experience. Has strong skills in Python, SQL, and PySpark. Experienced working with data lakes, warehouses, lakehouses, and cloud platforms, preferably Azure. Knowledgeable in data modelling, including Kimball and star schemas. Familiar with ETL tools such as Azure Data Factory, Synapse, Delta Live Tables, dbt, SSIS. Experienced with Infrastructure as Code (Terraform, ARM, Bicep). Skilled in Power BI More ❯

and non-technical audiences, tailoring 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 •Educational Background: Bachelor's or … Analysis Skills: Working knowledge of 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 communicate technical concepts; experience gathering More ❯

security, and best practices for 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 with ETL tools (e.g., Azure More ❯

security, and best practices for 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 with ETL tools (e.g., Azure More ❯

design and delivery at scale (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/SQL Server/Snowflake … design and delivery at scale (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/SQL Server/Snowflake More ❯

design and delivery at scale (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/SQL Server/Snowflake … design and delivery at scale (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/SQL Server/Snowflake More ❯

design and delivery at scale (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/SQL Server/Snowflake … design and delivery at scale (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/SQL Server/Snowflake More ❯

Factory and Databricks Medallion Architecture : Implement Bronze, Silver, and Gold layers using formats like Delta , Parquet , and JSON for data transformation. Data Modeling : Develop and optimize data models using star schema and slowly changing dimensions for analytics and operations. Data Governance : Ensure robust data security with Role-Based Access Control (RBAC) and Unity Catalog . Performance Optimization : Tune More ❯

in Microsoft Azure (e.g. Data Factory, Synapse, Azure SQL, Data Lake) Strong proficiency in Power BI , including DAX, data modelling, and deployment Experience designing and implementing data warehouses and star schema models Background in building scalable data pipelines and APIs Excellent communication skills and ability to work with both technical and non-technical stakeholders Previous experience in local More ❯

If you're looking to contribute, grow, and work on diverse data challenges, join us! Your Contribution Design and develop efficient and scalable data models and data marts (e.g.star schema, snowflake schema) using best practices for data warehousing and business intelligence that are optimized for self-service analytics tools Collaborate with business stakeholders (e.g. finance, marketing, operations) to More ❯

pipelines handling diverse data sources. 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 tools like Matillion, Informatica, or … GCP. Technical Skills Extensive experience 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., Git, Jenkins, Docker, Kubernetes). More ❯

experience with Business Glossary, Data Catalog, Data Lineage or Reporting Governance You know all about the SQL You have experience in Power BI, including DAX, data modeling techniques, minimum Star Schemas (Kimball) and others are nice to have. You get even more bonus points if You have a good Experience with master data management You are familiar with data More ❯

ability to communicate issues and solutions to a variety of stakeholders including the facilitation of client workshops. An understanding of key data modelling concepts (e.g., fact and dimension tables, star schemas and snowflake schemas, denormalised tables, and views). Experience with data handling, e.g. data querying, data manipulation or data wrangling to transform raw data into the desired format More ❯

ability to communicate issues and solutions to a variety of stakeholders including the facilitation of client workshops. An understanding of key data modelling concepts (e.g., fact and dimension tables, star schemas and snowflake schemas, denormalised tables, and views). Experience with data handling, e.g. data querying, data manipulation or data wrangling to transform raw data into the desired format More ❯

pipelines handling diverse data sources. 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 tools like Matillion, Informatica, or … GCP. Technical Skills Extensive experience 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., Git, Jenkins, Docker, Kubernetes). More ❯

Hands-on experience in data solution architecture, design, and deployment Experience with business intelligence tools, data modeling, staging, extraction, data warehouse, and cloud infrastructure Knowledge of multi-dimensional design, star schemas, facts, and dimensions Proficiency in ETL development techniques Experience optimizing data warehouse performance Experience across various industry sectors is a plus Understanding of data management best practices, including More ❯

with data security, governance, and 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 value. Translate business requirements into … growth and sustainability. Technical Expertise: 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 (Apache Airflow), Pub/Sub More ❯

and comfortable working across both 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, Lambda, IAM, etc.) Proficiency in More ❯

in a collaborative, trusting environment that values diversity of thought and creative solutions. What Do We Need From You? Experience developing Azure Data solutions Knowledge of data modelling principles (star schema, snowflake, data vault) Experience implementing end-to-end ETL/ELT solutions Maintaining and optimising an Enterprise Data Warehouse Data analysis skills Testing and software release management More ❯

sector is alive with career potential. What Do We Need From You? Experience in the development of Azure Data solutions Knowledge of data modelling principles, including common patterns, e.g. star schema, snowflake or data vault Experience in implementation end-to-end ETL/ELT solutions Experience in m aintaining and optimising an Enterprise Data Warehouse Knowledge of data More ❯

and comfortable working across both 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, Lambda, IAM, etc.) Proficiency in More ❯

and comfortable working across both 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, Lambda, IAM, etc.) Proficiency in More ❯

and validation. Apply data modeling techniques to structure data for optimal performance and usability. Profile Strong knowledge with SQL, DBT, Databricks, Python, Oracle Strong testing mindset (quality-first principle) Star schema modeling (facts/dimensions) You have an e xperience in the banking sector You have good written and spoken communication skills in DUTCH and ENGLISH. You are More ❯

BI, Tableau, Qlik, etc.). Big s: Experience with an ETL tool (Talend, SSIS, Informatica ) ; Knowledge of MDX and/or DAX languages ; Solid understanding of BI modeling (DataMart, star schema, snowflake ) ; Bonus points if you know your way around Machine Learning, Big Data, or Microsoft Azure! What We Offer: A serious job without taking ourselves too seriously More ❯