What are the responsibilities and job description for the Database Administrator position at CAR SOUND EXHAUST SYSTEMS INC?
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: $94,900-$121,200/annually
Location: ONSITE in Oceanside, CA
What you will be doing:
We are seeking a skilled BI Analyst specializing in Databricks to join our dynamic BI team. The ideal candidate will have a strong background in data analysis, data engineering, and data visualization, with specific expertise in using Databricks to transform and analyze data. You will work closely with stakeholders across the organization to deliver actionable insights and support data-driven decision-making.
Responsibilities:
- Ensure performance and security of data warehouse for both on-prem MS SQL and Azure SQL
- Design, develop, and maintain scalable data pipelines and ETL processes.
- Collaborate with developers, analysts, and business stakeholders to understand data requirements and translate them into effective data models.
- Ensure data quality and integrity by implementing best practices in data governance and validation.
- Develop and test effective backup and recovery for data warehouse including building fault tolerant ETLs
- Optimize data warehouse/data marts for performance and scale
Requirements:
- Bachelors degree in Computer Science, Information Systems, Data Science, a related field, or equivalent experience
- 5 years as a database administrator or architect
- Advanced Microsoft SQL/Azure SQL skills and related tools.
- Experience with PL-SQL, MySQL, NoSQL databases
- Experience with on-prem and cloud transformation tools (SSIS, Data Factory, Data Bricks, etc)
- Experience with development tools such as .NET and scripting languages such as Python, PowerShell, and others
- Experience with SSRS and other reporting and analytics tools.
- Knowledge of data visualization tools like Power BI, Tableau, or similar.
- Excellent problem-solving skills and attention to detail.
Whats in it for you?
- Competitive Salary
- PTO, Sick Pay, Birthday Holiday, Paid Holidays
- Medical, Dental, Vision
- 401k Matching (Up to 5%)
- Childcare assistance
- Education assistance
- Company sponsored events
- Growing department and team
#MF
Salary : $94,900 - $121,200