Business Intelligence Engineer

at Potbelly Sandwich Works, LLC in Chicago, Illinois, United States

Job Description

Business Intelligence Engineer Chicago, IL

6-month contract to hire
$80-90k per year + bonus(once permanent employee)
100% Remote in the United States
Potbelly Sandwich Shops, where Good Vibes and Great Careers are a way of life! Come Build the Potbelly Nation with us.
Potbelly got its start in 1977 as a small antique store that turned into a lines-out-the-door neighborhood sandwich shop. Before you knew it, we were serving up delicious food in a fun environment at more than 400 shops across the United States.
We continue to wake up every day with one goal: Make people happy through good vibes and delicious craveable food. Put those awesome ingredients together, and there's no telling what we'll cook up next!
Medical, Dental, Vision, Domestic Partner Benefits, Spouse & Children Benefits, Paid Parental Leave, 401k with a match, Flexible Spending Account, Paid Time Off, Incentive Bonus Plan, Paid Holidays, Short-Term Disability, Long-Term Disability, Life/AD&D Insurance, Home office allowance, Cell phone allowance, Internet allowance, mileage reimbursement, AMEX travel card provided.

Job Title: BUSINESS INTELLIGENCE ENGINEER
Department/Function: Information Technology
Reports To: Director of Data and Analytics

GENERAL DESCRIPTION

Are you passionate about transforming data into actionable insights? Do you thrive in a dynamic IT environment where innovation drives success? If so, we invite you to join our team as a Business Intelligence Engineer at Potbelly.

FOCUS
Responsibilities
Assists in analysis, design, implementation and testing activities associated with database development, system integration, reporting systems and maintenance.
Program and implement reporting interfaces, tools and solutions.
Update programs to correct or enhance functionality.
Develop and maintain Power BI reports and dashboards.
Assist users in learning and using reporting tools.
Perform ad hoc queries, analysis and reporting as required.
Develop and Maintain ETL data pipelines using PySpark.
Monitor data sources for errors and omissions, recommend and implement improvements.
Ensure availability and performance of the databases that support the system.
Provide on-call support.
Act as an IT liaison for data stewards, and help establish successful data governance.
Document and maintain Data Lineage and Ontology.
Handle various special projects.

ESSENTIAL PHYSICAL FUNCTIONS
Must have the ability/stamina to work a minimum of 45 to 55 hours a week.
Will frequently key in data.
Must be able to engage in problem-solving skills to help identify and solve potential issues.
Must be able to communicate heavily through phone, email, video conferencing, Microsoft Teams, text/SMS, and in-person communications.

EXPERIENCE, EDUCATION AND BEHAVIORS
Must represent The Potbelly Advantage and Our Values.
3+ years of experience with complete Microsoft SQL Server stack
Microsoft SQL Server.
SQL Server Integration Services
3+ years T-SQL experience.
2 years Python script, PySpark and SparkSQL Notebooks using DeltaLake and Iceberg tables.
Familiarity with AWS Glue, AWS S3 buckets.
Familiarity with REST Services and GraphQL.
Familiarity with Agile software development.
Familiarity with Azure DevOps.
Strong interpersonal communications, time management, organization, decision making and customer service skills.
Represent Potbelly in a professional manner at all times.
Will work rotational schedule including nights, weekends and holidays as needed.

Join us on this data-driven journey. Apply today!

Already applied? Go to TalentReef to see your application

Position Information

Company: Potbelly Corporate
Position: Business Intelligence Engineer
Status: Full Time
Shift: First (Day), Second (Afternoon), Third (Night)
Req #: 9982902
Date Posted: May 21, 2024
Location: 111 N. Canal St., Chicago,
 US,
 IL,
 60606
Job Category: Corporate

We’re an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, or disability status.