Business Intelligence Engineer

BI Engineer III

The Apex Group was established in Bermuda in 2003 and is now one of the world’s largest fund administration and middle office solutions providers.

Our business is unique in its ability to reach globally, service locally and provide cross-jurisdictional services. With our clients at the heart of everything we do, our hard-working team has successfully delivered on an unprecedented growth and transformation journey, and we are now represented by over circa 13,000 employees across 112 offices worldwide.Your career with us should reflect your energy and passion.

That’s why, at Apex Group, we will do more than simply ‘empower’ you. We will work to supercharge your unique skills and experience.

Take the lead and we’ll give you the support you need to be at the top of your game. And we offer you the freedom to be a positive disrupter and turn big ideas into bold, industry-changing realities.

For our business, for clients, and for you

Responsibilities:

• Collaborate with business stakeholders, internal and external, to gather and analyze data requirements, understanding business processes and objectives.
• Design, develop, and maintain end-to-end data models and ETL processes to support business reporting and analytics needs.
• Utilise industry-standard methodologies and tools to design and implement conceptual, logical, and physical data models.
• Leverage cloud technologies to build scalable and flexible data solutions.
• Optimize data models and queries for performance and efficiency, considering factors like database architecture and query optimization techniques.
• Work closely with data engineering and data architecture teams to implement data models and ensure seamless integration into existing systems.
• Provide expertise and guidance on database design, data warehousing, and BI best practices.
• Collaborate with data governance teams to ensure compliance with data standards, quality, security, and privacy regulations.
• Perform data analysis and visualization to identify trends, patterns, and insights for business stakeholders.
• Stay updated with the latest trends and advancements in BI technologies and methodologies.
• Resolve Service Now tickets for Power BI Infrastructure/Administration tasks
• Perform peer code reviews

Requirements:

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Proven experience as a BI Engineer, Data Modeler, or similar role.
• Strong proficiency in SQL and experience with relational databases such as SQL Server, and Snowflake (preferred).
• Experience designing and implementing data models with DBT.
• Comfortable using Github for version control.
• Hands-on experience with cloud technologies (AWS, Azure) and familiarity with data warehousing concepts.
• Solid understanding of ETL processes, data integration, and data quality management.
• Strong analytical and problem-solving skills with a keen attention to detail.
• Excellent communication and collaboration skills, with the ability to work effectively in a team environment.
• Ability to prioritize tasks effectively and work in a fast-paced, dynamic environment.
• Financial services domain knowledge highly desirable, particularly regarding funds and accounting systems.

Disclaimer: Unsolicited CVs sent to Apex (Talent Acquisition Team or Hiring Managers) by recruitment agencies will not be accepted for this position. Apex operates a direct sourcing model and where agency assistance is required, the Talent Acquisition team will engage directly with our exclusive recruitment partners.

Experience Level

Senior Level