Job Summary:
Lamons is seeking a Business Intelligence Analyst to design, develop, and maintain business intelligence reports and dashboards. This role involves partnering with business leaders to gather reporting requirements and deliver analytics solutions that enhance operational decision-making.
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.
Qualifications:
Required:
• Bachelor’s degree in Computer Science, Software Engineering, Data Science, Data Analytics, Information Systems, or related field.
• Experience developing reports, dashboards, or data visualization through academic projects, internships, or professional experience.
• Experience working with relational databases such as Microsoft SQL Server, PostgreSQL, or Oracle.
• 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.
Preferred:
• Exposure to Python programming, APIs, and emerging AI technologies is preferred.
• Coursework or certification in Business Intelligence, Data Analytics, Artificial Intelligence, Machine Learning, or Data Visualization.
• Experience gathering business requirements and delivering reporting solutions to business stakeholders.
• Experience supporting manufacturing, industrial, or operations – focused reporting environments.
• Experience with Python, AI-enabled analytics, Open AI, Azure AI, or similar technologies.
Company:
Lamons is an oil & energy company specializing in gaskets, fasteners, and flange accessories. Founded in 1947, the company is headquartered in Houston, USA, with a team of 501-1000 employees. The company is currently Late Stage.