ETL / BI Developer
Salary is DOE; ~85-125k
Anaheim, CA 92805
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
Experience with Microsoft Power BI
Experience with Microsoft Azure
Experience with Git
Experience in Manufacturing
BSCS, BSIT, or similar
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
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.
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.