26 to 50 of 57 Remote Dimensional Modelling Jobs

solutions to both technical 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 … optimization. •Programming/Statistical 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 More ❯

Microsoft Azure ecosystem Exposure to or interest in: Microsoft Fabric and its evolving role in enterprise data platforms Azure DevOps for CI/CD and deployment T-SQL and dimensional modelling (Kimball methodology) Experience in Financial Services or Lloyd's market is a plus Apply now or get in touch to find out more - alexh@pioneer-search.com More ❯

SQL to create scalable, intuitive data solutions that drive business value. Key Responsibilities Build Data Products: Collaborate with business domains to design and develop ETL/ELT pipelines and dimensional models optimised for Power BI Drive Governance: Define and enforce data ownership, quality, and security standards within the Data Mesh architecture Enable Self-Service: Create intuitive data models and … and collaboration. You should bring: Technical Expertise: Proven experience coding ETL/ELT pipelines with Python, SQL, or ETL tools, and proficiency in Power BI, Tableau, or Qlik Data Modelling Skills: Strong knowledge of dimensional modelling and database principles Governance Experience: Track record of working in democratized data environments, establishing controls and guardrails Collaboration & Communication: Ability to More ❯

SQL to create scalable, intuitive data solutions that drive business value. Key Responsibilities Build Data Products: Collaborate with business domains to design and develop ETL/ELT pipelines and dimensional models optimised for Power BI Drive Governance: Define and enforce data ownership, quality, and security standards within the Data Mesh architecture Enable Self-Service: Create intuitive data models and … and collaboration. You should bring: Technical Expertise: Proven experience coding ETL/ELT pipelines with Python, SQL, or ETL tools, and proficiency in Power BI, Tableau, or Qlik Data Modelling Skills: Strong knowledge of dimensional modelling and database principles Governance Experience: Track record of working in democratized data environments, establishing controls and guardrails Collaboration & Communication: Ability to More ❯

SQL to create scalable, intuitive data solutions that drive business value. Key Responsibilities Build Data Products: Collaborate with business domains to design and develop ETL/ELT pipelines and dimensional models optimised for Power BI Drive Governance: Define and enforce data ownership, quality, and security standards within the Data Mesh architecture Enable Self-Service: Create intuitive data models and … and collaboration. You should bring: Technical Expertise: Proven experience coding ETL/ELT pipelines with Python, SQL, or ETL tools, and proficiency in Power BI, Tableau, or Qlik Data Modelling Skills: Strong knowledge of dimensional modelling and database principles Governance Experience: Track record of working in democratized data environments, establishing controls and guardrails Collaboration & Communication: Ability to More ❯

SQL to create scalable, intuitive data solutions that drive business value. Key Responsibilities Build Data Products: Collaborate with business domains to design and develop ETL/ELT pipelines and dimensional models optimised for Power BI Drive Governance: Define and enforce data ownership, quality, and security standards within the Data Mesh architecture Enable Self-Service: Create intuitive data models and … and collaboration. You should bring: Technical Expertise: Proven experience coding ETL/ELT pipelines with Python, SQL, or ETL tools, and proficiency in Power BI, Tableau, or Qlik Data Modelling Skills: Strong knowledge of dimensional modelling and database principles Governance Experience: Track record of working in democratized data environments, establishing controls and guardrails Collaboration & Communication: Ability to More ❯

semi-structured data formats, including JSON, XML, Hive tables, and Parquet files Cloud platforms (e.g., Azure, AWS, GCP), including deployment, configuration, and integration of database services Data warehousing, including dimensional modelling and ETL processes Machine learning pipeline awareness Experience with data governance and metadata management What is also important to us is that you are highly motivated and More ❯

with data extracts, data analysis and data validation as required The role requires: In-depth working knowledge and experience working with relational databases Background in data warehouse design (e.g. dimensional modelling) and data analysis Advanced MS SQL Server skillset (T-SQL, stored procedures, functions, dynamic SQL) Proven experience of developing complex reports using SSRS or closely equivalent tools More ❯

central Data Platform, working closely with the Data Management Team. Analysis of normalised transactional data and analytic data sources. Analysis of semi structured and file-based data extracts. Data modelling to transform operational data into analytic/reporting structures such as Kimball style multi-dimensional models. Essential Skills for the Data Analyst: Proven Data Analyst experience of at … least 5 years, within a Financial Services environment, with particular emphasis on Risk or cross asset derivatives areas. Data modelling, cleansing and enrichment, with experience in conceptual, logical and physical data modelling and data cleansing and standardisation. Familiarity with Data warehousing and analytical data structures. Data quality assurance, validation and linkage. Experience creating BI models and dashboards, ideally More ❯

Integration Services (SSIS) including development of full DW ETL Solutions MS Analysis Services (SSAS) for complex cube reporting solutions MS Reporting Services (SSRS) including development of complex reports Kimball Dimensional Modelling Methodology Experience of the following systems would also be advantageous: Team Foundation Server MDS Benefits Competitive Benchmarked Salary 25 days holiday Discretionary bonus scheme Employee assistance programme More ❯

SQL environments Work with business and technical teams to gather and document data requirements Design, implement, update, and support data pipelines in Azure Data Factory (ADF) Maintain data warehouse dimensional model and develop data marts Develop standards and processes to optimize cost and service delivery Provide ongoing support, debug issues, and perform root cause analysis Enforce data management governance More ❯

the partner, estimate the necessary resources, coordinate and follow up until delivery to the end user. Based on functional analyses, you translate partners needs into efficient technical solutions, through modelling and structuring the data. You draw up test scenarios and use them to carry out the necessary tests on the data warehouse. You also coordinate the user acceptance tests … addition, you have at least 3 years experience in a similar position. You have knowledge of requirements analysis, agile working, user experience, ETL, SQL, data models and flows and dimensional modelling (Kimball). Knowledge of Data Vault Modelling is a plus. Customer-oriented - You easily capture needs from partners and have good diplomatic skills. Analytical - You quickly More ❯

well documented and thoroughly tested Collaborating with analytics and data scientists to understand their needs and build models that drive insights and decision making Champion best practices for data modelling, transformation, and governance, in your immediate time and across the business Consult on our evolving data platform, advising on the tooling, infrastructure and practices needed to enable best-in … SQL skills, with experience writing efficient and well structured queries Hands on experience with DBT, building and maintaining modular, scalable data models that follow best practices Strong understanding of dimensional modelling Familiarity with AWS data services (S3, Athena, Glue) Experience with Airflow for scheduling and orchestrating workflows Experience working with data lakes or modern data warehouses (Snowflake, Redshift More ❯

Strong executional capacity in dev/data/security operations, including writing code for automation, scripting and managing cloud infrastructure and security (e.g. Terraform). Great communication and data modelling (especially dimensional modelling) skills (e.g. Kimball). A high degree of self-sufficiency, with a proven track record of delivery in a high autonomy environment. What we More ❯

PowerBI/Tableau developer, with a solid track record in delivering complex solutions. They will be proficient in desktop and cloud, with expert level experience in calculated metrics, data modelling, and optimising reports. You will Lead the design and development of visualisation dashboards that meet complex data requirements and present information in a clear and concise manner Drive data … design with business users Ability to perform data blending, data aggregation and complex calculated fields when required Possess hands on experience with SQL and knowledge of data warehousing and dimensional modelling will be advantageous Experience using large data platforms such as Snowflake, Databricks or similar Exposure to other visualisation platforms is helpful, but not essential Required Characteristics Cares More ❯

PowerBI/Tableau developer, with a solid track record in delivering complex solutions. They will be proficient in desktop and cloud, with expert level experience in calculated metrics, data modelling, and optimising reports. You will · Lead the design and development of visualisation dashboards that meet complex data requirements and present information in a clear and concise manner · Drive data … design with business users Ability to perform data blending, data aggregation and complex calculated fields when required Possess hands on experience with SQL and knowledge of data warehousing and dimensional modelling will be advantageous Experience using large data platforms such as Snowflake, Databricks or similar Exposure to other visualisation platforms is helpful, but not essential ???? Required Characteristics Cares More ❯

month project focused on redesigning and enhancing our data models and reporting layer. This role is key to establishing a robust data foundation using dbt, SQL, and modern data modelling best practices. Reporting to the Lead Analytics Engineer, who oversees the data tagging, modelling, and reporting workstreams, you'll play a critical role in a high-impact initiative … can hit the ground running and provide immediate value through strong technical delivery and collaboration. Key Deliverables: Provide subject matter expertise to help shape and guide the overall data modelling strategy for the project. Design and implement intermediate data models to support a comprehensive and unified view of subscriptions data. Lead the planning and execution of MVP data mart … accurate, and scalable reporting. Plan, scope, and initiate the build of fast-follow development phases. As a Data Analyst you will; Serve as a subject matter expert on data modelling throughout the project lifecycle. Design and implement scalable and maintainable dbt models for our subscriptions data domain. Create and maintain a suite of dbt tests to ensure data quality More ❯

as a Tableau developer, with a solid track record in delivering complex solutions. They will be proficient in desktop and cloud, with expert level experience in calculated metrics, data modelling, and optimising reports. You will · Lead the design and development of visualisation dashboards that meet complex data requirements and present information in a clear and concise manner · Drive data … design with business users Ability to perform data blending, data aggregation and complex calculated fields when required Possess hands on experience with SQL and knowledge of data warehousing and dimensional modelling will be advantageous Experience using large data platforms such as Snowflake, Databricks or similar Exposure to other visualisation platforms is helpful, but not essential Required Characteristics Cares More ❯

org level contributions. Rotate around the business to build relationships and act as a multiplier. What we look for in you Understand, assess and effectively apply modern data architectures (dimensional model, data mesh, data lake). Experience in applying and using data observability methods effectively. Experience in modern software development practices (agile, CI/CD, DevOps, infrastructure as code More ❯

with the potential for extension. This role offers a hybrid working arrangement, requiring 1-2 days per week onsite at Heathrow, Hounslow, with on-site parking available. Responsibilities: Data Modelling: Design and optimize star schema data models tailored to our client's business needs for streamlined analytics and reporting. Collaboration: Work closely with data architects, BI developers, and business … with business goals. Data Quality & Governance: Establish data quality checks and governance practices to ensure accuracy and integrity within data models. Skills/Must have: Proven experience in data modelling using Kimball methodology, with a focus on dimensional modelling and star schemas. Strong proficiency in SQL and experience with data modelling tools like ER Studio, Power More ❯

a focus on planning, budgeting, and forecasting processes. Demonstrated experience in designing and building complex, large-scale Anaplan models from scratch. Strong understanding of Anaplan architecture, UX, and advanced modelling techniques. Experience in multi-dimensional modelling and managing large data sets within Anaplan. Certifications: Anaplan Level 1 and Level 2 Model Builder certifications (Level 3 is strongly … Connect, APIs, or ETL tools). Familiarity with data governance, version control, and Anaplan workspace management. Analytical Skills: Strong analytical and problem-solving abilities with an aptitude for financial modelling and operational analysis. Experience implementing end-to-end Anaplan solutions for financial institutions or within finance-focused projects. Knowledge of Agile project management methodologies. Familiarity with complementary tools (e.g. More ❯

You'll have broad career progression opportunities across Group, which includes several high profile household name What you'll bring: Strong Python & TDD skills Expertise in modern data architecture (dimensional modelling, data mesh, data lake) & best practices (agile, CI/CD, IaC, observability). Experience with Cloud and big data technologies (e.g. Spark/Databricks/Delta Lake More ❯

What you will bring to the team: Experience managing or supervising a team of BI Analysts. Experience in reporting professional with a good understanding of SQL scripting and data modelling gained in a BI and reporting development environment. Extensive experience in using Power BI (Desktop and Online, as well as Excel (to a lesser degree). Comfortablityworking with an … incollaboratively with those around you, proactively building exceptional working relationships with internal and external stakeholders – you are equally able to shape the decisions with well-informed views. Experience with dimensional modelling (warehouses, data vaults, etc.) would be desirable. What we can offer you: Flexible working & holidays - Enjoy flexible working and competitive holiday allowance, with annual buy & sell scheme More ❯

What you will bring to the team: Experience managing or supervising a team of BI Analysts. Experience in reporting professional with a good understanding of SQL scripting and data modelling gained in a BI and reporting development environment. Extensive experience in using Power BI (Desktop and Online, as well as Excel (to a lesser degree). Comfortablity working with … collaboratively with those around you, proactively building exceptional working relationships with internal and external stakeholders - you are equally able to shape the decisions with well-informed views. Experience with dimensional modelling (warehouses, data vaults, etc.) would be desirable. What we can offer you: Flexible working & holidays - Enjoy flexible working and competitive holiday allowance, with annual buy & sell scheme More ❯

clients. Their need is for products that display data in simple ways that aid business decisions and satisfy reporting requirements. In-depth BI, Analytics and Data Science Knowledge of dimensional modelling/optimising of data for end-user consumption Report writing (with PowerBI and/or Tableau) Advanced data analysis About working for us Our focus is to More ❯