Database Developer - 4481

MagnaFlow; Oceanside (CA); On-site; USD 130,000 - 150,000; Full time

Benefits offered by this job

Competitive Salary

PTO and Sick Leave

Birthday Holiday

Paid Holidays

Medical, Dental, Vision

401k Matching

Job summary

Magnaflow, based in Oceanside, CA, seeks a Database Developer to design, develop, and optimize database solutions for BI and analytics initiatives. You will build ETL/ELT pipelines using SSIS, Azure Data Factory, and Databricks, and develop data warehouses to empower reporting across the organization.

The role requires 5+ years in database development, deep knowledge of SQL Server and Azure SQL, and experience with data governance and data quality practices.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field or equivalent hands-on experience.
• Minimum 5+ years of experience in database development, data engineering.
• Advanced expertise in Microsoft SQL Server and Azure SQL, including query optimization and stored procedure development.

Responsibilities

• Design, develop, and maintain high-performance database solutions.
• Build and manage ETL/ELT pipelines using SSIS, Azure Data Factory, Databricks.
• Develop and support enterprise data warehouse and data mart architectures.
• Collaborate with application developers, analysts, and business stakeholders to translate requirements into data models.
• Ensure data quality, integrity, and governance across platforms.

Skills

Analytical mindset

Communication

Education

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

Tools

SSIS

Azure Data Factory

Databricks

SQL Server

Azure SQL

Power BI

Tableau

Python

PowerShell

.NET

Job description

Who are we:Magnaflow is a leading manufacturer and supplier based in Oceanside, CA of premium products to the automotive aftermarket industry such as catalytic converters, performance exhaust and replacement exhaust. Through the Camburg division in Huntington Beach, CA. Magnaflow also supplies race-inspired performance suspension products and vehicle uplifting services, Magnaflow is focused on future growth through both new business development and new product introduction. Our websites are www.magnaflow.com and www.camburg.com.Salary Range:$130,000-$150,000 USD annually*Final agreed upon compensation will be based on a variety of factors including but not limited to an individual’s related experience, education, certifications, skills, and work location.What you will be doing:The Database Developer is responsible for designing, developing, maintaining, and optimizing the organization's databases, data pipelines, and reporting infrastructure. This role ensures data integrity, availability, security, and performance while supporting business intelligence, analytics, and operational applications. The ideal candidate combines strong database development expertise with modern data engineering practices to transform raw data into reliable, scalable solutions that drive business decisions.Responsibilities:Design, develop, and maintain high-performance database solutions, including complex stored procedures functions, and query optimization across SQL Server and Azure SQL environmentsBuild and manage scalable, fault-tolerant ETL/ELT pipelines using both on-prem and cloud-based tools (e.g., SSIS, Azure Data Factory, Databricks)Develop and support enterprise data warehouse and data mart architectures to enable reporting, analytics, and business intelligence initiativesCollaborate with application developers, analysts, and business stakeholders to translate business requirements into efficient data models and solutionsEnsure data quality, integrity, and consistency through validation, monitoring, and implementation of data governance best practicesOptimize database and warehouse performance through indexing, partitioning, query tuning, and workload managementImplement robust backup, recovery, and disaster recovery strategies to ensure availability and resilience of critical data systemsSupport integration between enterprise systems (ERP, WMS, etc.) through reliable and scalable data pipelinesTroubleshoot and resolve data-related issues, performance bottlenecks, and ETL failures in production environmentsSupport users with analytics tools such as PowerBIRequirements:Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent hands-on experience5+ years of experience in database development, data engineering, or related rolesAdvanced expertise in Microsoft SQL Server and Azure SQL, including query optimization and stored procedure developmentWhat you need:Strong experience with ETL/ELT development using tools such as SSIS, Azure Data Factory, Databricks, or similar platformsExperience designing and supporting data warehouse architectures (star/snowflake schemas, data marts, fact/dimension modeling)Working knowledge of additional database technologies (e.g., Oracle, MySQL, or NoSQL platforms)Experience with scripting and development languages such as Python, PowerShell, or .NET for automation and data processingFamiliarity with reporting and analytics tools (SSRS, Power BI, Tableau, or similar)Strong understanding of data integration patterns, data governance, and best practices for data securityExcellent problem-solving skills with a focus on performance, scalability, and reliabilityWhat’s in it for you?Competitive SalaryPTO, Sick Pay, Birthday Holiday, Paid HolidaysMedical, Dental, Vision401k Matching (Up to 5%)Education assistanceCompany sponsored eventsGrowing department and team#LI-Onsite