Job Description
Role:BI Developer
Department: Business Intelligence and Reporting
Reporting to: Global Head of Business Intelligence and Reporting
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 client 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.
Apex Group is a leading global financial services organization with a commitment to delivering exceptional solutions to our clients. We are seeking a talented and motivated BI Developer to join our team and play a crucial role in transforming data into actionable insights using Power BI, Tableau, and Snowflake.
As a BI Developer at Apex Group, you will be responsible for designing, developing, and maintaining cutting-edge BI solutions using Power BI and Tableau, while leveraging Snowflake as the data warehousing platform. You will collaborate with cross-functional teams to gather requirements, design data models, create engaging visualizations, and deliver valuable insights to drive informed business decisions.
- Responsibilities:**
- **BI Solution Development:**
- Design, develop, and deploy interactive dashboards, reports, and visualizations using Power BI and Tableau.
- Utilize Snowflake as the data source to ensure accurate, up-to-date, and well-structured data for reporting.
- **Data Modeling and Integration:**
- Develop and maintain data models in Snowflake to support business reporting requirements.
- Collaborate with data engineers to ensure seamless data integration from various sources into Snowflake.
- **Requirements Gathering:**
- Collaborate closely with business stakeholders to understand their reporting needs and translate them into actionable BI solutions.
- Provide insights on best practices for data visualization and reporting based on industry standards.
- **Performance Optimization:**
- Optimize query performance and report loading times to ensure a seamless user experience.
- Identify and resolve data quality and performance issues in collaboration with data engineering teams.
- **Data Governance and Security:**
- Implement data governance practices to maintain data accuracy, security, and compliance within BI solutions.
- Ensure adherence to data privacy regulations and policies.
- **BI Tool Expertise:**
- Stay up-to-date with the latest features and capabilities of Power BI, Tableau, and Snowflake.
- Provide guidance on tool selection and best practices for BI development.
- **Documentation and Training:**
- Document BI solutions, data models, and processes to ensure knowledge sharing and maintainability.
- Conduct training sessions to educate end-users on how to use and interpret BI reports.
- Qualifications And Skills:**
- Bachelor's degree in Computer Science, Information Technology, or related field.
- Proven experience as a BI Developer using Power BI and Tableau.
- Familiarity with Snowflake data warehousing and integration.
- Strong proficiency in SQL for data extraction and manipulation.
- Experience with data modeling, ETL processes, and data integration.
- Ability to create compelling visualizations that communicate complex data effectively.
- Excellent problem-solving skills and attention to detail.
- Effective communication and collaboration skills.
- Preferred:**
- Familiarity with financial services industry regulations and compliance.
- Exposure to cloud-based BI solutions and services.
- Knowledge of other BI tools and data visualization libraries.
- Certification in Power BI, Tableau, or Snowflake.
**Join Apex Group and contribute to our mission of delivering excellence in the global financial services industry. As a BI Developer, you'll have the opportunity to shape data-driven insights that inform strategic decisions, enhance client experiences, and drive our organization's growth. Be part of a dynamic team that leverages Power BI, Tableau, and Snowflake to transform data into valuable assets for our clients and stakeholders.**
Job Specification
We are seeking a highly accomplished and visionary Principal Business Intelligence Developer to join our team in a key hands-on leadership role. As a Principal BI Developer, you will be responsible for the BI and Reporting solutions of a part of our global business, lead and mentor a team of BI Developers, and collaborate with cross-functional stakeholders to deliver innovative data-driven solutions. You will leverage your deep expertise in BI and Reporting to guide the development and implementation of cutting-edge data marts, dashboards and reporting solutions. If you are a seasoned BI practitioner with exceptional BI architecture and leadership skills and a proven track record of driving impactful data initiatives, we want to hear from you.
Responsibilities:
- Hands-on technical ownership of a set of BI and Reporting solutions, including reports, data marts and dashboards, for a part of Apex's global business. This includes responsibility for the build, run and maintain of these solutions.
- Ensure that BI and Reporting solutions meet performance and security requirements and that outputs are delivered within the defined SLA's.
- Management of and mentorship of a team of BI Developers, fostering their growth, providing technical guidance, and ensuring the team's continued professional development.
- Model Apex values to your team and ensure that they complete all Apex's mandatory training requirement and comply with all Apex policies and processes.
- Ensure that the team follows best practices for software development, including version control, coding standards, and testing methodologies.
- Stay at the forefront of the latest advancements in BI & Reporting and guide the team in adopting the most suitable methodologies and techniques in a way that integrates with the rest of the Apex Group and its Unified Data Platform.
- Communicate status, risks, and issues to both the Global Head of Business Intelligence and Reporting and key business stakeholders.
- Build a trusted advisor relationship with your executive and senior management where you understand their business needs and provide technical solutions. You will also present complex findings, insights, and technical concepts in a clear and compelling manner, influencing data-driven decision-making at the highest levels of the organization.
- Collaborate closely with cross-functional teams, including business stakeholders, data engineers, and IT teams, to identify requirements and their potential solutions.
- Membership in the BI and Reporting Design Authority that defines standards, provides technical governance and oversight, and acts as brains trust for our solutions.
Requirements:
- Bachelor's degree in Information Systems or a related numerically orientated business field. A master's degree is a plus.
- Extensive experience (At least 10 years of experience) in Business Intelligence and Reporting, with a proven track record of delivering impactful solutions to complex business problems.
- Expertise in scripting languages, such as Python, R, or PowerShell, for both data manipulation and orchestration.
- Strong understanding of multiple BI and Reporting tools
- Extensive experience with SQL, preferably in multiple dialects (e.g. MS SQL Server, Oracle and Snowflake), and experience working with relational databases for data extraction and manipulation.
- Best in Class understanding of the principles behind data visualisation.
- Excellent problem-solving skills, with the ability to think critically, analyse complex data, and propose innovative solutions.
- Outstanding communication and leadership skills, with the ability to effectively convey technical concepts to both technical and non-technical stakeholders.
- Proven experience in leading and managing complex BI and Reporting solutions, projects and teams, ensuring successful outcomes, and fostering a culture of excellence.
- Strong strategic thinking and ability to drive the vision and roadmap for BI & Reporting initiatives, setting technical standards and guiding the adoption of emerging technologies
- Strong understanding of cloud security and data protection best practices.
- Strong understand of cloud-based data processing, data lakes, and serverless architectures.
- Active involvement in the BI community through publications, conferences, or open-source contributions.
- Expertise in SQL Performance optimisation and understanding of the principles behind SQL Optimizers.
- Familiarity with data governance, data privacy, and compliance frameworks (e.g., GDPR, CCPA).
- Familiarity with using REST API's to extract data from one or more cloud platforms (e.g. SalesForce, Workday)
- Experience with near-real time data warehousing, modelling and reporting.
- Familiarity with compiled applications, such as Java or C#.
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.
