GreenStone
Data Engineer / Senior Data Engineer
GreenStone, East Lansing, Michigan, United States, 48823
We are excited for you to apply to our Data Engineer position located in East Lansing, MI. This position designs, implements and supports data warehousing and data management solutions. Responsible for verifying accuracy of data and maintaining and supporting the data warehouse. Designs and builds relational databases for data storage or processing. Develops designs for warehouse implementation, data acquisition, and archive recovery. May evaluate new data sources for adherence to the organization's quality standards and ease of integration. Designs and implements complex reports from data warehouse and other data sources.
GreenStone employees are driven by a desire to help rural communities! GreenStone employees exhibit the same work ethic, values and commitment to each other as the customers we serve.
Our $14 billion portfolio of customers, ranging from rural homeowners to global agriculture and food businesses, provides our employees with a unique opportunity to maintain a local presence while working for a top workplace. Our diverse business structure provides exciting opportunities for passionate, talented professionals in many areas. Additionally, many of our team members are highly respected in their area of expertise at both the state and national level making GreenStone one of the top Farm Credit associations in the country.
Major Responsibilities:
Maintains and enhances the enterprise business intelligence platform to support business reporting and analytical requirements utilizing SSRS and PowerBI.Builds, manages and monitors the ETL process for BI applications. Liaises with other team members in Finance and IT to optimize data and information usage. Assists in performance tuning of database warehouse.Work with Azure Data Factory and Databricks to build and maintain a Data Lakehouse.Monitor the ETL process to ensure performance of the system and security of the data.Ensures the use of demonstrated best practices for Business Intelligence solutions.Ensure creation of quality design documentations of all BI initiatives to departmental, corporate and industry standards.Contribute and assist in the development, deployment and automation of highly complex reporting through BI application.Participate in user requirement gathering, leading the prototype for all BI initiatives.Keep abreast of technology and innovation in all relevant areas.Coordinate with IT to implement updates, upgrades and enhancements to the data warehouse and other BI applications.Ability to work with on premise or cloud environments.Position Requirements...
Bachelor's Degree required.Computer Science, Information Systems, Business Administration, Finance or related majors preferred.Experience with Databricks, Python, Azure Data Factory and Data Lakehouse preferred.1+ years' experience with complex data architecture and data management assignments, including data analysis and design, master data management, database administration, data security management, metadata management, data warehousing, business intelligence, and data quality improvement required.MS BI certification preferred.Must be proficient in computer technology, Microsoft applications and Microsoft BI PlatformKnowledge of data management and data architecture functions, including physical database design, data migration, and relational database management system; data modeling, and metadata management, tools, and processes.SQL Server, SSRS and PowerBI experience is required.Experience transitioning from on-prem to the cloud would be a plus.Here's What We Can Offer You...
GreenStone has an outstanding Total Rewards package, which includes, but is not limited to:
Salary commensurate with experience15 vacation days, 12 sick days, and 12 paid holidays per year401(k) plan - up to a 9% employer contribution/matchMedical, Dental, Vision, STD, LTD, Life/AD&D benefits, etc.$150/year Logo Wear allowance$400/year Wellness Subsidy/Reimbursement & wellness programsStudent Debt repayment grant
*** Please include your salary requirements in your cover letter
GreenStone Farm Credit Services is an equal opportunity employer. It is our policy to provide equal employment opportunity to all persons regardless of race, color, religion, national origin, sex, sexual orientation, gender identity, age, disability, veteran status, genetic information, or any other characteristic protected by law. We comply with all federal, state and local equal employment opportunity regulations. We conduct all personnel decisions and processes relating to our employees and job applicants in an environment free of discrimination and harassment.
GreenStone employees are driven by a desire to help rural communities! GreenStone employees exhibit the same work ethic, values and commitment to each other as the customers we serve.
Our $14 billion portfolio of customers, ranging from rural homeowners to global agriculture and food businesses, provides our employees with a unique opportunity to maintain a local presence while working for a top workplace. Our diverse business structure provides exciting opportunities for passionate, talented professionals in many areas. Additionally, many of our team members are highly respected in their area of expertise at both the state and national level making GreenStone one of the top Farm Credit associations in the country.
Major Responsibilities:
Maintains and enhances the enterprise business intelligence platform to support business reporting and analytical requirements utilizing SSRS and PowerBI.Builds, manages and monitors the ETL process for BI applications. Liaises with other team members in Finance and IT to optimize data and information usage. Assists in performance tuning of database warehouse.Work with Azure Data Factory and Databricks to build and maintain a Data Lakehouse.Monitor the ETL process to ensure performance of the system and security of the data.Ensures the use of demonstrated best practices for Business Intelligence solutions.Ensure creation of quality design documentations of all BI initiatives to departmental, corporate and industry standards.Contribute and assist in the development, deployment and automation of highly complex reporting through BI application.Participate in user requirement gathering, leading the prototype for all BI initiatives.Keep abreast of technology and innovation in all relevant areas.Coordinate with IT to implement updates, upgrades and enhancements to the data warehouse and other BI applications.Ability to work with on premise or cloud environments.Position Requirements...
Bachelor's Degree required.Computer Science, Information Systems, Business Administration, Finance or related majors preferred.Experience with Databricks, Python, Azure Data Factory and Data Lakehouse preferred.1+ years' experience with complex data architecture and data management assignments, including data analysis and design, master data management, database administration, data security management, metadata management, data warehousing, business intelligence, and data quality improvement required.MS BI certification preferred.Must be proficient in computer technology, Microsoft applications and Microsoft BI PlatformKnowledge of data management and data architecture functions, including physical database design, data migration, and relational database management system; data modeling, and metadata management, tools, and processes.SQL Server, SSRS and PowerBI experience is required.Experience transitioning from on-prem to the cloud would be a plus.Here's What We Can Offer You...
GreenStone has an outstanding Total Rewards package, which includes, but is not limited to:
Salary commensurate with experience15 vacation days, 12 sick days, and 12 paid holidays per year401(k) plan - up to a 9% employer contribution/matchMedical, Dental, Vision, STD, LTD, Life/AD&D benefits, etc.$150/year Logo Wear allowance$400/year Wellness Subsidy/Reimbursement & wellness programsStudent Debt repayment grant
*** Please include your salary requirements in your cover letter
GreenStone Farm Credit Services is an equal opportunity employer. It is our policy to provide equal employment opportunity to all persons regardless of race, color, religion, national origin, sex, sexual orientation, gender identity, age, disability, veteran status, genetic information, or any other characteristic protected by law. We comply with all federal, state and local equal employment opportunity regulations. We conduct all personnel decisions and processes relating to our employees and job applicants in an environment free of discrimination and harassment.