Sr. Business Intelligence Developer

General Nutrition Centers - Pittsburgh, PA

Full-time - Mid Level

Hybrid - Pittsburgh, PA

Food and Beverage Retailers

About the position

At GNC we embrace a "Live Well" philosophy, fostering a dynamic environment where innovation meets passion. Whether someone is an athlete or just starting to focus on their health, we want to deliver the cutting-edge products they deserve. We are looking for an individual who is excited and eager to play a pivotal role in driving excellence in the health and wellness industry. This position offers the opportunity to engage in a collaborative environment where you will make a personal impact every day.

Responsibilities

• Design, develop, and maintain robust data cubes and data marts to support reporting and analysis.
• Optimize data models for performance and scalability.
• Create intuitive and visually appealing Power BI dashboards and reports.
• Ensure data accuracy, consistency, and security within Power BI reports.
• Implement write-back capabilities to data cubes and SQL tables using tools like PowerOn.
• Understand database architecture concepts, including normalization, indexing, and query optimization.
• Collaborate with database administrators to ensure optimal database performance.

Requirements

• Bachelor's degree in Computer Science, Statistics, Mathematics, or a related field.
• 3-7 years of experience
• Proven experience in data warehousing, ETL processes, and data modeling.
• Strong proficiency in SQL, T-SQL, R, and Python.
• Advanced knowledge of Power BI and other data visualization tools.
• Must have a strong understanding of Data Analysis Expressions (DAX).
• Experience with write-back processes and tools like PowerOn.
• Understanding of database architecture and optimization techniques.
• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills.
• Ability to work independently and as part of a team.

Benefits

• medical insurance
• dental insurance
• vision insurance
• employer-paid life insurance
• flex spending accounts
• 401K program with company match
• 8-week paid parental leave
• 5 paid bereavement days
• 11 paid holidays per year
• short-term and long-term disability
• 30% employee merchandise discount