Credit Union:

Advantis Credit Union

Region:

Milwaukie, OR

Closing:

1/28/2022

Job Description:

Responsibilities of this role include:

  • Development and support of all standard and ad hoc data warehousing architecture and development and support of complex database designs of the data warehouse. Develop and implement a standard for ad-hoc reporting requirements.
  • Coordinate with Database Administrator or source data vendors to remedy technical and other issues impacting the Data Warehouse, data and/or output.
  • Utilize databases and information systems to research and identify areas for improvement.  Interpret data and make recommendations to stakeholders.
  • Develop strategic and tactical analytics that support balanced scorecards, dashboards, data summaries and key performance indicators.
  • Maintain detailed knowledge of department function(s) and areas of workflow and system data management within the credit union’s Data Warehouse.
  • Work closely with business partners to gather data requirements; align their needs with source data capabilities; develop new technical objects or upgrade existing processes; and troubleshoot and research data issues.
  • Explain data, data scope, impact of data changes to various reporting teams to help non-technical, internal customers to drive their analytics and reporting.
  • Partner with other analysts, external vendors and business partners in the development of advanced/complex reporting capabilities and resolution of issues relating to reporting applications, tools, and data.

Requirements:

  • Bachelor’s degree in Computer Science, Applied Computer Science, Computer Applications, or Database Administration required.
  • Minimum 3 years’ experience in database management, relational/dimensional data modeling, data mining, report writing required. Financial Industry experience preferred.
  • Minimum 3 years’ Microsoft SQL programming experience required. Experience with C# or VB.NET is required.
  • Ability to develop database queries, scripts, tools, and methods to manage data according to management requirements.  Proficient with relational database concepts and practices to evaluate and write complex SQL queries. Able to create and maintain common database objects such as views, stored procedures, and user-defined functions.
  • Proficient with MS Excel at an advanced level. PowerQuery and PowerPivot skills desired.
  • Ability to work in a deadline driven environment with strong problem solving and decision-making skills.  Strong attention to detail and process orientation.
  • Excellent verbal and written communication skills.  Ability to present information effectively to all levels of the organization. Ability to document and create policies and procedures to ensure compliance for internal and external regulations.
  • Ability in investigating discrepancies, capturing and maintaining data in an information management system or complex databases.
  • Strong knowledge of data mapping and data modeling processes, database design and configuration.
  • Ability to apply various analytical tools and software application experience to increase quality, productivity, and overall effectiveness of data.
  • Flexibility to deal with unexpected events, and occasionally attend meetings and events that may occur outside of regularly scheduled work hours.

Great Place to Work!

At Advantis, we help our members succeed financially.  We serve our members with a purpose and a passion, and our talented team delivers uncommon value with every interaction.

We inspire fresh ideas, bold creativity, and outside-the-box ingenuity by asking, “How can we do banking differently?”  We celebrate individual achievement and excellence with proud recognition and upward opportunity.  We work together in a spirit of “together we can” teamwork, mutual respect, and a unified effort to reach common goals.  We work hard but we get to do it in an atmosphere that’s upbeat and fun.  We live our passionate community commitment to strengthen, educate, and elevate the prosperity of the communities we’re proud to call home.

If you like to work with passion and purpose, collaborate, elevate, and celebrate, Advantis Credit Union is the place for you. Advantis is one of Oregon’s largest member-owned financial cooperatives, serving the Portland areas for over 90 years.

To learn more about Advantis, please click here.

Advantis Credit Union is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity, gender expression, veteran status, or disability.