Business Intelligence Developer at Apex Group

Job Specification

• We are seeking a highly accomplished and visionary Business Intelligence Developer to join our team in to help drive out Reporting and BI solutions. As a BI Developer, you will be responsible for the BI and Reporting solutions of a part of our global business. Collaborate with business analysts and cross-functional stakeholders to deliver innovative data-driven solutions. You will leverage your expertise in BI and Reporting to develop and implement ETL, reporting and dashboards solutions. If you are a seasoned BI practitioner with exceptional BI and reporting writing skills and have a proven track record of driving out optimized solutions, we want to hear from you.

Competensies

• Proficient in reporting writing tools such as SSRS, dashboarding tools like PowerBI.
• Solid understanding of relational databases, Microsoft T-SQL.
• Solid understanding of ETL processes.
• Understanding of scheduling tools such as control-m.
• Fundamental understanding of basic warehouse concepts.
• Knowledge and understanding of performance tuning of complex SQL queries.

Responsibilities

Report solutioning

• Work with both Business Analysts and business owners to development new reports and dashboards and the enhancement of existing reports and dashboards.

Performance tuning

• Performance tuning of stored procedures and reports

Production Support

• Investigate production reporting issues and help business their understand their data.

ETL Maintenance and Enhancements

• Maintaining and enhance current ETL processes using various ETL tools

After Hours Standby Support

• Be on regular after-hour stand-by support for the data warehouse loads.

Adherence to standards, processes and procedures

• Ensure that development standards and processes are followed according to Apex’s best practices.

Qualifications and requirements 

• A degree or diploma (3 years) with majors Information Systems or Computer Science.
• A good working knowledge of IT systems in a corporate environment.
• At least 3-5 years of solid SQL Server development experience, with proficiency in report writing skills.  This includes but not limited to building complex stored procedures, functions, and views. 
• At least 5 years’ experience in building integration solutions independently.
• Strong attention to accuracy and detail.
• Strong analytical and problem-solving skills, including an ability to work independently from the business analyst team when appropriate.
• A high tolerance for ambiguity as requirements is not always clear at the start of a project and can change as users and analysts start to see the data.
• Self-starter who can take the initiative to learn new technologies independently and not just wait to be sent on training.
• Solid time management and communication skills essential.
• Ability to multi-task and to work on multiple project streams simultaneously.
• High personal integrity.

Preferred skills but not essential

• Scheduling tools such as Control-m
• Exposure to cloud based BI and ETL solutions and services
• Familiarity with financial services industry regulations and compliance.