Software Engineer Associate Power BI

Job description

Software Engineer Associate Power BI

Requisition ID: 229620

Thanks for your interest in ScotiaTech, Scotiabank's new and innovative Technology hub in Bogota.

Join a purpose driven winning team that promotes creativity and innovation in a fast-paced environment, where we’re always committed to results, in an inclusive, diverse, and high-performing culture.

**_Purpose_**

Contributes to the overall success of the _Global Human Resources Technology_ / Solution Architecture & Engineering in Colombia and Canada ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team’s business strategies and objectives.

Ensures all activities conducted are in compliance with governing regulations, internal policies and procedures.

**Accountabilities**

+ Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.

+ Participate in the development and support of cost effective and efficient applications or prototypes of low to medium complexity according to standards to meet the demands of the high availability, complex, on-line transaction processing environment.

This involves participating in the system design, developing the required programs, performing unit testing and participating in the integrated system tests.

+ Collaborate with business stakeholders and technical teams to gather requirements and deliver solutions.

+ Ensure data accuracy, performance, and compliance with governance standards.

+ Provide production and user acceptance testing application support to assigned applications by identifying, evaluating and resolving problems of low to medium complexity and escalating to management as per documented procedures.

+ Participate in the implementation of new systems or enhancements by running required conversion programs, performing shakedown testing of the production environments, preparing the Change Control Release documentation and running the parallel test cycles.

+ Keep current on rapidly changing technological trends, self-teach new technologies and maintain a broad understanding of the Division's business and technology strategies.

+ Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.

+ Actively pursues effective and efficient operations of his/her respective areas in accordance with Scotiabank’s Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.

+ Champions a high-performance environment and contributes to an inclusive work environment.

**Dimensions**

The Developer will focus on designing, developing, and supporting business intelligence solutions within a Microsoft-centric environment.

You will be part of a collaborative Agile team that includes Data Engineers, BI Architects, Business Analysts, and QA professionals.

This role involves working across the BI development lifecycle - from data modeling to dashboard creation and performance optimization-primarily using Power BI and SSAS (Tabular and/or Multidimensional).

To succeed in this role, you should have a strong foundation in data modeling, DAX, and SQL, along with experience working in enterprise environments that leverage Active Directory and JIRA.

Your ability to translate business requirements into scalable, insightful analytics solutions will be key to supporting decision-making across Global HR Technology.

**Education / Experience / Other Information (include only those that are specific to the role)**

+ Bachelor’s degree in computer science, Information Systems, or a related field (Nice to have).
+ 2–3 years of hands-on experience with the Microsoft BI Stack, including SQL Server, SSAS (Tabular and Multidimensional), SSRS, and Power BI.

(Must)
+ Proven experience in designing, developing, and optimizing data models using SQL Server Analysis Services (SSAS), with a strong focus on performance tuning and scalability.

(Must)
+ Strong proficiency in DAX, Row-Level Security (RLS), Power Query (M), and SQL for building robust and secure BI solutions.

(Must)
+ Familiarity with Power BI Service, including workspaces, dataflows, and semantic models.

(Must)
+ Experience working in Agile/Scrum environments.

(Nice to have)
+ Familiarity with Active Directory for access control and security.

(Nice to have)
+ Experience using JIRA for task and project management.

(Nice to have)
+ English level B1 or higher (spoken and written) to support Canadian stakeholders.

(Must)
+ Strong analytical and communication skills.

(Nice to have)
+ Knowledge of data governance, data quality, and metadata management (Nice to have)
+ Understanding of CI/CD practices for BI deployments is a plus.

#Li-Hybrid
#COLGBS

Location(s): Colombia : Bogota : Bogota

ScotiaTech is a business unit within ScotiaGBS, a Scotiabank Group company located in Bogota, Colombia.

The ScotiaTech hub was created to support different technology systems and processes of the Bank.

We offer an inclusive, positive work environment, and competitive benefits.

At ScotiaTech, we value the unique skills and experiences each individual brings and are committed to creating and maintaining an inclusive and accessible environment for everyone.

Candidates must apply directly online to be considered for this role.

We thank all applicants for their interest in a career at ScotiaTech; however, only those candidates who are selected for an interview will be contacted.

Required Skill Profession

Other General