Data Engineer - Meridian or Chubbuck

Overview

The Data Engineer is responsible for designing, managing, optimizing, and monitoring data retrieval, storage, and distribution systems. This role focuses on the technical aspects and improvements of data integration tools, the enterprise data warehouse, data lake, and reporting tools. The position includes developing complex SQL queries to retrieve, manipulate, and provide formatted data as required for key business operations. This role centers on having a deep understanding of the data, combined with strong SQL coding skills, to deliver solutions to business stakeholders

Responsibilities

Duties and Responsibilities:

• Design, build, and maintain SQL generated data models, export files and automation processes across the organization by utilizing technical skills in SQL development, data warehousing solutions, data modeling, data Lakehouse technologies, data architecture, and Business System reporting development.
• Perform advanced level SQL coding and query optimization to retrieve data quickly and efficiently, optimizing data movement, generating formatted data files or researching data integrity issues.
• Provide subject matter expertise for data objects, relationships, and interpretation as required to support business applications.
• Collaborate with team members and BI Data Engineers to transform data into valuable information for business decisions.
• Architect, configure, analyze, and maintain data structures for BI analytics and reporting.
• Ensure data sources are accurate, consistent, reliable, and secure.
• Oversee the full lifecycle development, implementation, support, architecture, and tuning of the Enterprise Data Warehouse, including Data Models, Delta Live Tables, and ETL pipelines.
• Design, build, and maintain data pipelines and infrastructure processes across the organization.
• Develop conceptual and logical data models.
• Identify and implement internal process improvements, such as automating manual processes and optimizing data delivery.
• Ensure data security and compliance with data governance standards.
• Support the integration of enterprise application databases and real-time processing into the data warehouse.
• Utilize technical skills in SQL, ELT/ETL development, data warehousing solutions, data modeling, data Lakehouse technologies, data architecture, and BI reporting development.
• Work with technologies including Azure Data Lakehouse architecture, Azure Data Factory, Azure Databricks, SQL Server, Power BI, Oracle database, and AI/ML.
• Collaborate with external professional services and third-party vendors to understand systems and plan future enhancements.
• Write technical policies, procedures, and documentation, including data flow and architecture diagrams.
• Contribute to the design, development, and implementation of business intelligence reports and applications.
• Focus on dimensional data model design, ETL/ELT frameworks, performance tuning, cost management, data processing, metadata management, operational data integration, master data management, data quality, data auditing, profiling, and BI reporting solutions.
• Perform other duties as assigned.

Qualifications

Qualifications:

Bachelor’s degree in computer science (or equivalent) is required. Certifications in Databricks, data analytics and/or data engineering a plus. Experience in a Data Engineering or similar role preferred.

Experience in:

• Experience with relational databases and writing structured query language (SQL) preferred. 3 year(s).
• Proficiency in Microsoft SQL Server, Oracle, and other relational and NoSQL databases.
• Experience with SQL, ELT/ETL development, and business intelligence tools like Microsoft Power BI.
• Proficient with source-code management tools such as GitHub.
• Knowledge of programming languages such as Java, R, and Python is a plus.
• Experience with data warehouses, Data Lakehouse Architecture, data modeling, and data pipelines preferred.
• 2 years of experience in cloud computing with Azure, including Azure Databricks and Data Factory preferred.
• Understanding of data processing, hardware platforms, and enterprise software applications.
• Advocate of CI/CD methodologies and agile ways of working.
• Ability to maintain confidentiality of Credit Union and member records.
• Self-motivated with strong prioritization, deadline management, and adaptability skills.
• Willingness to work occasionally outside of normal business hours.
• Excellent English oral and written communication skills.
• Ability to work collaboratively with other department supervisors.
• Strong analytical and problem-solving skills.
• Ability to communicate effectively with all Credit Union personnel.

Performance Standard:

A demonstrated cooperative and positive attitude toward members and other Credit Union staff. Ability to determine member needs and cross sell Credit Union services. Professional in appearance, attendance, quality, and quantity of work performed.

Ability to work under pressure and conflicting situations. Must be willing to comply with the Bank Secrecy Act and USA Patriot Act as implemented by Idaho Central Credit Union.

Physical Requirements:

• Perform tasks requiring manual dexterity (processing paperwork, filing, stapling, sorting, collating, typing, counting cash, etc.).
• Sit for extended periods of time.
• Lift 20-40 pounds of applicable supplies including but not limited to copy paper, cash drawers, marketing material, etc.
• Repetitive motion using wrists, hands, and fingers.
• Reach keyboards.
• Ability to operate basic office machines (calculator, computer, telephone, copy machine, fax machine, etc.).

The above statements reflect the general details considered necessary to describe the essential functions of the job and should not be construed as a detailed description of all the work requirements that may be inherent of the job.

Must be eligible for membership at Idaho Central Credit Union to obtain employment.

Idaho Central Credit Union is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, national or ethnic origin, sex, age, disability, protected veteran status or other characteristics protected by law.