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.
