Developer and Database Analyst (DBA)

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

Were 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 UKs 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 youll not only be working on exciting client challenges youll 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 Gravitas 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 well support you on your own growth journey. We want to be the place you learn grow and unlock your true potential.

Well work with you to build a progression plan to outline how youll grow at our company and everything well do to help you get there. Were 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 wont be forgotten our development support is extraordinary for a firm of our size.

• Its a busy fast-paced environment here at Gravita. Feel free to check out our social media channels (Instagram X LinkedIn and Glassdoor).