Construction Project Business Intelligence Analyst; Mult. Pos

Job Title Construction Project Business Intelligence Analyst

#0802

A job at TSMC Arizona offers an opportunity to work at the most advanced semiconductor fab in the United States. TSMC Arizona’s first fab will operate its leading-edge semiconductor process technology (N4 process), starting production in the first half of 2025. The second fab will utilize its leading edge N3 and N2 process technology and be operational in 2028. The recently announced third fab will manufacture chips using 2nm or even more advanced process technology, with production starting by the end of the decade.

America’s leading technology companies are ready to rely on TSMC Arizona for the next generations of chips that will power the digital future.

As a Construction Project Business Intelligence Analyst, you will demonstrate a strong sense of reliability and enthusiasm and will possess an attitude that embodies our core values – Integrity, Commitment, Innovation, and Customer Trust. Multiple positions available.

Design, develop, and maintain business intelligence architecture and reporting solutions to support construction project performance management. Extracts, transform, and integrate data from ERP systems including SAP and Oracle, project scheduling software including Primavera P6 and Microsoft Project, cost control systems, and field data platforms.

• Develop and manage relational databases, data models, and data warehouses using SQL.
• Design and implement ETL processes to ensure data accuracy and integrity.
• Create automated dashboards, visualizations, and KPI reports using Power BI, Tableau, or Qlik View to analyze schedule variance, cost performance, resource utilization, safety metrics, and quality indicators.
• Perform quantitative data analysis to identify trends, anomalies, and operational risks.
• Apply statistical modeling and forecasting techniques to project construction timelines and budget outcomes.
• Define technical data requirements and system specifications.
• Document data architecture, reporting methodologies, and governance standards. Implement data validation, access controls, and compliance procedures to ensure data security and regulatory adherence.

Education and Work Experience :

• Master’s degree or foreign equivalent in Information Systems, Computer Science, Data Analytics, Business Analytics, or related field, plus two (2) years of experience in the construction industry, business intelligence, data analysis, or related role.

• Must have 2 years of experience in each of the following:
• SQL for data extraction and analysis;
• Developing dashboards and reports using one of the following:
  Power BI, Tableau, or Qlik View;
• Implementing ETL processes and data warehousing concepts;
• Performing statistical analysis and forecasting; and
• ERP/project management systems including one of the following: SAP, Oracle, Primavera P6, or Microsoft Project.

• Candidates must be willing and able to work on-site at our Phoenix Arizona facility.

Standard

Work Hours:

40 hrs/week, Mon-Fri, 8:30 a.m.

- 5:30 p.m.

As a valued member of the TSMC family, we place a significant focus on your health and well-being. When you are at your best—physically, mentally, and financially—our company is at its best. We offer a comprehensive and competitive benefits program that provides the resources you need to help you manage your health and achieve your goals across many areas of your life.

This includes a variety of medical, dental, and vision plan offerings you can choose from that best fit you and your family’s needs. Additionally, TSMC provides income‑protection…