Job#: 2076881

Job Description:

Job Description: Customers shop for their Everyday Essentials more often than any other category. As a result, it is critical that we help them find what they need and create experiences that allow them to build their baskets and complete their shopping trips quickly. The Everyday Essentials Shopping team is looking for a Business Intelligence Engineer to turn raw data into reporting and insights to help us better understand how customers interact with our features, offerings, and experiences. We obsess over providing customers with the more relevant and engaging experiences. We are only able to do that by using data to build insights into customer preferences by segment, form hypotheses about how we can improve the customer experience that we can test, communicate the results of our efforts to partners, and enable testable solutions.

In this role, you will begin by being responsible for building out a suite of automated data solutions, reporting, and metrics associated with measuring and delivering insights on customer engagement, basket building, and relevance in Everyday Essentials. As you develop an understanding of customers and build an in-depth knowledge of the underlying data, you will build mechanisms to support self-service access to data, translate data into testable hypotheses, build data solutions that can used in production environments, and be a critical partner to business and technical leaders. Since you will be most familiar with the underlying data, you will be an important member of the team that is expected to contribute new ideas for how we can improve the customer experience.

The team you will join is a close-knit, cross-functional team with Product Managers, Software Engineers, Program Managers, and Business Intelligence Engineers. You will have the opportunity to learn from other BIEs on our team and partner closely with a Data Engineering team that we work with regularly. We look to move fast while promoting learning. You will be encouraged to learn about and leverage Generative AI/LLMs in your daily work. From day 1, you will be an important member of the team that will have the chance to grow while contributing to high-impact efforts.

Key Responsibilities:

* Own the design, development, and maintenance of scalable solutions for ongoing metrics, reports, analyses, and dashboards to support drive understanding of the engagement and relevance of customer experiences.

* You will create data visualizations, in at least in Excel and Quicksight dashboards, to make data more interpretable and actionable for the business.

* Translate business problem statements into reporting/analysis requirements. Work with internal customers, including Product Leaders, Data Engineers, Software Engineers, and other BIEs, to define best output based on expressed stakeholder needs.

* Design and create data tables to support ongoing reporting, analyses, and customer experiences. This will include gathering business requirements, designing the schema, building data pipeline, performing data validation, and loading table into required databases.

* Perform ad-hoc deep-dive analyses to identify the drivers of changes in key metrics, size new opportunities., explore unusual patterns in the data, and how customers are using a feature. Employ data mining, model building, segmentation, and other analytical techniques to capture important trends in customer segments.

* Become an expert in relevant data sources and metrics. Identify and recommend data sources and metric definitions to support business requirements collected from partners and based on your knowledge/expertise. Use your expertise to define and test hypotheses.

* Develop tools and mechanisms that enable self-service access to data for business and technical partners. This includes providing clear documentation for your reporting and comments in your code/queries.

* Review and audit existing ETL jobs and SQL queries.

* Monitor and troubleshoot operational or data issues in the data pipelines.

Basic Qualifications

* Bachelors degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field.

* 3+ years in analyzing and interpreting data with Redshift, Oracle, NoSQL etc.

* 3+ years in designing, building, and automating recurring reporting/dashboards in support of a business, product, or program team.

* Expertise in writing complex SQL queries and optimizing them to run efficiently.

* Expertise with data reporting and visualization using Excel, Tableau, Quicksight, or similar tools.

* Experience with data modeling, warehousing and building ETL pipelines.

* Experience performing basic statistical analysis.

Preferred Qualifications

* Graduate degree in math/statistics, computer science or related field, or marketing is highly desirable

* Experience working in e-Commerce or Retail is a plus.

* Experience working in a role focused on customer behavior is a plus.

* Scripting experience using Python to process data for modeling.

* Experience in Statistical Analysis packages such as R, SAS and Matlab

* Experience with EC2, DynamoDB, S3, and Redshift

* Experience in designing and implementing Machine Learning solutions.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our ‘Welcome Packet’ as well, which an Apex team member can provide.