BI Engineer - Data Analytics

Costco • Issaquah, WA

1d • $85,000 - $225,000 • Onsite

About The Position

Costco IT is responsible for the technical future of Costco Wholesale, the third largest retailer in the world with wholesale operations in fourteen countries. Despite our size and explosive international expansion, we continue to provide a family, employee centric atmosphere in which our employees thrive and succeed. This is an environment unlike anything in the high-tech world and the secret of Costco’s success is its culture. The value Costco puts on its employees is well documented in articles from a variety of publishers including Bloomberg and Forbes. Our employees and our members come FIRST. Costco is well known for its generosity and community service and has won many awards for its philanthropy. The company joins with its employees to take an active role in volunteering by sponsoring many opportunities to help others. Come join the Costco Wholesale IT family. Costco IT is a dynamic, fast-paced environment, working through exciting transformation efforts. We are building the next generation retail environment where you will be surrounded by dedicated and highly professional employees. Business Intelligence (BI) Engineers are responsible for the successful delivery, design, and support of high visibility desktop reports, mobile reports, and dashboards. BI Engineers leverage BI applications in accordance with application development standards and best practices. BI Engineers work closely with Product Owners and UI/UX Designers during wireframe and prototype development. This role will also engage with Architects (Solution/Data), Engineers (Data, Platforms, DevOps, etc.), and Stakeholders to deliver timely, accurate, high performing, and reliable BI products and solutions to end-users. BI Engineers identify ways to improve data reliability, efficiency, and quality of data management required for building BI applications and reports. If you want to be a part of one of the worldwide BEST companies “to work for”, simply apply and let your career be reimagined.

Requirements

• 3+ years’ experience working with BI technologies and tools, such as Microsoft Power BI, IBM Cognos, SAP Webi and Tableau; proven and successful implementations of Microsoft Power BI.
• 2+ years’ of experience with Power BI.
• 1+ years’ using programing languages, such as DAX, MDX, SQL, Python, Java, C#
• 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.

Nice To Haves

• 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 with Big Query.
• 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 Airflow, UC4 Job Scheduler (or similar Job Schedulers), Cloud Run and Power Automate toolset.
• Proficient in Google Workspace applications, including Sheets, Docs, Slides, and Gmail.

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, Airflow, UC4, Cloud Run, Azure Functions, 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: Big Query, Oracle, SAP BW, SAP HANA, and Azure services, such as Azure SQL DW (Synapse), ADLS, Cosmos, Databricks, Delta-Lake and fabric mirroring 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.

Benefits

• paid time off
• health benefits - medical/dental/vision/hearing aid/pharmacy/behavioral health/employee assistance
• health care reimbursement account
• dependent care assistance plan
• short-term disability and long-term disability insurance
• AD&D insurance
• life insurance
• 401(k)
• stock purchase plan

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: Associate degree