Business Intelligence Analyst

Lamons; Houston (TX); On-site; USD 70,000 - 95,000; Full time

Job summary

Lamons in Houston, TX is seeking a Business Intelligence Analyst to design, develop, and maintain BI reports, dashboards, and data visualizations that support operational and strategic decision‑making. You will partner with business leaders to gather requirements, develop SQL‑based solutions, and deliver timely analytics through Tableau and other BI tools.

This role involves data modeling, data integrity, and exploring AI‑enabled analytics.

Qualifications

• Bachelor’s degree required in Computer Science, Software Engineering, Data Science, Data Analytics, or related field.
• Recent graduates encouraged to apply.
• Preferred coursework in Business Intelligence, Data Analytics, Artificial Intelligence, Machine Learning, or Data Visualization.

Responsibilities

• Meet with business leaders 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 BI solutions.
• Develop and maintain data models including fact and dimension tables and star schema designs.
• Validate data accuracy and ensure consistency across reports and source systems.
• Develop and maintain standardized reports and dashboards for cross‑departmental use.
• Translate business requirements into scalable reporting solutions for operational and financial insights.
• Collaborate with business leaders to understand reporting needs and BI solutions.
• Develop executive, operational, and departmental KPI dashboards for performance monitoring.

Skills

Analytical thinking

Communication

Detail-oriented

Project management

Python exposure

Education

Bachelor’s degree in Computer Science, Software Engineering, Data Science, Data Analytics, Information Systems, or related field

Tools

SQL

Tableau

Relational databases

Job description

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 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.
• 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.
• Mustbe able to lift up to 15 pounds occasionally.