Data Engineer - Kalamazoo, MI
Greenleaf Trust
Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.
Job summary
Greenleaf Trust seeks a Data Engineer in Kalamazoo, MI to design, develop, and maintain the enterprise data platform. You will build and optimize SQL databases, data warehouses, ETL/ELT pipelines, and data movement across internal and external systems, collaborating with BIS and stakeholders.
You will assist with modern cloud transitions, including Microsoft Fabric and data lake architectures, while ensuring data governance and security.
Qualifications
- Bachelor's degree or equivalent combination of education and experience.
- 2-5 years of data engineering, database development, or related roles.
- Experience creating and supporting data integration processes.
Responsibilities
- Design, develop, and maintain SQL databases, data warehouse, and related structures.
- Develop and optimize SQL queries, stored procedures, views, and objects.
- Administer and tune enterprise database environments for performance and reliability.
- Design scalable data models for operational and analytical workloads.
- Design, implement, and maintain ETL/ELT processes and data pipelines.
- Manage data movement between internal and external systems via APIs and integrations.
- Develop automated data import/export/transform/validate processes.
- Troubleshoot data integration issues and participate in migrations/modernization.
Skills
Education
Tools
Job description
If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.
3 days ago Requisition ID: 1604881
At Greenleaf Trust N.A., our teams are dedicated to providing the highest level of comprehensive wealth management services, trust administration and retirement plan services. We adhere to the highest standards of fiduciary excellence while providing customized solutions and highly personal service to our clients.
The Data Engineer is responsible for designing, developing, supporting, and maintaining Greenleaf Trust's enterprise data platform. This includes database development, data warehousing, data integration, data movement, and data platform administration.
The Data Engineer works closely with Business Information Services (BIS) team members, system administrators, business stakeholders, consultants, and vendors to deliver reliable, secure, and scalable data solutions. Responsibilities include developing and maintaining data pipelines, integrating internal and external systems, administering enterprise data environments, and supporting the organization's transition to modern cloud-based technologies including Microsoft Fabric and data lake architectures.
- Design, develop, and maintain SQL databases, data warehouse, and related data structures.
- Develop and optimize SQL queries, stored procedures, views, and database objects.
- Support the ongoing administration, maintenance, and performance tuning of enterprise database environments.
- Design and implement scalable data models to support operational and analytical workloads.
- Monitor and troubleshoot database performance, availability, and reliability issues.
- Design, develop, and maintain ETL/ELT processes and data pipelines.
- Support data movement between internal and external systems using APIs, middleware, file transfers, and integration platforms.
- Develop and maintain automated processes for importing, exporting, transforming, and validating data.
- Troubleshoot and resolve data integration issues.
- Participate in data migration, conversion, and modernization initiatives.
- Assist in the implementation, administration, and support of Microsoft Fabric solutions.
- Support the development and maintenance of enterprise data lake and lakehouse environments.
- Work with consulting partners to learn and assume ownership of modern data platform administration and support.
- Participate in the evaluation and implementation of emerging data technologies and best practices.
- Contribute to future-state architecture supporting analytics, automation, and artificial intelligence initiatives.
- Support the development and maintenance of enterprise ontologies, semantic models, and business definitions that improve data consistency, discoverability, and AI readiness.
- Partner with business stakeholders and Business Analysts to understand data requirements.
- Translate business requirements into technical database and integration solutions.
- Participate in project planning, solution design, testing, and implementation activities.
- Provide technical recommendations related to data architecture, integration approaches, and platform capabilities.
- Support users in resolving data-related issues and service requests.
- Support data governance, metadata management, and data quality initiatives.
- Develop and maintain technical documentation, diagrams, procedures, and operational standards.
- Ensure compliance with information security, privacy, and regulatory requirements.
- Participate in project management and change management processes.
- Incorporate security considerations into all technical designs and solutions.
- Identify opportunities to automate manual processes and improve operational efficiency.
- Support CI/CD, version control, automated testing, and reliable deployment practices.
- Evaluate emerging technologies and recommend platform enhancements.
- Participate in knowledge transfer activities and technical cross-training.
- Perform other duties as assigned.
Greenleaf Trust is committed to diversity, equity, and inclusion, both within the organization itself, and the communities in which we serve. We continue to seek opportunities to give back and serve, work to ensure our actions are better and more inclusive and to provide opportunities for our team members to uphold the same expectations.
Employees are required to comply with all information and physical security policies and procedures. Recurring training in information and physical security policies will be provided throughout your period of employment. Participation in the training is required. Refer to the Personnel Information Security Guide and the Information Security Policy Manual for further guidance on information security responsibilities and expectations.
- Bachelor's degree in Computer Science, Information Systems, Data Science, Mathematics, Engineering, or related field or equivalent combination of education and experience.
- 2-5 years of experience in data engineering, database development, data warehousing, or related technical roles.
- Experience creating and supporting data integration processes.
- Experience working with data warehouses, dimensional models, and relational databases.
- Experience gathering and translating business requirements into technical solutions.
- Experience with Python or other scripting languages.
- Advanced SQL development skills.
- Strong understanding of relational database concepts.
- Knowledge of data warehousing and dimensional modeling principles.
- Knowledge of medallion architecture.
- Understanding of ETL/ELT development practices.
- Knowledge of Power BI or similar business intelligence tools.
- Strong analytical and problem-solving skills.
- Ability to troubleshoot complex data and integration issues.
- Strong written and verbal communication skills.
- Ability to communicate technical concepts to non-technical audiences.
- Strong organizational skills and attention to detail.
- Ability to work independently and collaboratively.
- Knowledge of Microsoft Fabric administration and development and lakehouse/data lake architectures preferred; Databricks or Snowflake experience also considered.
- API design and integration experience preferred.
- Understanding of data governance and metadata management preferred.
- Knowledge of DevOps, source control, and deployment processes preferred.
- Various copiers, printers, and scanners
- BIS Division team members
- Business partner staff
- This position requires a significant amount of time sitting and working on a computer, sitting in meetings and/or talking on a telephone.
Normal office environment, subject to constant interruptions, that is well lit, properly ventilated and handicap accessible.
- Regular and predictable attendance in the Kalamazoo, Michigan office is required.
- Our normal operating hours are Monday through Friday from 8:15 a.m. to 5:00 p.m. Some after-hours time required for implementations and troubleshooting as needed.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
