Business Intelligence Analyst II
About The Position
The Business Intelligence Analyst II at WRM will play a pivotal role in advancing the organization’s data‑driven strategy. This position is responsible for transforming complex datasets into actionable insights that guide decision‑making across departments. The analyst will design and maintain data models, develop interactive dashboards, streamline data processes, and support system integrations to ensure reliable and accessible information. Success in this role requires strong analytical skills, technical expertise, and the ability to collaborate with stakeholders to translate business needs into effective data solutions.
Requirements
- Bachelor’s degree in Information Systems, Data Analytics, Computer Science, Business, or a related field
- 3–5 years of professional experience in business intelligence, data analytics, or data engineering
- Strong proficiency in SQL Server, including T‑SQL, stored procedures, views, and performance optimization
- Hands‑on experience with ETL tools (SSIS or equivalent)
- Proficiency with data visualization platforms such as Power BI, Tableau, or Looker
- Solid understanding of relational databases, data modeling, and data governance principles
- Experience supporting system integrations, APIs, or cross‑platform data flows
- Excellent analytical, organizational, and communication skills
- Ability to manage multiple priorities and meet deadlines in a fast‑paced environment
- High attention to detail and commitment to accuracy
- Demonstrated ability to work independently as well as collaboratively within a team
Nice To Haves
- familiarity with Power Apps, Python, C#, JavaScript, or Power Automate
- Microsoft SQL, Power BI, or related analytics certifications
- Relevant cloud platform certifications (Azure, AWS, or Google Cloud)
Responsibilities
- Develop and maintain SQL queries, stored procedures, and scripts in SQL Server to support data extraction and transformation.
- Design, enhance, and manage ETL workflows (SSIS or equivalent), ensuring accuracy, reliability, and efficiency of data pipelines.
- Support system integration initiatives and data implementation projects across multiple platforms.
- Collaborate with operations, finance, HR, and other departments to understand reporting needs and deliver scalable BI solutions.
- Build dashboards, reports, and data visualizations using Power BI, Tableau, or other business intelligence tools.
- Perform in‑depth data analysis to identify trends, performance metrics, and actionable operational insights.
- Maintain clear documentation for data sources, data flows, reporting logic, and business rules.
- Partner with stakeholders to define and standardize KPIs, ensuring consistency across the organization.
- Contribute to continuous improvement initiatives focused on data governance, quality, and reporting processes.
- Perform additional duties as assigned to support organizational goals.
Benefits
- Comprehensive Benefits: Choose from one of three medical plans, based on your needs, dental, and vision coverage; along with 401(k) with 5% company match
- Career Growth: Training programs and advancement opportunities in wastewater operations and environmental services
- Paid Time Off: Generous PTO policy accrues from day 1, floating and company paid holidays.
- Additional Perks: Company-paid life and disability insurance, employee assistance program, and more
- Supportive Leadership: Leadership that values safety, professionalism and growth
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
