Data Engineer - Business Intelligence

This is a hybrid role. Three days a week working at our headquarters in Brighton, MI and two days a week remote.

Lake Trust’s Business Intelligence & Analytics team is a cornerstone to achieve future business objectives. This team is responsible for creating data pipelines, delivering business intelligence solutions, and analysis of complex data sets for Lake Trust Credit Union. The data engineer will lead complex projects with a focus on parsing, extracting, managing, and automating the process of transforming disparate data sets into analysis-ready data. The data engineer should be able quickly develop prototypes and proofs of concept. Some of the tools used will be Microsoft SQL Server, Alteryx, R, Microsoft PowerBI and Python. The Data Engineer role requires creativity with a high attention to detail and drive for data accuracy. If you enjoy working within an agile team this may be a great role for you.

What You’ll Do

The Data Engineer will work on implementing complex data projects with a focus on collecting, parsing, managing, analyzing large sets of data to turn information into insights using multiple platforms. The Data Engineer will make the appropriate data accessible and available for use by Lake Trust. He or she should be able to decide on the needed hardware and software design needs and act according to the decisions. The data engineer should be able to develop prototypes and proof of concepts for the selected solutions. Some of the tools used will be Microsoft SQL Server, Alteryx Designer and Server, R, Microsoft PowerBI and Azure. The Data Engineer role requires creativity with a high attention to detail and drive for data accuracy. If you enjoy working within an agile team this may be a great role for you.

ESSENTIAL FUNCTIONS

• Contribute to group knowledge sharing platforms and best practice
• Have strong SQL querying skills
• Ability to solve problems with data
• Discovery of data across many different systems, data sources and data types
• Hands-on experience with data warehousing
• Document requirements and resolve conflicts and clear ambiguities
• Proficient in designing efficient and robust ETL workflows
• Experience cataloging data sources
• Work in teams and collaborate with others
• Tune solutions to improve performance and end-user experience
• Ability to profile data to measure quality, integrity, accuracy, and completeness
• Perform other duties and responsibilities as required or assigned

KNOWLEDGE, SKILLS AND ABILITIES

• Effectively provide open and honest feedback via performance reviews and 1-1 conversation.
• Ability to work in an agile team
• Effective analytical and decision-making skills
• Strong written and verbal communication skills
• Proven ability to support a strong member/customer service culture
• Enjoy being challenged and to solve complex problems on a daily basis
• Proven effective communication and collaboration
• Demonstrated and dynamic analytical/problem solving skills
• Complete work independently
• Ability to understand the big picture
• High attention to detail
• Act as a change agent
• Teamwork skills within the department and on project teams
• Continuous improvement mindset
• Demonstrated ability to work effectively in a fast-paced, complex, and dynamic business environment
• Strong interpersonal skills to build relationships and communicate effectively with managers, staff, and vendors

What You’ll Bring

• Undergraduate degree in computer science, data analytics, statistics, social sciences, or similar is required
• Four years job related experience is required
• Proven experience writing high-quality code, demonstrated through academic projects, work experience, or an active Github account is required

What You’ll Get

We know that pay and benefits are important. And, we’ve really got that covered. But, we also know that those are not the only things that you need to decide if this is the place for you. Join our team of Lake Trusters and you’ll enjoy:

• Being treated like you are more than the work you do
• Working with an energetic team focused on making our members wildly successful
• An opportunity to work with others that have your back every step of the way
• Opportunities to make a difference both inside and outside of our walls