BI Developer - Midrand at Fidelity Services Group

Duties & Responsibilities

• Serve as the primary point of contact for business intelligence (BI) and data warehousing (DW) design, development, and maintenance.
• Work with business and IT stakeholders to understand reporting and data analysis requirements and convert them into technical specifications.
• Design, develop, test, and deploy ETL processes to load data from multiple disparate sources into a centralized data warehouse.
• Design and implement dimensional data models (star schema, snowflake schema, etc.), OLAP cubes, and other data marts as needed.
• Write SQL queries, stored procedures, and functions to support data extraction, transformation, and loading (ETL), reporting, and data analysis.
• Develop custom reports and dashboards using BI tools such as Tableau, Power BI, QlikView, or similar.
• Perform root cause analysis of data issues and take corrective action to resolve them.
• Monitor and optimize ETL processes and database performance, making recommendations for improvements where necessary.
• Keep abreast of new BI/DW technologies and make recommendations for adoption where relevant.
• Train and mentor junior team members on BI/DW concepts and best practices
• Assist in the creation of project plans, timelines, and budgets.
• Adhere to all company policies and procedures.

Required Skills and Qualifications:

• Bachelor’s degree in computer science, information systems, or related field
• 5+ years professional experience as a business intelligence developer or data analyst
• Expertise with SQL, relational databases (e.g. Oracle, MySQL, MS SQL Server), and OLAP cubes
• Experience developing ETL processes using SSIS or other tools.
• Proficiency in BI tools such as QlikView, Qlik Sense, PowerBI, Tableau etc.
• Solid understanding of data warehousing concepts and methodologies.

Preferred Skills and Qualifications:

• Master’s degree in computer science, information systems, or related field
• Certification in BI tools such as QlikView, Qlik Sense, PowerBI, Tableau etc.
• Experience with Big Data technologies (Hadoop, Spark)
• Experience with Python or R for statistical analysis