Senior Business Intelligence Developer

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

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.

Actively supports team development by providing guidance, feedback, and growth opportunities, while ensuring alignment with strategic goals

Leads by example, fostering a high-performance culture through clear direction, accountability, and empowerment.

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

7 years of 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.

Previous team leadership experience is desirable.

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.