The Business Intelligence - Senior 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
6+ 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.