Staff Data Engineer (BI)

Overstock.com•Salt Lake City, UT

2d•$116,917 - $150,000•Remote

About The Position

Bed Bath & Beyond is hiring a Staff Data Engineer (BI) to develop and support business intelligence reporting solutions and the MicroStrategy platform. The position collaborates with data engineering teams to onboard data sources and works with business leaders, including Finance, Marketing, and Product, to translate ambiguous needs into scalable data and reporting solutions. The role serves as a subject matter expert for KPI definitions and supports the performance, scalability, and governance of MicroStrategy environments. The position analyzes user requirements, creates and modifies BI applications, and develops reports, dashboards, charts, and other reporting solutions. It applies logical data modeling concepts within existing data warehouse structures, supports data scientists in designing and manipulating data to predict and measure outcomes, and develops testing, validation, and documentation procedures. The role also provides customer support and technical assistance, consults on BI application design and maintenance, and delivers end-user training and training materials. This position is 100% remote, requires residence in the United States, and reports to headquarters in Murray, Utah. Salary is $116,917–$150,000 per year.

Requirements

Bachelor’s degree or U.S. equivalent in Computer Science, Information Technology, Information Systems, Data Analytics, or a related field.
At least 4 years of professional experience as a Business Intelligence Analyst or in another occupation working with relational databases, developing complex SQL queries, and developing reports and dashboards using MicroStrategy in an enterprise reporting environment.
At least 4 years of professional experience developing MicroStrategy reports and dashboards, including creating metrics, filters, and dashboards.
At least 4 years of professional experience designing and implementing logical data models within MicroStrategy, including creating attributes, hierarchies, facts, and schema objects to support reporting requirements.
At least 4 years of professional experience developing and optimizing complex SQL queries in relational databases, using advanced constructs such as window functions, CTEs, multi-table joins, aggregations, and subqueries for BI and reporting workloads.
At least 4 years of professional experience performing data validation and reconciliation to ensure report accuracy, including identifying and resolving discrepancies between source systems and reporting outputs.
At least 3 years of professional experience with cloud-based data platforms, including GCP, AWS, or Azure, querying large datasets, and supporting BI and reporting workloads.
At least 2 years of professional experience with relational data models and data warehouse environments, including BigQuery or Snowflake, and understanding fact and dimension structures and partitioned tables for reporting and analytics.

Responsibilities

Collaborate with data engineering teams to onboard data sources required for reporting and analytics.
Collaborate with business leaders, including Finance, Marketing, and Product, to translate ambiguous requirements into scalable data and reporting solutions.
Serve as a subject matter expert for KPI definitions and ensure alignment across teams and reporting layers.
Support BI platform strategy, including performance optimization, scalability, and governance of MicroStrategy environments.
Analyze business user needs and develop BI reporting solutions, including MicroStrategy reports and dashboards.
Work with data scientists to design, develop, or manipulate data to predict and measure outcomes and consequences of design.
Develop BI application testing and validation procedures and provide documentation.
Consult with and support customers on BI application design and maintenance.
Work with department managers and executives to identify needs and software requirements and assess design feasibility within time and cost constraints.
Develop, create, and modify general BI application software or specialized utility programs.
Design BI applications for client use to optimize operational efficiency.
Modify MicroStrategy reports and dashboards to correct errors, adapt to system changes, or improve performance.
Analyze user requirements and design and develop graphs, charts, dashboards, and other BI solutions.
Apply logical data modeling concepts, such as star schema, 3NF, and dimensional modeling, to reporting solutions within existing data warehouse structures.
Design and deliver end-user training and training materials, and provide technical support as necessary.