The Role
Designs, develops, and maintains BI reports, dashboards, and visualizations (primarily Tableau) using SQL and relational databases. Partners with stakeholders to gather requirements, build data models, validate data accuracy, and deliver KPIs. Supports integrations, troubleshooting, and evaluation of AI-enabled analytics and automation solutions.
Summary Generated by Built In
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
Skills
Education
Work Experience
Physical Requirements
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.
- Must be able to lift up to 15 pounds occasionally.
Skills Required
- Bachelor's degree in Computer Science, Software Engineering, Data Science, Data Analytics, Information Systems, or related field
- Experience developing reports, dashboards, or data visualizations via academic projects, internships, or professional experience
- Experience working with relational databases such as Microsoft SQL Server, PostgreSQL, or Oracle
- Working knowledge of SQL, including joins, 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
- Excellent attention to detail and ability to validate and ensure data accuracy
- Strong written and verbal communication skills; ability to present technical information to non-technical stakeholders
- Ability to manage multiple projects and priorities while meeting established deadlines
- Position is fully on-site at Houston headquarters
- Exposure to Python programming, APIs, and emerging AI technologies
- Experience gathering business requirements and delivering reporting solutions to business stakeholders
- Experience supporting manufacturing, industrial, or operations-focused reporting environments
- Preferred: Coursework or certification in Business Intelligence, Data Analytics, AI/ML, or Data Visualization
- Preferred: Experience with AI-enabled analytics, OpenAI, or Azure AI
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Lamons is one of the largest Gasket, Bolt and Hose Assembly manufacturers in the world that is privately held. Our mission is to provide industry-leading Safety Sealing and Attachment Solutions through our Valued Quality Products, Exceptional Service and with a culture of Never-Ending Continuous Improvement. We achieved this mission through deploying the capabilities of our manufacturing facilities in Houston and Denver while utilizing our 19 strategically located branches to support our customers’ needs 24/7.
