1 to 25 of 38 Star Schema Jobs

responsibilities: Partner with business teams to understand requirements and deliver meaningful, actionable insights. Design and implement data pipelines from APIs and relational sources. Model data effectively using Kimball/Star Schema methodologies. Develop dashboards, reports, and automated integrations in Power BI. Support the onboarding of data from newly acquired businesses. Contribute to data strategy, process improvement, and best … skills and experience: Advanced SQL proficiency (joins, CTEs, window functions). Strong Power BI skills, including semantic modelling, DAX, and report design. Experience building data warehouse solutions (Kimball/Star Schema). Excellent communication and stakeholder engagement skills. Proactive, organised, and adaptable with a genuine team spirit. Desirable: Knowledge of Medallion Architecture and Data Lakehouse concepts. Working knowledge More ❯

Rate: $89/hour C2C Location: San Francisco, CA Duration: 12+ months/long-term Interview Criteria: Telephonic + Skype Direct Client Requirement Must haves: (BI, Tableau, SQL, DWH, Star Schema, date lake/Snowflake) and at least one of the following: Qlik, Cognos, Business Objects, or MicroStrategy) In this client is looking between 9-15 years of … working with large-scale data warehouses and strong SQL skills. The individual should understand the extraction and transformation process for reporting needs. Strong understanding of data modeling concepts, including star schema, fact and dimension tables, and SCDs. The individual will collaborate with data modelers to design efficient data models and optimize reporting structures. Experience working in nearshore and More ❯

with tools such as MuleSoft, 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 IAM, KMS, and RBAC implementation. More ❯

with tools such as MuleSoft, 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 IAM, KMS, and RBAC implementation. More ❯

with tools such as MuleSoft, 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 IAM, KMS, and RBAC implementation. More ❯

environments Implement CI/CD processes using Azure DevOps for secure, reliable deployment Technical Skills: Strong expertise in: Power BI and paginated reporting SQL and data architecture Dimensional modelling (star schema, snowflake, denormalised structures, SCD handling) DAX, Visual Studio and data transformation logic Azure Fabric, Azure Data Factory, Synapse, Data Lakes and Lakehouse/Warehouse technologies ETL/ More ❯

environments Implement CI/CD processes using Azure DevOps for secure, reliable deployment Technical Skills: Strong expertise in: Power BI and paginated reporting SQL and data architecture Dimensional modelling (star schema, snowflake, denormalised structures, SCD handling) DAX, Visual Studio and data transformation logic Azure Fabric, Azure Data Factory, Synapse, Data Lakes and Lakehouse/Warehouse technologies ETL/ More ❯

environments Implement CI/CD processes using Azure DevOps for secure, reliable deployment Technical Skills: Strong expertise in: Power BI and paginated reporting SQL and data architecture Dimensional modelling (star schema, snowflake, denormalised structures, SCD handling) DAX, Visual Studio and data transformation logic Azure Fabric, Azure Data Factory, Synapse, Data Lakes and Lakehouse/Warehouse technologies ETL/ More ❯

environments Implement CI/CD processes using Azure DevOps for secure, reliable deployment Technical Skills: Strong expertise in: Power BI and paginated reporting SQL and data architecture Dimensional modelling (star schema, snowflake, denormalised structures, SCD handling) DAX, Visual Studio and data transformation logic Azure Fabric, Azure Data Factory, Synapse, Data Lakes and Lakehouse/Warehouse technologies ETL/ More ❯

environments Implement CI/CD processes using Azure DevOps for secure, reliable deployment Technical Skills: Strong expertise in: Power BI and paginated reporting SQL and data architecture Dimensional modelling (star schema, snowflake, denormalised structures, SCD handling) DAX, Visual Studio and data transformation logic Azure Fabric, Azure Data Factory, Synapse, Data Lakes and Lakehouse/Warehouse technologies ETL/ More ❯

and Experience Hands-on experience with Pentaho Data Integration (PDI/Kettle) . Strong proficiency in SQL (MySQL, PostgreSQL, Oracle, SQL Server, etc.). Experience with data warehousing concepts (star schema, dimension modelling). Familiarity with ETL performance tuning and error handling techniques. Experience working with Linux/Unix environments and Shell Scripting. Understanding of REST/SOAP More ❯

environments Implement CI/CD processes using Azure DevOps for secure, reliable deployment Technical Skills: Strong expertise in: Power BI and paginated reporting SQL and data architecture Dimensional modelling (star schema, snowflake, denormalised structures, SCD handling) DAX, Visual Studio and data transformation logic Azure Fabric, Azure Data Factory, Synapse, Data Lakes and Lakehouse/Warehouse technologies ETL/ More ❯

performing data analysis and performance tuning. Proven knowledge and skills in designing data models and tables such as fact, snapshot, and dimension (including but not limited to medallion architectures, star schemas and slowly changing dimension designs). Ability to test and document end-to-end processes. Proven problem-solving abilities. Demonstrated experience in learning and understanding business domains. Experience More ❯

PySpark and Python Support the medallion architecture (bronze, silver, gold layers) to ensure a clean separation of raw, refined, and curated data Design and implement dimensional models such as star schemas and slowly changing dimensions Work closely with analysts, governance, and engineering teams to translate business requirements into data solutions Apply data governance and lineage principles to ensure documentation More ❯

data pipelines using Fabric Pipelines, Azure Data Factory, Notebooks and SSIS. Develop Power BI dashboards and paginated reports tailored to business needs. Model complex datasets into actionable insights using star schemas, snowflakes, and denormalised models. Optimise SQL queries and build semantic models within Fabric. Collaborate with cross-functional teams to translate business requirements into technical solutions. Support CI/ More ❯

Excel based analysis towards automated or semi-automated solutions. Experience in translating business requirements whilst also enhancing their ask by providing and explaining useful additional analysis. Expert knowledge of star schema modelling including dimensional data modelling, the identification of dimensions, facts, measures and hierarchies. Advanced experience developing analytics using Microsoft Power BI and/or other data visualisation More ❯

data streaming Strong proficiency in SQL and Python Familiarity with Azure Data Services and CI/CD pipelines in a DevOps environment Solid understanding of data modelling techniques (e.g., Star Schema) Excellent problem-solving skills and a high attention to detail Desirable: Azure Data Engineer certification Experience working with unstructured data sources (e.g. voice) Exposure to Power BI More ❯

Parties. Drive Continuous Improvement. Technical Skills Required: Azure Data Factory. AWS Data Services (Redshift, S3, Lambda) - Desirable. SSRS - hands-on experience. ETL - Design, Data Quality Frameworks & Pipeline Management. SQL - Star Schema - Data Modelling. Data Warehouse Design, Development & Testing. Data Warehousing Methodologies. User Support - Power BI - desirable experience. Undertake & Support IT Governance processes (License review etc). Customer Focused More ❯

Parties. Drive Continuous Improvement. Technical Skills Required: Azure Data Factory. AWS Data Services (Redshift, S3, Lambda) - Desirable. SSRS - hands-on experience. ETL - Design, Data Quality Frameworks & Pipeline Management. SQL - Star Schema - Data Modelling. Data Warehouse Design, Development & Testing. Data Warehousing Methodologies. User Support - Power BI - desirable experience. Undertake & Support IT Governance processes (License review etc). Customer Focused More ❯

Parties. Drive Continuous Improvement. Technical Skills Required: Azure Data Factory. AWS Data Services (Redshift, S3, Lambda) - Desirable. SSRS - hands-on experience. ETL - Design, Data Quality Frameworks & Pipeline Management. SQL - Star Schema - Data Modelling. Data Warehouse Design, Development & Testing. Data Warehousing Methodologies. User Support - Power BI - desirable experience. Undertake & Support IT Governance processes (License review etc). Customer Focused More ❯

Modeling : Deep understanding of data warehousing concepts and best practices. Experience of, and ability to, transform raw transactional data into well-structured analytics-ready datasets using schemas like the star schema (Kimball methodology) Data Quality & Governance : build trust in data by implementing data validation checks, testing frameworks, and clear documentation within your pipelines Experience in the following areas More ❯

Modeling : Deep understanding of data warehousing concepts and best practices. Experience of, and ability to, transform raw transactional data into well-structured analytics-ready datasets using schemas like the star schema (Kimball methodology) Data Quality & Governance : build trust in data by implementing data validation checks, testing frameworks, and clear documentation within your pipelines Experience in the following areas More ❯

skills including DAX, Power Query (M), and semantic model design • Experience working with Power BI Premium and optimising for performance and scalability • Strong understanding of data architecture principles (e.g. star schema, data lakehouse environments) • Solid SQL experience for data transformation, validation, and extraction • Proven experience building reusable, governed datasets across reporting domains • Demonstrated ability to automate manual reporting … operational data (distribution/supply chain/manufacturing is advantageous) Key Responsibilities: • Design, build, and maintain Power BI semantic data models and datasets • Collaborate with Data Architects to align schema and data definitions • Develop and deploy enterprise-level dashboards across core business domains • Automate manual reporting processes and reduce reporting lead times • Enable self-service reporting through training, mentoring More ❯

Collaborate with stakeholders to understand requirements and deliver practical solutions. Ensure data quality and consistency across reporting pipelines. What We’re Looking For Power BI Expertise: Advanced data modelling (STAR schema, relationships, filter direction). Strong DAX skills for measures and calculations. Experience optimizing performance for large datasets. Excel Mastery: Advanced formulas (SUMIFS, COUNTIFS, text functions). Dashboard More ❯

Collaborate with stakeholders to understand requirements and deliver practical solutions. Ensure data quality and consistency across reporting pipelines. What We’re Looking For Power BI Expertise: Advanced data modelling (STAR schema, relationships, filter direction). Strong DAX skills for measures and calculations. Experience optimizing performance for large datasets. Excel Mastery: Advanced formulas (SUMIFS, COUNTIFS, text functions). Dashboard More ❯