Apply on Employer Site

TRC Companies, Inc. · 14 hours ago

Senior Data Analyst

San Ramon, CA

Full-time

Onsite

Senior Level

$36/hr - $42/hr

TRC Companies, Inc. is a pioneering firm that combines science with technology to provide innovative solutions across various sectors. They are seeking a Senior Data Analyst to analyze business processes, manage databases, and develop solutions using Power Apps to enhance business operations.

ConstructionConsultingEnvironmental EngineeringProfessional Services

H1B Sponsor Likely

Responsibilities

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

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

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

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

Work closely with cross-functional teams to understand business objectives

Collaborate with IT teams to implement solutions aligned with business goals

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

Stay abreast of industry trends, emerging technologies, and best practices

Propose and implement improvements to existing database structures and processes

Qualification

SQLDatabase ManagementPower BIETL ProcessesPower AppsAnalytical SkillsProblem-Solving SkillsCommunication SkillsInterpersonal SkillsTeam Collaboration

Required

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

Preferred

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

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.

Company

TRC Companies, Inc.

Glassdoor3.6

TRC stands for adaptability.

Founded in 1961

Lowell, Massachusetts, USA

5001-10000 employees

https://www.trccompanies.com/

H1B Sponsorship

TRC Companies, Inc. has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2021 (1)