Welcome Back,

Career Opportunity: Business Intelligence Architect – East Lansing, MI

Job Title
Business Intelligence Architect – East Lansing, MI
GreenStone Farm Credit Services
East Lansing, Michigan
Experience Level
Mid-Career (5-10 years)
Supervisor's Title
Information Technology
Salary Range
DOE, depending on experience
Posted Date
Friday, June 16, 2017
Closing Date
Open until filled
Job Description

About Us...

GreenStone Farm Credit Services is over an $8 billion financial services institution with 500 employees in 35 locations throughout Michigan and northeast Wisconsin.  GreenStone provides short term and long term credit to our customers, as well as a variety of other products and services, such as crop insurance, life and disability insurance, accounting services, tax planning and preparation, and appraisals

Job Description...

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.

Primary Responsibilities...

  • Maintains and enhances the enterprise business intelligence platform to support business reporting and analytical requirements.
  • 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.
  • 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
  • Mentor other team members, including consulting or outsourced resources as needed on BI architecture best practices.

Position Requirements...

  • Bachelor's Degree in Computer Science, Information Systems, Business Administration, Finance.
  • 6+ 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.
  • Knowledge 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.
  • Knowledge of Microsoft BI Platform (SSIS, SSAS, SSRS, Power BI)
  • MS BI certification is strongly desired.

Here's What We Can Offer You...

GreenStone has an outstanding Total Rewards package, which includes, but is not limited to:

  • Salary commensurate with experience
  • 15 vacation days, 12 sick days, and 10 paid holidays per year
  • 401(k) plan – up to a 9% employer contribution/match
  • Medical, Dental, Vision, STD, LTD, Life/AD&D benefits, etc.
  • $100/year Logo Wear allowance
  • $400/year Computer Subsidy/Reimbursement
  • $400/year Wellness Subsidy/Reimbursement & wellness programs
  • Tuition Reimbursement

*** Please include your salary requirements in your cover letter