Solution Architect, Data & Analytics in Preston

WHO WE ARE
We’re Talking Rain Beverage Company, we create better-for-you beverages featuring great flavors and colors from natural sources. We live life in full flavor and believe the world should too. We create connections with every sip of our iconic Sparkling Ice, Sparkling Ice Caffeine, Sparkling Ice Energy, Popwell and MIXT. When it comes to success, we know we’re only as strong as our team. That’s why we’re an equal-opportunity employer. We value diversity and practice inclusivity, hiring great people who enhance our company.

WHAT YOU'LL DO
Data is more than stats to our Business Transformation team—it’s a story waiting to be told. They translate the details into solutions and strategy, driving us forward. In this role, you’ll be at the forefront of designing and implementing cutting-edge data solutions that drive our business to new heights. You'll collaborate with teams across the company, ensuring our data infrastructure is top-notch, scalable, and secure. As a data visionary, you'll architect robust systems that transform raw data into actionable insights, fueling our innovative marketing strategies and operational excellence. Your expertise in data integration, warehousing, and advanced analytics will empower us to predict trends, optimize performance, and deliver exceptional customer experiences.

Responsibilities:

• Collaborate with senior-level stakeholders to understand business requirements and design comprehensive data & analytics solutions and provide solution recommendations and improvements to leadership.
• Architect and lead the overall end-to-end design and implementation of Data & Analytics Solutions, leveraging the breadth of Microsoft Fabric and Azure services.
• Evaluate and recommend tools and technologies to support data processing and analytics initiatives.
• Lead schema design and data modeling, ensuring robust data schemas and models that support business requirements and ensure data integrity and performance.
• Partner with other IT team members to monitor and enforce data governance policies, ensuring data accuracy, consistency, and security.
• Contribute to the scaling, optimization, enhancement and rationalization of data & analytics solutions.
• Support the development of highly performant and robust data transformation pipelines.
• Help develop highly interactive and visually appealing dashboards and reports using BI tools to communicate findings, data insights and Key Performance Indicators to various organizational stakeholders.
• Understand & lead team in execution of business intelligence best practices in reporting and data modeling.
• Provide technical leadership and mentorship to other members of the team.
• Ensure food safety, quality, and SQF practices are always followed, advising your immediate manager of any food safety and/or quality issues.
• Complete other responsibilities as assigned.

We create connections with every sip. And we’ve found a lot of value in in-person connections! As a young, fast-growing company, we’re still creating and refining the systems that will fuel our future growth. Onsite presence is beyond collaboration, and here is why onsite presence matters:

• Accelerates process building - Being onsite lets teams test, adjust, and lock in new processes in real time, partnering closely with multiple teams to ensure they are efficient and scalable.
• Enables richer, faster feedback loops – Real-time observation and discussion with Rain Makers across departments help us spot gaps, adapt processes, and improve outcomes immediately.

WHAT YOU BRING

• 6+ years of Data Analyst and/or Business Intelligence experience.
• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field; equivalent experience accepted.
• Proven experience with cloud services with emphasis on Data and BI focused solutions.
• In-depth knowledge of Fabric and Power BI, including advanced data modeling, analysis, and visualization techniques.
• Strong project management skills, with experience in agile development methodologies.
• 4+ years of SQL experience.
• 2+ years interacting with or creating ETLs.
• Proficiency with the Microsoft Office suite (e.g., Outlook, PowerPoint, Excel).
• Refined communication skills, with the ability to speak both to technical engineers and executive stakeholders.

WHAT WE OFFER
Nothing makes a great job even better than throwing in a few perks! All regular, full-time Rain Makers are equipped with everything they need to maintain their health and well-being. That means things like:

• Three Weeks of Vacation per calendar year. And that’s just to start! Spend some time with us, and you’ll accrue an additional week every few years, depending on your exempt status!
• FMLA qualifying Rain Makers receive six weeks of paid parental leave. Parents get to spend time at home bonding with their new addition (whether it arrives by birth, fostering, or adoption).
• Flexibility Stipend. For eligible Rain Makers, spend this extra monthly stipend as you wish, but know it’s intended to contribute to things like your phone, internet or other business uses while working remotely or needs outside of normal working hours.
• Relocation Available (when available)
• Onsite and Hybrid Rain Makers: Get paid to carpool! Drive to work with another Rain Maker every week at least 2X a week and receive mileage reimbursement.
• 401k with Immediate Vesting. With matched contributions and investment customization, we'll help build a plan to reach your goals.
• Fitness Reimbursements. We provide reimbursements for community events and competitions like fun runs, triathlons, and cycling tours.
• Medical/Dental/Vision. Our plans are excellent and flexible to your needs. And one is even free for our Rain Makers!