Business Intelligence Developer

Position Summary:

Essential Job Functionsinclude, but are not limited to, the following:

• Business Requirements & Solution Development

  : Help gather requirements from users and utilize a software development life cycle (SDLC) to deliver a high-quality BI solution, such as Power BI dashboards and reports. Spend approximately 25–75% of time designing, developing, and implementing business intelligence solutions1. This includes ensuring that solutions meet user needs and adhere to best practices for data management and visualization.

• Project Estimation & Communication

  : Provide estimates for effort levels of IT development requests both before and after the requirements gathering process. Organize and manage communication with the user community, including setting clear expectations. Provide target due dates to customers for work in queue to ensure transparency and accountability in project delivery.

• Data Integration & Management:

  Integrate data from various sources (e.g., Microsoft SQL Server databases, files stored in SharePoint/OneDrive, and external systems via RESTful APIs) into the BI platforms. Ensure data is properly extracted, transformed (using tools like Power Query or ETL processes), and loaded for analysis. This function requires handling JSON data from APIs and maintaining data quality and consistency across all reports.

• Status Tracking & Documentation

  : Track and maintain the status of assigned open items in an organized fashion. Use project management or ticketing tools to document progress, and update stakeholders regularly. This includes keeping documentation of requirements, development notes, and user guides for BI solutions as needed, facilitating easier knowledge transfer and backup support.

• User Support & Training

  : Train people one-on-one on the proper use of BI systems and services (such as how to navigate Power BI reports or utilize self-service analytics features). Act as a customer-service-oriented resource by addressing user questions, aiding in data interpretation, and ensuring stakeholders are comfortable using the tools. Identify and train a backup(s) to manage key tasks when absent, thereby maintaining continuity of support.

• Quality Assurance & Troubleshooting

  : Conduct thorough testing and troubleshooting of BI applications and reports. This includes performing unit tests on data calculations (e.g., validating DAX formulas in Power BI) and verifying that visualizations accurately reflect the underlying data. Address and resolve user-reported issues or inconsistencies in a timely manner to maintain trust in the BI solutions’ reliability.

• Continuous Improvement & Additional Duties

  : Work on improving existing BI systems by evaluating their performance and user feedback, then implementing enhancements or optimizations (for example, refining data models for better performance). Continuously keep up-to-date with the latest Power BI features and industry best practices to introduce innovative solutions. Perform additional functions not specifically outlined in this position description as directed by the leader, demonstrating flexibility and a commitment to the team’s success.

Position Skills and Experience Requirements:

To perform this job successfully, an individual must be able to perform each essential duty effectively. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform essential job functions.

• Education

  : Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field. (An equivalent combination of education and experience may be considered.)

• Experience

  : A minimum of 5 years of experience in business intelligence development, data analysis, or a related role is expected for this senior-level position. This includes hands-on experience creating BI reports and dashboards and working with databases to support decision-making.

• BI & Microsoft Ecosystem Expertise

  : Extensive experience with Microsoft Power BI and the broader Microsoft environment (e.g., MS SQL Server, SharePoint, OneDrive) is required. The candidate should be adept at building complex Power BI reports and data models, writing SQL queries/stored procedures on SQL Server, and handling data files or libraries in SharePoint/OneDrive.

• Data Integration Skills

  : Familiarity with RESTful APIs and JSON is important for this role, as it enables integration of external data sources and web services into our BI solutions. The candidate should know how to retrieve and parse JSON data, and possibly use tools or scripts to call APIs for refreshing data.

• Technical Proficiency

  : Prior experience with development tools and frameworks used in developing BI solutions is expected. This may include ETL tools (for data import/export and transformation), version control systems, and other BI-related software. Experience with Microsoft’s BI stack (such as SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), or Analysis Services) is a plus, as is familiarity with scripting or programming languages for data manipulation.

• Customer Service & Communication

  : Strong customer service orientation with excellent communication and facilitation skills is required. The role involves translating complex data findings into insights that non-technical stakeholders can understand, so the ability to communicate clearly both in writing and verbally is critical.

• Analytical Mindset

  : Strong analytical and problem-solving skills are essential. The candidate should be capable of interpreting data to identify trends or anomalies and devising solutions to address business questions. A detail-oriented approach ensures accuracy in the reports and analyses produced.

• Collaboration & Adaptability

  : Ability to work independently and as part of a team is important. The Senior BI Developer must be self-motivated to drive projects to completion and also able to collaborate effectively with IT colleagues, end-users, and management. Being comfortable taking initiative when opportunities for improvement arise, as well as being a supportive team player, is key to success in this role.

Preferred Qualifications

• Professional Certification

  : Certification such as Microsoft Certified: Data Analyst Associate (or similar BI/analytics certification) is highly desirable, as it demonstrates validated expertise in Power BI and data analysis best practices.

• Other Tools & Platforms

  : Experience with Smartsheet (collaborative work management tool), the Plex Manufacturing Cloud (our cloud-based ERP system), or OneStream (our corporate performance management platform) is beneficial. Familiarity with these systems indicates versatility and the ability to integrate data from various enterprise sources.

• Data Warehousing & ETL Knowledge

  : Solid understanding of data warehousing concepts and experience with ETL processes is preferred. Knowledge of designing dimensional data models or working with data warehouse solutions (for example, familiarity with star schema design or tools like Azure Data Factory, SSIS, etc.) will help in managing and structuring data for BI use.

• Advanced Analytics Exposure

  : Exposure to statistical analysis or data science is an advantage. Experience with languages or tools such as R or Python for data analysis, or familiarity with machine learning concepts, can enhance the analytical capabilities of the BI role (though these are not core duties).

• Leadership & Mentoring

  : Demonstrated ability or experience in mentoring junior developers or leading analytics projects can be beneficial. While this role is an individual contributor, leadership skills show the capacity to take ownership of complex initiatives and guide them to success.

Soft Skills