BI Developer Analytics Engineer

Jobot; Montebello (CA); On-site; USD 90,000 - 100,000; Full time

Benefits offered by this job

Competitive compensation

Growth role

Full benefits including 401K

PTO and Holidays

Job summary

Jobot is seeking a bilingual BI Developer / Analytics Engineer in Montebello, CA to design, develop, and maintain enterprise reporting and analytics solutions using Power BI and Tableau. The role collaborates with Business Analysts and data teams to deliver scalable dashboards and semantic models.

The ideal candidate has 3+ years in BI, strong SQL, dimensional modeling, and business acumen to translate requirements into reliable analytics.

Qualifications

• 3+ years of experience in BI development, analytics engineering, or business intelligence solutions.
• Strong experience developing dashboards and enterprise reporting solutions.
• Advanced SQL skills and experience optimizing analytical queries.
• Experience with dimensional modeling and data warehousing concepts.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• 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 into scalable analytics and reporting assets
• Develop semantic datasets and business-friendly data models
• Support executive, operational, and departmental reporting needs
• Design and maintain curated data marts and dimensional models
• Define and standardize KPIs and metrics
• Collaborate with data engineering to optimize data structures for analytics
• Write and optimize complex SQL queries for analytics workloads
• Improve dashboard performance and data refresh efficiency
• Standardize reporting definitions and governance
• Provide training and support for business users on self-service reporting

Skills

SQL optimization

Dashboard design

Analytical thinking

Education

Bachelor’s or Master’s in CS/IS/Data Analytics

Tools

Power BI

Tableau

Job description

Bilingual BI Developer Analytics Engineer

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

A bit about us:

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.

Why join us?

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

Job Details

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.

Responsibilities and Duties:

Business Intelligence Development:

• 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

Data Modeling & Analytics Engineering:

• 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

Query Optimization & Performance:

• 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

Reporting Governance & Standards:

• 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

Collaboration & Support:

• 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

Required Education and Qualifications

• 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 engineering, or business intelligence solutions
• Strong experience developing dashboards and enterprise reporting solutions
• Advanced SQL skills and experience optimizing analytical queries
• Experience with dimensional modeling and data warehousing concepts
• Strong analytical, problem-solving, and communication skills

Must have Power BI and/or Tableau, as well as Web-based Dashboard Development

Jobot is an Equal Opportunity Employer. We provide an inclusive work environment that celebrates diversity and all qualified candidates receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, age (40 and over), disability, military status, genetic information or any other basis protected by applicable federal, state, or local laws. Jobot also prohibits harassment of applicants or employees based on any of these protected categories. It is Jobot’s policy to comply with all applicable federal, state and local laws respecting consideration of unemployment status in making hiring decisions.

Sometimes Jobot is required to perform background checks with your authorization. Jobot will consider qualified candidates with criminal histories in a manner consistent with any applicable federal, state, or local law regarding criminal backgrounds, including but not limited to the Los Angeles Fair Chance Initiative for Hiring and the San Francisco Fair Chance Ordinance.

Information collected and processed as part of your Jobot candidate profile, and any job applications, resumes, or other information you choose to submit is subject to Jobot's Privacy Policy, as well as the Jobot California Worker Privacy Notice and Jobot Notice Regarding Automated Employment Decision Tools which are available at jobot.com/legal.

By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Jobot, and/or its agents and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here: jobot.com/privacy-policy