Data Analyst

Posting Title: Data AnalystReports To: Director of Data & ArchitectureLocation: 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. *This position is not eligible for relocation. WHO WE AREFor 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 TEAMOur 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 ROLEThe 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 YOUWith 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. Kn