Construction Project Business Intelligence Analyst (Mult. Pos.) - Job# 0802

TSMC•Phoenix, AZ

1d•Onsite

About The Position

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. Construction Project Business Intelligence Analyst - Brief Description 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.

Requirements

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.
2 years of experience in SQL for data extraction and analysis
2 years of experience developing dashboards and reports using one of the following: Power BI, Tableau, or QlikView
2 years of experience implementing ETL processes and data warehousing concepts
2 years of experience performing statistical analysis and forecasting
2 years of experience with ERP/project management systems including one of the following: SAP, Oracle, Primavera P6, or Microsoft Project.

Responsibilities

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 QlikView 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.