Data Warehouse Architect

1 month ago


Rotherham, Rotherham, United Kingdom Stellar Select Limited Full time

About Stellar Select Limited

We are a specialist lender that offers a supportive and engaging work environment with a focus on employee growth and development. Our company culture values collaboration, innovation, and continuous learning.

Job Overview

This newly created role will be instrumental in designing, developing, and maintaining the company's data warehouse. The successful candidate will have expertise in data warehousing, modelling, and database design, with proficiency in SQL (SSMS) and ETL tools (e.g., SSIS, SAS DI, Informatica, Talend).

  • The role involves designing and implementing data models and schemas, building and optimising ETL processes for seamless data integration from various sources, and developing efficient SQL queries for data retrieval and manipulation.
  • The ideal candidate will have experience with data warehouse platforms (e.g., SQL Server, Redshift, BigQuery, Snowflake) and BI tools (e.g., Power BI, Tableau).
  • A strong understanding of DBMS and data warehousing concepts, as well as experience with cloud-based data warehouses, is essential.
Key Responsibilities
  • Design and implement data models and schemas to ensure data quality and integrity.
  • Build and optimise ETL processes for seamless data integration from various sources.
  • Develop efficient SQL queries for data retrieval and manipulation.
  • Oversee data warehouse build, deployment, and maintenance.
  • Collaborate with business analysts, IT, and development teams to align on data requirements and system integration.
Requirements

To be successful in this role, you will need:

  • Proven experience in data warehousing, modelling, and database design.
  • Proficient in SQL (SSMS) and ETL tools (e.g., SSIS, SAS DI, Informatica, Talend).
  • Experience with data warehouse platforms (e.g., SQL Server, Redshift, BigQuery, Snowflake).
  • Familiarity with BI tools (e.g., Power BI, Tableau).
  • Strong understanding of DBMS and data warehousing concepts (e.g., SQL, Python, Shell).
  • Experience with cloud-based data warehouses.
  • Understanding of data governance and security best practices.

Estimated Salary: £40,000 - £45,000 per annum.



  • Rotherham, Rotherham, United Kingdom Connected Data Solutions Full time

    Job Title:Senior Data ArchitectAbout the Company:Connected Data Solutions is a leading company that specialises in workforce management through data integration.Job Description:We are looking for a Senior Data Architect to design and implement data integration solutions for our clients.Key Responsibilities:Design and implement data integration strategies to...


  • Rotherham, Rotherham, United Kingdom Connected Data Solutions Full time

    Technical Data ArchitectWe're seeking an experienced Technical Data Architect to lead the design and implementation of data integration solutions for our clients. As a key member of our workforce management solutions team, you will play a crucial role in developing and executing data integration strategies, consulting with clients, and ensuring seamless data...


  • Rotherham, Rotherham, United Kingdom Stellar Select Limited Full time

    About Our Client:Stellar Select Limited is a specialist lender that offers a supportive and engaging work environment with a focus on employee growth and development.We are looking for an experienced Data Warehouse Developer to join our team. The ideal candidate will have a strong understanding of data warehousing concepts and be proficient in SQL (SSMS) and...


  • Rotherham, Rotherham, United Kingdom SitePoint Pty Full time

    Job DescriptionSituated in Sheffield/Rotherham/Doncaster, we are recruiting a Finance Data Architect to oversee the development of our data warehouse. The ideal candidate will have strong knowledge of data modelling, database design, and SQL.ResponsibilitiesAnalyse data requirements and design data models and schemes for the data warehouse.Develop complex...


  • Rotherham, Rotherham, United Kingdom Stellar Select Limited Full time

    Job Title: Data Warehouse DeveloperLocation: Rotherham HybridAbout the CompanyOur client is a specialist lender that offers a supportive and engaging work environment with a focus on employee growth and development.Key ResponsibilitiesDesign and implement data models and schemas.Build and optimise ETL processes for seamless data integration from various...


  • Rotherham, Rotherham, United Kingdom SitePoint Pty Full time

    Job OverviewWe are seeking a skilled Data Warehouse Specialist to join our team at SitePoint Pty. This role involves designing and developing data models and schemes for our data warehouse, ensuring efficient data retrieval and manipulation.Key ResponsibilitiesDesign and develop data models and schemes for the data warehouse.Develop complex SQL queries and...


  • Rotherham, Rotherham, United Kingdom Connected Data Solutions Full time

    Job Description:We are seeking a highly skilled UKG Pro WFM Solutions Architect to join our team. As a key member, you will be responsible for designing and implementing data integration solutions using UKG Pro WFM. This role requires strong technical skills in database management, ETL processes, and data warehousing.Key Responsibilities:Design and implement...


  • Rotherham, Rotherham, United Kingdom Pearson Education Full time

    About the OpportunityWe are seeking a highly skilled Data Engineer to join our team in Manchester, Rotherham, or London offices. As a key member of our data engineering team, you will play a crucial role in designing, developing, and maintaining complex data architectures.The ideal candidate will have experience working with AWS services, expertise in...

  • Cloud Data Architect

    2 weeks ago


    Rotherham, Rotherham, United Kingdom Pearson Education Full time

    About the RoleWe are looking for a talented individual with expertise in designing, developing, and maintaining complex SQL queries, stored procedures, and data pipelines. The ideal candidate will have hands-on experience with Amazon Aurora MySQL, Microsoft SQL Oracle, DynamoDB, and other database systems.The successful candidate will also be responsible for...

  • Database Architect

    2 weeks ago


    Rotherham, Rotherham, United Kingdom Stellar Select Limited Full time

    As a Data Warehouse Engineer at Stellar Select Limited, you will play a critical role in designing, building, and maintaining the company's data warehouse. This involves developing efficient SQL queries, building ETL processes, and overseeing data warehouse deployment and maintenance. To succeed in this position, you must have a solid understanding of...

  • Chief Data Officer

    1 day ago


    Rotherham, Rotherham, United Kingdom G4S Technology Full time

    Job OverviewWe are seeking a highly skilled Chief Data Officer to lead our data warehouse operations and drive data architecture and management initiatives. The ideal candidate will have expertise in transforming disparate data sources into a warehouse model, with a proven track record of successful data governance implementation.


  • Rotherham, Rotherham, United Kingdom Stellar Select Limited Full time

    We are seeking an experienced Data Warehouse Developer to join our team at Stellar Select Limited in Rotherham Hybrid. This is a newly created role that involves designing, developing, and maintaining the company's data warehouse.About the JobIn this role, you will be responsible for designing and implementing data models and schemas, building and optimising...


  • Rotherham, Rotherham, United Kingdom G4S Business Unit:US Youth Services Full time

    Job OverviewWe are seeking a highly skilled Data Governance Strategist to lead our data warehouse operations and drive data architecture initiatives. As a seasoned professional, you will create and manage advanced strategies to address data and ETL challenges, aligning with business goals, legal compliance, and growth needs.


  • Rotherham, Rotherham, United Kingdom G4S Technology Full time

    About the RoleG4S Technology is hiring a seasoned data professional to lead their data warehouse operations and drive data architecture and management initiatives. The role involves creating and managing advanced strategies to address data and ETL challenges, aligning with business goals, legal compliance, and growth needs.The ideal candidate will have...


  • Rotherham, Rotherham, United Kingdom Pearson Full time

    Our cloud-native data transformation lead will be responsible for designing, developing and maintaining complex data pipelines and architectures, as well as ensuring the smooth operation of our data warehouses. This role requires a strong understanding of big data technologies, including AWS, MySQL, and NoSQL databases.


  • Rotherham, Rotherham, United Kingdom Pearson Full time

    We are seeking a highly skilled Data Engineer to join our team in Manchester, Rotherham, or London offices. As a key member of our team, you will be responsible for designing, developing, and maintaining complex SQL queries, stored procedures, and data pipelines.The ideal candidate will have proficiency in one or more database systems such as Amazon Aurora...

  • Big Data Specialist

    1 month ago


    Rotherham, Rotherham, United Kingdom Stellar Select Limited Full time

    About the RoleThis newly created position at Stellar Select Limited will play a crucial part in shaping the company's data strategy. The successful candidate will possess expertise in data warehousing, modelling, and database design, with a strong background in SQL (SSMS) and ETL tools (e.g., SSIS, SAS DI, Informatica, Talend).Key ResponsibilitiesDesign and...


  • Rotherham, Rotherham, United Kingdom Pearson Full time

    Pearson is a leading education company that values the power of an inclusive culture and strong sense of belonging. We are seeking a Senior Data Transformation Specialist to join our team in Manchester, Rotherham, or London offices.The successful candidate will have experience working with complex data transformation projects, project initiations, and...

  • SQL Developer

    2 weeks ago


    Rotherham, Rotherham, United Kingdom CV-Library Full time

    Job Description SummaryWe are seeking an experienced Data Warehouse Developer to join our dynamic team at CV-Library. As a Data Warehouse Developer, you will be responsible for designing, building, and maintaining our company's data warehouse.Your primary responsibilities will include:Designing and implementing efficient data models and schemas.Building and...


  • Rotherham, Rotherham, United Kingdom Stellar Select Limited Full time

    Stellar Select Limited seeks an experienced Data Warehouse Developer to join its team. The successful candidate will be responsible for designing and developing data warehouses, ensuring high-quality data integration and analysis. A strong background in SQL and ETL tools is essential, as well as experience with data warehouse platforms such as SQL Server and...