Senior enterprise data analyst

Posting Title Senior Enterprise Data Analyst
Department: Corporate Services & Transformation
Full/Part Time: Full Time
Job Type: Permanent
Location: Vancouver
Work Arrangement: Hybrid
Salary Range: $85,313.00 - $132,830.00
Close Date: 04/18/2024

Job Summary
BC Financial Services Authority (“BCFSA”) helps to protect British Columbians during the biggest financial decisions in their lives. We regulate B.C. ’s financial services sector, including credit unions, real estate licensees, registered pension plans, insurance and trust companies and mortgage brokers. Through modern, effective and efficient oversight, BCFSA protects consumers by impartially setting and enforcing standards across the entire sector ensuring the prosperity of the province.
BCFSA is an equal opportunity employer and welcomes applications from all groups. This includes Indigenous Peoples, women, visible minorities, persons with disabilities, persons of diverse sexual orientation, gender identity or expression (LGBTQ2S+), and others who may contribute to diversity at BCFSA.
We recognize unique styles, perspectives, beliefs, and creativity that support a diverse, respectful, inclusive and collaborative work environment. To achieve this, we are committed to:

• Hiring team members who represent the population we serve;
• Removing barriers that may prevent equitable employment; and
• Supporting respectful work environments where everyone feels included and able to produce excellent results.

BCFSA is proud to be Great Place to Work Certified™. This is based on direct feedback from our Team Members. Our organization has also been selected as one of BC's Top Employers (2023) in recognition of our competitive compensation, work-life balance, and progressive programs.

WHAT WE OFFER:
When you join us, you become part of a high-performing team. Here, each Team Member can bring their unique talent to make outstanding contributions as we work towards the common goal of protecting British Columbians during the most important financial transactions in their lives. We offer:

• Healthy living and work-life balance
• Comprehensive health and wellness benefits plan
• Opportunities for personal and professional development
• Competitive compensation
• A challenging and engaging team environment
• Defined benefits pension plan which provides guaranteed income for life
• Flexible work arrangement for eligible positions
• Our team members enjoy the flexibility of a hybrid work model. They can choose every day where they want to work to be the most effective, from the comfort of their home to our beautiful office in downtown Vancouver. (Eligibility may vary, depending on position).

SUMMARY
This is a senior technical role that intersects with data analysis, data engineering, and data modeling domains. The senior data analyst works as a subject matter expert alongside engineers, modelers, and business executives to gather and transform data, build and maintain data pipelines, conduct statistical analyses, and create visualizations and reports that will contribute to identifying trends, patterns, and opportunities that drive business initiatives. The role’s expertise will extend to collaborating across teams, integrating data from diverse sources, and contributing to the data analytics and reporting capabilities.

COMPETENCIES

• People Development

o Provides feedback and coaching, rewards hard work and risk taking, takes mentoring role, challenges, and develops employees, accepts mistakes, provides visibility/opportunity.

• Communicating Effectively

o Expresses ideas and information in a clear and concise manner; tailors’ message to fit the interests and needs of the audience; delivers information in a manner that is interesting and compelling to the listener.

• Serving Stakeholders

o Builds strong relationships with internal & external stakeholders; stays aware of their needs, concerns, and satisfaction; responds promptly to their questions and requests; effectively manages stakeholders’ expectations.

• Delivering High Quality Work

o Critically reviews work processes to ensure quality; addresses problems that could impact quality; makes sure project deliverables and services meet all requirements and expectations; does not make the same mistakes twice.

• Critical Thinking

o Skilled at finding logical flaws in arguments and plans; identifies problems and solutions that others might miss; provides detailed insight and constructive criticism into problems and complex situations.

• Acting as a Champion for Change

o Challenges the status quo; encourages people to question existing methods, practices, and assumptions; supports people in their efforts to try new things.

• Strategic Thinking/Management

o Creates and communicates a long-term vision, balances short- and long-term goals, keeps own and team's work aligned with overall goals, understands the market, and can predict change, understands the industry and the competition, creates, and adjusts strategic plans.

ACCOUNTABILITIES

• Apply analytical techniques to uncover trends, patterns, and anomalies within large datasets, transforming raw data into meaningful insights.
• Build and operationalize complex data solutions, correct problems, apply transformations, and recommend data cleansing/quality solutions.
• Design, create, and implement logical and physical data models for both IT and business solutions to capture the structure, relationships, and constraints of relevant datasets.
• Assist business function stakeholders in forecasting through predictive models, aiding businesses in future planning, and ensuring stakeholders can make data-driven decisions based on thorough data analysis.
• Assist the Data Engineer in building and maintaining robust data pipelines and supporting extract, transform, and load (ETL) processes.
• Collaborate cross-functionally to comprehend departmental objectives, delivering impactful recommendations tailored to essential metrics and KPIs.
• Assist in modeling, designing, and implementing data visualization tools such as Power BI to enhance data analytics and reporting capabilities.
• Effectively collaborate and communicate with various stakeholders to understand data and business requirements and translate them into data models.
• Create entity-relationship diagrams (ERDs), data flow diagrams, and other visualization tools to represent data models.
• Contribute actively to knowledge-sharing initiatives among colleagues, promote best practices and continuous improvement culture, and lead the community of practice.
• Work closely with Data Stewards and key stakeholders from several business functions to understand business domain knowledge and deliver meaningful insights.
• Collaborate with the Senior Data Governance Analyst to ensure that data governance policies are effectively implemented, providing expertise on data quality, security, and compliance measures for comprehensive data governance strategies.
• Engage in regular cross-functional meetings with the key IM&T and line of business resources to align data analytics efforts with the organization's overall data strategy and data management objectives, promoting a holistic and well-coordinated approach to data initiatives (e.g., self-serve analytics, advanced analytics).

JOB REQUIREMENTS

• 5 years of experience in a related role, demonstrating a progressive increase in responsibilities and accomplishments.
• Expertise and hands-on experience in cloud analytics platforms preferably Microsoft Azure Synapse, Data Factory, Data Flow, GIT repository, and Data Bricks.
• Expertise the various data analysis tools (e.g., Excel, Power BI)
• Experience with Python Programming in Jupyter Notebooks and using Python data libraries such as NumPy, Pandas).
• Strong analytical and statistical mindset with a keen attention to detail and the ability to derive insights from complex datasets.
• Expertise in SQL and experience working with relational databases.
• Expertise in data modeling and data warehousing concepts.
• Experience in AI, machine learning, natural language processing, or other related fields.
• Strong problem-solving and analytical skills required to understand the requirements of both business and technology stakeholders.
• Excellent verbal and written communication skills allowing clear articulations when conveying conclusions drawn from analyzed information.
• Familiarity with financial services industry regulations and compliance requirements is an asset.

EDUCATION

• Bachelor’s degree in Commerce, Statistics, Computer Science, Information Management or related fields in data science, data management, and data analytics.

PROVISOS
Candidates must be eligible to work in Canada and living in British Columbia or intent to settle in the province.
Internal candidates are kindly requested to use their BCFSA email address when applying for this position. This will help us identify and streamline the internal application process.

Hiring Process Accommodation
BCFSA wants to ensure every job applicant is treated fairly and with respect and encourages applications from all candidates, including those with diverse abilities. We welcome you to inform us confidentially if you may require any special support in the application process, including disability accommodation, in order to participate fully in our recruitment experience. Email us at to notify us of any needs related to your job application.