Redwood Credit Union is looking for a team player who will use their programming skills to develop solutions that meet our business objectives. Desired skills include data warehousing, business analytics, coding, designing, and debugging applications.
The role is based in either of our corporate offices in Santa Rosa or Napa, California.
THE JOB (THE BIG STUFF)
- You will respond to requests for ad-hoc queries, generating data that our business partners need to make good decisions. You will also play a key role in bringing data into various systems.
- You bring expert knowledge on SQL, Developing & optimizing queries, stored procedures, functions, and views
- Design and develop ETL processes that will transform a variety of raw data, flat files, xl spreadsheets into SQL Databases
- A solid understanding of data management best-practices and in-depth experience with Microsoft SSIS & SSRS is required
- Design and develop enterprise and departmental business intelligence and data warehousing solutions
- Experience in creating and improving existing data warehouse processes, optimizing reporting and improving data integrity throughout the organization
- Knowledge of SQL Server Analysis Services to enhance existing, or develop new, OLAP cubes used in the EDW system
- Experience with scripting languages – Python, PowerShell etc
NON-ESSENTIAL FUNCTIONS
- Maintain technical proficiencies to support current and planned hardware, software, and network computing needs.
- Establish and maintain relationships with key contacts in the community including volunteer centers and non-profit organizations.
- Participate in community events, community volunteer boards & associations.
- Perform other duties as assigned.
Required Skills
WHAT'S NEEDED FROM YOU:
- In-depth analytical skills and the ability to convey complex concepts
- Demonstrated ability to interpret requirements and deliver reliable, scalable, tested solutions.
- The ability to handle changing priorities, while maintaining a high level of accuracy and attention to detail
- Detail and quality-oriented with the desire to quickly learn new concepts, business models, and technologies
Required Experience
MINIMUM QUALIFICATIONS:
- Advanced knowledge of SQL, SSIS and Data Warehouse.
- Advanced knowledge of structured query programming languages and general coding concepts.
- Knowledge of structured query languages used in programming reports and scripts for the core systems database.
- Thorough knowledge to program browser-based languages in creation of interfaces and interoperability.
- Current knowledge of laws, rules, and regulations pertaining to information technology relating to financial institutions.
MANDATORY VACCINATION POLICY:
As a condition of employment, new hires must be fully vaccinated against COVID-19 on or before the first day of employment (subject to legally mandated exemptions).