Data Analyst

The Data Analyst will report to the Manager, Data Analytics and Insights, Power Sector and will have the following responsibilities: Maintain and ensure the accuracy, consistency, and reliability of data across multiple data sources and systems. Design and implement automated tests to ensure data integrity and identify potential issues before they impact reporting and analytics. Write, optimize, and maintain SQL queries to extract, manipulate, and analyze data from databases. Design, develop, and maintain interactive and visually appealing Power BI dashboards to provide actionable insights to stakeholders. Work closely with business units and IT teams to understand data requirements, resolve data-related issues, and ensure consistent data delivery. Document data models, data flow, and testing procedures to ensure clarity and knowledge sharing across teams. Identify opportunities to improve data processes and workflows, ensuring the efficiency and accuracy of data management practices. Strong proficiency in SQL for data extraction, manipulation, and analysis. Experience with Power BI for creating dynamic dashboards and reports. Knowledge of relational databases and data warehousing concepts. Understanding of automated data integrity testing. Strong analytical thinking and attention to detail. Problem-solving skills with the ability to work independently or in a team environment. Bachelor s degree in Data Science, Computer Science, Information Systems, Statistics, or related field. Min 5+ years of experience as a Data Analyst or in a similar role. Prior experience on Python is preferred. Experience working with real-time systems and data connectivity is preferred. #LI-VK1 About Us Groundbreaker. Game changer. Pioneer. TRC has long set the bar for clients who require more than just engineering, combining science with the latest technology to devise innovative solutions that stand the test of time. From pipelines to power plants, roadways to reservoirs, schoolyards to security solutions, clients look to TRC for breakthrough thinking backed by the innovative follow-through of an industry leader. TRCs professionals work with a broad range of commercial, industrial and government clients and the communities they serve. We deliver breakthrough solutions that address local needs -- so our clients can better succeed in an ever-changing world. Working at TRC means tackling interesting, meaningful projects. We pride ourselves on our collaborative spirit, entrepreneurial zeal and agile corporate structure. We recognize that the expertise of our staff is our strongest asset, so we generously reward employees for successful performance and invest in their careers through training and the development of new skills and certifications. Overview We are seeking a highly motivated Data Analyst with strong SQL skills and experience in maintaining data integrity. The ideal candidate will be responsible for ensuring the accuracy and consistency of data sources, writing tests to validate data, and creating impactful Power BI dashboards. This role requires a detail-oriented individual who can work collaboratively with cross-functional teams to provide data-driven insights and ensure data quality. Responsibilities The Data Analyst will report to the Manager, Data Analytics and Insights, Power Sector and will have the following responsibilities: Maintain and ensure the accuracy, consistency, and reliability of data across multiple data sources and systems. Design and implement automated tests to ensure data integrity and identify potential issues before they impact reporting and analytics. Write, optimize, and maintain SQL queries to extract, manipulate, and analyze data from databases. Design, develop, and maintain interactive and visually appealing Power BI dashboards to provide actionable insights to stakeholders. Work closely with business units and IT teams to understand data requirements, resolve data-related issues, and ensure consistent data delivery. Document data models, data flow, and testing procedures to ensure clarity and knowledge sharing across teams. Identify opportunities to improve data processes and workflows, ensuring the efficiency and accuracy of data management practices. Qualifications Strong proficiency in SQL for data extraction, manipulation, and analysis. Experience with Power BI for creating dynamic dashboards and reports. Knowledge of relational databases and data warehousing concepts. Understanding of automated data integrity testing. Strong analytical thinking and attention to detail. Problem-solving skills with the ability to work independently or in a team environment. Bachelor s degree in Data Science, Computer Science, Information Systems, Statistics, or related field. Min 5+ years of experience as a Data Analyst or in a similar role. Prior experience on Python is preferred. Experience working with real-time systems and data connectivity is preferred. #LI-VK1 EEO Statement TRC is an Equal Opportunity Employer. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other characteristic protected by applicable law. All employment decisions are made based on qualifications, merit, and business needs. We celebrate diversity and are committed to creating an inclusive environment for all employees. The complete job description and application are available on TRC s career site. TRC accepts applications for this position on an ongoing, rolling basis and reserves the right to cancel this posting at any time.