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

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

Storage solutions. Familiarity with programming languages such as Python or C# for scripting and automation. Proven experience in designing data warehouses, data lakes, and star schema models. Proficient in implementing DevOps practices using Azure DevOps, GitHub, and CI/CD pipelines. Strong understanding of big data architectures, data ...

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

Months experience with developing and maintaining logical and physical dimensional data models, building data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc. 84 Months experience in a data modeling tool (e.g., ErWin, ER/Studio). 84 Months experience in relational ...

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

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

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

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

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

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

streams Develop PySpark/Spark SQL notebooks for advanced data cleansing, transformation, and business logic Create production-ready semantic models for Power BI, including star schemas and Direct Lake optimisation Implement governance and security controls (RLS, OLS, service principals) Drive CI/CD best practices using Azure DevOps ...

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

post-release reviews to ensure solutions continue to support business goals. About you: Proficiency in PowerBI (including DAX) and SQL querying. Strong experience with star schema data modelling. Familiarity with tools like SQL Server Management Studio and Azure DevOps. Excellent understanding of database design, table joins, views ...

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

Work With: Designing conceptual, logical, and physical data models for operational, analytical, and regulatory workloads. Creating data architecture blueprints and defining modelling patterns (3NF, star schema, Data Vault). Embedding data quality and governance into pipelines and ensuring compliance with lineage, retention, and security policies. Leading architectural discovery ...

Required skills: Should have strong experience in AWS Data stack like S3/Lambda/Glue/Redshift etc., Should be able to do Schema Management Good experience in Payment platform and ISO 20022. Strong experience on streaming and EDA tools like KAFKA and AWS MSK/Kinesis etc. … Logical and physical data modelling, normalisation, and design. Should have good understanding when to denormalize for queries; trade-offs between 3NF, Data Vault, and star schemas. Should do Command Query responsibility segregation. Good understanding of observability tools like Prometheus/Grafana/CloudWatch. Good hands-on experience with Scala ...