Business Intelligence Developer II

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