Lead BI Engineer – Retail Analytics

Lead BI Engineer – Retail Analytics

Fractal is a strategic AI partner to Fortune 500 companies with a vision to power every human decision in the enterprise. Fractal is building a world where individual choices, freedom, and diversity are the greatest assets. An ecosystem where human imagination is at the heart of every decision. Where no possibility is written off, only challenged to get better. We believe that a true Fractalite is the one who empowers imagination with intelligence. Fractal has been featured as a Great Place to Work by The Economic Times in partnership with the Great Place to Work® Institute and recognized as a ‘Cool Vendor’ and a ‘Vendor to Watch’ by Gartner.

Please visit Fractal | Intelligence for Imagination for more information about Fractal

Note: This position is not eligible for Immigration Sponsorship at this time

Location: Bay Area, CA (Hybrid, 3 days per week onsite preferred)

Role Overview:

We are seeking a hands-on Senior BI Engineer to support a large-scale Retail Store Analytics engagement for one of the most recognized global technology brands in the world. In this role, you will own the dashboard development, design, and maintenance standards for the client's analytics ecosystem, creating and curating reusable design components for custom web applications and Tableau dashboards, including Tableau visualization extensions and the curation of client brand assets.

You will work closely with business teams to understand requirements, design intuitive visualizations, and deliver production-quality BI solutions using Tableau, ThoughtSpot, and Plotly. You will be the design voice within a blended delivery team, working day-to-day alongside the client's analytics and BI stakeholders and approximately 15 Fractal BI engineers and full-stack developers. Your work will directly shape a program that consolidates over 80 dashboards into a single, coherent reporting hub with consistent architecture, interaction patterns, and visual identity, while elevating the usability and self-service experience of the client's data products.

Key Responsibilities:

• Design and develop dashboards and reports in Tableau, ThoughtSpot, and Plotly
• Translate business requirements into technical specifications and data models
• Work with analytics engineers on data modeling and dimension table design
• Implement dbt data quality tests and ensure data used in dashboards is accurate
• Centralize and standardize ~80 dashboards into a single hub with consistent architecture
• Create comprehensive documentation for all dashboards including lineage and refresh schedules
• Manage access control and resolve dashboard permission issues promptly
• Provide ad-hoc analysis and custom dashboard development for stakeholder requests
• Optimize dashboard performance and query efficiency
• Stay current with BI tool features and recommend improvements
• Participate in design reviews and provide feedback on data visualization best practices
• Train stakeholders on self-service analytics capabilities

Required Experience:

• 6-10 years of BI/Analytics engineering experience
• 4+ years developing dashboards in Tableau or similar BI tools
• 3+ years with SQL and data warehouse concepts
• 2+ years working with business stakeholders and requirements gathering

Technical Skills:

• Expert-level proficiency in Tableau (or equivalent BI tool)
• Advanced SQL: complex queries, window functions, performance optimization
• Experience with dbt (data transformation and testing)
• Knowledge of Snowflake and data warehouse architectures
• Familiarity with Plotly and ThoughtSpot (or similar analytics platforms)
• Basic Python or JavaScript for custom visualizations (desirable)
• Understanding of data governance and security best practices

Soft Skills:

• Strong communication skills with ability to explain technical concepts to non-technical users
• Design thinking mindset with focus on user experience
• Attention to detail and quality assurance
• Ability to manage multiple stakeholder requests and prioritize effectively
• Collaborative team player with willingness to mentor junior team members

Education:

• Bachelor's degree in Computer Science, Engineering, Mathematics, Statistics, or related field
• Master's degree or relevant certifications preferred

Pay:

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Fractal, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $120,000 - $160,000 with the potential for a higher base depending on experience, skills, and overall fit for the position. In addition, for the current performance period, you may be eligible for a discretionary bonus.

Benefits:

As a full-time employee of the company or as an hourly employee working more than 30 hours per week, you will be eligible to participate in the health, dental, vision, life insurance, and disability plans in accordance with the plan documents, which may be amended from time to time. You will be eligible for benefits on the first day of employment with the Company. In addition, you are eligible to participate in the Company 401(k) Plan after 30 days of employment, in accordance with the applicable plan terms. The Company provides for 11 paid holidays and 12 weeks of Parental Leave. We also follow a “free time” PTO policy, allowing you the flexibility to take the time needed for either sick time or vacation.

Fractal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.