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.