Logo of Huzzle

BI Engineer - Data & Analytics

  • Job
    Full-time
    Mid-level (3-4 years)
  • Seattle

AI generated summary

  • You should have experience in BI tools, data modeling, data analysis, and strong SQL skills. Familiarity with analytics and reporting practices is essential.
  • You will design and implement data models, analyze data trends, and create dashboards to drive business insights, ensuring data accuracy and availability for informed decision-making.

Requirements

  • Required
  • 3+ years’ experience working with BI technologies and tools, such as IBM Cognos, Microsoft Power BI, Tableau; proven and successful implementations of Microsoft Power BI.
  • 2+ years’ of experience with Power BI.
  • 1+ years’ using programing languages, such as Java, C#, DAX, MDX, SQL, Python.
  • 1+ years’ BI related experience using ETL, Data warehousing management, Data Mining, Report Designer or development; ability to write complex SQL queries against a variety of data sources.
  • Experience in using Azure cloud architecture, low code power apps, visualization technologies.
  • Strong analytical and problem solving skills.
  • Recommended
  • BA/BS or higher in Computer Science, Engineering, or equivalent software/services experience.
  • Microsoft Power BI, Power Apps, Power Automate, Microsoft Power Platforms, IBM Cognos, Tableau certifications.
  • Azure Certifications.
  • Experience with Git / Azure DevOps.
  • Experience delivering reporting design, visualizations, and solutions through agile software development methodologies.
  • Experience working with sensitive data and ecommerce/distribution/logistics business areas.
  • Exposure to the retail industry.
  • Exposure to developing solutions for retail metrics (sales, inventory, margin, projections etc.).
  • Excellent verbal and written communication skills.
  • Experience with UC4 Job Scheduler or similar Job Schedulers, Power Automate toolset.
  • Required Documents
  • Cover Letter
  • Resume

Responsibilities

  • Owns responsibility for end-to-end development and support of Costco’s BI reporting environments for ongoing metrics, reports, dashboards, etc.
  • Assists in the design and development of proof of concept and prototype application environments.
  • Adopts and adapts to newly approved technologies, programming languages, tools, and standards for business intelligence.
  • Collaborates to ensure application designs utilize appropriate patterns and standards.
  • Documents BI application specifications and produces operational support manuals.
  • Analyzes business needs and software requirements to determine the feasibility of design within time and cost constraints, including the ability to estimate work needed.
  • Identifies and interprets trends, patterns, and correlations among various data points.
  • Assesses functional and nonfunctional requirements and creates designs to meet both business and technical needs.
  • Designs builds and maintains automated reporting, dashboards, and analysis to enable teams to self-service data needs.
  • Supports defining technical requirements, such as tool or platform selection criteria for the reporting environments.
  • Assists in solution design efforts (i.e. analysis, data warehouse design, architecture) and understands the data warehouse or data marts implementation related to BI.
  • Takes full responsibility for the balance between functional, system management, and service quality.
  • Ensures the appropriate BI architectural standards are adhered to.
  • Tests and resolves problems, performs root cause analysis, identifies gaps, recommends solutions and preventative measures.
  • Automates, documents, shares, educates, delegates, and improves processes.
  • Applies knowledge to practical and sustainable applications and capabilities.
  • Partners with product owners, product managers, the solution leads, and other stakeholders to create and maintain robust datasets and models to support reporting and self-service solutions.
  • Builds prototypes and wireframes of potential features.
  • Translates business needs into technical specifications to deliver customized reporting and software solutions (BI, Advanced analytics, APIs/Services).
  • Works in tandem with BI/Solution Architects, Data Architects, Data Stewards, Data Engineers, Data Scientists, and Data Quality Engineers to design efficient visualizations, score cards, dashboards, reports; and recommends ongoing optimization of BI data models, data sets, and data quality.
  • Oversees the end-to-end development and support of Costco’s BI reporting environments for ongoing metrics, reports, dashboards using Power BI, Power App, Power Automate, and other technologies as needed.
  • Creates data visualizations that illustrate data learnings and insights in an understandable and user-friendly manner through software UI / UX design using Power BI and other tools as needed.
  • Creates, refines, and optimizes dashboards for reporting applications by connecting to one or many of the following: Oracle, SAP BW, SAP HANA, and Azure services, such as Azure SQL DW (Synapse), ADLS, Cosmos, Databricks, Delta-Lake to improve and speed up delivery of BI solutions.
  • Identifies, designs, and implements internal process improvements: automating manual processes, optimizing BI capabilities.
  • Identifies ways to improve data reliability, efficiency, and quality of data management required for building BI applications and reports.
  • Communicates technical concepts to non-technical audiences both in written and verbal form.
  • Performs peer reviews for other BI engineers’ work.

FAQs

What is the main responsibility of a BI Engineer at Costco IT?

The main responsibility of a BI Engineer is to own the end-to-end development and support of Costco’s BI reporting environments, which includes metrics, reports, dashboards, and ensuring their timely and accurate delivery.

What technologies and tools should a BI Engineer be familiar with?

A BI Engineer should be familiar with BI technologies and tools such as Microsoft Power BI, IBM Cognos, and Tableau, as well as programming languages like Java, C#, DAX, MDX, SQL, and Python.

Is experience with Azure cloud architecture required for this role?

Yes, experience with Azure cloud architecture is required for the BI Engineer position.

What qualifications are recommended for applicants?

Recommended qualifications include a BA/BS or higher in Computer Science or Engineering, Microsoft Power BI and Azure certifications, experience delivering reporting design through agile methodologies, and exposure to the retail industry and metrics.

What types of applications and solutions will BI Engineers be working on?

BI Engineers will be working on business intelligence solutions, including complex data sets, queries, reports, dashboards, and analyses for critical merchandising operations.

What is the pay range for a BI Engineer position?

The pay range for the BI Engineer position varies by level: Level 1 is $85,000 - $110,000, Level 2 is $105,000 - $135,000, and Level 3 is $130,000 - $160,000.

Do BI Engineers have to collaborate with other teams?

Yes, BI Engineers need to collaborate with product owners, solution architects, data architects, data engineers, and other stakeholders to design and implement efficient BI solutions.

How important are communication skills for this role?

Excellent verbal and written communication skills are very important for this role, as BI Engineers must communicate technical concepts to non-technical audiences.

What kind of benefits does Costco offer to BI Engineers?

Costco offers a comprehensive package of benefits that includes paid time off, health benefits (medical, dental, vision, etc.), 401(k), stock purchase plan, and various types of insurance, among others.

Is prior experience in the retail industry preferred?

Yes, exposure to the retail industry and developing solutions for retail metrics such as sales and inventory is preferred for this role.

Retail & Consumer Goods
Industry
10,001+
Employees
1983
Founded Year

Mission & Purpose

Costco Wholesale is a multibillion dollar global retailer with warehouse club operations in 11 countries. We are the recognized leader in our field, dedicated to quality in every area of our business and respected for our outstanding business ethics. Despite our large size and rapid international expansion, we continue to provide an atmosphere in which our employees thrive and succeed. If you are an ambitious, energetic person who enjoys a fast-paced team environment filled with challenges and opportunities, you've come to the right place. Our successful employees are service-oriented with integrity and commitment toward a common goal of excellence. Costco offers great jobs, great pay, great benefits and a great place to work.