POSITION SUMMARY

The hire will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow, collection, modeling, and visualizations for cross functional teams. This position will serve as a data pipeline builder and data wrangler responsible for optimizing data systems and building them from the ground up. The position will support our software developers, report developers, data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.

--------------------------------------------------------------------------------

ESSENTIAL FUNCTIONS

Reasonable Accommodations Statement

To accomplish this job successfully, an individual must be able to perform, with or without reasonable accommodation, each essential function satisfactorily. Reasonable accommodations may be made to help enable qualified individuals with disabilities to perform the essential functions.

Essential Functions Statement(s)

• Assemble large, complex data sets that meet functional / non-functional business requirements.
  
• Build, support and maintain the data infrastructure / services required to transform, compile, mine and stitch data together from a wide variety of data repositories such as the company's ERP systems, Data Warehouse and BI Applications while developing new modeling techniques and tools for analytics and reporting.
  
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, performance, etc.
  
• Build analytics tools that utilize data technologies to provide actionable insights into our customers, products, performance, processes, and other key business performance metrics.
  
• Work with stakeholders, internal / external teams to assist with data-related technical issues and support their data infrastructure / service needs.
  
• Develop a data strategy, build alignment, and execute on a data management process for key systems for proper retention, purging and access
  
• Promotes and consults on data management, governance, and data quality of data requirements with other functional data owners to ensure data integrity across the operation of systems are consistent and meets stated business rules and requirements.
  
• Design and execute analytic projects; generate insights to support business decisions using advanced analytical and visualization techniques such as descriptive, predictive, and prescriptive analytics.
  
• Build high-performance algorithms, predictive models, and prototypes.
  

POSITION QUALIFICATIONS

Competency Statement(s)

• Accountability - Ability to complete assigned tasks with little oversight and is willing to accept personal responsibility for work and results.
  
• Analytical Skills - Ability to use thinking and reasoning to solve a problem.
  
• Adaptability - Ability to adapt to change in the workplace.
  
• Business Acumen - Ability to grasp and understand business concepts and issues.
  
• Communication Skills - Ability to effectively communicate (both verbally and in writing) with others either individually or in a group setting.
  
• Customer Oriented - Ability to take care of the customers' needs while following company policies and procedures.
  
• Integrity - Ability to be truthful and be seen as credible in the workplace.
  
• Innovative - Ability to look beyond the standard solutions.
  
• Management Skills - Ability to organize and direct oneself and effectively supervise others.
  
• Intent - Ability to collaborate and wants what's best for everyone involved.
  
• Relationship Building - Ability to effectively build relationships with internal/external customers and co-workers.
  
• Leadership - Ability to influence others to perform their jobs effectively and to be responsible for making decisions.
  
• Problem Solving - Ability to find a solution for or to deal proactively with work-related problems.
  
• Technical Aptitude - Ability to comprehend complex technical topics and specialized information.
  

SKILLS & ABILITIES

Education: Bachelor's Degree in Information Technology or related field or equivalent work experience.

Experience: 3+ years background in data warehouse design (e.g. dimensional modeling) and data mining, MS Power BI modelling, Dax, data storytelling, report publishing, security and knowledge of how people make decisions with data

Skills: Candidate will have strong business acumen, able to work in cross-functional teams and Agile experience. Must be able to adapt to changing business needs, learn new coding languages and develop using Microsoft SQL Business Intelligence platforms (SQL Server, TSQL, SSAS, SSIS, SSRS), Microsoft Power Platform (Power Apps, Automate, Power BI, Power AI) experience preferred. Working experience in Azure cloud services, Azure automation, Azure data lake, webapps, Logic Apps, APIs, and etc. also a plus. Requires minimum of 3 years database, SQL and Power BI experience. Must be proficient with Microsoft Office Suite, including Access and pivot tables. Knowledge of Microsoft Dynamics 365, Dataverse (Common Data Service) and Microsoft Office 365 Platforms preferred. Knowledge of working with and building Azure Machine Learning models or solutions as plus.

Certifications & Licenses: Valid Driver's License or demonstrable ability to gain access to worksites. Experience in Lean Six Sigma preferred.

Other Requirements: Knowledge of: Microsoft based software applications, desktop and server operating systems. Skill in: project management, problem solving, troubleshooting, organizing work flow and processes; internal customer service. Ability to: work quickly and efficiently; train, coach, develop; multi-task; communicate effectively with internal customers and vendors; develop good working relationships. Other functions, skills and abilities may also apply. Skills in managing and leading a team preferred.

Diversity has power. It's an investment in our present and our future. That's why we celebrate and respect the rich culture and differences of our employees, customers, business partners, and communities we serve.

At G&J Pepsi, employment decisions are made without regard to: race, color, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, protected veteran status or other characteristics protected by law.