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

About the role

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. Work Location: 5088 W. Innovation Circle, Phoenix, AZ 85083. Candidates must be willing and able to work on-site at our Phoenix Arizona facility.

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.

Qualifications

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

Skills

• SQL for data extraction and analysis (2+ years experience)
• Developing dashboards and reports using Power BI, Tableau, or QlikView (2+ years experience)
• Implementing ETL processes and data warehousing concepts (2+ years experience)
• Performing statistical analysis and forecasting (2+ years experience)
• ERP/project management systems experience with SAP, Oracle, Primavera P6, or Microsoft Project (2+ years experience)

Benefits

• Comprehensive and competitive benefits program including medical, dental, and vision plan offerings.
• Income-protection programs to financially assist in case of injury or illness.
• 401(k)-retirement savings plan.
• Competitive paid time-off programs and paid holidays.

Schedule

Standard Work Hours: 40 hrs/week, Mon-Fri, 8:30 a.m. - 5:30 p.m.