Position Overview

The Senior Business Intelligence Developer is responsible for the technical implementation of current and future data warehouse, business intelligence solutions and data migration strategies using Microsoft BI stack.

Key Responsibilities

• Implement new business intelligence and data warehouse requirements using SQL, ETL, business intelligence tools, and database programming and reporting tools


• Meet with customer business and technical leaders to identify and scope the business opportunities, document and vet business requirements, identify effective reporting techniques, identify the best data sources for reach report field, identify risks and constraints, and design reporting formats


• Develop, implement, and maintain ETL (extract, transform, and load) solutions to bring new data into the data warehouse


• Develop optimized database design to achieve acceptable performance by tuning view, tables and indexes for proper response time


• Develop new capabilities and architectures that capitalize on the development of client portal, and ad-hoc BI capabilities


• Full life-cycle development and maintenance of data warehouse, ETL, and business intelligence solutions


• Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners


• Provide guidance and recommendation on BI reporting packages


• Develop ETL Packages using Microsoft SQL Server Integration Services


• Implementation/Maintenance of Data Warehouse / Cube building


• Optimize the ETL Packages


• Analyze system issues reported by users and present workable solutions


• Deploy ETL Packages/Cubes on Development/Test environment, and provide deployment instruction for further deployment on production


• Planning and oversight of the design, build and test environments of the systems and related interfaces


• Daily supervision of staff and all associated tasks assigned to managing a development and support team


• Participate in peer-reviews of solution designs and related code


• Provide the technical leadership that allows the team to enrich their technical skills, understandings, methods, and development toolsets


• Creating unit test cases, creating unit test plans, and executing unit testing


• Mentor and train technical and non-technical team members

Required Skills

• 7+ years of hands on experience implementing business intelligence solutions using Microsoft BI stack


• Strong SSRS, SSIS and SSAS skills


• Strong TSQL and MDX query writing skills


• Experience working with PowerBI or Dundas is preferred


• Strong customer service orientation


• Analytical, troubleshooting, and problem-solving skills


• Logical, efficient & proactive


• Keen attention to detail


• Ability to effectively communicate ideas 


• Experience working in a team-oriented, collaborative environment


• Comfortable with ambiguity and possess an ability to adapt quickly and easily. Ability to analyze complex problems and move them to resolution


• Background and style that elicits respect in the organization through style of engagement, technical depth, customer service and results


• Positive attitude and ability to build strong relationships within the company and with external partners. 


• Very strong communication (written and verbal)