Business Intelligence Developer (Hybrid)

Westerra Credit Union•Denver, CO

11d•$85,871 - $109,000•Hybrid

About The Position

Building upon foundational data skills, this role advances Westerra’s analytics capabilities by designing, developing, and maintaining business intelligence solutions and complex data workflows. This individual will directly contribute to enhancing the organization’s analytical maturity and data-driven decision-making through technical leadership and hands-on development.

Requirements

6+ years’ experience in data analysis, reporting, and ETL development
5+ years’ experience writing and tuning SQL queries
2+ years' experience with reporting and analytics platforms (Tableau, SSRS, or PowerBI)
Experience with cloud data technologies
2+ years’ experience with ETL tools such as SSIS (preferred)
Proficiency in Microsoft Office
Strong written and verbal communication skills
Demonstrated continuous learning and the ability to apply that learning to projects
Highly organized with strong time management skills
Maintains high-level of confidentiality
Ability to work with cross departmental teams with varying levels of technical experience to understand appropriate business strategies and objectives and ensure alignment with data solutions
Strong understanding of data integration, source target mapping and business rules transformation in heterogeneous systems environment
Knowledge of database engines and technologies including SQL Server, MySQL, and AWS Athena
Understanding of data management principles and best practices including data quality, security, and data integration
Can be accountable for managing projects/processes, working independently with limited supervision
Acts autonomously on most decisions. Requires guidance on more complex judgments.
Advanced understanding of Westerra’s business and a growing awareness of the broader competitive landscape
Able to handle problems that are difficult and sometimes complex
Ability to influence timelines, expectations, and proactively negotiate within department

Nice To Haves

Experience with advanced analytics tools such as DataBricks, Azure Synapse, or Microsoft Fabric (preferred)
Experience with R or Python a plus
Credit Union experience a plus

Responsibilities

Contribute to the ongoing implementation of Westerra’s data strategy and roadmap.
Collaborate with business units to understand needs, propose scalable solutions, and clarify complex data issues.
Design and develop advanced data solutions addressing a wide variety of analytical challenges.
Write complex queries, perform data transformations, aggregations, and develop optimized stored procedures.
Build, enhance, and maintain advanced data models for high-performance dashboarding and analytics.
Respond to and complete ad-hoc data requests and in-depth analyses.
Provide mentorship and review the work of junior data team members.
Perform other duties as assigned.

Benefits

Three health plans through UMR that offer a variety of coverage options, including HSA and FSA options
Two dental plans through Delta Dental
Basic life and AD&D insurance, short-term disability and long-term disability
20+ days of paid time off (PTO) per year
Anniversary time off that consists of 1+ days of paid leave for each anniversary year (PLAY)
16 hours of volunteer time off (VTO) per year
11+ paid holidays
401(k) that includes up to 6% match
Up to 2% off the rate on a new Westerra mortgage, applicable to primary residence, second home, or investment property
2% off Auto/RV/Motorcycle Loans
Up to $5250 per year for educational reimbursement
4 weeks of paid parental leave
Mental health resources including an Employee Assistance Program (EAP)
Individualized learning and development programs