Data Analyst

Posting Title: Data Analyst

Reports To: Director of Data & Architecture

Location: San Jose, California

Salary Range: $125,000 to $150,000

Final determination of a successful candidate's starting pay will vary based on a number of factors, including market location and may vary depending on job-related knowledge, skills, education and experience. The pay scale listed for this position is generally for candidates that meet the specified qualifications and requirements listed on this specific job description. We provide a competitive compensation package that recognizes your experience, credentials, and education alongside a robust benefits program to meet your needs. Our compensation reflects the cost of labor across several US geographic markets.

WHO WE ARE

For nearly 70 years, Cupertino Electric, Inc. (CEI) has been powered by people who've built a reputation for delivering high-profile, complex projects. Real, tangible things that alter the landscape and improve lives. But even more than that, we've built a reputation for integrity. We're problem solvers and innovation seekers. We're team players and safety fanatics. And we always-always-do the right thing. Even when no one is looking. Because what we do here is important, but how we do it is everything.

THE IT TEAM

Our projects may be complex, but our approach is simple: We build great things and we do it with great people. Using well-designed processes and controls, integrating smart and reliable solutions, and providing access to the information needed, our IT Team comprised of seasoned and experienced professionals, enable the success of the organization. We do this while minimizing operational and financial impact.

ABOUT THE ROLE

The Data Analyst position at Cupertino Electric is vital in converting complex business and technical data into actionable insights. These insights are essential for enhancing operational efficiency and informing strategic decision-making. The role requires a blend of technical expertise and business understanding to provide advanced analytics and reporting across our integrated technology stack.

Data Analysis and Reporting

• Develop and maintain Power BI dashboards and reports to provide insights into business operations, project performance, and financial metrics.

• Conduct detailed JD Edwards ERP data analyses to support financial planning and operational decision-making.

• Examine data from construction management platforms (Procore and ACC) to track project progress, resource allocation, and efficiency metrics.

• Build and optimize queries in Databricks to process large datasets, supporting advanced analytics initiatives.

• Design automated reporting solutions using Reports Now and Power BI that integrate data from multiple sources.

• Support DevOps practices by creating and maintaining monitoring and performance dashboards.

Technical Implementation

• Collaborate with Data Engineers to develop and maintain data pipelines in Databricks

• Create and maintain documentation

• Implement data quality checks and monitoring systems across all platforms

• Support the maintenance and improvement of existing reports and dashboards

• Assist in data migration projects and system integrations

• Participate in DevOps initiatives to improve reporting deployment and automation

Business Partnership

• Partner with business stakeholders to understand reporting requirements and translate them into technical solutions

• Provide training and support to end-users on reporting tools

• Present findings and recommendations to various levels of management

• Participate in cross-functional projects to improve data accessibility and utility

Knowledge: Having wide-ranging experience, uses professional concepts and company objectives to resolve complex issues in creative and effective ways. Some barriers to entry exist at this level (e.g., dept/peer review).

Job Complexity: Works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors. Exercises judgment in selecting methods, techniques and evaluation criteria for obtaining results. Networks with key contacts outside own area of expertise.

Supervision: Determines methods and procedures on new assignments and may coordinate activities of other personnel (Team Lead).

ABOUT YOU

With over 3 years of experience in data analysis and reporting, you bring the following technical and analysis competencies to the position.

Technical Competencies

• Data Platform Knowledge: Advanced SQL querying and optimization . Experience with Databricks environment and Spark SQL . Understanding of data warehouse concepts and dimensional modeling . Knowledge of ETL processes and data pipeline development . Proficiency in Reports Now for custom report development.

• Business Intelligence: Expert-level Power BI development skills . Experience creating interactive dashboards and reports . Knowledge of data visualization best practices . Understanding of performance optimization techniques.

• DevOps and System Development Life Cycle: Experience with DevOps practices and tools . Knowledge of pipelines for report deployment . Familiarity with version control and automated testing.Understanding of monitoring and logging best practices.

• Construction Management Systems: Procore data structure and reporting capabilities . ACC system integration and analysis . Experience combining data from multiple construction management platforms . Understanding of construction workflow and processes.

• Enterprise Systems: JD Edwards experience . Reports Now development and customization . Understanding of enterprise architecture principles . Experience integrating data from multiple business systems.

Analysis Competencies

• Requirements Analysis: Ability to gather and document business requirements. Experience in translating business needs into technical specifications. Skilled in stakeholder interviews and requirement validation. Understanding of construction industry reporting requirements.

• Process Analysis: Understanding of business process modeling. Experience in identifying process improvements through data analysis. Knowledge of workflow optimization techniques. Ability to analyze construction project workflows

• Problem-Solving: Strong analytical and critical thinking skills . Experience in root cause analysis . Ability to develop and evaluate multiple solutions . Skilled in data-driven decision making

• Quality Analysis: Experience in data quality assessment and improvement. Knowledge of quality assurance methodologies. Understanding of testing principles and practices. Familiarity with DevOps quality control processes

WHAT YOU WILL GAIN

As a Data Analyst at Cupertino Electric, you will have the opportunity to transform complex data into meaningful insights that drive strategic decisions and operational improvements. You'll work with cutting-edge technology and collaborate with diverse teams, enhancing your technical skills and business acumen in a dynamic and supportive environment.

MINIMUM QUALIFICATIONS

Any combination of education and experience that would likely provide the required knowledge, skills and abilities as well as possession of any required licenses or certifications is qualifying.

Education: Bachelor's degree in computer science, Information Systems, Business Analytics, or a related field

Licensure/Certifications: None required.

Experience: 3+ years of experience in data analysis and reporting . Strong SQL skills and experience with large-scale databases . Proficiency in Power BI, including DAX and Power Query . Experience with cloud-based data platforms, preferably Databricks . Familiarity with construction management software (Procore, ACC).

#LI-JT1

PLEASE NOTE: CEI will never ask for any money or financial information from applicants during the hiring process. To learn more about "job scams" how to avoid them, click here. (~~~)

CEI is a place where every single person can-and does-have an impact on the work we do and the communities we serve. Here, you can build your own story and grow to your full potential. You can collaborate and celebrate with amazing people. And you'll go home every day knowing you helped contribute to important work that shapes people's lives. Our commercial, data center and energy projects may be complex, but our approach is simple. We build great things and we do it with great people.

The job duties listed are typical examples of work performed by positions in this job classification and are not designed to contain or be interpreted as a comprehensive inventory of all duties, tasks, and responsibilities. Specific duties and responsibilities may vary depending on department, program or project needs without changing the general nature and scope of the job or level of responsibility. Employees may also perform other duties as assigned.

Cupertino Electric, Inc. (CEI) is proud to be an Equal Employment Opportunity and affirmative action employer. We celebrate diversity and do not discriminate based on race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability status, or any other applicable characteristics protected by law.

Cupertino Electric Inc. aims to make ~~~ accessible to any and all users. If you have a disability or special need that requires accommodation to navigate our website or complete the application process, please contact us at ~~~ or 1-(877)-747-4CEI.

Cupertino Electric, Inc. (CEI) is proud to be an Equal Employment Opportunity and affirmative action employer. We celebrate diversity and do not discriminate based on race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability status, or any other applicable characteristics protected by law.