Business Intelligence Engineer

Ampcus Inc; Seattle (WA); On-site; USD 90,000 - 130,000; Full time

Job summary

A leading technology consulting firm seeks a Business Intelligence Engineer to deliver actionable insights from data and enhance customer experiences. You will design reporting, dashboards, and automated solutions while collaborating with cross-functional teams. Ideal candidates hold a relevant degree and have extensive experience in SQL, data visualization, and business analytics.

Benefits

Flexible working hours

Professional development opportunities

Collaborative team environment

Qualifications

• 3+ years in data analysis using SQL and reporting tools.
• Experience in designing dashboards and automating reports.
• Background in data modeling and ETL processes.

Responsibilities

• Own the design, development, and maintenance of data solutions for insights.
• Translate business problems into reporting requirements.
• Perform ad-hoc analyses to understand changes in key metrics.

Skills

Data Analysis

SQL

Data Visualization

Customer Engagement

Education

Bachelor's degree in BI, finance, engineering, statistics, or computer science

Tools

Quicksight

Excel

Tableau

Redshift

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Business Intelligence Engineer

Location(s): Seattle, WA


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

• 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

• 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 solutions such as EC2, DynamoDB, S3, and Redshift
• Experience in designing and implementing Machine Learning solutions.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.

About the company

Ampcus Inc. is an ISO 20000, ISO 27000, ISO 9001, CMMI DEV/3 SM, and CMMI SVC/3 SM certified global provider of a broad range of Technology and Business consulting services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, client goals become our goals.

Notice

Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at [e-mail] or 407-000-0000.

Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.

An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report . NYC applicants may request an alternative process or accommodation at [e-mail] or 407-000-0000.