Business Systems Analyst

Foxconn Industrial Internet - FII; Houston (TX); On-site; USD 85,000 - 110,000; Full time

Job summary

Foxconn Industrial Internet - FII is seeking a business systems analyst in Houston, Texas. The ideal candidate will have over 3 years of experience in project management and business systems analysis, along with skills in SQL, Tableau, and ETL tools. Responsibilities include managing project schedules, gathering user needs, leading testing efforts, and resolving data-related issues. A Bachelor's degree in relevant fields is required. Join a dynamic team and contribute to a cutting-edge data platform.

Qualifications

• 3+ years of experience as a project manager.
• 3+ years of experience as a business systems analyst.
• Excellent organizational and interpersonal skills.
• Ability to manage multiple tasks and projects.

Responsibilities

• Manage project schedule and costs.
• Gather user needs and clarify requirements.
• Discuss design feasibility and manage UI design.
• Lead testing efforts such as QA and UAT.
• Help resolve dashboard performance and server issues.

Skills

Project Management

Business Systems Analysis

ETL Tools (Alteryx)

SQL

Data Visualization (Tableau)

API Integration

Communication Skills

Problem-Solving

Data Development Projects

Teamwork

Education

Bachelor’s degree in Business Analytics/Engineering/MIS/IT/Computer Science

Tools

Tableau

Git Repositories (GITLAB)

JIRA

HTML5/CSS3/JavaScript

Python

Kafka

Spark

Job description

Job Summary

Foxconn Houston has several Lighthouse Factory plants manufacturing servers and server cabinets. The company is currently setting up the North American arm of the company-wide data platform team. The team is hiring a dedicated business systems analyst with project management experience to:

• manage project schedule and control project costs
• capture and analyze user needs, system requirements and business processes
• translate user needs into functional and technical specifications
• complete QA testing of dashboards
• lead acceptance testing with users
• co-work with frontend data analysts, backend data engineers and full-stack data analytics engineers to provide frontend Tableau dashboards and backend data pipelines with high quality on-time.
• Handle exceptions by identifying the cause and resolving the problem

This business systems analyst will collaborate with the team lead, data analyst, data engineer and data analytics engineers to make sure that data pipeline effectively supplies quality data to Tableau dashboards for the end users in a timely manner. The business systems analyst will create, manage and maintain the SRS, Systems Requirements Specs, documents. This role will manage data platform project scopes, timelines, roadblocks and costs alongside the team lead.

Responsibilities

• 20% Manage project schedule and cost
• 25% Gather user needs and clarification of user requirements
• 25% Discuss design feasibility, design dashboard UI and manage requirements document
• 20% Lead testing efforts such as QA and UAT
• 10% Help resolve dashboard performance, pipeline and server issues as the contact for end users

Skills / Qualifications

• Experience working as a project manager for 3+ years.
• Experience working as a business systems analyst for 3+ years.
• Experience with Alteryx or other ETL tools.
• Experience with SQL, Database, Data Warehouse and Data Lake.
• Experience with Tableau or other data visualization tools and Excel.
• Experience with backend API integration.
• Excellent communication, organization, and interpersonal skills.
• Experience leading data development projects.
• Excellent problem-solving skills with extreme attention to detail.
• Outstanding work ethic and commitment to individual and organizational success.
• Excellent analytical and advanced troubleshooting skills with end-users/clients.
• Ability to manage multiple tasks and projects, both independently and as part of a team.
• Demonstrated ability to learn new things and continuously drive process improvement.

Plus/Desired

• Native speaking in Chinese Mandarin with ability to read the language and work in a professional setting.
• Familiar with electronics manufacturing industry domain know-how.
• Experience with Git Repositories (GITLAB) or JIRA
• Experience with HTML5, CSS3, JavaScript and use front-end code debugging tools such as Chrome.
• Experience with ETL tool programing, debugging, maintenance, and monitoring to ensure data ingestion, cleansing, and loading.
• Experience with Big Data, Python, Kafka and Spark programing, debugging, maintenance, and monitoring.
• Experience with data warehouse modeling and standardization.
• Experience with system automated code CI/CD.
• Proficiency in Big Data Tools: Hadoop, Kudu, Hive, Kafka, Spark and/or Flink.
• Database development using Kudu 1.10.0 and higher, or Hive 2.1.1 and higher.

Educational Requirements

• Bachelor’s degree in Business Analytics/Engineering/MIS/IT/Computer Science or related fields.