Senior SQL Developer - Pretoria at Datacentrix

Required Skills and Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent practical experience in a similar role.
• Certifications in Microsoft SQL Server or Power BI.
• 5+ years of experience in SQL development within a Microsoft environment.
• Profound knowledge of Microsoft SQL Server, Power BI, T-SQL, SSIS, SSAS, and SSRS.
• Proven experience in BI development and data warehousing with a focus on financial data.
• Strong analytical skills and ability to translate financial reporting needs into technical solutions.
• Excellent communication skills, with the ability to work effectively with both IT and financial teams.
• Experience with financial systems and understanding their data and reporting frameworks.
• Knowledge of financial principles and terminologies.

Key Responsibilities:

Financial Reporting and Analytics:

• Act as a key liaison between the IT and financial departments, ensuring a deep understanding of financial reporting needs.
• Design and implement customized SQL and Power BI solutions to meet specific financial data reporting and analysis requirements.

BI Development:

• Develop business intelligence solutions leveraging Microsoft SQL Server, Power BI, and other technologies.
• Optimize SQL queries and stored procedures for efficient data analysis and reporting, with a focus on financial data.

ETL and Data Integration:

• Lead the creation and maintenance of ETL processes, particularly for financial data, using SQL Server Integration Services (SSIS) and other tools.
• Ensure high data quality and integrity in financial reporting.

Analysis Services and Data Warehousing:

• Utilize SQL Server Analysis Services (SSAS) to create OLAP cubes, focusing on financial metrics and KPIs.
• Design and maintain data warehouse solutions with an emphasis on financial data aggregation and reporting.

Collaboration and Solution Design:

• Collaborate extensively with the financial department to identify and clarify reporting needs and objectives.
• Translate financial reporting requirements into effective, efficient SQL-based solutions.