Staff Data Engineer (BI)

Overstock.com; Oregon; Hybrid; USD 117,000 - 150,000; Full time

Job summary

Bed Bath & Beyond is seeking a remote Business Intelligence Analyst to collaborate with data engineering and leadership to deliver scalable BI solutions using MicroStrategy. You will translate requirements, define KPIs, and drive governance across reporting layers from dashboards to data models.

Expect to design and optimize BI reports, validate data, and partner with data scientists to derive actionable insights, while supporting end-user training and BI app maintenance.

Qualifications

• Bachelor's degree in CS/IT/Data Analytics or related field.
• 4+ years in BI analytics with relational databases and SQL.
• 4 years creating MicroStrategy reports, metrics, filters, dashboards.
• 4 years designing logical data models in MicroStrategy.
• 4 years optimizing complex SQL in relational DBs.
• 4 years data validation and reconciliation for reports.
• 3 years cloud data platforms (GCP/AWS/Azure) incl. large datasets.
• 2 years relational data models and data warehouse (BigQuery/Snowflake).

Responsibilities

• Collaborate with data engineering to onboard new data sources for reporting.
• Translate ambiguous requirements into scalable data and reporting solutions.
• Serve as SME for KPI definitions and align across teams.
• Support BI platform strategy, governance, and MicroStrategy performance.
• Develop BI reports and dashboards using MicroStrategy.
• Work with data scientists to model data for predictions and insights.
• Design BI testing procedures and proper documentation.
• Consult and support customers on BI app design and maintenance.
• Identify needs with managers to determine feasibility, time, and cost.
• Create and modify general BI apps and utilities.
• Design BI apps for client use to optimize operations.
• Modify MicroStrategy reports/dashboards for errors and performance.
• Analyze user requirements to build graphs, charts, dashboards.
• Apply star schema and 3NF dimensional modeling for reporting.
• Deliver end-user training and materials; provide support.

Skills

BI reporting

SQL queries

Data modeling

MicroStrategy

Cloud platforms (GCP/AWS/AZ)

Relational databases

Data analytics

Education

Bachelor's degree in CS/IT/Analytics

Tools

MicroStrategy

BigQuery/Snowflake

Job description

We Go Beyond:At Bed Bath & Beyond, we believe that everyone should "Be You!" Bed Bath & Beyond is a community that upholds a culture of understanding, acceptance, and respect. We believe a person's individuality, traits, beliefs, and characteristics should be valued and embraced. Living by this ethos is essential to the success of our business. Our goal is to foster a more inclusive environment where every employee visibly demonstrates inclusive behaviors and respect for individuals.

Job Duties

• Collaborate with data engineering teams to onboard new data sources required for reporting and analytics.
• Collaborate with business leaders (including Finance, Marketing, 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 the overall BI platform strategy, including performance optimization, scalability, and governance of MicroStrategy environments.
• Analyze business user needs and develop Business Intelligence (BI) reporting solutions, including development of reports and dashboards using MicroStrategy.
• Work with data scientists to design, develop and/or manipulate data to predict and measure outcome and consequences of design.
• Develop business intelligence application testing and validation procedures and provide proper documentation.
• Consult and provide support for customers about BI apps design and maintenance.
• Work with department managers and executives to identify needs and software requirements to determine feasibility of design within time and cost constraints.
• Develop, create, and modify general BI applications software or specialized utility programs.
• Design BI applications for client use with the aim of optimizing operational efficiency.
• Modify existing MicroStrategy reports and dashboards to correct errors, adapt to system changes, or improve performance.
• Analyze user requirements and based on findings, design and develop graphs, charts, dashboards and other BI solutions.
• Apply logical data modeling concepts (e.g., star schema, 3NF, dimensional modeling) to support reporting solutions within existing data warehouse structures.
• Design and deliver end-user training and training materials; provide technical support as necessary.

Telecommuting

This position is 100% remote; must reside in U.S.; and reports to HQ in Murray, UT.

Salary: $116,917 - $150,000 per year

Minimum Requirements

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

Physical Requirements

This position requires you to sit, stand and perform general office functions. You may also be required to lift up to 25 pounds occasionally. Bending, stooping and reaching are also frequently required.

Equal Employment Opportunity

It is our policy to provide equal employment opportunity for all applicants and associates.

This policy includes our commitment to ensure that all employment decisions are made without regard to race, color, religion, gender, national origin, disability, pregnancy, veteran status (including Vietnam era veterans), age, sexual orientation, gender identity, or any other non-job-related characteristic protected by law.