Description:
We are looking for a Database Engineer & Developer 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.
Experience
Qualifications, Knowledge & 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