Senior SQL Developer

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

JobSpecification

•Design and architect end-to-end data warehouse solutions using modern data
platforms
•Define data models (star/snowflake schema), data marts, and OLAP structures
•Create and manage ETL pipelines to ingest data from various sources (structured,
semi-structured)
•Collaborate with business and data teams to translate requirements into scalable
data architecture
•Ensure data quality, governance, security, and compliance standards are met
•Optimize data storage and query performance for analytical workloads
•Develop data strategy and roadmap aligned with business objectives
•Guide and mentor data engineering teams on best practices
•Strong experience with data warehousing concepts, architecture, and best
practices
•Expertise in dimensional modeling, data lakes, and data marts
•Hands-on experience with one or more cloud platforms
•Proficiency with ETL tools
•Excellent SQL and performance tuning skills
•Familiarity with DevOps, CI/CD for data pipelines, and version control (Git)
•Strong understanding of data governance, cataloging, and security
•Experience with BI tools (Power BI, Tableau, etc.) is a plus
SkillsRequired

•Tools & Technologies Cloud Platform : Azure (Data Bricks, DevOps, Data factory,
azure synapse Analytics, Azure SQL, blob storage, Databricks Delta Lake)
•Languages: Python/PL/SQL/MS SQL
•Databases: Snowflake/ MS SQL Server/Oracle
•Design Tools: Erwin & MS Visio.
•Data warehouse tools: SSIS, SSRS, SSAS. Power Bi, DBT, Talend Stitch, PowerApps,
Informatica 9,
•Cloud experience is preferred

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.