Position Overview

Responsible for managing and optimizing data systems using Microsoft SQL, Python and BI tools to

deliver scalable, automated BI solutions. The role involves designing data models, maintaining

reporting infrastructure, and translating business needs into actionable insights. Collaborates with

cross-functional teams to support decision-making through efficient data delivery and analysis.

Key Responsibilities

(may perform other duties as requested, not specifically addressed in this document)

 Design, develop, and maintain ETLs, stored procedures, and database objects to support

reporting and data analysis.

 Build and manage scalable data solutions across multiple platforms, ensuring data integrity and

performance.

 Collaborate with business stakeholders to gather requirements and deliver actionable BI

solutions using SQL and Power BI.

 Translate business needs into technical specifications for data warehouse design and reporting

automation.

 Monitor and optimize data processes, automation, and reporting cycles to improve efficiency

and accuracy.

 Maintain ticketing systems and ensure timely resolution of data-related requests in line with

SLAs.

 Support continuous improvement initiatives by analyzing trends, identifying opportunities, and

contributing to PSP/DMAIC sessions.

 Participate in agile teams, cross-functional meetings, and change management efforts to

ensure smooth data operations.

 Promote BI adoption and knowledge sharing across departments, acting as a strategic liaison

between business and data teams.

 Demonstrates strong collaboration skills and readily offers mentorship and support to team

members when needed.

Required Qualifications Education and specific Training

 Bachelor's degree (or in progress) in Computer Science, Data Science, Engineering, or a related

technical field.

 Strong proficiency in MS SQL Server (2016+), including SQL Server Data Tools, query

optimization, and indexing.

 Solid understanding of data architecture, database management (SQL/NoSQL), and cloud

platforms (e.g., AWS, Azure).

Work Experience

 5 years and above experience in database analysis, reporting, and BI development using SQL,

Power BI, and Excel, preferably in a call center or WFM environment.

 Strong hands-on experience with Microsoft SQL Server and data modeling concepts (e.g.,

star/snowflake schema, OLAP).

 Proficient in Microsoft Office; working knowledge of PowerApps and Flow is a plus.

 Practical experience with Python for data manipulation and automation.

Soft Skills & Other Requirements Technical Skills

Required:

 Advanced proficiency in Microsoft SQL Server, SSMS, and Power BI (including DAX).

 Experience with Python for data processing and automation.

 Solid understanding of data modeling (e.g., star/snowflake schema, OLAP) and statistical

analysis.

 Strong communication skills and proficiency in English.

Desirable:

 Experience with SSIS and SSAS.

 Knowledge of cloud data tools such as Azure Data Factory, Databricks, Google BigQuery, and

DevOps.

 Understanding of RPA fundamentals.

 Experience with Visual Basic, Macros, PowerApps, and Flow.

Competencies and specific skills

• Analytical Ability

• Achievement Orientation

• Communication Skills

• Continuous Improvement Mindset

• Customer Orientation

• Initiative Customer

• Interpersonal Skills

• Learning Abilities

• Planning and Organization

• Problem Solving

• Management Capability

• Teamwork

Decision Making Authority

(Describe the authority permitted by the job by indicating examples that illustrate the types

of independent decisions expected by the incumbent and the types of decisions expected to

be recommended.)

Decisions Expected

• Extraction Data Flow Designs alongside DWH.

• Optimal Query Designs.

• Process Design & Implementation for Data Solutions geared towards the necessity of their

Operations teams & Implementation of new Clients.

Recommendations Expected

• Optimal reporting options for internal operations.

• SQL Performance improvement suggestions.

• Internal BI & Data Manager Standard Operating Procedure Optimization.

Business Intelligence Analyst II