Data Warehouse Developer/ BI Developer

Back To Jobs Apply Now

Business Intelligence Developer (BI Developer)

As a BI developer you will be responsible for researching, designing, developing and implementing business intelligence solutions using Microsoft SQL Server Data Tools such as SQL, SSIS, SSAS, and SSRS.

This role includes analysis of business and software requirements, designing solutions, ensuring continuity between the companies’ technology systems, participating in code reviews and consulting with hardware staff to evaluate the operational as well as performance requirements of the applications and systems.

Data modeling, data analysis, reporting, and SQL development, but will be specialized and performing most of their duties in ETL.  This person will be performing new development as well as maintaining and enhancing existing applications and work through the entire Project Life Cycle Process on multiple projects. This position will help provide risk analysis, change control processes, information needs analysis, and business intelligence systems architecture design as well as serve in an active mentoring role to other Business Intelligence Associates.

Essential duties and Responsibilities:
  • Lead ETL development and mentor others on the team
  • Work with business users and project managers to understand inefficiencies in existing business applications and recommend solutions
  • Regularly communicate project progress, issues, and risks to team leader or project manager
  • Participate in Business Intelligence code and design reviews, reviewing others code, and having own code reviewed
  • Complete all code in a timely and quality manner
Qualifications and Experience:
  • Bachelor’s degree in a related area as well as a master’s degree (or equivalent work experience) and Microsoft certifications are a strong plus
  • 8+ years experience with Microsoft SQL Server Integration Services (2008-2012)
  • Strong commitment to deadlines and to client service (internal and external)
  • Creative and critical thinking ability; excellent troubleshooting and problem solving skills
  • Strong skills in both verbal and written communication
  • Strong organizational skills as well as an attention to detail
  • Experience creating project estimates and timelines
  • Good collaboration skills when interacting with both technical as well as non-technical resources
  • Operates well within a team as well as independently
  • Self-motivated and driven to produce quality products
  • Good judgment in productivity identifying issues and recommending solutions to others
  • Creative, entrepreneurial approach to technology possibilities

Required Technical Skills:

  • Proven ability to interpret data files and record layouts to map fields between multiple systems and database tables
  • Strong knowledge of relational databases and OLAP databases
  • Experience developing ETL for a data warehouse
  • Understanding of database and business intelligence concepts
  • Expert at developing and testing SSIS packages in SQL Server 2012 and 2008
  • Excellent SQL and T-SQL development skills

Other Desirable Qualifications:

  • Experience in the financial services industry
  • Experience with both operational and strategic reporting, as well as with SSAS and PowerPivot or other OLAP tools
  • Knowledge of implementing BI solutions through both SharePoint as well as PerformancePoint
  • Understanding of change data capture