Job Description

We're Gravita:

the accountants fuelling ambitious businesses. We're a full service, tech-enabled firm, working with entrepreneurs and businesses to help them achieve their goals, and make an impact in the world.


We're

growing fast

and are bringing like-minded advisors together to form a full-service

tech-enabled

accounting partner for thousands of SMEs. Our team use their incredible expertise alongside intuitive technology to help businesses and entrepreneurs plan better and grow faster.


Our mission is to become the

UK's leading tech-enabled accounting firm

for SMEs. We have ambitious goals and our high-calibre team work hard to achieve them. We are one team with one agenda, working collaboratively in a respectful environment to deliver a great service to our clients. So if you join us, you'll not only be working on exciting client challenges, you'll also be helping us

shape the future of accounting

.

#

The Role

We are looking for a developer / DBA who is eager to develop and learn in a fast moving environment.


You will be responsible for development and managing our Azure datalake environment, our Microsoft SQL Database, API interefaces. You will also be a key member of the team who drives the use of data and AI in our business as the accountancy profession transforms itself.


The Gravita Technology team is a small team, with large ambitions. If you join us, you will be exposed to fast moving environment, and have you will have the opportunity to learn and develop quickly.


The key skills required include

Python SQL - Possible DBT experience. Git Databricks Governance (Nice to have) But can be learnt. Pyspark (Nice to have) But can be learnt

You will report to our IT Delivery Manager who has a wealth of software development experience, and work alongside our other Software Engineer.

#

Key Responsibilities:

Develop, archictect and operate our Deltalake. Develop and operate key API interfaces between our Operational systems Manage and optimise our core CCH Practice Management System database. Work includes working with the Gravita Data lead, to drive improvements in the quality of our operational data. Develop procedures that can be operated by the support team

API/Interfaces

Develop and manage interfaces between Core operational systems. Create new SQL Tables for Ingested Data. Diagnose and fix issues with any Data Pipeline runs.

Gravita Datalake

On-going development and management of Deltalake. Convert old T-SQL for New Environment. Create new DBT Models to create Silver and Gold Level Tables / Views. Manage Governance of Databricks Unity Catalog. Work with PowerBI developer to ensure we have the necessary MIS reports. Assist the PowerBI team to move over to Deltalake.

CCH Database

Work with Data team on the data cleansing. Optimize SQL Queries. Deploy dashboards for Data Quality Monitoring.

Data and AI Strategy

Be a key member of the team developing Gravita's data and AI strategy. Develop data skills in new areas and help Gravita get benefit.

General

Use Git to version control projects. Consult on Database and SQL issues. Manage & Maintain Databases - Ensure our databases are secure, high-performing, and scalable, implementing best practices in administration, backup, and recovery Database Development - Design, build, and optimize database components to support our website and feature requirements, ensuring seamless functionality. Security & Compliance - Enforce security measures, access controls, and compliance protocols to protect sensitive data. SQL Query Development - Write efficient queries, stored procedures, and database scripts to support business operations and new system developments. Collaboration & Problem-Solving - Work closely with cross-functional teams, proactively solving data-related challenges and contributing to key projects.
#

Qualifications, Knowledge & Experience:

Experience

Python (3+ years) with ideally API Intetgration experience 3+ years' experience in SQL Development with ideally hands-on Azure SQL Database administration Azure SQL, Azure Analytics, Dataverse or similar solutions, or a willingness to learn and develop Some DBT experience Good T-SQL (queries, stored procedures, indexing, performance tuning) Experience maintaining, optimising, and scaling production databases Knowledge of Data Pipelines, Managing and evolving our Azure-hosted SQL infrastructure Supporting the dev team with schema updates and data integrity Handling SQL support tickets - from data updates to complex merges

In General

A problem-solving mindset, with the ability to understand business collegues requirements and then work independently and collaboratively in a fast-moving team. Good organisation with the ability to juggle multiple priorities, work independently, and maintain control in dynamic situations Creative and analytical thinker with a solutions-focused mindset, always looking for better ways of doing things
#

Your Career with Gravita

When you join Gravita, we'll support you on your own growth journey. We want to be the place you learn, grow and unlock your true potential.


We'll work with you to build a progression plan to outline how you'll grow at our company and everything we'll do to help you get there. We're also passionate about learning and development, to help you focus on your future.





#

The Nitty Gritty

Our standard working week is a 37.5-hour week on a hybrid basis Core working hours are 10am - 4pm Monday to Friday Flexible working and happy employees are at the top of our list here at Gravita and we have been working hard to support our teams through the fast-paced changes. Your development won't be forgotten, our development support is extraordinary for a firm of our size. * It's a busy, fast-paced environment here at Gravita. Feel free to check out our social media channels (Instagram, X, LinkedIn and Glassdoor).