Business Intelligence Analyst

Job Duties and Responsibilities

• Meet with business leaders and stakeholders to gather, analyze, and document reporting and dashboard requirements.
• Design, develop, and maintain interactive dashboards, reports, and visualizations using Tableau.
• Develop SQL queries to retrieve, analyze, and prepare data for reports, dashboards, and business intelligence solutions.
• Develop and maintain data models to support enterprise reporting, including fact and dimension tables and star schema designs.
• Validate data accuracy and ensure consistency across reports, dashboards, and source systems.
• Develop and maintain standardized reports and dashboards that promote consistent reporting across departments.
• Translate business requirements into scalable reporting solutions that provide meaningful operational and financial insights.
• Consult with business leaders to understand reporting needs and recommend business intelligence solutions that support operational objectives.
• Develop executive, operational, and departmental KPI dashboards to support performance monitoring and decision-making.
• Partner with cross-functional teams to identify reporting opportunities and recommend process improvements through business intelligence solutions.
• Document report specifications, SQL scripts, data definitions, and dashboard functionality.
• Maintain existing reports and dashboards, implementing enhancements and resolving data or reporting issues as needed.
• Support data integration and reporting initiatives involving SQL Server, PostgreSQL, Oracle, or other relational database platforms.
• Assist with troubleshooting reporting, data, and system-related issues impacting business intelligence solutions.
• Support the evaluation and implementation of AI-enabled reporting, automation, and analytics solutions, including the use of Python, APIs, and emerging AI technologies where applicable.
• Stay current on business intelligence, analytics, and data visualization best practices and recommend improvements to reporting capabilities.

Skills

• Working knowledge of SQL skills, including joins, Common Table Expressions (CTEs), window functions, stored procedures, and query optimization.
• Proficiency in Tableau report and dashboard development.
• Understanding of relational databases and data modeling concepts, including fact and dimension table design.
• Ability to gather business requirements and translate them into technical reporting solutions.
• Knowledge of business intelligence concepts, KPI development, and data visualization best practices.
• Strong analytical, problem-solving, and critical-thinking skills.
• Excellent attention to detail with the ability to validate and ensure data accuracy.
• Strong written and verbal communication skills with the ability to present technical information to non-technical stakeholders.
• Ability to manage multiple projects and priorities while meeting established deadlines.
• Exposure to Python programming, APIs, and emerging AI technologies is preferred.

Education

• Required: Bachelor’s degree in Computer Science, Software Engineering, Data Science, Data Analytics, Information Systems, or related field.
• Recent graduates are encouraged to apply.
• PREFERRED: Coursework or certification in Business Intelligence, Data Analytics, Artificial Intelligence, Machine Learning, or Data Visualization.

Work Experience

• Required: Experience developing reports, dashboards, or data visualization through academic projects, internships, or professional experience.
• Required: Experience working with relational databases such as Microsoft SQL Server, PostgreSQL, or Oracle.
• PREFERRED: Experience gathering business requirements and delivering reporting solutions to business stakeholders.
• PREFERRED: Experience supporting manufacturing, industrial, or operations-focused reporting environments.
• PREFERRED: Experience with Python, AI-enabled analytics, Open AI, Azure AI, or similar technologies.

Physical Requirements

• Prolonged periods of sitting and working at a computer.
• Must be able to communicate effectively in person, by telephone, and through virtual meeting platforms.
• Must be able to lift up to 15 pounds occasionally.