Business Intelligence Developer -responsible for researching, designing, developing and implementing business intelligence solutions using Microsoft SQL Server Data Tools including 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 and 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 and 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
` Commitment to on-going education
Qualifications and Experience
` Bachelor`s degree in a related area; master`s degree (or equivalent work experience) and Microsoft certifications are a strong plus.
` 8+ years experience with Microsoft SQL Server Integration Services (2008 and 2012)
` Strong commitment to deadlines and to client service (internal and external)
` Creative and critical thinking ability; excellent troubleshooting and problem solving skills.
` Strong verbal and written communications skills.
` Strong organizational skills and attention to detail
` Experience creating project estimates and timelines
` Good collaboration skills when interacting with both technical and non-technical resources.
` Operates well within a team as well as independently
` Self-motivated and driven to produce quality products
` Good judgment in proactively 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
` Strong experience developing ETL for a Data Warehouse
` Strong 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 is a plus.
` Experience with operational and strategic reporting
` Experience with SSAS and PowerPivot or other OLAP tools
` Knowledge of implementing BI solutions through SharePoint and Performance Point
` Understanding of Change Data Capture