Sr Business Intelligence Analyst

Live the experience . From professional empowerment to continual learning opportunities. From ongoing investment in new and emerging technologies to a career of self-determination. At Ulta Beauty, our tech team is critical to our scalability—and is recognized that way. We’ve been defined as a “mature start-up.” A place where interdepartmental exposure, open doors, and genuine collaboration is ubiquitous. Where challenges come fast and furious, requiring agility, mental dexterity, and creativity. Where our passion for better solutions drives us and is core to who we are.   We’re engineering for the future of retail, and it’s no-holds-barred. But for those motivated by continual change and ambiguity, by superior leadership, by whip smart colleagues who will press you daily for your very best, you’ll find that virtually nothing’s impossible at Ulta Beauty. COMPANY:                            Ulta, Inc.   LOCATION:                            1000 Remington Blvd., Suite 120, Bolingbrook, IL 60440   TITLE:                                     Senior Business Intelligence Analyst   HOURS:                                  Monday to Friday, 8:00 am to 5:00 pm   DUTIES: Develop efficient data models and SQL queries to support front end reporting and visualization solutions. 10.0% Deliver accurate and on time solutions to stakeholders to do their jobs throughout the year. 40.0% Create and update process documentation and/or playbooks to support the maintenance of solutions. 10.0% Support ad-hoc and non-project-based requests. 25.0% Support the testing of enterprise system changes and implementations. 15.0% 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 in any occupation with IT development, front end reporting development, enterprise reporting and analytics solutions, large-scale database management or related experience must include: 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 must also include: 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; and Experience with programming languages such as Java, Python, or R to support data processing, analytics, or reporting automation.   SALARY :                                $112,278.40 - $113,278.40 per year   APPLY:                                  https://careers.ulta.com/careers/517925    Ulta offers a standard benefits package. See a full list of benefits here: