Data Warehouse Developer

This role will analyze, design, develop, implement, and maintain software solutions that support the Enterprise Data Warehouse and Business Intelligence needs of the Credit Union.

The solutions may involve analysis and development across diverse development platforms, software, hardware, and tools.

• Design and create appropriate database objects (tables, indexes, etc.)
• Develop T‑SQL scripts, Stored Procedures, SSIS Packages, SQL Server Agent Jobs, etc. to support ETL functions. Incorporate data from multiple sources to provide a “single source of truth” for the Credit Union’s data needs.
• Develop SSRS and/or Power BI reports on an ongoing or ad hoc basis. Work with business units and IT to understand requirements and develop reports to meet those needs.

• Provide 24x7x365 support when required (including after‑hours/weekends).
• Troubleshoot database‑related defects/issues and provide consultation to IT teams.
• Assist developers and DBAs with database‑related activities (e.g., setup/install of DBs).
• Aid in the monitoring and performance tuning of databases, queries, and ETL extracts.
• Interface with 3rd‑party vendors for technical support (as needed).
• Inform Daily IT Status call of any processing issues.

• Actively work with the Project Management Office to meet data needs inherent in project delivery.
• Respond quickly and accurately with any project related requests for information from Project Managers and Business Analysts.
• Escalate issues appropriately and in a timely manner.

• Document system design, processes, and procedures as appropriate.
• Maintain source code in WPCU provided repository.
• Ensures proper policies, procedures, risk mitigation activities, and operating controls are followed. Reports gaps in policies, procedures, and operating controls to leadership to ensure member impact and risk is mitigated.