16 of 16 Permanent Star Schema Jobs

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 »

ETL, SQL programming/SSIS skills * Skills in data mapping and modelling. * 3-5 years' experience in SQL language * Knowledge of Kimball methodology/Star Schema modelling in Data Warehousing. * Experience of SSIS and SSMS. * Good understanding and experience of building ETL processes including extracting data via APIs. … ETL, SQL programming/SSIS skills * Skills in data mapping and modelling. * 3-5 years' experience in SQL language * Knowledge of Kimball methodology/Star Schema modelling in Data Warehousing. * Experience of SSIS and SSMS. * Good understanding and experience of building ETL processes including extracting data via APIs. more »

Lead the development of a cloud-based medallion architecture, encompassing bronze, silver, and gold layers, to support PCCA's enterprise data strategy. o Design star-schema data warehouses to enable robust reporting, BI, and AI use cases. o Oversee data ingestion, transformation, and orchestration workflows using Microsoft Fabric … including architectural blueprints and diagrams, effectively conveying complex concepts and driving architectural standards. o Proven tracking record of designing and implementing medallion architectures and star-schema data warehouses. o Experience operationalizing AI and ML models. o Proficiency in cloud data platforms, with a focus on Microsoft Fabric, Azure more »

based bonuses, and fully remote, flexible working hours. Analytical Data Engineer Job Overview Cleanse and transform data sets to create efficient one-to-many star schema models. Define necessary fact and dimension tables based on requirements to enable user drill-downs. Review and identify data sources, defining optimal … incorporating business rules and formulas. Develop advanced Power BI dashboards tailored to user needs. Provide guidance on data structures from APIs to align with star schema models. Work with the data team to deliver, test, and deploy data solutions. Engage with clients during onboarding to gather requirements and more »

engineering, and visualisation for business analytics and reporting. Experience Required: Commercial experience in a Data Engineering role - minimum six years Strong Data modelling experience (Star Schema/Kimball ) SQL and Python experience Power BI using DAX Azure Data Platform experience including Azure Data Lake, Azure Data Factory, Synapse more »

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 more »

as Erwin Data Modeler, ER/Studio, or Sparx Enterprise Architect to capture conceptual, logical data models etc. * Proficiency in creating logical models for star schemas. * Comprehensive understanding of DAMA Data management framework with specialisms in Knowledge Areas: Data Architecture, Data Modelling and Design , Reference and Master Data, DW more »

DAX language Must be data competent and possess a capability to understand data models and interrogate data. Used to working with dimension models/star-schemas Must be familiar and used to working with Microsoft Azure based solutions including SQL Server. Excellent interpersonal skills and experience of relationship management. more »

DAX language Must be data competent and possess a capability to understand data models and interrogate data. Used to working with dimension models/star-schemas Must be familiar and used to working with Microsoft Azure based solutions including SQL Server. Excellent interpersonal skills and experience of relationship management. more »

Runtime. ETL Development: Strong experience in designing, developing, and implementing ETL pipelines. Data Warehousing Concepts: Solid understanding of data warehousing principles, including dimensional modelling, star schemas, and snowflake schemas. Cloud Computing: Experience with cloud platforms like AWS, Azure, or GCP, as Databricks operates within these environments. Data Migration Tools more »

Runtime. ETL Development: Strong experience in designing, developing, and implementing ETL pipelines. Data Warehousing Concepts: Solid understanding of data warehousing principles, including dimensional modelling, star schemas, and snowflake schemas. Cloud Computing: Experience with cloud platforms like AWS, Azure, or GCP, as Databricks operates within these environments. Data Migration Tools more »

your own in SQL. Experience with working in an Agile DevOps team. Basic understanding of data warehousing concepts, such as ETL/ELT and star schemas. Good communicative skills in both Dutch and English. You get this € 4744 to € 6582 gross per month (Schaal 12). A 13th month more »

with accurate end-user reports Proficiency with reporting tools such as Oracle OAS and Microsoft Power BI Deep understanding of Data Warehouse design, including Star schema and dimensional modelling Strong analytical skills and technical aptitude, with the ability to influence system architecture decisions Experience leading testing disciplines within more »

Ability to work independently and take initiative while collaborating with teams. Desirable: Experience with Azure Databricks or other data engineering tools. Knowledge of the STAR schema and best practices for data modelling in Power BI. Experience working in an operational or strategic data role within a business setting. more »

urgently looking to hire a Junior SQL Reporting Developer on a contract basis: Responsibilities of the past 1-2 years: - Develop and maintain SQL star schemas - Develop sophisticated and complex reports in support of business user requirements - Test & cross validate reports for accuracy and integrity - Monitor and develop ETL more »

urgently looking to hire a Junior SQL Reporting Developer on a contract basis: Responsibilities of the past 1-2 years: - Develop and maintain SQL star schemas - Develop sophisticated and complex reports in support of business user requirements - Test & cross validate reports for accuracy and integrity - Monitor and develop ETL more »