Let’s get started
By clicking ‘Next’, I agree to the Terms of Service
and Privacy Policy
Jobs / Job page
Senior Data Warehouse Engineer image - Rise Careers
Job details

Senior Data Warehouse Engineer

Shearer's is a leading contract manufacturer in the snack industry looking for a Senior Data Warehouse Engineer to design, develop and manage data warehouse solutions with a focus on Power BI integration.

Skills

  • Expertise in Microsoft SQL Server and Power BI.
  • Proficiency in data modeling and ETL processes.
  • Strong analytical and problem-solving skills.
  • Excellent communication and collaboration skills.

Responsibilities

  • Design, develop, and maintain Data Warehouse Solutions.
  • Develop and implement Power BI semantic models, dashboards and reports.
  • Work with stakeholders to define data strategies.
  • Design, program, and manage ETL processes.
  • Ensure data quality and performance optimization.
  • Collaborate with data scientists and analysts.

Education

  • Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.

Benefits

  • Medical, Dental, Vision insurance.
  • Retirement Savings Plan with Match.
  • Short and Long Term Disability.
  • Employee Assistance Plan.
To read the complete job description, please click on the ‘Apply’ button
Shearer's Foods Glassdoor Company Review
3.0 Glassdoor star iconGlassdoor star iconGlassdoor star icon Glassdoor star iconGlassdoor star icon
Shearer's Foods DE&I Review
No rating Glassdoor star iconGlassdoor star iconGlassdoor star iconGlassdoor star iconGlassdoor star icon
CEO of Shearer's Foods
Shearer's Foods CEO photo
Bill Nictakis
Approve of CEO

Average salary estimate

$100000 / YEARLY (est.)
min
max
$80000K
$120000K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

What You Should Know About Senior Data Warehouse Engineer, Shearer's Foods

Join the Shearer's team as a Senior Data Warehouse Engineer, where you'll play a vital role in shaping our data landscape! Located in Massillon, Ohio, Shearer's is a leader in the snack industry, known for our delicious range of snacks, from kettle cooked potato chips to cookies. As a Senior Data Warehouse Engineer, you'll design, develop, and manage our data warehouse solutions while focusing on integrating Power BI to elevate our business intelligence capabilities. In this hybrid role, you'll create efficient data architectures and models to meet analytics needs, collaborate with teams to ensure data accuracy and compliance, and optimize ETL processes. You'll be responsible for developing actionable dashboards that empower stakeholders with insights. We’re looking for someone with a robust background in SQL, data modeling, and data warehousing concepts, coupled with strong analytical and communication skills. If you possess the ability to lead development teams and are familiar with cloud solutions like Azure, we’d love to meet you! Enjoy a fulfilling career with an inclusive workplace that values your contributions. Plus, our comprehensive benefits package ensures you and your loved ones are taken care of as you contribute to our mission of providing high-quality snacks to North America. If you’re ready to take your career to the next level and make a significant impact at Shearer’s, we invite you to apply now!

Frequently Asked Questions (FAQs) for Senior Data Warehouse Engineer Role at Shearer's Foods
What are the responsibilities of a Senior Data Warehouse Engineer at Shearer's?

As a Senior Data Warehouse Engineer at Shearer's, your responsibilities will primarily include designing, developing, and maintaining our data warehouse solutions. This involves creating efficient data architectures and models, implementing Power BI dashboards and reports for insightful analytics, managing ETL processes, and ensuring data quality and performance optimization. Collaboration with cross-functional teams will also be vital to understand their data needs and deliver effective solutions.

Join Rise to see the full answer
What qualifications are required for the Senior Data Warehouse Engineer position at Shearer's?

To qualify for the Senior Data Warehouse Engineer role at Shearer's, you should have a Bachelor's or Master's degree in Computer Science, Information Technology, or a related field, along with 5-10 years of progressive experience in data modeling and engineering. Proficiency in SQL, Power BI, and data warehousing concepts is essential, while familiarity with Azure-based solutions and best practices is preferred.

Join Rise to see the full answer
How does Shearer's use Power BI in the Senior Data Warehouse Engineer role?

At Shearer's, Power BI plays a crucial role in our business intelligence strategy. As a Senior Data Warehouse Engineer, you'll be responsible for developing and implementing Power BI semantic models, dashboards, and reports that provide actionable insights to various stakeholders, helping them make informed decisions based on data.

Join Rise to see the full answer
What skills are preferred for the Senior Data Warehouse Engineer at Shearer's?

Preferred skills for the Senior Data Warehouse Engineer position at Shearer's include proficiency in SQL Server programming, experience with Azure and cloud-based data warehousing solutions, familiarity with SSIS, SSAS, and integration software like Boomi, as well as knowledge of data governance best practices and exposure to AI/ML analytics are all beneficial.

Join Rise to see the full answer
What benefits can I expect when working as a Senior Data Warehouse Engineer at Shearer's?

When you join Shearer's as a Senior Data Warehouse Engineer, you'll enjoy a comprehensive benefits package that includes medical, dental, vision, and life insurance. Additionally, you’ll have access to a flexible spending account, retirement savings plans with matching contributions, and various disability insurances. Plus, we offer opportunities to volunteer in the communities we operate in!

Join Rise to see the full answer
Common Interview Questions for Senior Data Warehouse Engineer
Can you describe your experience with data warehouse design and implementation?

In responding to this question, focus on specific projects you've worked on that involved data warehouse design and implementation. Highlight your role, the technologies used, and any challenges you faced, along with how you overcame them. Mentioning how your designs facilitated business intelligence and analytics can also make your answer more compelling.

Join Rise to see the full answer
How do you ensure data quality and performance optimization in your projects?

Discuss the methods you utilize to ensure data quality, like regular data cleansing, and validation processes. Explain how performance optimization techniques, such as indexing and efficient ETL processes, contribute to the overall success of the data warehouse. Real-world examples of these practices in past roles will make your answer stronger.

Join Rise to see the full answer
What strategies do you employ when working with ETL processes?

Share your approach to designing and managing ETL processes, including tools and methodologies you often use. Emphasize the importance of effective data flow and integration, as well as your experiences in troubleshooting and optimizing ETL pipelines for better performance.

Join Rise to see the full answer
How do you utilize Power BI in your role as a Data Warehouse Engineer?

Detail your experience with Power BI, including how you've developed semantic models, dashboards, and reports. Emphasize your understanding of DAX and Power Query, and provide examples of how your use of Power BI has driven insights and improved decision-making processes in your previous roles.

Join Rise to see the full answer
Can you explain your understanding of data governance and its importance?

Discuss your knowledge of data governance principles and best practices, including data accuracy, security, and compliance. Emphasize how data governance frameworks facilitate collaboration and ensure data is managed properly within an organization, particularly in large data projects where multiple stakeholders are involved.

Join Rise to see the full answer
What challenges have you faced in your previous data engineering roles, and how did you overcome them?

Reflect on specific challenges related to data quality, integration, or project deadlines. Describe the steps you took to resolve these issues, including collaborating with team members, implementing new tools or processes, and any lessons learned that you applied in future projects.

Join Rise to see the full answer
How do you keep up with the latest trends in data warehousing and BI technologies?

Mention your approach to staying updated with new trends, such as attending conferences, participating in online courses, or following industry thought leaders and publications. Illustrate how keeping abreast of these trends has benefitted your work and provided innovative solutions in past projects.

Join Rise to see the full answer
Describe a time when you collaborated with a cross-functional team. What was your role?

Use the STAR method (Situation, Task, Action, Result) to discuss a specific instance of collaboration with a cross-functional team. Highlight your contributions, the project objectives, and how effective communication and teamwork led to a successful outcome.

Join Rise to see the full answer
Have you ever utilized cloud-based solutions in your data engineering projects? Please elaborate.

Discuss your hands-on experience with cloud platforms like Azure, AWS, or Google Cloud in relation to data warehousing. Provide insights into specific projects where you migrated on-premises solutions to the cloud, and the benefits and challenges associated with such transitions.

Join Rise to see the full answer
What tools and technologies are you proficient in, and how have you used them in your work?

List relevant tools and technologies you are proficient in, such as SQL, Power BI, Azure, and any ETL tools you have experience with. Provide concrete examples of how these tools have been utilized to solve problems or enhance data workflows in past roles.

Join Rise to see the full answer
Similar Jobs
Photo of the Rise User
Posted 3 days ago
Photo of the Rise User
Posted 12 days ago
Photo of the Rise User
Posted 4 days ago
Photo of the Rise User
Sweed Remote No location specified
Posted 2 days ago
Palmstreet Remote No location specified
Posted 3 days ago
Photo of the Rise User
Fetch Remote Office, Hybrid, Remote
Posted 5 days ago
NXTGIG Remote No location specified
Posted 2 days ago
Photo of the Rise User
Terrascope Remote No location specified
Posted 11 days ago

"Better Together Everyday"

417 jobs
MATCH
Calculating your matching score...
FUNDING
DEPARTMENTS
SENIORITY LEVEL REQUIREMENT
TEAM SIZE
SALARY RANGE
$80,000/yr - $120,000/yr
EMPLOYMENT TYPE
Full-time, hybrid
DATE POSTED
March 12, 2025

Subscribe to Rise newsletter

Risa star 🔮 Hi, I'm Risa! Your AI
Career Copilot
Want to see a list of jobs tailored to
you, just ask me below!