Analytics Data Engineer II

The Analytics Data Engineer II at Rogue Credit Union designs and maintains trusted data assets to support analytics, reporting, and decision making. Working closely with the Analytics Semantic Architect, this role translates approved business definitions and rules into reliable, well-organized data assets used across the organization with confidence. The position offers a strong degree of independence in designing, optimizing, and ensuring the reliability of data pipelines and structures.

Compensation

Salary range: USD 93,737 - 117,171 per year.

Responsibilities

• Design, construct, and sustain scalable master data assets that underpin enterprise analytics and reporting needs.
• Translate approved business definitions and rules into optimized data models and transformations, selecting implementation approaches based on performance, usability, and maintainability.
• Develop data assets using platform capabilities such as dataflows, pipelines, SQL, notebooks, views, and distributed processing frameworks.
• Continuously refine existing data structures to enhance performance and align with evolving enterprise needs.
• Design and implement robust data validation, reconciliation, and monitoring processes to ensure data completeness, accuracy, and reliability for analytics.
• Proactively identify, diagnose, and resolve complex data issues, including those impacting production systems.
• Participate in triage and remediation of data incidents, with readiness to support issue resolution outside standard business hours to maintain critical reporting and operations.
• Serve as a subject matter expert in analytics data engineering practices, applying industry best practices to strengthen Rogue's data management processes.
• Provide guidance on data modeling, transformation design, performance optimization, and platform capabilities.
• Contribute to the development and refinement of engineering standards to establish consistent, scalable, and maintainable approaches across the analytics function and related Rogue groups.
• Create and maintain clear technical documentation describing pipeline logic, transformation steps, dependencies, and operational considerations.
• Ensure metadata including lineage, definitions, and ownership is accurately reflected in analytics tools and aligned with governance standards.
• Perform other related duties as needed or assigned.

Requirements

• Three to five years of related experience in data or analytics engineering, designing and optimizing data for organizational reporting and analytics using modern analytics platforms (such as Microsoft Fabric, Azure, Databricks, or Snowflake) and familiarity with BI tools like Tableau, with a preference for experience in financial services, particularly within a credit union environment.
• Education: a bachelor’s degree, or industry recognized certifications equivalent to a bachelor’s degree such as information technology certifications in lieu of a degree.
• Interpersonal Skills: extensive personal contact, motivating, influencing, and training others as part of the role, with an emphasis on building relationships with external entities as needed.
• Other Skills: advanced SQL proficiency and experience building data transformations using pipeline or notebook based tools such as Python, PySpark, Spark SQL, Scala, or similar technologies. Strong analytical and problem solving abilities to identify, diagnose, and resolve data issues, with high attention to detail and commitment to data accuracy. Effective documentation of transformation logic, data lineage, and dependencies, and clear communication.

Technologies

• Microsoft Fabric
• Azure
• Databricks
• Snowflake
• Tableau
• SQL
• Python
• PySpark
• Spark SQL
• Scala
• Notebooks
• Dataflows
• Pipelines

About Rogue Credit Union

Rogue Credit Union is a member owned, not-for-profit financial cooperative based in the Rogue Valley in southern Oregon. It serves members in select counties in Oregon, Idaho, and California. The organization aims to make an impact in the communities it serves by living, giving, and supporting local. The mission centers on delivering exceptional member experiences that foster loyal relationships and strong community connections.

Role

The Analytics Data Engineer II builds and maintains trusted data used for Rogue Credit Union's analytics, reporting, and decision making. Working closely with the Analytics Semantic Architect, this role turns approved business definitions and rules into reliable, well organized data assets that can be used across the organization with confidence. The Analytics Data Engineer II operates with a high degree of independence and contributes to the design, optimization, and reliability of data pipelines and related infrastructure.

Disclaimer

• Rogue Credit Union is a drug free workplace and requires a drug screening test within 48 hours of the employment offer.
• Rogue Credit Union is an Equal Opportunity Employer and makes employment decisions without regard to race, color, national origin, religion, sex, age, disability, veteran status, or any other protected class. If you require a reasonable accommodation to complete any part of the application process or need an alternative method to access this online application, please call 541-622-7295.
• This Job Description is not a complete statement of all duties and responsibilities comprising the position.

Physical Requirements

• Some lifting up to 30 pounds
• Continuous sitting
• Occasional standing and walking
• Finger dexterity for computer use
• Occasional talking and hearing in person and on the phone
• Vision requirements: continuous clarity of vision at 20 inches or less and at 20 feet or more

Work Environment

This is an exempt position requiring scheduling flexibility. The employee must monitor hours and manage time spent on duties, and be capable of adapting to unpredictable schedules. As a representative of the Credit Union, the employee should conduct themselves professionally. The role may involve exposure to potentially hazardous conditions, such as robbery.