Sr Business Intelligence Analyst

Ulta Beauty, Inc.•Bolingbrook, IL

2d•Onsite

About The Position

Ulta Beauty is seeking a Senior Business Intelligence Analyst to join their tech team. The company describes itself as a 'mature start-up' where collaboration, agility, and creativity are key. This role is crucial for Ulta Beauty's scalability and is focused on engineering for the future of retail. The position offers opportunities for professional empowerment, continuous learning, and career self-determination within a dynamic and challenging environment.

Requirements

Bachelor’s degree in Information Technology, or related.
Three (3) years in any occupation with IT development, front end reporting development, enterprise reporting and analytics solutions, large-scale database management or related experience.
Three (3) years of experience designing, developing, and maintaining enterprise-level front-end reporting and data visualization solutions, including interactive dashboards and executive-level analytical reports, to support complex business decision-making.
Three (3) years of experience architecting and implementing data models, dimensional schemas (star and snowflake), and data preparation workflows, including ETL/ ELT processes, data validation, and optimization techniques to ensure data accuracy, scalability, and performance.
Experience working with SQL and advanced database concepts, including complex joints, subqueries, window functions, indexing strategies, and query optimization across large, Indexing strategies, high-volume datasets and Common Table expression.
Tableau Desktop for advanced report and dashboard development.
Tableau Server for enterprise publishing, permissions, performance optimization and user management.
Tableau Prep for data cleansing, transformation and preparation workflows.
SAP HANA Studio and SAP Business Objects tools.
Oracle, SQL Server, and GCP.
Experience supporting retail or enterprise business operations, including merchandising, planning, inventory, and supply chain analytics.
Experience with programming languages such as Java, Python, or R to support data processing, analytics, or reporting automation.

Responsibilities

Develop efficient data models and SQL queries to support front end reporting and visualization solutions.
Deliver accurate and on time solutions to stakeholders to do their jobs throughout the year.
Create and update process documentation and/or playbooks to support the maintenance of solutions.
Support ad-hoc and non-project-based requests.
Support the testing of enterprise system changes and implementations.