Senior Data Analyst

TRC Companies, Inc.•San Ramon, CA

57d•$36 - $42

About The Position

We are seeking an experienced Senior Data Analyst with a strong background in high-level SQL use and proficient database management skills. The ideal candidate will play a key role in analyzing business processes, translating requirements into technical specifications, and ensuring effective database management. Additionally, experience in Power Apps is a major bonus for applicants.

Requirements

Expertise in writing complex SQL queries and optimizing database performance.
Experience with ETL processes and data manipulation.
Strong understanding of database design principles, normalization, and indexing.
Strong experience with Power BI.
Excellent analytical and problem-solving skills.
Strong communication and interpersonal skills.
Ability to work independently and collaboratively in a fast-paced team environment.
Cross-functional stakeholder engagement.

Nice To Haves

Accredited degree(s) in Computer Science, Information Systems, or a related field.
Proven experience as a Business Analyst with a focus on SQL and database management.
Experience in Power Automate development and integration is a significant advantage.
Strong team player mentality.
Experience in a client facing role.
Experience in utilities or in other regulated industry.
Experience in defining business problems, gathering, validating, and documenting requirements, analyzing solution options, and implementing the solution.
Experience leading User Acceptance Testing sessions and process improvement initiatives.

Responsibilities

Data Analysis and Reporting:
Conduct in-depth analysis of business processes and data requirements.
Develop and execute complex SQL queries to extract, manipulate, and analyze data.
Generate comprehensive reports and dashboards to support decision-making processes.
Database Management:
Oversee the design, implementation, and maintenance of databases.
Optimize database performance, ensuring efficient data retrieval and storage.
Implement and enforce data security and integrity measures.
Requirement Gathering and Documentation:
Collaborate with stakeholders to gather and document business requirements.
Translate business needs into technical specifications for database development.
Maintain detailed documentation of database structures, processes, and procedures.
Power Apps Integration:
Leverage Power Apps to develop solutions that enhance business processes.
Integrate Power Apps with existing databases and systems.
Provide expertise in optimizing Power Apps for efficiency and user experience.
Collaboration and Communication:
Work closely with cross-functional teams to understand business objectives.
Collaborate with IT teams to implement solutions aligned with business goals.
Quality Assurance:
Conduct thorough testing of database systems and applications to ensure accuracy.
Identify and troubleshoot data anomalies, ensuring data quality and consistency.
Implement and oversee data validation processes.
Continuous Improvement:
Stay abreast of industry trends, emerging technologies, and best practices.
Propose and implement improvements to existing database structures and processes.

Benefits

Medical, dental, vision, and disability insurance.
401k package that includes both traditional and Roth IRA options and Company match.
Paid time off contingent upon full time or part time status and level of seniority (ranging from 15 to 25 days per year).
All full-time employees enjoy a minimum of 8 Paid Holidays per year.
TRC ensures that all employees, including those that work part-time, receive paid sick, family, and disability leave in accordance with the laws of their state of residence.
These benefits are applicable to US employees depending on their employment status (full time, part time, or temporary). TRC offers jurisdiction specific benefit packages for International and Puerto Rico employees.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume