BI Developer Analytics Engineer

$90000 - $100000 per year | Montebello, CA | On-site | Permanent

We are a tech-enabled last mile delivery provider that specializes in connecting ecommerce shippers to their customers through fast and reliable delivery services. We offer next-day and 2-day delivery options tailored for retailers, marketplaces, and direct-to-consumer brands, along with seamless integration for logistics providers and 3PLs.

Our focus is on technical innovation, our company ensures real-time tracking, SMS updates, and cost-effective solutions to enhance the delivery experience. Our services cover over 11,000 zip codes across the U.S. and Canada, reaching a population of 175 million customers.

• Competitive Compensation
• Growth role
• Full Benefits, including 401K
• Growing Tech-Focused Company
• PTO and Holiday Pay

We are seeking a Bilingual (English/Mandarin) BI Developer / Analytics Engineer to design, develop, and maintain enterprise reporting and analytics solutions that transform raw data into actionable business insights. This role will work closely with Business Analysts, business stakeholders, and data engineering teams to build scalable dashboards, semantic models, curated data marts, and self-service reporting solutions.

We will sponsor a candidate for this role.

The ideal candidate has strong experience in business intelligence development, dimensional data modeling, SQL optimization, and dashboard design using modern BI platforms. This role requires both technical expertise and strong business understanding to ensure consistent, reliable, and scalable analytics across the organization.

• Design, develop, and maintain interactive dashboards, reports, and self-service analytics solutions
• Build enterprise reporting solutions using Power BI, Tableau, and web-based dashboard technologies
• Translate business requirements provided by Business Analysts into scalable analytics and reporting assets
• Develop reusable datasets, semantic layers, and business-friendly data models
• Support executive, operational, and departmental reporting needs

• Design and maintain curated data marts for reporting and analytics
• Build dimensional data models including star and snowflake schemas
• Define and standardize enterprise KPIs and business metrics
• Develop semantic/business models to ensure consistency across reports and dashboards
• Collaborate with data engineering teams to optimize data structures for analytical consumption

• Write and optimize complex SQL queries for analytics workloads
• Improve dashboard performance, data refresh efficiency, and query execution times
• Troubleshoot reporting and data performance issues
• Ensure scalability and maintainability of BI solutions

• Standardize metrics and reporting definitions across departments
• Maintain data accuracy, consistency, and reporting quality standards
• Implement BI development best practices and documentation standards
• Support user acceptance testing (UAT) and dashboard validation activities

• Work closely with Business Analysts and stakeholders to understand reporting requirements and business processes
• Partner with data engineers to ensure reliable and high-quality data pipelines
• Provide support and enhancements for existing dashboards and reporting solutions
• Train and support business users on self-service reporting capabilities

• Bachelor’s degree or Master’s degree in Computer Science, Information Systems, Data Analytics, Business Analytics, or related field
• 3+ years of experience in BI development, analytics…