BI Solutions Lead: Data Modeling, Dashboards & Mentorship

MEISSNER FILTRATION PRODUCTS; Camarillo (CA); On-site; USD 65,000 - 87,000; Full time

Benefits offered by this job

Medical, Dental and Vision coverage

HQ Onsite Gym

Free EV Charging Stations

401k, Profit Sharing

Life Insurance

Employee Assistance Program

Paid Time Off & Holidays

Job summary

Meissner Filtration Products in Camarillo, CA is seeking a Business Intelligence Specialist II to design, develop, and manage enterprise BI solutions. You will mentor junior team members and drive data modeling and optimization across projects.

This role requires advanced SQL, ETL, and experience with Azure Data Warehouse and Power BI. You will partner with stakeholders to translate needs into technical specs and ensure data quality.

Qualifications

• Bachelor’s degree in Information Technology, Computer Science, Data Science or related field required.
• 4+ years of experience developing BI reports, dashboards, and data solutions.
• Advanced SQL skills and proficiency with multiple BI tools.
• Experience with ETL tools.
• Proficiency with Azure Data Warehouse or similar platforms.

Responsibilities

• Design and develop enterprise-level BI reports and dashboards supporting multiple business units using Microsoft technologies.
• Develop complex ETL processes and manage data warehouse objects.
• Create and optimize data models for improved report performance.
• Develop SQL queries to support reporting objectives.
• Lead requirements gathering sessions and translate business needs into technical specifications.
• Perform data quality audits and implement data validation frameworks.
• Optimize BI tool performance and manage system upgrades and migrations.
• Mentor level I Specialists and provide code review and quality assurance.
• Develop and maintain BI documentation and best practices standards.
• Troubleshoot complex technical issues and implement solutions.
• Recommend and implement enhancements to BI infrastructure and tools.

Skills

SQL

ETL

Azure Data Warehouse

Data Modeling

Python

Education

Bachelor’s degree in IT / CS / Data Science or related field

Tools

Power BI

Azure DevOps

ETL Tools

SQL Tools

Azure Data Platform

Job description

Meissner Filtration Products in Camarillo, CA is seeking a Business Intelligence Specialist II to design, develop, and manage enterprise BI solutions. You will mentor junior team members and drive data modeling and optimization across projects.

This role requires advanced SQL, ETL, and experience with Azure Data Warehouse and Power BI. You will partner with stakeholders to translate needs into technical specs and ensure data quality.