Scotiabank

Manager, ETL BP & DS

Scotiabank$90K — $120K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Proficiency in SQL and experience with relational databases
  • Experience with data modeling, ETL processes, and data warehousing
  • Proven experience as a Power BI Developer or similar role
  • Strong proficiency in Power BI, including DAX and Power Query
  • Excellent analytical and problem-solving skills
  • Strong communication and collaboration skills
  • Ability to work independently and manage multiple projects simultaneously

Responsibilities

  • Design and develop interactive dashboards and reports using Power BI
  • Create and maintain data models to support reporting and analytics needs
  • Develop and manage ETL processes to ensure accurate data loading
  • Perform data analysis to identify trends and insights for decision-making
  • Work with business stakeholders to gather requirements for BI solutions
  • Optimize Power BI reports and internal processes for performance and usability
  • Document BI solutions including data models and report specifications

Benefits

  • Opportunity to join a forward-thinking company with a collaborative team
  • Diverse opportunities for professional development
  • Internal development programs to enhance skills
  • Competitive compensation and benefits package
  • Commitment to making a difference in the communities served
  • Inclusive work environment that encourages creativity and celebrates success
Full Job Description
Requisition ID: 265795

Purpose

We are seeking a skilled Power BI/MSSQL Developer to join our team. The ideal candidate will be responsible for designing, developing, and maintaining business intelligence solutions using Microsoft Power BI and MSSQL database. This role involves working closely with business stakeholders to understand their data needs and collaborate with the team in data modeling and programming activities to produce actionable insights through interactive dashboards and reports.

Is this role right for you? In this role you will:
  • Data Visualization: Design and develop interactive dashboards and reports using Power BI
  • Data Modeling: Create and maintain data models to support reporting and analytics needs
  • ETL Processes: Develop and manage ETL processes to ensure data is accurately and efficiently loaded into the BI system
  • Data Analysis: Perform data analysis to identify trends, patterns, and insights that support business decision-making
  • Collaboration: Work with business stakeholders to gather requirements and ensure BI solutions meet their needs
  • Performance Optimization: Optimize Power BI reports, internal processes and programs for performance and usability
  • Documentation: Document BI solutions, including data models, ETL processes, and report specifications
  • Training and Support: Provide training and support to end-users on Power BI tools and reports
  • Data Governance: Ensure data accuracy, integrity, and security within the BI environment


Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:
  • Proficiency in SQL and experience with relational databases
  • Experience with data modeling, ETL processes, and data warehousing
  • Proven experience as a Power BI Developer or similar role
  • Strong proficiency in Power BI, including DAX and Power Query
  • Excellent analytical and problem-solving skills
  • Strong communication and collaboration skills
  • Ability to work independently and manage multiple projects simultaneously
  • Knowledge of data governance and best practices for data security
  • Preferred Qualifications:
    • Experience with other Reporting tools (e.g., Report builder) is a plus
    • Familiarity with cloud platforms (e.g., Azure, AWS) and their BI services
    • Certification in Power BI or related technologies
    • Proficiency in Spanish is an asset


What's in it for you?
  • The opportunity to join a forward-thinking company surrounded by a collaborative team of innovative thinkers.
  • A rewarding career path with diverse opportunities for professional development.
  • Internal development to support your growth and enhance your skills.
  • A competitive compensation and benefits package.
  • An organization committed to making a difference in our communities- for you and our customers.
  • We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!


Location(s): Canada : Ontario : Toronto

About Scotiabank

Scotiabankers are committed to helping individuals, companies, and communities to thrive in a changing world. From personal and business banking, brokerage, and insurance, to private wealth, and the most sophisticated commercial, corporate and institutional services, they serve the diverse needs of some 21 million customers in more than 55 countries. Founded in 1832 in Halifax, Nova Scotia, their growth has always been fuelled by the success of their customers and their longevity secured by an unshakable commitment to carefully and expertly managing risk and capital. That focus on doing what's right for customers—short- andlong-term—has made us a global financial services leader. Headquartered in Canada, they are over 86, 000 Scotiabankers strong. Each of us are committed to being the best at understanding their customers' needs and all of us working together to deliver practical advice and relevant solutions that help their customers become financially better off.

Scotiabank Careers

Join Scotiabank, a premier financial institution, and become part of a diverse and inclusive team that’s leading the way in global banking. At Scotiabank, we offer more than just job opportunities; we provide a platform for professional growth and innovation in the financial services industry.

Work You’ll Do

At Scotiabank, we’re not just filling positions; we’re cultivating leaders. Dive into a workplace where diversity training and leadership development shape the path to your future. Our commitment to professional growth is evident in our robust training programs and continuous learning opportunities that foster innovation and strategic thinking.

Explore a World of Opportunities

Whether you’re looking for a full-time position, an internship, or a leadership role, Scotiabank has a spectrum of opportunities to fit your career ambitions. Our team is composed of individuals who bring a wealth of skills and perspectives to our company, driving us forward with their creativity and strategic insights.

Innovative Work Environment

Scotiabank’s culture is one of collaboration and respect, where each team member’s contribution is valued. Engage in meaningful work that challenges you to leverage your skills and push the boundaries of what’s possible in the banking sector. Our innovative projects not only support the growth of the company but also ensure our position as a leader in the industry.

Benefits and Growth

Choosing a career at Scotiabank means opting for a life of growth and opportunity. Our employees enjoy competitive benefits, including comprehensive health coverage, retirement plans, and flexible working conditions, all designed to support your career and personal life. We believe in nurturing our team’s potential by providing them with the tools they need to succeed both professionally and personally.

Join Our Team

Ready to take the next step in your career? Explore the job opportunities at Scotiabank by searching our open positions that match your skills and interests. We are continuously hiring and looking for passionate, curious, and solution-driven team players.

Networking and Professional Development

Stay connected and advance your career through Scotiabank’s extensive networking opportunities. Participate in events that connect you with other professionals and leaders within the industry. Our career resources will help you prepare your resume, ace your interviews, and land the job that best suits your career goals.

Stay Ahead

Keep up to date with the latest in career tips, industry insights, and company news—all from the people who work here at Scotiabank. Personalize your experience by subscribing to job alert emails tailored to your preferences and be the first to know about new openings and exciting developments. Join Scotiabank and be part of a team that values integrity, respect, and accountability. Discover how your career can flourish in an environment committed to your professional development and personal growth.
Learn more about Scotiabank
Size
90,619 employees
Market Cap
$57.5 billion
Industry
5 Year Trend
+7%
NASDAQ

Similar Jobs

More Jobs at Scotiabank

More Information Technology Jobs

Find similar Manager, ETL BP & DS jobs: