Description

Wiese USA has an immediate opening for a Business Intelligence – Data Engineer based out of our corporate office in Olivette, MO. In this role, we are seeking a customer-minded technologist who is comfortable with driving change. Adaptable individual must be a problem solver, with proven ability to operate and deliver in a fast-paced, dynamic environment, all the while meeting our Culture and Customer Focused Values. Demonstrated desire to learn and develop professionally are crucial ingredients to this role.

This role will lead efforts to design data integration and governance architecture and ETL jobs, map pertinent fields from the data warehouse to CRM for sales and/or marketing efforts and ensure data accuracy and usability is maintained at the highest of standards. Lead development of new data processes and use of technologies and application development.

Essential Functions

• Create and maintain ETL pipelines from various internal and external data sources to our data warehouse using SQL, Microsoft Azure, Microsoft Access
• Create data warehouse in SQL environments
• Create applications to enhance business processes such as leveraging RFID scanning technology to capture data to create business system work order
• Create data automation processes
• Audit raw data and ETL jobs to run data quality and validation tests; ensure high standards of data hygiene
• Manage CRM campaign creation, workflow, and overall execution of system
• Meet with business stakeholders to understand desired reporting needs and enhancements; build out reporting functionality
• Design, configure, update, test and maintain back-office applications within the CRM environment
• Assist with integrating CRM applications with other enterprise applications, as required
• Build and sustain data acquisition roadmap for pertinent data sources
• Manage relationships with third-party data providers
• Locate and define new process improvement opportunities
• Responsible to be key player in developing and implementing a data strategy and data quality processes for company KPIs and analytics
• Expert knowledge in Data Architecture, Modeling, integration, governance and BI/Analytics principles
• Experience developing BI applications, delivering BI infrastructure and building best practices
• Accountable for major BI projects or common shareable reports across several projects
• Actively researches and develops new knowledge and collaborates on solutions
• Assist in the collection and documentation of user requirements
• Training team members and business users on self-service BI capabilities
• Confident in managing and executing projects cross-functionally with various stakeholders from start to finish

Qualifications

Education and Experience requirements:

8 plus years of experience in Computer Science, MIS, or other relevant business discipline, or an equivalent combination of education and experience. 5 years of BI or Data Engineering experience

Technical Experience

• 3-4 years with hands-on experience equating to expertise and mastery of SQL and similar experience working with relational databases, data warehouses, and CRM systems
• Working knowledge of Microsoft Access
• Working knowledge of data visualization tools (Power BI preferred) for internal reporting is a plus
• In-depth understanding of sales, marketing, business processes, and how they relate to the business software
• Strong analytic skills related to working with unstructured datasets, API data extraction and web scraping applications
• Strong critical thinking, analytical and problem-solving skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Advanced knowledge of BI tools for data analytics, visualization and reporting
• Advanced knowledge of Data Modeling. Ability to assimilate requirements into conceptual/logical data models across information management solutions (relational, Dimensional/Columnar, document)
• Strong knowledge of Agile Methodologies
• Advanced knowledge of best practices and standards for BI development

• Advanced Data Integration and Architecture Experience
• Microsoft Dynamics 365 Experience (CRM) is a plus

Soft Skills

• Manages complexity to effectively find solutions and solves problems
• Drives results by consistently achieving completion and closure of tasks, even the face of obstacles and setbacks
• Adaptive personality and ability to function in a fast-paced environment
• A problem-solving attitude that can adapt to varying timelines
• Strong interpersonal skills; promoting healthy relationships and team dynamics
• Manages the team effectively and enacts situational leadership
• Strong attention to detail to plan and align work with regards to sense of urgency and priority
• Strong capability to provide Business Insight
• Strong ability to influence organization stakeholders
• Has leadership understanding and influence with business customers
• Coaches and mentors both technical and business staff on information solutions
• Communicates in a clear, concise and timely manner and operates effectively as a team player
• Highly organized; able to organize and assimilate large quantities of complex information
• Strong executive presence and presentation skills and Experience presenting to senior-level leadership or other decision makers to present and sell ideas to various audiences (technical and non-technical)
• Resourceful with a strong work ethic and are willing to go the extra mile to get work done
• Must be comfortable with changing requirements and priorities
• Must be results oriented and ability to move forward without complete information