Overview

ETL / BI Developer
Direct Hire
Salary is DOE; ~85-125k
Anaheim, CA 92805

Required:

SQL Server

SSIS

SSAS

Strong T-SQL skills with understanding of data aggregation/manipulation through complex queries, views and stored procedures.

Recent experience enhancing, supporting and maintaining Business Intelligence and Data Warehouse solutions

Desired:

Experience with Microsoft Power BI

Experience with Microsoft Azure

Experience with Git

Experience in Manufacturing

BSCS, BSIT, or similar

Soft Skills:

Strong problem solving, quantitative and analytical abilities

Strong ability to collaborate in a cross-functional team environment with users of diverse backgrounds and skill levels from the novice user to the expert programmer

Strong communication skills, both written and verbal

Responsibilities:

Provide strategic, analytic and technical support for the enterprise Business Intelligence (BI) activities. Monitor and resolve support issues related to the BI and data warehouse platform.

Extract, transform, and load (ETL) data from various source systems into the data warehouse as well as provide data integration between business applications utilizing T-SQL and SSIS.

Proficiency in T-SQL, with the ability to understand, formulate and create efficient queries, views and stored procedures to prepare data for ETL, ad-hoc requests and reports.

Partner with key stakeholders to gather requirements and build data cubes and data marts using SSIS and SSAS to meet their needs.

Participate in data quality analysis projects, including data validation and data quality exception reporting.

Maintain data warehousing processes including automation, load management, scheduling, performance monitoring and tuning.

Assist with process documentation.

Summary:

We’ve been in business for 30+ years and are a leader in Audio/Video equipment supporting a variety of sectors including Corporate, Industrial, Government, Healthcare, etc. You will work as a member of a small team designing, building and deploying Business Intelligence solutions to meet the company’s strategic objectives. They will monitor and maintain existing Business Intelligence and ETL processes and provide support as needed. The developer should be analytical, an excellent communicator and have a problem-solving attitude.


More Jobs: