• Job Description

  Req#: 25-09295
  Pay rate range - $55/hr. to $58/hr. on W2
  100% Onsite
  
  Must Have
  Writing Sequel Queries 3 yrs
  Excel / Tableau or equivalent 3 yrs
  Data modeling – be able to data model (ETL) 3 yrs
  
  Required:
  A bachelor's Degree is strongly preferred
  
  Leadership Principle:
  Dive Deep
  Ownership
  Earns Trust
  
  Job Description:
  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 be 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, 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 the 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 a data pipeline, performing data validation, and loading the table into the 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
  * Bachelor's 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
  * A graduate degree in math/statistics, computer science or a 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, SA,S and MATLAB
  * Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
  * Experience in designing and implementing Machine Learning solutions.

• About the company

  Intelliswift has been a top IT & Software solutions company in USA which provides end-to-end IT services and building strong digital foundations

Notice