Outline of main duties and responsibilities

• Work with both Business Analysts and business owners to development of new reports and dashboards and the enhancement of existing reports and dashboards.
• Performance tuning of stored procedures and reports
• Assist the Business Analysts to investigate issues and help them in their data analysis.
• Be on regular after-hour stand-by support for the data warehouse loads.
• 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 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. 
• 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.
• 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