Developer: SQL and Reporting

Primary Purpose of the Job

We are seeking a skilled and detail-oriented professional to fill a hybrid role that encompasses SQL development, report writing, and data engineering. The ideal candidate will be responsible for managing data pipelines, developing and optimizing SQL queries, building reports and dashboards, and supporting the business with actionable data insights.

Main Duties and Responsibilities

• Design, develop, and optimize complex SQL queries, stored procedures, functions, and scripts.
• Ensure that all database systems are maintained and enhanced to meet the organisation's requirements for data integrity, security, and availability.
• Create and restore databases
• Monitor database performance, implement changes, apply new patches and versions when required
• Create Server agent jobs
• Build, manage and support data warehousing solution and contribute to the development of data models.
• Ability to establish ODBC connections between different types of databases and platforms
• Develop and maintain operational, financial, and ad-hoc reports using SQL-based reporting tools (e.g., SSRS, Power BI)
• Ensure data accuracy and consistency in all reports and dashboards.
• Design and implement data pipelines and ETL processes for integrating data from various sources.
• Work with large datasets, ensuring data reliability, consistency, and scalability.
• Create and maintain documentation on database design, ETL processes, and report development.
• Work closely with the developers on projects to assistance with the database structure and relationships