IT Senior Data Analyst - Business Intelligence (Chicago/Flex)

  • ULTA,
  • Bolingbrook, IL
Analysis, Analyst, Architecture, Artificial Intelligence, Automated, Business Intelligence, Business Requirements, Configuration Management, Data Analysis, Database, Data Modeling, Development, Ecommerce, ERP, Hardware, Management, Materials, Modeling, Project, Project Management, Python, Security, SQL, Testing, Validation
Full Time
Work from home not available Travel not required

Job Description


Ulta Beauty is the largest specialty beauty retailer in the United States and the place for the true beauty enthusiast who gets butterflies as she shops for beauty and experiments throughout our store. We are the only one to provide our guests prestige, mass and salon products and services under one roof All Things Beauty, All in One Place . We put our guests at the center of all we do, committing to offer her unrivaled ways to be beautiful in an environment that provides the thrill of exploration and delight of discovery.


In the important role of Sr. Data Analyst, he/she will develop a strong partnership and collaboration with key stakeholders in order to drive the business through leveraging data and insights. The Sr Data Analyst will apply technical proficiency across different stages of the Software Development Life Cycle including requirements elicitation, application architecture definition and design. He/she will also create high level design artifacts, produce high quality code deliverables, lead validation for all types of testing and support activities related to implementation, transition and warranty. The Sr Data Analyst will be part of a learning culture, where teamwork and collaboration are encouraged, and excellence is rewarded.

  • Requirements definition : Contributes to selection of the most appropriate techniques for the elicitation of detailed requirements. Undertakes business requirements as directed and maintaining traceability. Leads requirements prioritization with stakeholders. Reviews operational requirements, problems, and opportunities, seeking effective business solutions through improvements in automated and non-automated components of new or changed processes.
  • Application Support : Maintains application support processes, and checks that all requests for support are dealt with according to agreed procedures. Uses application management software and tools to investigate issues, collect performance statistics and create reports.
  • Configuration Management : Applies tools, techniques and processes to track, log, report on and correct configuration items, components and changes related to the configuration items.
  • Incident Management : Undertakes the identification, registration and categorization of incidents. Gathers information to enable incident resolution and promptly escalates incidents as appropriate. Maintains records and advises relevant persons of actions taken.
  • Data Analysis : Applies data analysis, data modeling, and quality techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components. Liaises with database engineers and other application development team members on the details of data structures and associated components.
  • Development Testing : Creates test cases using own in-depth technical analysis of both functional and non-functional specifications and processes. Maintains traceability records, from test cases back to requirements. Investigates requirements for environment, data, resources and tools. Reviews test results and modifies tests if necessary. Provides reports on progress, anomalies, risks and issues associated with the overall project. Identifies process improvements, and contributes to corporate testing standards and definition of best practice.
  • Relationship Management: Reviews the communications needs of each stakeholder group in conjunction with business owners and subject matter experts. Translates communications / stakeholder engagement strategies into specific tasks. Contributes to the development and enhancement of customer and stakeholder relationships.

  • Provide overall technical guidance, leadership, and solid execution of end-to-end technical design as relates to Business Intelligence projects.
  • Become a trusted partner with the supported business stakeholders as it pertains to Ulta Beauty data, usage of the data and reporting/insights.
  • Provide technical design oversight and coordinating activities across multiple teams/areas including SMEs, source systems, data acquisition, data integration, security, data quality etc.
  • Provide technical oversight in delivering architectural principles, data integration, data warehousing and reporting/analysis.
  • Provide conceptual/logical and physical data modeling design and integrated data transformation solutions.
  • Provide reporting/analytics relational database services and solutions, ETL system delivery methodology and advice on all aspects of implementation, including work estimation, resources staffing and planning.
  • Maintain a deep knowledge of SQL and relational databases.
  • Write queries and extract data to provide end user data accessibility.
  • Lead end-to-end design from project conception through deployment managing solution design reviews, project gateway approval, security, and overall project s solution design.
  • Conduct detailed data analysis, gap analysis, and data discovery/profiling.
  • Capture high and detail level design documentation with experience presenting to senior business SME s and technical leadership teams.
  • Assess readiness of technical solutions and hardware including systems, tools, technologies, and processes.
  • Stay current in new technologies/features as well as new opportunities to develop knowledge and staff.
  • Lead or coordinate IT business processes including translating business problems into technical requirements, developing technical specifications, technical development, troubleshooting, project management, estimation, conducting technical reviews, developing a test strategy/plan, supporting user acceptance testers, collaborating with technical leads/customers/IT teams, implementation support, creating training materials, creating system documentation, solution governance, providing accurate/summarized status to team.
  • Guide and assist the end users with self-service analytics if needed within the data ecosystem to meet their analytic needs.


  • Bachelor s degree in Computer Science, a related field, or applicable work experience
  • 5+ years of very strong experience with relational database data extraction, transformation and loading
  • Experience with Google Cloud Platform (GCP) / Big Query or similar cloud platforms a plus
  • Proven command of SQL and python
  • Experience with data modeling, mining, mapping, and monitoring
  • Experience with Business Intelligence platforms, reporting tools, and visualization products e.g. Tableau
  • Functional knowledge of retail domain across various source applications such as ERP and retail specific customer, ecommerce and store applications
  • Strong leadership skills
  • Proactive and focused on the business, stakeholders and guests
  • Possess a strong work ethic and business acumen
  • Demonstrate strong analytic and critical thinking skills
  • Excellent communication skills including with non-technical business partners
  • No-sql and unstructured / semi-structured data knowledge a plus
  • Experience using predictive models and performing descriptive analytics a plus
  • Experience with Machine Learning (ML) or AI (Artificial Intelligence) a plus
  • Experience in retail, CPG or logistics domains preferred

No third parties please.

Dice Id : 10118074
Position Id : 25528
Have a Job? Post it

Similar Positions

Business Systems/Data Analyst
  • Resource 1
  • Wood Dale, IL
IT Report Analyst
  • Braxton-Reed
  • Chicago, IL
Sr Analyst, Business Systems - Finance
  • V-Soft Consulting Group, Inc
  • Oak Brook, IL
Technical Business Analyst
  • Forbes Technical Consulting
  • Chicago, IL
Aderant Reports Developer
  • Atlantic Partners
  • Chicago, IL
SQL & Excel Report Analyst
  • Experis
  • Chicago, IL
IT Business Analyst - Time Keeping
  • Smithfield
  • Lisle, IL
Business Analyst - Entry-Level - Tech Startup
  • Enterprise Peak
  • Chicago, IL
Data Analyst
  • Harmer Consultants, Inc.
  • Schaumburg, IL
Business Analyst - IT Solutions
  • SWC Technology Partners, LLC
  • Oak Brook, IL
PowerBI Developer
  • U.S. Tech Solutions Inc.
  • Chicago, IL
Reports Developer
  • ComPsych
  • Chicago, IL