Data Engineer

Role Details

The Data Engineer is responsible for architecting, managing, optimizing, overseeing, and monitoring data retrieval, storage, and distribution. This role is responsible for the technical aspects and enhancements of the data integration tools, enterprise data warehouse, data lake, and enterprise reporting tools.

Duties and Responsibilities:

• Work closely with team members and BI Analysts to turn data into critical information and knowledge that can be used to make sound business decisions.

• Responsible for architecting, configuring, analyzing, and maintaining all data structures used for BI analytics and reporting.

• Ensure all data sources are accurate, congruent, reliable, and secure.

• Responsible for the full life cycle development, implementation, support, architecture and tuning of the Enterprise Data Warehouse, including Data Marts, Data Lake, and data pipelines.

• Define and build data integration processes to be used across the organization.

• Build conceptual and logical data models.

• Identify, design, and implement internal process improvements including automating manual processes, optimize data delivery and designing cloud infrastructure for greater scalability, etc.

• Ensure all data accesses, along with data at rest or in transit is secure and follows the best-in-class data governance standards.

• Support the integration of enterprise application databases and real time processing into the data warehouse.

• Technical skillsets needed include but not limited to: SQL, ELT/ETL development, configuring and maintaining data warehousing solutions, data modeling, data lake technologies, data architecture, and BI reporting development.

• Technologies involved but not limited to: Azure Data Lake, Azure Data Factory, Azure Databricks, Azure Synapse, SQL Server, Power BI, Oracle database, AI/ML

• This person will work closely with external professional services and third-party vendors to have a full knowledge of systems and help establish roadmap for future enhancements.

• Write technical policies, procedures, and documentation for the systems including data flow diagrams, architecture diagrams, etc.

• Contribute to a team responsible for the design, development and implementation of mission critical business intelligence reports and applications to enterprise scale.

• Design and development focus include but is not limited to dimensional data model design, ETL/ELT frameworks and processing, metadata management, operational data integration, master data management and data quality, data auditing and profiling, and business intelligence reporting solutions.

• Other duties as assigned.

Qualifications:

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

Experience in:

• Microsoft SQL Server, Oracle, and other relational and NoSQL databases.

• SQL development

• Experience with business intelligence visualization tools and business intelligence tools, such as, Microsoft Power BI

• Data warehousing, Data Lake, data modeling, data pipelines

• ELT/ETL development.

• Knowing programming languages such as Java, R, Python is a plus but is not required.

• Source-code management tools such as GitHub

• 2+ years’ experience working in cloud computing with Azure experience required

• Knowledge of data processing, hardware platforms, and enterprise software applications. Technical experience with enterprise systems, databases, and user support.

• Advocate of CI/CD methodologies and agile ways of working.

• Ability to always maintain confidentiality of Credit Union and member records.

• Self-motivated with the ability to prioritize, meet deadlines, and manage changing priorities.

• Willingness to work occasionally outside of normal business hours.

• Excellent English oral and written communication skills.

• Ability to work with other department supervisors.

• Strong analytical and problem-solving skills.

• Ability to work with and communicate with all Credit Union personnel in the various departments.

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.

ID: 2023-6038

Street 2: 4400 Central Way

External Company URL: https://www.iccu.com/

Street: MSC-05

Idaho Central Credit Union provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.