Business Intelligence Analyst

Business Intelligence Analyst

Recent graduates are encouraged to apply. Relevant internship, academic project, and hands-on experience will be considered. This position is fully on-site at our Houston headquarters. Lamons is conducting this search internally and is not partnering with staffing agencies or accepting unsolicited candidate submissions for this position.

Job Summary: The Business Intelligence Analyst designs, develops, and maintains business intelligence reports, dashboards, and data visualizations that support operational and strategic decision-making across the organization. This role partners with business leaders to gather reporting requirements, develop SQL-based data solutions, and deliver accurate, timely analytics through Tableau and other business intelligence tools. The Business Intelligence Analyst also supports reporting enhancements, data integrity, and emerging analytics technologies to improve business performance.

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 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.
• Monitor and 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.
• Perform other duties as assigned.

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.