Data Engineer

Job Description

Title: Data Engineer

Reports to: Enterprise Data Architect

Supervises: None

Status: Exempt

Objective

The Data Engineer position will play a crucial role in building and maintaining the data infrastructure necessary for effective business intelligence and analytics. The successful candidate will be responsible for designing, developing, and optimizing data pipelines, ensuring the availability, security, and quality of our data assets. This position offers an exciting opportunity to contribute to the advancement of data-driven decision-making within our organization.

Duties and Responsibilities

Designs, implements, and maintains robust, scalable, and efficient data pipelines for both batch and real-time processing

Collaborates with cross-functional teams to understand data requirements and implement solutions that meet business needs

Evaluates and selects database/data warehouse components including ETL software, metadata management tools, and database design solutions

Develops and implements data models that support the organization's analytical and reporting needs

Implements data quality checks and validation processes to ensure the accuracy and reliability of the data

Works closely with data governance teams to enforce data policies and standards

Collaborates with business stakeholders, data analysts, and other IT teams to understand data requirements and provide technical expertise

Assists in the design of databases and data warehouses to ensure interoperability with BI solutions

Communicates complex technical concepts to non-technical stakeholders in a clear and understandable manner

Conducts job duties and responsibilities according to the organization’s business systems development methodology and/or its Systems Development Life Cycle (SDLC) methodology

Troubleshoots BI tools, systems, and software; performance-tune these applications as necessary

Acts as evangelist for BI benefits across the organization; promote BI usage to relevant departments

Mentors and/or provide leadership to junior members of the team

Required Qualifications

College diploma or university degree in the field of computer science, information systems, or computer engineering

Minimum of 3 years direct work experience, building and maintaining ETL processes

Experience working in the financial industry preferred

Experience in data integration, ETL development, and data modeling, using Python, Powershell, SSIS and other transformation tools

Experience building, using and managing data warehouses, using MS SQL Server, Google Cloud, Snowflake, and similar

Proficiency in SQL, table and Index creation, data manipulation, and database management

Experience using automation tools, preferably VisualCron, OpCon, SQL job management and similar

Demonstrated ability with multi-system reporting skills (SQL, report development, design, and automation)

Report building experience using SSRS and BI tools. MS Power BI preferred

Knowledge of database design, performance tuning and troubleshooting

Knowledge of data processing flowcharting techniques

Understand and follow of the organization’s goals and objectives

Basic knowledge of applicable data privacy practices and laws

Strong written and oral communication skills

Exceptional analytical, conceptual, and problem-solving abilities

Able to prioritize and execute tasks in a high-pressure environment

Experience working in a team-oriented, collaborative environment

Desired Qualifications

Previous credit union or financial experience

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of the job, the employee is regularly required to sit; use hands to manipulate, handle, feel, and talk or hear. The employee is frequently required to reach with hands and arms. The employee is occasionally required to stand and walk. The employee must occasionally lift and/or move up to 15 pounds. Specific vision abilities required by this job include close vision, distance vision and ability to adjust focus.