Sr. Data Modeller/Business Analyst (Banking)
Would you like to leverage your data modelling expertise in a dynamic financial technology environment? Apply Now!
Working with one of our top financial clients, this role calls for a Sr. Data Modeller/ Business Analyst (Banking). This position involves supporting large-scale data initiatives within a data-driven equity markets environment, focusing on building scalable and efficient data structures for analytics and reporting across enterprise platforms.
Pay rate range (CAD): $75/hr – $80/hr
Responsibilities
- Design and develop Silver Layer tables and views to support analytics and reporting needs
- Build scalable data models supporting batch processing and future real-time use cases
- Collaborate with business analysts, data analysts, and technology teams to gather requirements and define data structures
- Perform data profiling, exploration, and analysis leveraging SQL and Python/PySpark
- Define data relationships, formats, and standards to enhance data consistency and usability
- Analyze large data sets to identify trends, anomalies, and actionable insights
- Optimize datasets for BI tools such as Power BI and real-time analytics platforms
- Support data ingestion initiatives by ensuring high-quality, reusable datasets for downstream applications
- Work within an Azure Databricks environment to support historical and real-time analytics
Desired Skill-Set
- 5+ years of experience in data analytics, data modelling, or business intelligence roles
- Proven hands-on relational data modelling experience, including designing table structures, relationships, and schemas
- Advanced proficiency in SQL
- Intermediate experience with Python, including PySpark for data profiling and exploration
- Strong ability to translate business needs into effective technical data solutions
- Deep understanding of data quality, profiling, and optimisation techniques
- Excellent cross-functional collaboration skills with technical and business stakeholders
- Degree in a quantitative discipline (e.g., Computer Science, Mathematics, Statistics, Engineering, Economics, Physics, Business)
Nice to Have
- Experience within Capital Markets or Equity Markets
- Hands-on experience with Azure Databricks platform
- Experience supporting real-time data platforms
- Familiarity with data modelling tools such as Erwin, Visio, or similar
- Knowledge of Power BI or other analytics visualization solutions
BeachHead is an equal opportunity agency and employer. We advocate for our candidates and welcome applicants regardless of race, color, religion, national origin, sex, age, or physical or mental disability. BeachHead or our clients may use technology-enabled tools, including automation and artificial intelligence (AI), to support parts of the recruitment process such as resume screening, application management, and candidate matching. These tools assist our recruiters and our clients, and do not replace human decision-making. This job posting represents a current or anticipated vacancy. The position may be filled at any time, and the posting may be removed without notice once the role has been filled.