Enterprise BI Specialist II — Data Modeling & Dashboards

Meissner Filtration Products, Inc.; Camarillo (CA); On-site; USD 97,000 - 130,000; Full time

Benefits offered by this job

Medical, Dental and Vision with HSA

Onsite gym facilities

Coffee bars at HQ

EV charging stations

401k and Profit Sharing

Life Insurance

Employee Assistance Program

Paid Time Off and Holidays

Job summary

Meissner Filtration Products, Inc. is seeking a Business Intelligence Specialist II to design, develop, and manage enterprise BI solutions.

This role mentors junior teammates and owns moderate-to-complex projects, delivering insights through data modeling and optimized reporting across units. You will design enterprise BI dashboards using Microsoft technologies, develop ETL processes, optimize data models, and lead requirements sessions with stakeholders, ensuring data quality and performance

Qualifications

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

Responsibilities

• Design and develop enterprise BI reports and dashboards across multiple business units.
• 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 specs.
• Perform data quality audits and implement data validation frameworks.
• Optimize BI tool performance and manage upgrades and migrations.
• Mentor level I Specialists and provide code reviews.
• Develop and maintain BI documentation and best practices.
• Troubleshoot complex technical issues and implement solutions.
• Recommend and implement enhancements to BI infrastructure and tools.

Skills

Advanced SQL

BI reporting

Data modeling

Stakeholder management

Mentoring

Data visualization

Python familiarity

Education

Bachelor’s degree in Information Technology, Computer Science, Data Science or related field

Tools

Azure Data Warehouse

Power BI

Azure DevOps

ETL tools

Job description

Meissner Filtration Products, Inc. is seeking a Business Intelligence Specialist II to design, develop, and manage enterprise BI solutions.

This role mentors junior teammates and owns moderate-to-complex projects, delivering insights through data modeling and optimized reporting across units. You will design enterprise BI dashboards using Microsoft technologies, develop ETL processes, optimize data models, and lead requirements sessions with stakeholders, ensuring data quality and performance