Описание вакансии
DUTIES and RESPONSIBILITIES:
- Transform complex and large datasets accurately into an operational format that can be used in conjunction with existing tools.
- Collect business requirements from Sales, Project Management, and Production.
- Collect and process customer project files and information, including PDF’s, Excel Documents, Text Files, and MIS / ERP System Data.
- Analyze structured and unstructured data for consistency and production readiness.
- Extract, transform, and load business data for standard and AdHoc analysis, reports, and documents.
- Develop and plan to ensure a high level of information accuracy and quality for all facets of the job, including change control and validations.
SKILLS AND KNOWLEDGE:
- University Degree
- Must have expert (2+ years) of Microsoft Excel experience, including advanced applications of Macros, Functions, Pivots, and Data Connection. Experience with PowerQuery and PowerPivot preferred.
- Some experience with Relational Databases (SQL Server) and Business Intelligence Tools is preferred.
- Excellent communication, interpersonal skills, team skills and capacity to communicate within all levels of the organization.
- Ability to manage multiple concurrent projects with firm deadlines.
- Ability to work with some ambiguity, identify and create solutions with minimal guidance
- Ability to read and understand oral/written instructions.
- Ability to write clear concise technical instructions in job ticket for all areas of production.
- Math skills including addition, subtraction, multiplication and division of whole numbers and fractions.