Data Engineer

There's Always a Seat at Our Bar
The Lagunitas Brewing Company began on a kitchen stove in Northern California in 1993 and has always looked to the future - whether supporting local communities by turning beer into money for the cause, or fueling stories, songs, and experiences with our IPA. Wherever you go: Beer Speaks, People Mumble.
What You'll Get

• Benefits - Awesome coverage for: Medical, Dental & Vision
• Time off - Approx 33 days off in your first year (combo of vacay, holidays and personal days)
• Retirement - up to 5% contribution on 401K plan
• BEER - and non-alcoholic Lagunitas beverages
• Schwag - 50% off food and merch
• Gym Membership - $50 monthly reimbursement for that beer belly (or at least to prevent it)
• Pet Insurance - keep your fur babies covered with pet insurance options
• Skills to Pay the Bills - professional development, 24/7 operation
• Opportunities - Expand your horizons in CA, Chicago . . . the world!
• It's Friday, Ya'll - Get Paidevery other Friday, starting at: $95,894-$107,881

The Gist
The mission of the Data & Analytics team is to lead Lagunitas into becoming a data-driven company and the best-connected brewer. As a team, we cultivate a data-driven entrepreneurial culture to the rest of the organization. We act as an incubator for smart data products and problem-solving business intelligence in all areas of business - from sales to logistics, and from marketing to finance. The Data & Analytics team is a multi-disciplined team that works pro-actively and solution-oriented to not only resolve issues, but more importantly to identify business opportunities.
Our team consists of Data Engineers, PowerBI developers and an Architect. As Data Engineer, you will have the following key responsibilities:
What You'll Do
About the Role:

• Team coordination: Coordinate a team of (external) Data Engineers and PowerBI developers, fostering a collaborative and high-performance culture.
• The D&A team is a multi-disciplined team, which means that you support the team where needed in every aspect of the team responsibilities.
• Work in an agile team with full responsibility to develop, maintain and support data products and applications in production environment.
• Deliver against Lagunitas data & analytics roadmap in alignment with Lagunitas strategic business plan.
• Keep up to date with Heineken, industry, and competitor trends.
• Support with data quality, data audit and data security activities that include routine reviews and reporting of technology policies and security compliance while sharing with data stewards to ensure implementation in the business functions.
• Provide input for architectural design and best practices for the implementation and data integration and data presentation layers throughout business units and across the organization.
• Actively support the business solutions managers in partnering with key / leadership-level stakeholders in identifying business opportunities with data.

Data Engineering:

• Design, implement and manage data solutions on the Microsoft Azure cloud platform. You will own the creation and maintenance of the data warehouse, data pipelines, data processing, and data integration to enable data-driven decision-making.
• Create, adjust, and propose SQL queries for new or changed reporting needs.
• Evaluate and optimize data models to meet performance and scalability requirements.
• Perform data modeling sessions with subject-matter experts from regional and global hubs.
• Coordinate functional and technical discussions and communicate effectively with a variety of audiences, moving between providing functional/technical design details and sharing how an information and data design would enhance business capabilities, stability, and supportability.
• Analyze, transform, and organize large and complex datasets ingested from different data sources.
• Maintain a secure data platform in collaboration with infrastructure and (regional or global) security teams.
• Responsible for upholding a high standard of documentation.

Business Intelligence

• Make a difference by helping the business towards a state-of-the-art self-service BI data products to overcome their business challenges.
• Own and embed the standardized Lagunitas reporting lay-out throughout the community of functional data owners.
• Optimize data delivery processes and improve data quality in developed data products.
• Design and build user-friendly repository to boost organized self-service BI.
• Develop Power BI reports, Custom Visuals, group creation, and effective dashboards after gathering and translating end-user requirements.
• Implement role-based security as part of security in Power BI.

What We're Lookin' For
Basic Qualifications/Requirements:

• Bachelor / Master degree in computer science, engineering or relevant field.
• 3-5 years leading Data Engineering and BI capability, with experience of coordinating a team of (external) developers.
• Proven track record of developing and driving a company's BI capability, including PowerBI.
• Proven understanding of data management, data warehouse models, data ingestion and data pipelines.
• Proven understanding of Microsoft Azure Cloud Platform (DataBricks, Data Factory, functions, Logic Apps, etc.)
• Experience with agile way of working.
• Deep understanding of descriptive & diagnostic analytics use cases within FMCG industry
• Familiarity with data visualization, datasets and data flows in PowerBI.
• Proficient in writing complex SQL.
• Experience with Python development.
• Strong project and time management skills.
• Strong communication skills at all levels of the company.
• Ability to work with stakeholders and team members located in different geographies.

Preferred Qualifications
Familiarity with SAP is also a plus.

• Knowledge of basic components and functionalities of Azure ML workspace.
• Knowledge of one or more functional areas such as Commercial Effectiveness, Sales or Supply Chain would be additional benefits.

Come as You Are
At Lagunitas, we welcome people (and dogs) from all walks of life. Anyone, regardless of their race, creed, nation of origin, sexual orientation, gender identity or expression, disability status, veteran status, marital status, or age, has a home here. Love, progress, and acceptance will always have a seat at our bar.