VineBrook Homes
  • Dayton, OH, USA
  • DOE +/-
  • Salary
  • Full Time

Health, Dental, Life, Supplemental Insurance, 401(k) w/match, PTO


Business Intelligence Developer 

VineBrook Homes is looking for a Business Intelligence and Data Warehouse developer who is passionate about data, has an attention to detail and accuracy, driven to provide innovative and unique solutions, and who likes to have fun while working hard to achieve success.  We are looking for that dynamic, customer service focused individual who embraces our innovative and creative culture while delivering awesome, clean, and flexible solutions that change how our departments get and use data and, in the end, help our employees do their jobs better.  The data provided by this role is high visibility with an absolute need for accuracy as it affects not just the monitoring of the business but forecasting and planning at the highest levels.  An ability to develop a comfort and rapport with the business users from the analyst level to the executive level, often juggling multiple requests, shifting priorities and short timelines, is a must.  Additionally, the ideal candidate should also always be open to new ideas and look for ways to improve the existing environments and tools.

Essential Functions

  • Development of SQL queries and Tableau Reports using our Data Warehouse
  • Architecture of data within out Data Warehouse
  • Review requests, meet with users and gather requirements for requested data needs, maintaining documentation of request and communicating status until completion.
  • Own and manage the BI/DW ticket queue for the reporting team.
  • Partner with business and technical personnel to identify, architect and implement best solutions for requests.
  • Define and improve the architecture of the data warehousing and business intelligence environments.
  • Develop, maintain/enhance the database structures (data modelling, indexing, etc.).
  • Develop, maintain/enhance and troubleshoot the data load scripts, jobs and packages (ETL).
  • Provide basic DBA support in monitoring the environment and backups, responding to issues and partnering with offsite DBA support on major issues.
  • Provide development of Tableau reports and dashboards
  • Support/refine security architecture of reporting and analysis systems.
  • Contribute to and maintain the data warehouse and reporting systems documentation.
  • Adhere and improve data warehousing and reporting standards and release processes; maintaining clean, readable coding methodologies.
  • Look for and act on continuous improvement opportunities that make yourself, IT and VineBrook better.

Technology we use for BI/Data Warehousing

Our data warehousing and BI reporting is centered on Microsoft SQL Server, Microsoft Excel Power Pivot, and Tableau.  Only candidates that can demonstrate skills in the following will be considered:

  • MS SQL 2012 and greater
  • TSQL/SQL Scripting
  • Tableau
  • Excel

Additional skills desired but not required:

  • Excel PowerPivot
  • Excel VBA
  • TIBCO Scribe or other ETL tool such as SSIS, Informatica, etc.
  • Windows PowerShell Scripting
  • Azure Cloud Infrastructure

 

Required Education and Experience

  • Minimum of 5 years of professional work experience related to database, business intelligence, and data warehouse architecture/development.
  • Minimum of Bachelor's degree in Computer Information Systems (or equivalent), statistical analysis, or equivalent proven professional experience.
  • Ongoing training on BI/DW methodologies and technologies such as TDWI certifications/classes

 

Additional Education/Experience Desired

  • Minimum of 3-5 years of work experience interacting with enterprise application systems (MRP/ERP)
  • Exposure to the Property Management, Real Estate, and/or Construction business lines is preferred
  • Understanding of basic financial reports such as income statements, balance sheet, cash flow, etc.
VineBrook Homes
  • Apply Now

    with our quick 5 Minute Application

  • * Fields Are Required

    What is your full name?

    How can we contact you?

    I agree to ApplicantPro's Applicant Information Use Policy.*
  • Sign Up For Job Alerts!

  • Share This Page
  • Facebook Twitter LinkedIn Email
.

Image Map

Logo Home Resident Services