Data Engineer - Farmington, United States - Community Choice Credit Union

Description

Job Description

**This is a contract position with an estimated duration of 12 months.

Purpose & Core Values

The primary purpose of any position is to assist Community Choice Credit Union to live out our purpose: we believe in helping our neighbors achieve the life they desire. A key component of this purpose is to provide outstanding service to both internal and external members by living our core values.

Position Summary

The Data Engineer is tasked with architecting and optimizing data systems that fuel the organization's strategic and operational decisions. This role blends deep technical expertise in data management with a deep understanding of business objectives, ensuring that data-driven insights are accessible and actionable across the credit union.

As a cornerstone in leveraging data for strategic advantage, the Data Engineer develops robust data pipelines and architectures, implements sophisticated ETL processes, and oversees the security and quality of data storage solutions. Collaboration across teams is central to this role, requiring the engineer to work closely with various departments to tailor data solutions that enhance efficiency, innovation, and member service.

The position demands a proactive approach to adopting and promoting the best data management, security, and analytics practices, with a constant eye on emerging technologies. This role is pivotal to achieving our mission, requiring a unique mix of technical skills, strategic vision, and dedication to our core values of commitment, charity, credibility, and unity.

The Data Engineer is key to empowering the credit union to fulfill its purpose of assisting members in achieving their desired lives, making strategic contributions through data insights that drive growth and operational excellence. This role is ideal for someone passionate about using data to foster change, innovate, and positively impact our community.

Core Competencies

• Core Values:
  1. Committed: We are committed to serving Michigan guided by the principles that underlie the credit union movement of service, integrity, and respect for every human being.
  2. Charitable: We Give Big every day to our membership, our communities, and each other. We are dedicated to supporting Michigan by giving our time and services to the communities we serve.
  3. Credible: We are our Members' trusted financial advisors; each Team Member plays an integral role in the well-being of our Members' financial lives and the success of Community Choice Credit Union.
  4. United: We are a Team. We unite to achieve success, celebrate success, and continually improve the service we provide to our members, our communities, and each other.
• Adaptability/Initiative: Adjusts quickly and effectively to changing conditions and demands, views change as a necessary and inevitable aspect of organizational life as well as an opportunity to learn new things. Is able to take on a variety of different tasks and roles in the organization. Can move in a relatively seamless manner from one task or focus to another and can fill in for other team members when they are absent or are experiencing work overload. Looks for new and productive ways to make an impact/value to the organization and/or team. Demonstrates a positive attitude when faced with organizational change and generates constructive feedback for continuous improvement. Demonstrates a professional demeanor.

Position Competencies

1. Attention to Detail: Follows detailed procedures; ensures accuracy in documentation and details; and all components/details. Remains focused during routine work; is organized and maintains a system of records.
2. Critical Thinking: Takes a proactive approach to anticipating and preventing problems. When problems occur, defines those problems, investigates obstacles, gathers relevant information, decides whether solving the problem should be a group decision, generates and analyzes alternate solutions and arrives at a workable solution. In addition, breaks down problems into sub components and assess pros and cons of costs, benefits and risks for multiple options prior to selecting one approach. Learns from past mistakes. Grasps concepts, patterns and underlying issues. Uses past experiences to help identify likely causes and solutions to problems that might otherwise seem to be unique events. Effectively communicates to help others see patterns and concepts by using examples and analogies that relate well to their own experience and current knowledge level.
3. Role Mastery of Essential Duties: Able to perform essential duties as outlined in job description. Contributes productivity and value within role. Is willing to learn and improve performance.

Essential Duties:

• Design and maintain scalable data pipelines for real-time and batch processing, enhancing data flow and accessibility.
• Develop and refine ETL and RPD processes to ensure data accuracy, reducing latency and improving data quality.
• Manage data storage solutions, ensuring scalability, reliability, and security for all data assets.
• Implement data lifecycle management policies to manage storage efficiently and comply with regulatory requirements.
• Collaborate with business units to understand their data needs, driving data-driven decision-making across the organization.
• Translate business requirements into technical specifications, aligning data initiatives with organizational goals.
• Enhance data models and structures to improve the quality and accessibility of data for reporting and analytics.
• Participate in data governance initiatives, establishing data standards and practices for consistency and quality.
• Implement data security measures to protect sensitive information and ensure member data privacy.
• Stay updated on data protection regulations, adapting practices to maintain compliance and safeguard data.
• Advocate for the adoption of modern data tools and methodologies to enhance operational efficiency and strategic decision-making.
• Provide technical support and guidance on data-related issues, fostering a collaborative and knowledgeable team environment.
• Develop and deliver training sessions on new data tools and reports, empowering end-users to leverage data effectively.
• Optimize data architecture for high performance under varying loads, ensuring efficient data processing.
• Continuously assess and improve ETL strategies and tools, enhancing data integration and quality.
• Work closely with analytics teams to develop insights that fuel growth and improve member experience.
• Implement and monitor compliance with data governance standards, ensuring data integrity and quality.
• Leverage latest trends and technologies in data engineering to drive innovation and competitive advantage.
• Serve as a liaison between technical and non-technical teams, ensuring clear communication and alignment on data projects.
• Keep abreast of emerging technologies and data management practices, continually improving data infrastructure and analytics capabilities.

Job Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirement listed below are representative of the knowledge, skill, and/or ability necessary for this position.

Reasonable Accommodations

The physical and mental demands are representative of those that must be met by an employee to successfully perform the essential functions of their job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job requirements, physical demands and do so within our work environment.

Education

Bachelor's Degree: Required

Experience

Three to five relevant work experience in a financial/banking institution

Three to five business analyst or data analyst role with driving Business Intelligence business adoption efforts

Skills & Abilities

Deep understanding and hands-on experience with Oracle's data management and analytics suite, including but not limited to:

• Oracle Database: Expertise in database administration, performance tuning, and PL/SQL programming for complex data manipulation and analysis.
• Oracle Data Integrator (ODI): Skillful use of ODI for designing and implementing efficient ETL processes, facilitating seamless data integration and transformation across diverse sources and targets.
• Oracle Analytics Cloud (OAC): Proficiency in utilizing OAC for developing comprehensive dashboards and reports, leveraging advanced analytics capabilities to derive actionable insights.
• Oracle Application Express (APEX): Experience in rapid web application development with Oracle APEX to create data-driven applications and reporting solutions.

Extensive experience with cloud platforms (OCI, AWS, Azure) and in-depth knowledge of designing scalable data warehouses using Oracle technologies, ensuring optimal performance and accessibility.

Proficiency in employing Oracle Business Intelligence Enterprise Edition (OBIEE) alongside BI tools like Power BI and Tableau for dynamic reporting and insightful data visualizations.

Solid understanding of data security principles and compliance with data protection regulations, complemented by experience in implementing Oracle's data governance and security solutions to safeguard data integrity and privacy.

Demonstrated ability to apply Agile methodologies within Oracle projects, efficiently managing multiple initiatives to leverage the full capabilities of the Oracle Data Stack for organizational growth and innovation.

Mental Demands

The team member must be able to read and interpret documents or instruments, understand and/or follow complex written and oral instructions, make decisions, recall multiple policies or procedures, resolve problems or unique circumstances in a timely and efficient manner, be able to express oneself clearly and/or concisely, perform mathematical functions, and handle multiple, concurrent tasks. Must be able to remain calm and professional at all times, understanding that members may express emotional frustration when the credit union cannot meet their specific requests.

Physical Demands

While performing the duties of this Job, the employee is regularly required to talk or hear. The employee is frequently required to sit and use hands to finger, handle, or feel. The employee is occasionally required to stand; walk; reach with hands and arms and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually moderate.

General Statement

The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties, skills, or working conditions.