Business Intelligence Developer

About the Company

We are a privately held global manufacturing company seeking a talented and motivated Business Intelligence (BI) Developer to join our team. This role is central to supporting and enhancing our reporting and analytics capabilities using Microsoft BI tools. You will work closely with end users to gather requirements, design and build dashboards and reports, and ensure data quality and performance. This is a hands-on role for someone with strong technical skills, effective communication abilities, and business acumen. Approximately 80% of your time will be focused on developing BI solutions and collaborating with users, while the remaining 20% will be spent managing and tuning our SQL environment to ensure optimal performance.

About the Role

This role is central to supporting and enhancing our reporting and analytics capabilities using Microsoft BI tools.

Responsibilities

• Collaborate with business users to gather reporting and analytics requirements.
• Design prototypes of dashboards and reports.
• Develop, deploy, and support reports and dashboards using tools such as Power BI, SSRS, and Excel.
• Write, optimize, and maintain complex SQL queries and stored procedures.
• Build and manage ETL processes using Microsoft tools (e.g., SSIS).
• Monitor and maintain the SQL environment to ensure performance, availability, and reliability.
• Support the companys migration and adoption of Microsoft Azure BI services.
• Test, validate, and troubleshoot BI solutions to ensure accuracy and performance.
• Train and support users in accessing and interpreting BI tools and dashboards.

Qualifications

• Bachelors degree in computer science, Information Systems, or a related field.
• 48 years of experience in a BI development role.

Required Skills

• Strong experience with Microsoft BI stack (SSRS, SSIS, Power BI).
• Proficiency in SQL Server and T-SQL query development.
• Experience in creating dashboards, KPIs, and data visualizations in Power BI.
• Familiarity with data modeling concepts and practices (star schema, snowflake schema).
• Exposure to Microsoft Azure BI tools (Microsoft Fabric, Data Factory, Synapse, Azure SQL, etc.) is a plus.
• Strong problem-solving and analytical skills.
• Excellent written and verbal communication skills.
• Ability to work independently and interface directly with end users and business stakeholders.

Preferred Skills

• Experience in a manufacturing or supply chain environment.
• Experience with performance tuning in SQL environments.
• Understanding of data governance and security best practices.