BI Engineer - Data Analytics

About the role

The Business Intelligence (BI) Engineer at Costco Wholesale is responsible for the successful delivery, design, and support of high visibility desktop reports, mobile reports, and dashboards. They work closely with Product Owners and UI/UX Designers during wireframe and prototype development, and engage with Architects, Engineers, and Stakeholders to deliver timely, accurate, high performing, and reliable BI products and solutions to end-users.

Responsibilities

• Owns responsibility for end-to-end development and support of Costco’s BI reporting environments for ongoing metrics, reports, dashboards, etc.
• Aids 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.
• 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.
• Pairs 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.
• Buils 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.

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 programming 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.

Preferred Qualifications

• 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.

Benefits

We offer a comprehensive package of benefits including 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 to eligible employees.

Pay

Pay ranges from Level 1 - $85,000 - $110,000 to Level SR - $150,000 - $190,000, with bonus and restricted stock unit (RSU) eligibility.

Equal Opportunity Employer

Costco is committed to a diverse and inclusive workplace. Costco is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or any other legally protected status.