Job Title: Data Architect
Location: Central London
Salary: Competitive
Job type: Full-time, Permanent.
Take the plunge. Live the dream. Do something which you know will touch the lives of millions of people the world over every single day and will change the way businesses and consumers think. Get out of bed in the morning for that adrenalin hit, love the pace, love the challenge, love doing what has never been done before – and love being the best you've ever been. And what's more, owning part of what you've created.
TruRating is a hypergrowth software as a service (SaaS) company that improves businesses, benefits consumers, and donates to charities. Our starting point is using patented technology to collect feedback from 80%+ of customers at the point of payment and linking this to transaction and product data to provide unique mass, real-time insight to merchants.
The Role:
The role is a hybrid lite model -at present largely at home with 2 days a month with the team in London, which could extend to once a week in the future.
The role of the Data Architect is critical to TruRating's continued growth and success. The role will help us continue to build on our data and insight capabilities and ensure we deliver uniquely powerful insights to our clients as we extend our reach and process huge volumes of near real time data.
The right candidate will have deep experience of working with the Azure BI stack, designing and maintaining complex ETL processes, working with third party platforms such as Snowflake, will love solving complex challenges and be up to date on new technology advances in the big data and insight space.
Responsibilities:
* Set the strategic vision for designing our data schemas, managing our data architecture, and scaling and enhancing our data platform
* Architect, develop and deliver end-to-end data processing from raw storage to front-end analytics solutions
* Provide exceptional leadership and support to the Data Services team
* Manage all data infrastructure services
* Work with our Product, Insights, and Development Teams to enhance data availability, deliver technical projects, and advise on how best to deliver and present data within the merchant facing analytics platform, open data deliverables, and client reporting
* Support data platforms to internal users for deep dive analytical activity and internal reporting requirements
* Contribute to wider architecture group's work (Solutions Architects working with our payment partners and merchants around data capture etc.) including creating/reviewing their designs and specifications.
The Candidate:
* Is comfortable leading the architecture, governance, design and development of systems which enable the analysis of data from multiple diverse internal and external sources
* Has great experience with the design and build of modern data warehouse solutions in the cloud
* Designs and documents solutions using data schemas, flowcharts, layouts, diagrams, charts and code comments
* Is a team player with excellent interpersonal skills; able to collaborate across the organization and has a hands on-approach to development
* Has a strong BI background and assists with design and development of Tabular cubes, Snowflake tables, and other data structures which provide reporting to internal and external users
* Can evaluate 3rd party software solutions
* Is experienced working with Agile and Rapid Application Development methodologies, using an Agile approach
* Has excellent written, verbal communication and presentation skills
* Is self-reliant, resilient and proactive with a high motivation to make things happen, deliver effectively and efficiently.
* Enterprise data warehouse design, star/snowflake schemas and ETL design
* Current experience of working with third party data platforms, such as the Snowflake Platform
* Azure Platform: Azure SQL DB, Azure Azure SQL DW, Azure Analysis Services, Azure Data Factory, Azure Function Apps
* MSSQL BI Stack, SSAS, SSIS, SSRS. Power BI desirable
* Source control with git and experience using CI/CD solutions
Benefits:
* 25 days annual leave
* Private medical healthcare with BUPA (medical history disregarded)
* SMART pension
* 'WeCare' support packages
* Group life insurance
Candidates with the relevant experience or job titles of: IT Programmer, Developer, Programmer, Software Programming, Software Development, IT Developer, IT Software Engineer, Software Development Engineer, Software Developer, Software Engineer, Java Engineer, Application Support Officer, Application Support, Sharepoint, Web Analyst, IT Application Support, IT Data Analyst, Data Support Analyst, ICT Data Analyst may also be considered for this role