BI Engineer III
Description
Job Description
Role: BI Engineer
Department: Data Office
Reporting to:
Location:
About Apex
Apex Group Ltd., established in Bermuda in 2003, is a global financial services provider. With over 80 offices in 70 countries worldwide and more than 12,000 employees, Apex Group delivers an expansive range of services to asset managers, financial institutions, private clients and family offices. The Group has continually improved and evolved its capabilities to offer a single-source solution through establishing the broadest range of services in the industry; including fund services, digital onboarding and bank accounts, depositary, custody, super ManCo services, corporate services including HR and Payroll and a pioneering ESG Ratings and Advisory solution. Apex Group’s purpose is to be more than just a financial services provider and is committed to driving positive change to address three core areas; the Environment and Climate Change, Women’s Empowerment and Economic Independence, Education and Social Mobility.
Life at Apex isn't just about the work you do, it's about embracing the culture and loving what you do. Every employee plays a part in making Apex who we are today and the more that we grow, the more important that becomes. Whatever your career path or specialism Apex ensures it rewards loyal and dedicated employees. The international nature of our business and global network of offices means that there are opportunities to broaden your life experiences and take both short-term or permanent relocation options.
Job Specification
We are seeking a highly skilled and detail-oriented BI Engineer to join our dynamic team. As a BI Engineer, you will be responsible for designing, creating, and maintaining data models that accurately represent the organization's data assets. You will work closely with business analysts, database administrators, and other stakeholders to understand data requirements and translate them into efficient and scalable data models.
Responsibilities:
- Collaborate with business stakeholders to gather and analyse 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 such as AWS and Azure 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 database administrators and development 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, 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.
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, Oracle, and Snowflake.
- Experience designing and implementing data models using tools like Erwin Data Modeler or similar.
- 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.
Join our dynamic team and drive innovation through data-driven insights!
What you will get in return:
A genuinely unique opportunity to be part of an expanding large global business. Joining Apex Group will provide you with a platform for professional and personal success and an environment where you can truly make an impact.
Our people are our greatest asset and we believe learning is central to developing talent, nurturing strong leaders, fostering a supportive company culture and ultimately drives our success.