BI Data Engineer II

Job Description

We are currently hiring a BI Data Engineer II in Boston, MA (Hybrid).

This is a great role on a team that is transforming Business Intelligence technology at Boston Beer. The Data Engineer II is a technical role with SQL Server and Azure cloud data technology at its core and has ample opportunity for technical growth as we move from traditional data technologies to cloud data architecture. As Boston Beer takes on new challenges in areas like supply chain and digital, this role will be highly involved in ensuring our data platform is scalable, performant, and ready for the future.

Working within the Boston-based Business Intelligence team, this role is responsible for various database activities all centered on delivering impactful Business Intelligence solutions and maintaining and improving our database systems. This is a multi-faceted role that includes technical analysis, design, development, testing and maintenance as well as user interaction including requirements gathering, training, etc. This role will work on our on-premises SQL data warehouse platform and helping to build out the data platform of the future in Azure.

What You'll Brew:

• Build out and migration to cloud data technologies, which may include (but not limited to) Azure ADLS, Apache Spark, Azure Synapse, Azure Data Factory, Python.
• Performance tuning and testing of BI structures and processes
• Participation in the design of data models to house and deliver essential reporting
• Consultation with other IT personnel to perform essential analysis on source data
• Collaborate with BI Team members and key BI power users on specific data designs and intended use.
• Collaborate on requirements definition, design, and build out of key data warehousing and integration deliverables for Supply Chain, Brand Insights, Digital, Sales and other areas.
• Occasional production support responsibilities
• This role may also be involved in data preparation and modeling using the Power BI
• Maintenance and extension of our SQL server jobs and Azure jobs to update datasets
• Partner with the BI team to promote and evolve design, development, and testing standards
• Adhere to IT department policies and procedures when performing tasks to ensure controls are in place and departmental goals are met
• Adhere to standards for testing, documentation, and change management

What Ingredients You'll Bring:

Minimum Requirements

• Bachelor’s degree in Computer Science, or a closely related field, or the equivalent
• 4+ years in a data integration or data warehouse development role, preferably in a Microsoft environment
• 3+ years working with Azure cloud data technologies including migration, integration, and design

Preferred Requirements

• Databricks experience is a plus.
• MuleSoft, SAP Hana data experience helpful
• SQL Server, SSIS experience is a plus
• Powershell experience is a plus.
• Knowledge of AWS is a plus.

Some Perks:

Our people are our most important “ingredient.” We hire the best talent; and we reward, develop, and retain them too.

In addition to generous healthcare on day one, stock purchase plan, 401k and more, Full Time Boston Beer Coworkers have the following perks available*:

• Tuition reimbursement
• Fertility/adoption support
• Free financial coaching
• Health & wellness program and discounts
• Professional development & training
• Free beer!
• Talk to your recruiter about eligibility

Boston Beer Corporation is an equal opportunity employer and is committed to a diverse workforce. In order to help ensure reasonable accommodation for individuals protected by Section 503 of the Rehabilitation Act of 1973, the Vietnam Veteran’s Readjustment Act of 1974, and Title I of the Americans with Disabilities Act of 1990, applicants who wish to request accommodation in the job application process can contact [email protected] for assistance.