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. This is a Full-Time Salary Position. This position is responsible for designing, developing, and maintaining robust data cubes and data marts to support reporting and analysis, and collaborating with business stakeholders to translate their data needs into technical solutions. The Power BI development aspect focuses on creating intuitive dashboards and reports, implementing custom visualizations and calculations and ensuring data accuracy.

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