Data & Analytics Engineer (Microsoft Fabric) at Rincon Consultants, Inc – Ventura, California

About Us

We are a California-based environmental consulting firm with 500+ professionals and over 30 years of experience serving clients across the transportation, energy, water, infrastructure, private development, and government sectors. We are proud to be a Certified Great Place to Work, as reflected in the experiences our employees share on Glassdoor and the trust, connection, and sense of purpose felt across our company.
Our mission is to deliver practical, science-based environmental and planning solutions that support communities, infrastructure, and natural systems. At Rincon, people come first. We value collaboration, fairness, and transparency, and we are committed to creating an environment where everyone can grow, contribute meaningfully, and do their best work.

About the Role

Rincon Consultants is seeking a skilled Data & Analytics Engineer with experience in Microsoft Fabric to design, build, and maintain scalable data solutions. As part of the Enablement Team, this role will focus on the migration of enterprise data into MS Fabric, developing modern data pipelines, integrating diverse data sources, and enabling analytics and reporting across the organization. You will be responsible for managing business critical data engineering processes and data architecture solutions to enable analytical and reporting solutions by working closely with data analysts and business stakeholders to ensure high-quality, reliable, and accessible data.

How We Collaborate

This role may offer a hybrid work setup, blending time in the office with remote work as business needs evolve. We enjoy coming together in person to collaborate, connect with teammates, and partner with clients. We may prioritize candidates who live within 50 miles of a Rincon office. Eligible office locations for this role include Carlsbad, Fresno, Los Angeles, Monterey, Oakland, Palm Springs, Riverside, Sacramento, San Luis Obispo, San Diego, San Jose, Santa Barbara, and Ventura.

What You’ll Do

• Design, develop, and maintain data pipelines and ETL/ELT processes using Microsoft Fabric
• Build and manage Lakehouse architectures leveraging OneLake and Delta tables
• Develop and optimize data models for reporting and analytics (Power BI integration)
• Ingest and integrate data from various sources (flat files, APIs, databases, cloud services)
• Ensure data quality, governance, and security across the data platform
• Monitor and optimize data workflows for performance and cost efficiency
• Collaborate with cross-functional teams to understand business requirements and translate them into data solutions
• Implement CI/CD practices for data pipelines and infrastructure
• Document data architecture, pipelines, and workflows

What You’ll Bring

• Bachelor’s degree in Computer Science, Data Engineering, Data Science or related field (or equivalent experience)
• ​​​​​​​3+ years of experience in data engineering or related roles
• Hands-on experience with Microsoft Fabric (Data Factory, Lakehouse, Dataflows, Notebooks)
• Strong proficiency in SQL and Python (or PySpark)
• Experience working with Azure ecosystem (Azure Data Lake, Synapse, Azure SQL, etc.)
• Familiarity with data modeling concepts (star schema, dimensional modeling)
• Experience with ETL/ELT pipeline development
• Understanding of data governance, security, and compliance best practices

​​​​​​​​​Preferred Qualifications

• Experience with Microsoft Purview for data governance and control
• ​​​​​​​Experience with Power BI (semantic models, dashboards, DAX)
• Knowledge of Delta Lake and Spark-based processing
• Experience with real-time or streaming data pipelines
• Familiarity with DevOps tools (Azure DevOps, Git, CI/CD pipelines)
• Experience with environmental or related subject data

Investing in You

The base salary range for this full-time position is $110,000-$115,000 plus a generous benefits program. Salary ranges are based on the market median of similar jobs, according to third-party salary benchmark surveys. Base pay is determined based on internal equity and a candidate’s job-related knowledge, skills, and experience.

We offer a comprehensive Total Rewards Package designed to support employee well-being, growth, and financial security. Our benefits are designed to offer flexibility and choice, including health coverage options, employer-sponsored insurance, retirement benefits, generous time off, and programs that support learning, growth, and community engagement. Explore more about our culture, benefits, and life at Rincon on our Culture and Benefits page.

Additional Employment Information

Individuals offered employment must successfully complete a pre-employment drug screening as a condition of employment. Additionally, those hired who may be assigned to federal projects will be subject to further drug testing, including screening for cannabinoids (THC/marijuana), in compliance with the Drug-Free Workplace Act of 1988 and other applicable federal regulations, which take precedence over California state and local laws.

Rincon Consultants, Inc does not accept unsolicited applicant/candidate resumes from search firm recruiters and/or temporary agencies that do not have a signed contract and specified work order with Rincon Consultants. Further, such resumes received will be deemed the sole property of Rincon Consultants and no fees will be paid in the event Rincon Consultants subsequently hires such individual. Rincon Consultants is an equal opportunity employer. All aspects of employment will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.