PRINCIPAL RESPONSIBILITIES

Design, Development and enhancement of complex business reports under the supervision of Sr. data Analyst / Supervisor with high degree of accuracy and timeliness. Leverage different tools and technologies like SQL, Advanced Excel, VBA and BI reporting tools to develop reports for automation and distribution of reports. Migration of reports as the company adopts new technologies like Power BI, SQL etc.   40%

Develop SQL programs to load raw data from different databases, apply complex business logic and generate curated datasets to be used by business users for reporting and decision-making. Develop tools or interactive applications using VBA and advanced Excel to automate manual processes. 30%

Supporting complex business data analysis needs by understanding requirements and converting into technical deliverables. Leverage data warehouse and other data sources to answer business queries. 20%

Develop and maintain documentation for all processes including SOPs, Code inventory etc. 10%

Perform other duties, as assigned.  5%

MINIMUM REQUIREMENTS

EDUCATION:  Bachelor’s

FIELD OF STUDY:  Pass / Honours

KNOWLEDGE, SKILLS, ABILITIES, AND OTHER ATTRIBUTES:

• Knowledge of Reporting concepts and familiar with business reporting.
• Skills: – Advanced Excel, VBA, Power-BI & SQL

PREFERRED QUALIFICATIONS

EDUCATION:  Bachelor’s

FIELD OF STUDY:  Pass / Honours

EXPERIENCE:  Knowledge of advanced excel / Knowledge of SQL / Power-BI / VBA

KNOWLEDGE, SKILLS, ABILITIES, AND OTHER ATTRIBUTES:

• Excel (VBA) & SQL

What We Offer

We understand the important balance between work and life, fun and professionalism, and corporation verse community. We strive to support your career aspirations and provide the benefits you need to live a more fulfilling life.

Our compensation and benefits programs were created with an ‘Employee-First Approach’ focused on supporting, developing, and recognizing YOU.  We offer a wide array of wellness and mental health initiatives, support volunteerism, and environmental efforts, encourage employee education through leadership training, skill-building, and tuition reimbursements, and always strive to provide promotion opportunities from within.

All these things are just a small way to show our employees that we recognize their value, we understand what is important to them, and we reward their contributions.