Job Description
Job Description:
The History of Foley Family Wines & Spirits
In spring of 1996, Bill & Carol Foley purchased 1,000 acres of lush and fertile earth within the then relatively unknown Sta. Rita Hills region of Santa Barbara County. Their plan – produce hand-crafted Chardonnay and Pinot Noir that reflected the best of California’s Central Coast. Named for their two daughters – Lindsey & Courtney – Lincourt Vineyards was born, and with it, the beginning of Foley Family Wines & Spirits.
In the 25 years since, Foley Family Wines & Spirits has grown into one of the world’s largest producers of fine wine, adding some of the industry’s most valuable wineries, located in the most recognized winemaking regions, including Napa, Sonoma, the Pacific Northwest, and New Zealand. Today, the Foley Family Wines & Spirits portfolio boasts a number of the most-celebrated names in wine, including Chalk Hill Estate, Chalone, Ferrari-Carano, and Sebastiani.
Job Summary:
FFWS is seeking an experienced Sr. Business Intelligence Analyst to design, develop, and maintain business intelligence solutions. The ideal candidate will have strong data modeling, reporting, and dashboarding expertise using Power BI and Power Apps. You will work closely with various departments to transform data into actionable insights and provide management with the tools to make data-driven decisions.
The ideal candidate will have a strong work ethic and can-do attitude and be comfortable tackling any challenge. We provide significant flexibility and autonomy to team members, have high expectations, and expect everyone to contribute meaningfully to our broader collective goals.
**This is a Remote position that can be located anywhere in the U.S.**
Roles and Responsibilities:
• Write Extract-Transform-Load (ETL) and SQL jobs to build out desired outputs for reporting and dashboards.
• Implement and document ETL processes for data preparation and transformation.
• Develop and maintain robust data models that support business intelligence reports and dashboards.
• Build out any new connectors needed to bring in new reporting, connections varying from SFTP, API, Email, or custom connection.
• Design, develop, and maintain Power BI dashboards and reports that provide insights into key performance indicators and operational trends.
• Optimize existing Power BI reports and dashboards for performance and usability.
• Ensure data accuracy, quality, and integrity in BI reporting.
• Train and support end-users in utilizing Power BI reports and dashboards effectively.
• Work cross-functionally with IT, data analytics, and business teams to improve data reporting and visualization strategies.
• Support the current BI environment on SQL Server and Targit.
• Stay apprised of current and new functionality and/or metrics of digital platforms.
• The corporate office is located in Santa Rosa, CA. Occasional travel to this location will be required, based on business need.
Knowledge, Skills & Abilities:
• Experience in creating enterprise-level BI platforms using Microsoft technologies.
• Experience with SQL and ETL dataflows.
• Experience writing SQL or other programming languages.
• Excellent communication skills – both written and verbal.
• Effective organizational skills with strong attention to detail, collaborative.
• Stay updated on Power BI features and functionalities and implement best practices for reporting and dashboarding.
• Team player with an entrepreneurial mindset.
Experience & Qualifications:
• Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related field.
• 5+ years of experience in Business Intelligence or Data Analytics roles.
• Strong experience with Power BI for data modeling, reporting, and dashboard development.
• Proficiency in DAX (Data Analysis Expressions) and Power Query.
• Experience with SQL for querying and managing large datasets.
• Knowledge of data warehousing concepts and ETL processes.
• Strong analytical and problem-solving skills.
• Ability to work with diverse teams and effectively communicate complex concepts to technical and non-technical audiences.
Company Core Values:
Teamwork – Be a Spirited Partner
Commitment – Crush Every Day
Quality – Good vs. Grape: It’s All in The Details
Integrity – It Takes a Community
Safety – Tend the Vines
Entrepreneurship – Love the Wine You’re With
Fun! - Smile! You Have Purple Teeth!
Foley Family Wines & Spirits provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, sexual orientation, gender identity, veteran status or any other characteristic protected under federal, state or local law.
Create a Job Alert
Receive an email alert when similar new jobs are posted. It's free, fast and easy.
Create Alert
Job Tags
Full time, Local area, Remote job,