Business Intelligence Analyst

The Business Intelligence Analyst is responsible for creating, maintaining, deploying, all forms of reporting for internal customers. You will work collaboratively with the BI (Business Intelligence) Staff, other IT staff, and business stakeholders with the goal of delivering actionable data analytics. This position plays multiple roles including data architect, data modeler, SQL programmer, report writer, report designer, and project manager.

Essential Functions Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

1. Design, build, and deploy business intelligence reports, self-service reports, and dashboards using a variety of front-end visualization tools such as Tableau, SSRS and Crystal Reports
   1. Test and validate underlying report data; convey the key insights or story the data to reveal in a visual format that is grouped, summarized, or formatted to be easily consumed, understood, insightful and actionable
   2. Provide Direction and Guidance to other Business Intelligence Analysts.
2. Work with large, messy, disparate datasets and conduct ad-hoc analyses to quickly inform critical business decisions. Create ETLs or processes that pull data from multiple places and centralize it in one data source.
3. Review and optimize existing queries written by other developers; perform ongoing monitoring and refinement of reports and BI solutions.
4. Participate in innovative technology evaluation and ensure alignment of business unit data and analytics practices with enterprise data processes and practices.
5. Develop and maintain operating procedures and support documentation for all reporting infrastructure.
6. Proactively engage in continuous improvement efforts for all reports and their operation.
7. Excellent communication skills and ability to work cross-functionally.
8. Perform other duties as assigned.

Required Qualifications

1. Bachelor s degree in Computer Science, Information Systems, Mathematics, or a related field.
2. 3-5 years of experience in IT and Business Intelligence creating advanced reports using tools such as Tableau (or other BI tools like Power BI, Qlik, or Tibco), SSRS, SSIS, T-SQL, MS SQL Server preferred.
3. A minimum of 3 years of experience designing, writing, and maintaining Crystal Reports.

Preferred Qualifications

1. Prior experience in Business Intelligence development, planning, design, configuration, coding, and troubleshooting of BI tools preferred.
2. Strong understanding of database systems and data warehouse architecture preferred.
3. Familiar with any ERP database schemas and departmental processes preferred.
4. Experience with Python or other scripting language is a plus.

Required Skills/Abilities

1. Ability to act with integrity, professionalism, and confidentiality.
2. Excellent verbal and written communication skills.
3. Excellent time management skills with a proven ability to meet deadlines.
4. Strong analytical and problem-solving skills.
5. Ability to communicate with both technical and non-technical individuals.

Work Environment/Physical Demands/Travel
This job operates in a professional business office or home office where standard office equipment is routinely used, such as computers, photocopy machines, fax machines, telephones and filing cabinets. This position is largely a sedentary role. Must be able to lift 30 pounds at times. Must be able to access and navigate each department at the organization s facilities.

6314