Business Intelligence Analyst

We are looking for a BUSINESS INTELLIGENCE ANALYST who can help shape our vision and support our mission. Here is what the position will look like.

• Partner with Accounting, Operations and other cross-functional stakeholders to understand analytical and reporting needs and deliver accurate, actionable business intelligence solutions.

• Gather, analyze, and document reporting and analytical requirements through research, data analysis, and stakeholder collaboration.

• Translate complex internal and external business intelligence requests into high-quality analytical products using the most credible and efficient data sources.

• Design, develop, and maintain recurring and ad hoc financial and operational reports, dashboards, and analyses using SQL, Power BI, SQL Server Reporting Services (SSRS), and Excel.

• Develop, optimize, and maintain complex SQL queries, stored procedures, and views to extract, transform, and analyze financial, claims, enrollment, capitation, and utilization data.

• Analyze complex datasets to identify trends, variances, risks, and opportunities related to budgeting, forecasting, cost analysis, and overall financial performance.

• Ensure accuracy, integrity, and consistency of data through validation, reconciliation, and quality assurance processes.

• Identify, document, and assist in resolving data quality issues.

• Identify opportunities to automate reporting processes, improve data workflows, and enhance self-service analytic capabilities.

• Maintain documentation of reports, data sources, business logic, and analytical methodologies.

We seek self-motivated and reliable candidates who can work independently and find solutions to complete the job. We value relationships and invest in our employees., Education: Bachelor's degree in a project management-related area, statistics, computer science, information systems, finance, accounting, or related field. An equivalent combination of experience and/or education may be considered in lieu of a bachelor's degree.

Experience:

• A minimum of 2 years' experience working in a data-focused role, leveraging data to inform business decisions.

• 2 years' experience with SQL is required with a preference for advanced SQL experience and SQL Server.

• Experience developing reports and dashboards using BI and data visualization tools (e.g., Power BI, SSRS, Excel, Business Objects, or similar platforms) is required.

• A background in job cost accounting is a plus.

Knowledge, Skills, and Abilities:

• Ability to analyze and interpret complex data patterns and trends.

• Strong analytical, problem-solving, and critical-thinking abilities, with attention to detail and data accuracy.

• Capable of translating complex business questions into clear requirements and effective data solutions.

• Strong SQL skills with the ability to write and optimize complex queries (e.g., subqueries, window functions, temp tables, CTEs, etc.).

• Demonstrates support for the company's mission, vision and values.

• Proficiency with Microsoft Office applications, including Word, Excel, PowerPoint, Outlook, and Teams.

• Excellent written and verbal communication skills. Must have strong interpersonal and teamwork skills, supported by good organizational and time management.

• Ability to manage multiple priorities and projects with tight deadlines.

$85,000 - $95,000 a year

AD&D insurance, Health insurance, 401(k) matching, Vision insurance, Dental insurance, Disability insurance, Paid holidays, An innovative and collaborative team who supports each other, the employees and vision of the company to reach our goals individually, together and as an organization. This position will be a hybrid model work environment, 4 days in the office each week and 1 flex, remote day.

Benefits Package: Company Paid!

• Medical, Dental, Prescription & Vision Benefits
• Life, AD&D and LTD insurance
• Paid Vacation and Holidays
• Company- Matched 401(k) and IRA Retirement Savings

About

Wachter is a family-owned company since 1930 and we see each employee as a critical piece of the Wachter Family. With over 900 licenses across the country, Wachter serves commercial and industrial clients with the right technologies needed to keep them successful. We design, install, and maintain the technologies that keep businesses operating efficiently. Our team of dedicated electricians, engineers, and technicians provides electrical, data, security, communications, and automation services to clients in numerous industries.