Data Engineer - Data Migration

Data Engineer  

Are you seeking impactful and meaningful work Do you enjoy designing and building data driven solutions Are you interested in working in an empathetic and collaborative environment 

This opportunity might be for you! 

GreenPath Financial Wellness is amidst a digital transformation journey that will transform how we do business with technology. You will be key to this transformation by supporting the design and creation of data driven solutions. Youll collaborate with the data platform team to develop and enhance the data warehouse business intelligence solutions data pipelines tabular and Microsoft Power BI dashboards. 

GreenPath Financial Wellness wholeheartedly believes a strong organization is based on the foundation of diverse groups of team members. We believe deeply in employees not only bringing their whole selves to work each day but also feeling comfortable being their authentic self. We encourage people from each and every background and walk of life to apply for opportunities which they are passionate about and meet the qualifications.  

At the heart of this role is a deep passion and commitment to GreenPaths mission to empower people to lead financially healthy lives. Through our core values of integrity teamwork and quality GreenPath serves individuals directly empowering strong financial decisions with high quality tools resources and information.   

Financial wellness is a key factor in peoples freedom to pursue their dreams. We envision a world where people are ready for lifes ups and downs and we all have the tools we need to accomplish our financial goals. 

Need to Know Logistics: 

• The opportunity to work hybrid environment is available if local to Farmington Hills MI
  • If out of state remote work is available
• Fulltime direct hire opportunity. Eligible for full benefits package (listed at bottom of post)
• Eastern Time Zone business hours

We Have:  

• The opportunity to make a difference in all areas of the business through collaboration with various leaders and team members
• Experienced IT and Data teams for you to join
• A guiding principle to put people at the center of everything we do. Empathy coaching humancentered design and behavioral economics practices anchor our work in meeting peoples needs.
• Caring compassionate and creative humans that show up every day with integrity and a drive to provide a quality experience through each and every interaction. This is more than a job for most of us. We are on a mission to make it easier for people to be financially well. 
• Partnerships with others enable us to impact financial health on a large scale. We collaborate to design and deliver financial health services that are a win for people for our partners and for GreenPath.
• Products and services designed specifically with our clients in mind.

You Have: 

• Bachelors degree in IT or Computer Science or equivalent experience.
• 3 years of experience with Data Models Data Warehousing  building data pipelines with ETL tools like SSIS Azure Data Factory

• Experience with Data Warehouse infrastructure and analytical tools
• Experience in MS SQL Server TSQL Query performance tuning Normalized and Denormalized database schemas
• Fluent with Azure cloud services and experience in cloud data engineering in Azure.
• Experience with integration of multi cloud services with onpremises technologies.
• Skilled in creating data visualization dashboards Power BI and Tabular model
• Strong integrity accuracy positivity and dependability
• Motivation to be a selfstarter and work independently on multiple projects
• Excellent analytical and problem solving skills
• An ability to work collaboratively with others
• Ability to interface and collaborate well with business and technical stakeholders 

The Day to Day: 

• Work with business leaders to understand requirements formulate use cases and then translate that into an effective technical solution.
• Understand and work with multiple enterprise application data sources and integrations. 
• Expert in creating scalable logical and physical data models to support analytical and data science platforms
• Create and maintain high performing ETL/ ELT data pipelines follow best practices and maintain documentation
• Expert in data profiling TSQL and query tuning. Should have good understanding of database indexes execution plans and debugging skills.
• Develop and maintain tabular model and Power BI dashboards to support an efficient way to make data driven decisions.
• Design and implement solution to monitor quality of production data set up alerts and support to ensure the data accuracy. Design and implement data quality framework.
• Perform code reviews for work completed by other team members to make sure that coding standards and practices are followed.

• Mentor other development team members on technical and functional areas of development.
• Implement CI/CD processes and manage production releases. 
• Participate in brainstorming sessions and contribute ideas to improve enterprise technical solutions and infrastructure to support scale up.
• Effectively communicate and interact with business and technical personnel to solve complex data related business and technical problems.
• Monitor data warehouse infrastructure and business intelligence scheduled processes and identify opportunities to make enhancements.
• Ensure the work delivered is of high quality and meets the business and technical requirements.
• Maintain an enthusiastic positive attitude and be a dependable team member.
• Other ad hoc duties as requested by management

The Perks: 

What will you get out of working at GreenPath In addition to a competitive compensation and benefits package (medical vision and dental plans) here are some of the additional perks our employees enjoy:  

• We all need someme timeevery once in a while. All fulltime employees receive 19 paid days off during their first year of employment in addition to 10 companypaid holidays per year. Use it for a fabulous vacation to play nurse (or patient) at home or sit on your couch watching DIY marathons on HGTV all day. We dont care  itsyourtime. Enjoy.
• Need some additional time to focus on preventative care  GreenPath provides all employees with additional Preventative Care Time Off to encourage all employees to be proactive about their physical wellness. 
• Saving forRetirementGreenPath employees can start contributing to a 403b right away!After one year of employment we make a monthly contribution to eligible employees Retirement Account equivalent to 5% of their gross compensation.
• Need toreduce your student loan debt GreenPath is a qualified employer under the federal Public Service Loan Forgiveness (PSLF) program which means that you may be able to have a portion of your federal student loans forgiven after meeting certain eligibility requirements of the PSLF program.
• Planning on growing your familyGreenPath offerspaid Maternity and Paternitybenefits.
• Continuous learners can get their classroom fix in a couple of different ways. GP team members are eligible for up to$2500 in tuition reimbursementper year. In addition GP team members can attend courses throughInvest in Yourself aninhouse educational programoffering training classes on a variety of topics ranging from Cash Flow Planning to Microsoft Excel to Stress Management.
• Want to take additional college courses  We have an agreement with Cleary College where all GreenPath employees are eligible for a 25% discount on college tuition. 

GreenPath Financial Wellness reserves the right to change this description at any time. GreenPath Financial Wellness practices the concept of equal employment opportunity with respect to hiring promotions transfers pay discipline fringe benefits and all other terms and conditions of employment. No individual will be discriminated against and no employment decisions will be made on the basis of an individuals race color national origin religion age gender gender identity sexual orientation protected disability marital status familial status veteran status height weight or citizenship. 

Qualifications :

• Bachelors degree in IT or Computer Science or equivalent experience.
• 3 years of experience with Data Models Data Warehousing  building data pipelines with ETL tools like SSIS Azure Data Factory

• Experience with Data Warehouse infrastructure and analytical tools
• Experience in MS SQL Server TSQL Query performance tuning Normalized and Denormalized database schemas
• Fluent with Azure cloud services and experience in cloud data engineering in Azure.
• Experience with integration of multi cloud services with onpremises technologies.
• Skilled in creating data visualization dashboards Power BI and Tabular model
• Strong integrity accuracy positivity and dependability
• Motivation to be a selfstarter and work independently on multiple projects
• Excellent analytical and problem solving skills
• An ability to work collaboratively with others
• Ability to interface and collaborate well with business and technical stakeholders 

Additional Information :

All your information will be kept confidential according to EEO guidelines.

Remote Work :

Yes

Employment Type :

Fulltime