Project Engineering Operations Data Analyst
Dematic · Guadalupe, Mexico ·
- Category
- Data analytics
We offer:
Career Development
Competitive Compensation and Benefit
Pay Transparency
Global Opportunities
Learn More Here:
Dematic provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
The base pay range for this role is estimated to be $ - $ at the time of posting. Final compensation will be determined by various factors such as work location, education, experience, knowledge, and skills.
Tasks and Qualifications:
What You Will Do In This Role:
Maintenance of existing Project Engineering Power BI Reports. This includes about 50 existing reports that need occasional maintenance including bug fix, linking/refresh to snowflake data tables, and troubleshooting the validity of displayed data.
Modify existing reports based on user requested enhancements. This may include feature control such as additional filters or complete layout redesign to help provide improved user interface or ease of use.
Creation of new PE Reports (Power BI or equivalent). Work with PE team users to determine functional requirements and develop new reports or data visualization based on snowflake tables and other databases as necessary to match data elements. This includes leading a regular meeting to discuss changes with key stakeholders.
Act as subject matter expert on the PE Power BI reporting space including refresh or update timestamps and revision control as required. Review report usage statistics to recommend report replacement or deletion. Review overall reporting structure and hierarchy for simplification. Provide training as necessary, usually over Teams while sharing screen.
Provide offline analysis of data to identify trends or exceptions as requested. This may be ad-hoc reporting (usually in excel) or in support of established reporting/dashboarding in Power BI.
Identify & resolve complex problems through the application of problem-solving and data analysis skills. Provide data driven insights to enable decision making.
Understand primary data sources (SAP, PWA, etc) for PE reporting needs and how they are used by key stakeholders. This allows for better understanding of business insights needed and if reporting outputs are valid.
What We Are Looking for:
Bachelor’s degree in engineering, Technology, or Computer Science.
Strong familiarity with Microsoft Power BI or similar visualization & dashboarding tool
Familiarity with SQL, query design, and relational database models
Familiarity with SAP
Expert-level skill with Microsoft Excel
Extensive experience with data cleansing, preparation, manipulation & analysis
Confident in using data to support decision making using sound analytical approaches
Strong verbal & written communication skills
Eager to grow technical and analytical skills in a fast-paced environment
Advanced degree a plus
Experience as a Power BI developer or equivalent
Experience with SQL queries and Snowflake
Experience with SAP Analytics Cloud
Python experience with automation and data preparation
Applicants must be authorized to work for any employer in the United States. We are unable to sponsor or take over sponsorship of an employment Visa now or in the future.
#LI-RW1