What are the responsibilities and job description for the Data Analyst 3 position at ektello?
Sr. Data & Reporting Analyst
Location: Santa Ana, CA, USA
Top Skills: SQL, Power BI, SAP
(Korean Bilingual not required but is a plus)
Top 4 Things To Focus On
The Sr. Data & Reporting Analyst is responsible for all points of data mining, extraction, manipulation, analysis, and reporting. Accountable for developing and reporting daily, weekly and monthly analysis of key performance indicators related to warehouse operational metrics. This position requires an extremely detailed, timely, consistent and accurate approach to reporting. Having strong written and verbal communication skills are critical to succeed in this position as senior management team will be the targeted audiences for the reports and analysis performed by this position. Reporting can also be used to set the priorities throughout the operations, ensuring that key issues are addressed. Daily/weekly briefings and communications are needed to ensure consistent information is shared throughout the operations. This position is a task-oriented role, requiring very good organizational skills and follow through. The position requires interaction with a broad number of employees to validate data and collaborate on discrepancies found. This position is a key role in the critical analysis of costs associated with the logistics warehouse and transportation operations & cost. This position is also responsible for supporting improvement opportunities throughout the organization, for monitoring discrepancies and escalating to appropriate parties.
In order to meet daily responsibilities, the candidate must be proficient with SAP, MS Excel, SQL, PowerPoint; and, must have experience developing dashboards using BI Tools.
Required Knowledge, Education And Experience
Beeline Summary
The main function of the Data Analyst is to provide business intelligence support and supporting areas by means of both repeatable and ad hoc reporting delivery reports (charts, graphs, tables, etc) that enable informed business decisions.
Job Responsibilities
Analyzes performance of process activities, identifies problem areas, and presents findings in clear, concise charts, graphs, tables, or summaries.
Establishes standardized methods of recording, tracking and reporting on activity.
Design, implement, automate and maintain large scale enterprise data ETL processes.
Modify existing databases and database management systems and/or direct programmers and analysts to make changes.
Skills
Ability to work as part of a team, as well as work independently or with minimal direction.
Excellent written, presentation, and verbal communication skills.
Demonstrated knowledge of one or more key information service standards such as SDLC, ITIL, QA/testing, Project Management, Six Sigma, etc.
Strong PC skills including knowledge of Microsoft SharePoint.
Education/Experience
Bachelor's degree in a technical field such as computer science, computer engineering or related field required.
5-7 Years Of Experience Required.
Process certification, such as, Six Sigma, CBPP, BPM, ISO 20000, ITIL, CMMI.
Comments
Michael Rapske approved via email
Location: Santa Ana, CA, USA
Top Skills: SQL, Power BI, SAP
(Korean Bilingual not required but is a plus)
Top 4 Things To Focus On
- Experience in logistics, distribution center, warehouse, and/or supply chain environments
- High proficiency in MS Excel, SQL, Access, PowerPoint, and BI Tools
- Proficiency in SAP and WMS (Warehouse Management Systems)
- Report automation & design
The Sr. Data & Reporting Analyst is responsible for all points of data mining, extraction, manipulation, analysis, and reporting. Accountable for developing and reporting daily, weekly and monthly analysis of key performance indicators related to warehouse operational metrics. This position requires an extremely detailed, timely, consistent and accurate approach to reporting. Having strong written and verbal communication skills are critical to succeed in this position as senior management team will be the targeted audiences for the reports and analysis performed by this position. Reporting can also be used to set the priorities throughout the operations, ensuring that key issues are addressed. Daily/weekly briefings and communications are needed to ensure consistent information is shared throughout the operations. This position is a task-oriented role, requiring very good organizational skills and follow through. The position requires interaction with a broad number of employees to validate data and collaborate on discrepancies found. This position is a key role in the critical analysis of costs associated with the logistics warehouse and transportation operations & cost. This position is also responsible for supporting improvement opportunities throughout the organization, for monitoring discrepancies and escalating to appropriate parties.
In order to meet daily responsibilities, the candidate must be proficient with SAP, MS Excel, SQL, PowerPoint; and, must have experience developing dashboards using BI Tools.
Required Knowledge, Education And Experience
- Minimum 3 years of experience in reports and data analysis within logistics, distribution center, warehouse, and/or supply chain environments
- Experience in cost analysis, and reporting of key performance indicators
- High proficiency in MS Excel (40%), SQL (35%), Access, BI Tools, and PowerPoint (25%) is required
- Experience in a logistics, warehouse, and/or supply chain (operations) environment is required
- Experience with SAP is required
- Bachelors Degree in Business Analytics, Engineering, Mathematics, Accounting, or related field
- Results driven and ability to handle multiple projects
- Excellent analytical, decision-making, and problem solving skills
- Strong data mining skills and experience extracting & manipulating data from multiple sources
- Critical thinking skills - analysis, interpretation, inference, explanation, self-regulation, open-mindedness, and problem-solving
- Strong math, communication, and organizational skills
- Excellent attention to detail
- Must be comfortable working in a multi-cultural business environment
- Strong verbal and written communications skills
- Ability to employ effective time management skills
- Independently follow and execute work assignments
- Must be able to work without supervision; self-starter
- Ability to interact with all levels of management including executives
- Performs work under time schedules and stresses which are normally periodic or cyclical, including time sensitive job stress, intellectual challenge, constant technical data feedback, and language barriers.
- Data & business analysis
- Data mining & extraction from multiple sources to build reports
- Daily, weekly, monthly report generation
- Report automation & design
- Maintaining existing dashboards; weekly & monthly analysis and reporting
- Help drive critical business decisions by in depth analysis; provide recommendations based on findings
- Develop models that help with decision-making
- Identify opportunities for performance improvement
- Publish standard and complex ad-hoc reports with varying detail for different audiences
- Data Accuracy - 99 % achievement rate
- Timely Report Generation - 99 % achievement rate
- Objective, simple presentation of data - 99 % achievement rate
Beeline Summary
The main function of the Data Analyst is to provide business intelligence support and supporting areas by means of both repeatable and ad hoc reporting delivery reports (charts, graphs, tables, etc) that enable informed business decisions.
Job Responsibilities
Analyzes performance of process activities, identifies problem areas, and presents findings in clear, concise charts, graphs, tables, or summaries.
Establishes standardized methods of recording, tracking and reporting on activity.
Design, implement, automate and maintain large scale enterprise data ETL processes.
Modify existing databases and database management systems and/or direct programmers and analysts to make changes.
Skills
Ability to work as part of a team, as well as work independently or with minimal direction.
Excellent written, presentation, and verbal communication skills.
Demonstrated knowledge of one or more key information service standards such as SDLC, ITIL, QA/testing, Project Management, Six Sigma, etc.
Strong PC skills including knowledge of Microsoft SharePoint.
Education/Experience
Bachelor's degree in a technical field such as computer science, computer engineering or related field required.
5-7 Years Of Experience Required.
Process certification, such as, Six Sigma, CBPP, BPM, ISO 20000, ITIL, CMMI.
Comments
Michael Rapske approved via email