Business Systems Analyst

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.