Mobis Parts America, LLC. builds and runs Azure-based data platforms that support enterprise reporting, analytics, and business intelligence. In this onsite Data Engineer III, Cloud role in Fountain Valley, CA, you will design, implement, and maintain secure, scalable cloud data pipelines and infrastructure while working closely with business analysts, Power BI developers, DBAs, and infrastructure teams.
What you’ll be doing
You will develop end-to-end ETL/ELT workflows, including automated batch and near real-time data integration. This includes integrating data from on-premises and cloud environments, troubleshooting production data workflows, and optimizing performance through tuning and query optimization.
- Design, develop, and maintain ETL/ELT pipelines
- Build automated batch and near real-time integration processes
- Integrate on-premises and cloud data sources
- Troubleshoot and optimize data workflows, including performance tuning and query optimization
- Design and maintain data warehouse and data lake architectures
- Develop logical and physical data models
- Optimize database schemas, indexes, and partitioning strategies
- Support historical data retention and archival requirements
You will also operate and improve core Azure services that power the platform.
- Manage and support Azure Data Factory (ADF)
- Manage and support Azure Data Lake Storage (ADLS) and Azure Data Lake Storage Gen2
- Manage and support Azure SQL Database and Azure PostgreSQL (Azure Database for PostgreSQL)
- Manage and support Azure ExpressRoute, Gateway Servers, and Azure Virtual Networks
- Configure networking, security groups, and access controls
Operational excellence matters. You will monitor platform availability and performance, handle maintenance activities, and respond to production incidents with root-cause analysis, while supporting availability and continuity needs.
- Monitoring and maintenance, including monitoring platform availability and performance
- Backup and recovery management
- High Availability (HA) and disaster recovery planning
- Replication and failover configuration
- Develop scripts and automation for operational tasks
- Support CI/CD deployment processes
- Automate monitoring, alerting, and maintenance activities
- Resolve production incidents and root causes; maintain SLA and operational standards
- Provide technical support to business and development teams
Qualifications
- 4 - 7 years of data engineering experience (Required)
- 3 - 5 years of Azure cloud experience (Preferred)
- Experience with Power BI environments
- Experience migrating on-premises systems to Azure
- Bachelor’s Degree in Computer Science, Information Systems, or related field (Required)
- Experience with: Azure Data Factory (ADF), Azure Data Lake Storage Gen2, Azure SQL Database, Azure Database for PostgreSQL, Azure ExpressRoute, and Azure Virtual Networks
- Knowledge of SQL, data modeling, ETL / ELT, and data warehousing
- Experience with Star Schema / Dimensional Modeling
- Scripting: Python, PowerShell, SQL T-SQL / PostgreSQL
Salary and schedule
This exempt, annual-salary position offers an expected hiring range of $90,466.10 - $134,342.16, depending on experience and qualifications.
Schedule: Monday - Friday, 8:00 AM - 5:00 PM with a flexible schedule at the discretion and approval of the Manager. No travel required.
Benefits
- Medical, Dental, and Vision
- 401K with employer matching
- Tuition Reimbursement
- Paid Vacation, Paid Sick Days and Paid Holidays
- Mapped career plans
- Company Discounts & more!
