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

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

KNOWLEDGE, SKILLS AND ABILITIES

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

What You'll Bring

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

• 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
• Being treated like you are more than the work you do