We are currently seeking a Senior Data Warehouse Developer to collaborate with our technology and business leaders in advancing our database systems. This role will initially be based onsite in San Dimas, CA for the first 90 days, with potential for remote work thereafter.
Job Summary for the Senior Data Warehouse Developer:
As a Senior Data Warehouse Developer, you will provide technical expertise for data warehouse design, development, and implementation.
Key responsibilities for Senior Data Warehouse Developer include:
Designing database structures aligned with system architecture, considering factors such as data volumes, user base, distribution, response times, and security.
Developing and maintaining advanced Business Intelligence (BI) capabilities, including OLAP cubes and predefined reports.
Offering technical expertise in ETL, reporting and analytics, data discovery, and profiling.
Creating, maintaining, and optimizing SQL Server SSIS Packages and SSAS solutions within the data warehouse environment.
Architecting large scale data warehouses, implementing mid- to large-scale ETL solutions, performing data analysis and profiling, and leading ETL teams.
Providing off-hour and weekend on-call support for troubleshooting and identifying root causes of Data Warehouse production issues.
Preferred Requirements in the Senior Data Warehouse Developer:
Bachelor's degree in a related discipline (Computer Science preferred), or equivalent professional experience.
5-9 years of professional experience.
Proficiency in creating, maintaining, and optimizing SQL Server SSIS Packages and SSAS solutions within a data warehouse environment.
Desired Skills in the Senior Data Warehouse Developer:
Experience with Tableau Server, Power BI, and/or Snowflake is advantageous.