Business Intelligence Developer

Operations San Diego, California Dallas, Texas


Description

Position Overview

The Business Intelligence team works closely with product and departmental managers, directors, and executives across the organization to provide in-depth analysis and intuitive reporting to drive intelligent decision making. The ability to make informed decisions quickly and accurately serves Renovate America to maintain a competitive edge in the home improvement financing marketplace. Our Business Intelligence developers pride themselves on delivering invaluable insights into the business landscape in a dynamic and ever-changing environment.

The Business Intelligence Developer must be proficient in database design, technical integrations, data analysis and reporting. Coordinating across a wide spectrum of stake holders, from business end users to IT specialist, to ensure that systems are meeting functional requirements, and also that the output of those systems is meeting informational requirements. This role will support our Contact Center.

Key Responsibilities

  • Dashboard Report Development – Work in a fast paced business environment to design and develop dynamic reports to support RA at all stages of business. Collaborate with end users to define requirements and deliver data in a robust and meaningful way.
  • Data warehousing / ETL – Create and maintain ETL packages to integrate disparate systems, send data to 3rd party partners. Continuously enhance data warehouse to align with development releases and ease use for BI as well as other departments.
  • Ad Hoc Reporting – Respond quickly to business inquiries from users across all levels of the business. Deliver definitive conclusions with detailed assumptions that provide a clear description of the dataset surrounding the inquiry.
  • Data Quality – Gather deep understanding of processes that are responsible for creating data in order to develop comprehensive tests that ensure unity across business actions and the data recorded. Explore datasets to identify trends and patterns to alert decision makers of potential upcoming business events.
  • Ability to thrive in a fast-paced and challenging environment supporting the Operations division
  • Communicate with end users and project management personnel to understand and document business requirements for developing Business Intelligence solutions


The duties and responsibilities described above are not a comprehensive list and additional tasks may be assigned from time to time.  The scope of the job may change as necessitated by business demands. 

Qualifications

  • Minimum three (3) years of experience interacting with databases in a complex business intelligence environment; data warehousing and reporting
  • Contact Center specific reporting / analytics experience preferred
  • Moderate to advanced knowledge of T-SQL programming, optimizing T-SQL statements, SSIS, stored procedures, functions, tables, views, indexes and triggers
  • Reporting software experience required (Tableau preferred)
  • Knowledge of Windows Batch/XML scripting and C#/.Net application development a plus
  • Experience with Visual Studio and BitBucket/Github a plus
  • Agile development experience a plus
  • Ability to communicate relevant information in an effective manner to people at all levels of the organization
  • Desire to solve problems and think analytically
  • Self-starter with a strong willingness and desire to learn, grow and achieve as part of a team
  • Ability to work on projects with minimal supervision, meeting deadlines and reprioritize work to meet changing requirements
  • Strong time management skills
  • Flexible and able to adapt to new processes and requirements in a dynamic environment

Physical Requirements

  • The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position. 
  • While performing the duties of this position, the employee is regularly required to remain in a stationary position and to frequently move around the office and other locations and sites to accomplish tasks and interact with co-workers, customers, and business affiliates. The employee will constantly operate a computer and other office machinery.  In addition, the employee will be required to receive and exchange information through oral communication and must be able to convey instructions to others accurately, loudly, and quickly. 
  • While performing the duties of this job, the employee is required to work in an office environment, and the noise level is usually moderate to loud.