SR DATA AND REPORTING ENGINEER

Date:  Mar 29, 2024
Location: 

Palatine, IL, US, 60067

At Weber, grilling is a passion that’s reflected in everything we do. Our goal is to share this passion and spark inspiration with the people who matter most – our grilling community. Weber has been the world’s premiere manufacturer of charcoal and gas grills and accessories since 1952. If you have the desire to work for a company that is recognized for exceptional quality products and high customer satisfaction, employment with Weber may be right for you. We provide a friendly working atmosphere with an environment of growth and opportunity through innovation, pride, and excellence.

 

Weber is committed to inclusive, equitable and diverse Hiring practices. Our goal is to create a workforce which resembles the diverse rich communities we live, play, and support every day. 

 

Discover What’s Possible with a career, at Weber.

 

Summary

We are seeking an experienced Senior Data and Reporting Engineer with a strong technical understanding to join our team. The ideal candidate will spearhead the development of an Enterprise data warehouse platform, Snowflake, collaborating closely with key stakeholders to drive the organization's continuous growth. They will be responsible for designing, developing, and maintaining the infrastructure and systems required for data storage, processing, and analysis. Additionally, they will collaborate with key stakeholders and cross-functional teams to understand reporting requirements, drive data management projects, and innovate solutions to enhance the data platform. They play a crucial role in building and managing the data pipelines, data solutions that enable efficient and reliable data integration, transformation, and delivery for all data users across the Enterprise.

We want to ensure our stakeholders can easily self-serve the data and build reports they need to drive their projects and make decisions. If you're excited to work on a fast-moving team using cutting-edge technologies to collect, store, transform, analyze, and model data, we want to meet you!

 

Essential Duties and Responsibilities (include the following, and other duties may be assigned):

 

Data Architecture and Modeling:

  • Strong foundation in data architecture, data modeling, and reporting to ensure our data infrastructure supports efficient analytics and reporting operations.
  • Collaborate with stakeholders and cross functional teams to understand business requirements and define data structures and relationships.
  • Design, develop and maintain robust, and scalable data models and schemas to support analytics and reporting requirements.

 

Data Integration:

  • Integrate data from different sources, both internal and external, to create a unified and comprehensive view of the data.
  • Work closely with cross-functional teams to understand data requirements and ensure successful integration.

 

ETL Development and Data Integrity:

  • Develop, optimize, and maintain ETL/ELT processes to extract, load and transform data from various sources into our Snowflake data platform.
  • Implement data quality checks and validation routines within data pipelines to ensure the accuracy, consistency, and completeness of data
  • Interact and coordinate work with other technical and testing members in the team.
  • Review and write code that meets set quality gates.

 

Performance Tuning:

  • Optimize data infrastructure and enhance overall system performance.
  • Optimize data pipelines and data processing workflows for performance, scalability, and efficiency.
  • Optimize design efficiency to minimize data refresh lags, improve performance and enable data as a service through reusable assets.

 

Technical Leadership:

  • Drive the design, code, and maintenance of data engineering standards.
  • Troubleshoot and resolve issues related to data processing and storage.
  • Coordinate with team members in finding root-cause of problems and issue resolution.
  • Perform quality checks and user acceptance testing.

 

Cross-Functional Team Collaboration:

  • Meet with internal team to clarify and document reporting requirements.
  • Collaborate to understand existing issues and new requirements.

 

Documentation:

  • Create, update, maintain technical documentation of the processes and configuration.
  • Develop and maintain documentation for data processes, pipelines, and models.

 

Education and Experience Requirements:

  • Bachelor's or Master’s Degree in Computer Science, Information Technology or a related field
  • Minimum 10 years of experience in a technical role in data extracts, analysis, and reporting.
  • 6+ years of advanced SQL development experience coupled with robust Python or Java programming capabilities. Extensive experience building and optimizing ETL pipelines, data modeling and schema design.
  • 4+ years of hands-on experience with cloud data warehousing technologies (Snowflake is preferred, BigQuery, AWS, Azure, SAP BW).
  • Experience with SAP ERP systems – OTC, Finance, Master Data is preferred
  • Certification in relevant areas (e.g., Snowflake, AWS Certified Data Analytics, Google Cloud Professional Data Engineer) is preferred
  • Strong dedication to code quality, automation and operational excellence using CI/CD pipelines and unit/integration tests. Have experience with GitHUB, Jenkins or Selenium.
  • Proven Experience with reporting and analytical tools like Power BI, Tableau, etc.
  • Familiarity with Streaming using Spark or Flink or Kafka or NoSQL or relevant technologies
  • Continuously stay up-to-date on industry trends and advancements in data engineering and analytics.
  • Able to work with little supervision while being accountable for individual and departmental results
  • Able to multi-task and meet deadlines under pressure
  • Solid understanding of data security and compliance requirements.
  • Effective communication skills, conveying complex technical concepts to non-technical stakeholders.

 

Competencies To perform the job successfully, an individual should demonstrate the following competencies:

  • Technical Expertise: Maintains current technical knowledge and best practices and actively builds new skills.  Provides ideas to help solve business and technical problems for the organization through technical expertise.  Able to work across multiple platforms and applications and see interconnections with some guidance. 
  • Action Orientation: Uses time effectively to complete tasks in a thorough and timely manner. Focuses on most important items first. Maintains high levels of personal organization and works at high level of efficiency and rapid pace.  Seeks out challenges and initiates action on issues even when scope is unclear.  Maintains composure in times of stress. 
  • Collaboration: Understands the importance of relationships to ensure team success.  Builds positive relationships, uses tact in sensitive situations; listens well to various points of view; relates well to others at all levels.  Speaks and writes in a clear and concise manner.  Takes time to get to know others outside of his/her immediate functional area.   Aligns personal goals to team and organizational goals. 
  • Communication: Establishes rapport and is straightforward and approachable.  Listens carefully, asks pertinent questions, responds effectively and adapts personal style to suit the audience.  Actively gathers customer viewpoint and feedback to aid in decision-making. Speaks, writes and presents in a clear and concise manner.  Uses effective meeting facilitation tools and techniques to attain meeting objectives in a timely manner. Establishes and maintains positive long-term relationships with a diverse network of contacts, including internal and external customers. 
  • Customer Engagement: Engaging external customers and internal resources to achieve mutually beneficial outcomes in a way that provides an optimal experience for the customer. 

Weber-Stephen Products LLC is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, creed, religion, national origin, sex, sexual orientation, gender identity and expression, age, disability, or Vietnam era, or other eligible veteran status, or any other protected factor.

 


Nearest Major Market: Chicago