Data Engineer - Columbus, United States - KEMBA Financial Credit Union

Description

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.