Business Intelligence Engineer, Chattanooga

Job Description:

Title:  Business Intelligence Engineer

Operating Company:  Environmental Solutions Group

Location: Chattanooga

Reports to: Director – Business Intelligence

Department:  Technology and Development

COMPANY SUMMARY:

Environmental Solutions Group (ESG) encompasses industry-leading brands — Heil Environmental, Marathon, Bayne, The Curotto-Can, 3rd Eye, and Soft-Pak — to create a premier, fully integrated equipment group serving the solid waste and recycling industry. Through extensive voice-of-customer outreach, in-house engineering and manufacturing capabilities, a wide-reaching service network, and proven industry expertise, Environmental Solutions Group is focused on solving customer problems through environmentally responsible products and providing world-class support. 

POSITION SUMMARY:

The Business Intelligence Engineer will design, develop, and maintain reporting solutions for ESG users to provide insights and improve business efficiencies.  They will craft and execute queries for data, presenting information through reports and visualizations, and utilize data across ESG lines of business to expand our data warehouse.  The Business Intelligence Engineer will manage a reporting development pipeline and support reporting functions around security, scheduling, emailing, and exporting data.  They will meet with business users to define reporting requirements and provide troubleshooting and training for reporting issues.

ESSENTIAL JOB FUNCTIONS INCLUDE:

• Design, build, and deploy Power BI dashboards and visualizations for internal users and applications.
• Provide technical support and troubleshooting of Power BI solutions, including investigation of data issues and validations.
• Create and optimize database queries from multiple sources.
• Develop database views, functions, tasks, and stored procedures to power reports.
• Conduct unit testing and troubleshooting.
• Evaluate, plan, and report on capacity usage based on user engagement and number of reports.
• Manage workspaces, report deployment, and data security.
• Maintain detailed technical documentation for report logic.
• Create data models within Power BI using Power Query.
• Create data sets, reports, and dashboards using Power BI from various sources.
• Deliver solutions in an iterative manner.
• Work with business users and leadership team to define reporting requirements and look and feel of reporting content.
• Provide support and training to ESG team members.
• Biweekly travel, typically within an hour to Fort Payne, AL.

JOB SPECIFICATIONS:

General Requirements:

• Bachelor's Degree, or higher, in Computer Science, Information Systems, or a related field is required or equivalent experience.
• 3-5 years of experience with business intelligence reporting tools
• 3+ years of experiencing implementing Power BI dashboards.
• Expertise with Power BI development, Power Query, DAX tooling or functions, data modeling, and Row-level Security, and gateways.
• Strong SQL skills – familiarity with T-SQL or Snowflake required.
• Experience with ERP system reporting – JDEdwards a plus.
• Travel required on a bi-weekly basis to work with manufacturing teams.
• Experience with data warehouse design and dimensional modeling.
• Demonstrable portfolio of sample visualizations created in Power BI preferred.

• Ability to lead reporting requirements meetings with users at all levels of the company.
• Ability to learn new software and technologies quickly.
• Detail-oriented and willing to document projects within JIRA.

KNOWLEDGE, SKILLS, AND ABILITIES:

Ethics and Work Standards: Maintain the highest ethical and work standards, while promoting the same attributes in co-workers and others.  Ensure that all business activities – with both internal and external customers – to be performed with a professional demeanor and that all participants be held accountable to this high standard.

Communication:  Expresses thoughts clearly, both orally and in writing, using good grammar. Presents concise, well-organized reports in Microsoft Word, PowerPoint, and Excel.  Listens to understand input, feedback, and concerns.  Provides complete information in an open, honest, and straightforward manner.  Responds promptly and positively to questions and requests.

Teamwork and Relationshi