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

Job Title

Construction Project Business Intelligence Analyst #0802

Statement about position/company:

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.

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.

Minimum Qualifications/Requirements:

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.

Technical Skills:

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

Physical Requirements:

• 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 programs to financially assist you should you experience an injury or illness, and a 401(k)-retirement savings plan to help you secure your financial future. TSMC also offers competitive paid time-off programs and paid holidays allowing you to recharge and spend time with your family and loved ones.

Work Location:

5088 W. Innovation Circle, Phoenix, AZ 85083

TSMC is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected characteristic. We encourage all qualified individuals to apply, and we welcome applications from individuals with diverse backgrounds and experiences. Candidates must be able to perform the essential functions of the job with or without a reasonable accommodation. If you need a reasonable accommodation as part of this application process, please contact [email protected]. Requisition 0802