Sr. Business Intelligence Analyst
About the role
Life Fitness / Hammer Strength is seeking a Senior Business Intelligence Analyst to partner with business stakeholders and technical partners, playing a key role in delivering insights and information needed for critical business decision-making.
Responsibilities
- Collaborate with business stakeholders building relationships that establish you as the SME that understands the business and delivers data and analytics solutions that drive business outcomes
- Work with your business stakeholders to identify data and analytical needs and design solutions that meet near-term needs while advancing the long-term data strategy and roadmap
- Manage business intelligence projects from inception to deployment, ensuring timelines and quality standards are met
- Analyze data from ERP, CRM, and other business systems to understand structures, relationships, and business processes
- Design, build, and maintain data pipelines using Azure Data Factory, Coalesce.io, and Snowflake to load, transform, and integrate data into the data warehouse, ensuring scalability, accuracy, and high performance
- Architect, build, and maintain reusable data models using Power BI that expose data warehouse data to front end visualization tools, ensuring scalability and performance
- Create and deliver interactive reports and dashboards using Power BI, turning complex data into actionable intelligence that drives business decisions, and train the business on their use
Qualifications
- Bachelor's degree or equivalent combination of continuing education and work experience
- 6+ years of experience in a business intelligence or data engineering role
- 3+ years of experience designing and developing ELT/ETL pipelines and data models
- Proven experience in one or more ELT/ETL tools (Azure Data Factory, Coalesce.io preferred) and front-end visualization tools (Power BI preferred)
- Strong SQL and data modeling skills
- Experience working with ERP data (Oracle E-Business Suite preferred) and integrating it into BI solutions
- Demonstrated experience developing and maintaining a dimensional data warehouse
- Strong ability to present results within and outside of team to users of various levels of technical knowledge; exceptional written and verbal communication skills with an ability to tailor presentations appropriately to a given audience
- Strong track-record of demonstrated constructive, critical thinking and problem-solving skills with an ability to manage multiple competing priorities effectively
- Proven ability to develop partnerships at all levels, work collaboratively in a team environment, manage through influence, and establish oneself as a leader / respected SME
- Strong attention to detail
Benefits
The salary range for this position, intended for U.S. applicants, is $109,400 - $153,800 annually. The actual salary will vary based on applicant’s education, experience, skills, and abilities. The salary range reflected is based on a primary work location of Rosemont, IL and the actual salary may vary for applicants in a different geographic location.
This position is eligible to participate in Life Fitness / Hammer Strength’s annual Manager Incentive Plan to receive an annual discretionary bonus in addition to base salary.
Life Fitness / Hammer Strength offers a comprehensive package of benefits for full-time team members, including:
- A 401(k) savings plan with 4% employer match
- Medical, dental and vision insurance
- Paid time off, including 12 paid holidays throughout the calendar year
- Paid vacation days beginning at 13 days annually
- Paid sick leave as provided under state and local paid sick leave laws
- Company paid short-term disability and optional long-term disability
- Health savings account, health care and dependent care reimbursement accounts
- Employee and dependent life insurance and supplemental life and AD&D insurance
- Hospital indemnity
- Identity protection, legal services, adoption assistance, tuition assistance, commuter benefits, employee discounts, and an employee assistance program that includes free counseling sessions
Pay
$109,400 - $153,800 annually
Schedule
Hybrid position based out of the Global Support Center in Rosemont, IL - M/F remote and T-Th are in-office collaboration days