What are the responsibilities and job description for the Junior Data Analyst position at PURIS?
About PURIS
PURIS operates across North America as the largest independent trenchless rehabilitation provider with 1,200 employees dedicated to building lasting infrastructure with smart, sustainable resource management. The PURIS Family of Companies provide trenchless renewal solutions in the water, wastewater, and stormwater markets. Our environmentally friendly solutions work within the existing infrastructure to save time, minimize environmental impact, and cause fewer community disruptions. With an unrivaled toolbox of technologies, PURIS has the RIGHT solution for each project.
Job Summary Description
This role supports the organization’s data and reporting needs by developing and maintaining interactive Power BI dashboards and reports. The position is responsible for collecting, cleaning, and transforming data from a variety of sources—such as Excel, SQL databases, cloud platforms, and APIs—into reliable datasets that drive business insights. The role involves performing foundational data analysis to identify trends and anomalies, ensuring data accuracy and consistency across all reporting outputs, and documenting data models and processes for ongoing reference. Collaboration is central to the position, as it requires working closely with team members to understand reporting requirements and deliver meaningful, actionable insights. The role also provides end‑user support for Power BI dashboards and stays current with new Power BI capabilities and data visualization best practices to continuously enhance reporting quality.
Responsibilities
Key Responsibilities
PURIS operates across North America as the largest independent trenchless rehabilitation provider with 1,200 employees dedicated to building lasting infrastructure with smart, sustainable resource management. The PURIS Family of Companies provide trenchless renewal solutions in the water, wastewater, and stormwater markets. Our environmentally friendly solutions work within the existing infrastructure to save time, minimize environmental impact, and cause fewer community disruptions. With an unrivaled toolbox of technologies, PURIS has the RIGHT solution for each project.
Job Summary Description
This role supports the organization’s data and reporting needs by developing and maintaining interactive Power BI dashboards and reports. The position is responsible for collecting, cleaning, and transforming data from a variety of sources—such as Excel, SQL databases, cloud platforms, and APIs—into reliable datasets that drive business insights. The role involves performing foundational data analysis to identify trends and anomalies, ensuring data accuracy and consistency across all reporting outputs, and documenting data models and processes for ongoing reference. Collaboration is central to the position, as it requires working closely with team members to understand reporting requirements and deliver meaningful, actionable insights. The role also provides end‑user support for Power BI dashboards and stays current with new Power BI capabilities and data visualization best practices to continuously enhance reporting quality.
Responsibilities
Key Responsibilities
- Assist in the design, development, and maintenance of interactive Power BI dashboards and reports.
- Collect, clean, and transform data from multiple sources (Excel, SQL databases, cloud applications, APIs, etc.) into usable datasets for reporting.
- Perform basic data analysis to identify trends, patterns, and anomalies.
- Collaborate with team members to understand reporting requirements and deliver insights that meet business needs.
- Ensure data accuracy, consistency, and integrity across reports.
- Document data models, processes, and report structures for future reference.
- Provide support to end-users on Power BI dashboards and assist with troubleshooting issues.
- Stay up to date with new Power BI features and data visualization best practices.
- Assist in monitoring scheduled data refreshes and resolving refresh failures to ensure timely report updates.
- Support the development of standardized reporting templates and contribute to improving reporting processes and efficiency
- Bachelor’s degree in data Analytics, Information Systems, Business, Statistics, or a related field (or equivalent practical experience).
- Basic understanding of data modeling, relational databases, and ETL processes.
- Hands-on experience with Microsoft Power BI (coursework, internships, or projects).
- Familiarity with data analysis tools such as Excel (pivot tables, Power Query, formulas).
- Exposure to SQL or other query languages is a plus.
- Strong problem-solving, attention to detail, and communication skills.
- Eagerness to learn, grow, and adapt in a fast-paced, data-driven environment.
- Experience working with APIs, SharePoint, or cloud-based data sources.
- Knowledge of DAX and Power Query (M language).
- Understanding of basic statistical concepts and data visualization principles.
- Previous internship or academic project experience in data analytics.
- Comprehensive and competitive benefits package that includes medical/Rx, dental, vision, critical illness and accident insurance, and short-term disability.
- Several 100% company-paid benefits including:
- Life Insurance
- Long-term disability
- Employee assistance program
- Bonus program
- 401(k) savings plan with company match
- Generous PTO
- 10 paid holidays
- Tuition reimbursement