Business Intelligence Developer (5039)

Career Opportunities: Business Intelligence Developer (5039)

When joining Elevations, you can expect to work for a company that:

• Has been in business serving the local community since 1953.
• Is a two-time Malcolm Baldridge National Quality Award winner, the only presidential award for performance excellence.
• Has been voted as the “Best Bank” by our members and community and “Best Companies to Work for in Colorado” by our employees.
• Promotes a safe and inclusive environment where people express themselves openly and have opportunities to grow.
• Recognizes and rewards people who make every person feel welcomed, valued, respected and heard.
• Has a highly-engaged workforce committed to innovation, continuous improvement, and collaboration.
• Understands when our employees thrive, our members and community thrive too.
• Is dedicated to consistently providing amazing experiences and creating raving fans.

What’s in it for you:

• A leadership team that strives to make this the best place you’ve ever worked!
• Ample opportunity to learn, develop and grow.

  We offer access to LinkedIn Learning, career and leadership development programs, job shadowing, a mentor program, and tuition reimbursement.

• A highly-competitive total rewards package with 4 weeks paid time off, work anniversary paid time off, and 12 paid holidays.
• Support in giving back to our community with 16 hours of paid volunteer time off.
• A wellness-focused environment that encourages and empowers you to invest in your work-life balance, health and wellbeing.
• A strong Employee Assistance Program, offering a variety of personal and professional resources.
• A high-performance culture where you can be proud of your contributions and what we are able to achieve as a team.
• A place where your voice can be heard and your work will have an impact.

Summary/Objective:

The Business Intelligence Developer plans, designs, and develops Business Intelligence (BI) and Data Warehouse solutions that enhance Elevations Credit Union’s (ECU) analytics and reporting capabilities.

This position translates requirements into solutions and creates, maintains, and supports BI systems and reporting structures. The BI Developer works throughout the project lifecycle, from scoping to final delivery, to ensure that solutions are properly scoped, designed, implemented, and tested to meet business needs.

This position improves business effectiveness by creating and maintaining BI solutions used to leverage information across the enterprise in order to support a learning organization that values process improvement.

Essential Functions include:

• Designs, develops, and maintains ECU’s enterprise data warehouse; integrates BI solutions within the enterprise data warehouse.

  Implements and supports data warehouse architecture.

• Follows best practices in data modeling and source-to-target mapping.
• Acts as an internal subject matter expert on information technology (IT) solutions.
• Provides superior customer service with an emphasis on partnership and collaboration while managing relationships with end users, business leaders, and others to ensure service delivery exceeds expectations.
• Follows best practices and guidelines to support best-of-breed dashboards, metrics, scorecards, and reporting solutions.
• Utilizes sound development life cycle practices, adheres to established processes, and documents delivery of application solutions (including business analysis, design, testing, implementation, support, and decommissioning).

  Performs changes according to process, teamwork, and best practices for IT Change Management.

  Documents change, facilitates architecture review, plans and schedules change, coordinates with stakeholders, conducts testing, ensures training needs are addressed, and plans for roll-back in the event that roll-back is needed.

• Performs planned maintenance (e.g., application upgrades, releases, enhancements, service packs, etc.) on BI solutions and underlying infrastructure.
• Supports BI solutions; performs triage on incidents, troubleshoots issues, and resolves incidents while communicating with stakeholders.
• Ensures that adequate security procedures are developed and followed to protect Elevations from potential loss and maintain the confidentiality of ECU’s information.
• Contributes technical knowledge and understanding of applications to training programs, support processes, and operating procedures.
• Delivery – Able to execute multiple projects within required timelines and expectations.
• Relationship Management – Good communication, influence, and relationship management skills required.
• Analysis – Demonstrated conceptual thinking and analytical skills.
• Security – Ensures that security is maintained and not compromised (to include attacks, unauthorized access, and confidentiality of data).
• IT Knowledge – Stays current with emerging technology trends.
• Supervision – Works as a self-starter with moderate supervision within standard operating procedures
• On-Call Support – Typically requires after-hours on-call support on a rotating basis.

Reports to:

VP, Application Engineering

Manages:

No supervisory responsibility

Building Strategic Work Relationships, Communication, Business Acumen, Initiating Action, Planning and Organizing, Innovation, Adaptability

Required Education and Experience:

• 4 year college degree or equivalent work experience; B.S., Computer Science or equivalent
• 4 or more years of related business intelligence, data modeling, and/or data warehousing experience.
• Expertise with database and data warehouse designs, data modeling, data performance tuning, data integration.
• Expertise with T-SQL – queries, stored procedures, functions, views, constraints, indexing, performance management, and backup management
• Expertise in development and maintenance of SQL Server Integration Services code for ETL and ELT.
• Knowledge and applied documentation experience with a variety of industry concepts, methodologies, and frameworks within data warehouse and business intelligence field including requirements, architecture, and design documentation
• Experience with source control
• Knowledge and experience working in Agile software development and concepts of ITIL practices.
• A significant level of trust and diplomacy is required, in addition to normal courtesy and tact.

  Scope of work will include access to sensitive data and financial perspectives requiring extreme confidentiality.

  Communication may involve motivating or influencing organizational leaders.

• Demonstrated ability to learn new tools and technologies as required.

Preferred Experience:

• Knowledge/understanding of cloud computing and Microsoft Azure services like Azure SQL DW, Azure SQL DB Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, and other services.
• Demonstrated knowledge of Azure DevOps and its different components including Repos and Pipelines a plus.
• Familiar with Microsoft SQL Server Reporting Services, including the ability to design, develop, and integrate data sources to support reports using SQL Server or Analysis Services data sources
• Understanding of Data Quality, Metadata Management, and Master Data Management concepts and practices
• Experience with dim and fact data warehousing, as well as tabular modeling
• Working knowledge of multi-dimensional databases with the ability to create calculated members and key performance indicators (KPIs)

This job operates in an office setting and routinely uses standard office equipment

Physical Requirements:
Sitting frequently, walking occasionally, use of hands frequently, hearing constantly, talking frequently, exerting up to 10 lbs of force occasionally to lift, carry, push, pull, or move objects.

Position Type/Expected Hours of Work:

Regular, Full-time, Normal business hours

Classification:

Exempt

Location:

Broomfield

We value human relationships and are a face-to-face culture, but allow for remote work as long as our employees are onsite the majority of the time.

Compensation:

The minimum point of the budgeted range is $82,800 + annual bonus.

The starting salary for the individual in this position will be adjusted for his, her, or their experience.

Other Duties:

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job.

Duties, responsibilities and activities may change at any time with or without notice.

About Us: Elevations Credit Union is a member-owned not-for-profit financial institution serving Colorado’s Front Range.

Founded in 1953, we’ve grown from 12 members and less than $100 in assets to an institution with 13 branches and more than 120,000 members that manages over $2 billion in assets and is the No.

1 credit union mortgage lender in Colorado.

At Elevations, we’ve made a commitment to move away from a product-centered business model and focus instead on creating consumer solutions.

Our objective is to provide our members, as well as the entire community, with unbiased consumer information.

EEO Statement: Elevations Credit Union is an equal opportunity employer.

We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical​​​ condition, pregnancy, genetic information, gender, sexual orientation, gender identity or ​expression, veteran status, or any other status protected under federal, state, or local law.

All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs.

Candidates for certain positions may be required to submit to a credit history report in determining qualification for employment with Elevations Credit Union.

If the position you are applying for requires a credit history report, any information received in such a report will not be the sole factor in making an employment decision.

A history of personal financial irresponsibility may be reason for disqualification insofar as it relates to your potential job duties.

Elevations Credit Union is aware that occasionally there are extenuating circumstances that may affect an individual’s credit history.

We comply with the Fair Credit Reporting Act and the Colorado Employment Opportunity Act.