Document data sources, definitions, import procedures, and permissions policies
Plan, organize, and put security measures in place to protect data against damage, modification, or disclosure caused by accident or unauthorized people
Recognize data patterns, connections, and important signs that point to sound guidance
Enhance data discoveries through researching through dialogue or other methods
Take charge of every element of data collection and administration
Serve users across the whole organization by gathering, reviewing, and purifying data from multiple sources to provide a single source of truth.
Conduct in-depth analysis to assist decision-making and find chances to increase profits
Work together as a cross-functional team to uphold effective business procedures
To enable precise, quick, and proactive information-based decision-making, combine a strong business sense with honed data manipulation skills
Give evidence to support actionable insights regarding sales activity, the efficiency of processes, and the achievement of KPI targets and outside standards.
Utilize data to your advantage to help grow the business
With relevant parties, discuss findings and suggestions from datasets
Create, deploy, and maintain dashboards to support strategic objectives
Take charge of reporting and analysis on a regular and as-needed basis
Guide and instruct staff on BI tools and best practices to improve the use of data in their work by preparing regular written reports and presentations for leadership
Audit, update, and clean up master data files in ERP on a regular basis, paying specific attention to product data and price
Maintain and import data into MS SQL Server
Utilize specialized reporting tools to retrieve data from the ERP system
Gather master and transactional data for every aspect of the company, including product management, sales and customer activity, finances, expenses, commissions, and human resources
Request and discuss vendor-supplied data directly with vendors
Coordinate data-gathering techniques and criteria to provide consistency, integrity, and control
Examine user requests for database enhancements to determine how much time and money will be needed
Maintain the performance and integrity of current databases, in particular via systematic audits and comparisons to reference systems
Act quickly to alert users and fix identified data quality issues
Create and maintain collaborative worksheets and other tools to make it easier for users to manually enter data
Prioritize work by meeting deadlines and handling many projects
Own assigned tasks and act with a high degree of accountability
Support the maintenance and assistance of ERP systems
Control and keep track of automated file sharing and posting extracts for both internal and external users
Accomplish set goals by keeping an active grasp of the product line and how the organization is structured
Job Requirements:
Bachelor s/Master s degree in Engineering, Computer Science (or equivalent experience)
At least 3+ years of relevant experience as a data engineer
Prolific experience working with SQL, VBA, and PowerShell Scripting
2+ years of experience performing advanced manipulations of large data sets
Thorough knowledge of data warehousing ideas and techniques
Strong technical writing abilities and understanding of supply chain management
Nice to have some understanding of business intelligence tools
Familiarity with AWS, Excel, and Data Analysis is desirable
Nice to have some knowledge of Excel VBA and Microsoft Office
Must be a self-starter who thrives in a fast-paced atmosphere and who is detail-oriented
Proven ability for achieving success through and with people
Ability to effectively explain difficult information in writing and verbally
Be able to work iteratively and with comfort
Possess the capacity to query and troubleshoot data, and be dedicated to lifelong learning and development
Must be motivated and analytical
High level of familiarity with using quantitative data to promote a viewpoint
Excellent written and verbal English communication skills