Compliance Analyst supporting regulatory compliance and risk management in Canadian wealth management. Analyzing data and collaborating with business units to uphold compliance standards.
EX
Hybrid Associate Business Analyst, Data Management and Analytics – Data Ops/Data Analyst
Posted 5 months ago
About the role
- Data analyst role focusing on interactive reports and dashboards in an analytics team. Requires extensive experience in PowerBI, SQL, and reporting tools in insurance and reserving.
Responsibilities
- Designing interactive reports and dashboards using PowerBI/SSRS or excel integrating MS Access Database
- Writing complex DAX expressions for custom measures and calculations, use MS Access forms, macros, modules (including VBA automations) for further custom report generation
- Configuring scheduled data refresh and Power BI Gateways, Implementing Row Level Security
- Connecting to various data sources (SQL Server, ODBC, Excel, APIs, etc.) for data extraction from relational databases and external sources
- Create, modify and test various SQL queries, Access/VBA Macros, Stored procedures and views for obtaining data from diverse source systems and platforms
- Leverage SQL/SSIS code as part of an ETL process to support report development on PowerBI or help support with necessary enhancement
- Develop stored procedures functions using T-SQL/SQL to automate report refresh or data views
- Excellent verbal and written communication skills including demonstrated ability to effectively and professionally communicate with others, including situations where you may disagree with people
Requirements
- Bachelor’s/Master's degree in economics, mathematics, computer science/engineering, operations research or related analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to apply
- 5+ years in analytics (Preferably with Insurance and Reserving)
- Must have experience in reporting tools like MS Access, VBA, PBI and good advance SQL skills
- Must have experience in using ETL tools like SSIS or Azure etc.
- Good to have experience in SSRS, Excel , SSAS
- Good critical thinking and problem solving skills
- Strong record of achievement, solid analytical ability, and an entrepreneurial hands-on approach to work
- Outstanding written and verbal communication skills, and presentation skills
- Able to work in fast pace continuously evolving environment and ready to take up uphill challenges
- Is able to understand cross cultural differences and can work with clients across the globe
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Senior Quantitative Analyst in the Market Risk team at Central 1, maintaining market data integrity and leading risk analysis. Collaborating with teams to ensure compliance and informed decision - making.
Senior Data Analyst developing analytics solutions using Power BI for Bird construction. Partnering with teams to enable a data - driven culture and deliver actionable insights.
Working student supporting HR Data Analytics & Reporting initiatives at Schaeffler. Involves research, development of communication materials, and team collaboration.
Data Analyst at Sicredi improving financial and social development insights through data analysis and programming tools. Collaborating with various teams to optimize processes and products.
Data Analyst optimizing online products for user needs and improving conversion rates at Prima. Collaborating with stakeholders and analyzing customer behavior to identify opportunities.
Quantitative Data Analyst verifying models used in measuring credit risk. Collaborating within SEB's professional team in Vilnius and driving innovation in validation processes.
Senior Data Analyst driving analytics in transformation initiatives at Preply, shaping business models and uncovering growth opportunities through data insights.
Pro Bono Analytics Specialist at Cooley overseeing pro bono data analysis and producing reports. Collaborating with teams to enhance management of pro bono and social impact practices.
Sales Operations Reporting & Analytics Specialist creating reports and dashboards for Springer Nature. Collaborating across teams to deliver operational improvements in the academic publishing industry.