Business Intelligence Developer at Apex Group

Summary of the position

• We are seeking a highly accomplished and visionary Business Intelligence Developer to join our team.
• As a BI Developer, you will report into the Business Intelligence Manager and be responsible for developing and maintaining BI and Reporting solutions.

Comptencies

• Proficient in reporting writing tools such as SSRS, dashboarding tools like Power Bi.
• 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.
• Performance tuning of complex SQL queries.

Outline of main duties and responsibilities

As a Business Intelligence Developer, you will be expected to:

• Work with both Business Analysts and business owners to develop and enhance reports and dashboards.
• Maintain and enhance existing ETL processes.
• Be on regular after-hour stand-by support for the data warehouse loads.
• Performance tuning of stored procedures and reports.
• Ensure that development standards and processes are followed according to Apex’s best practices.

Skills and experience

• A degree or diploma (3 years) with majors Information Systems or Computer Science will be a strong advantage.
• A good working knowledge of IT systems in a corporate environment.
• At least 2-3 years of solid SQL Server development experience, with profiency in report writing skills. This includes but not limited to building complex stored procedures, functions, and views.
• 3-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.
• The below skills are not an absolute requirement but would give the candidate a significant advantage over others.
• Scheduling tools such Control-m
• Cloud based database solutions like Snowflake
• Cloud based ETL solutions like DBT
• A background in Investment and Financial Accounting