Go Back
Data Warehouse Developer (MS BI SSIS) loc:East Lansing,MI
2016-02-28 09:00:18
Job Type:
Full Time only
Budget $:
100,000 - 200,000
- He/she will be part of the team to review, analyze, modify, and create ETLs, utilizing SSIS, testing, debugging, integration and implementation processes.
- His/her tasks will also include documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.
- This position involves the delivering of data integration projects and would therefore require leveraging best practices expertise and experience at implementation; as well as effective technology know-how.
Essential Duties & Responsibilities- Handles complex duties within the database warehousing functionProvides analytical support and consultation on projects to ensure appropriate design, implementation, testing, and documentation
- Develops and maintains an enterprise data warehouse system and corresponding data martsEnsures quality of data through the configuration and audit of the data warehouse
- Troubleshoots and adjusts existing data warehouse applicationsAssists in establishing development standardsResearches and assesses new data warehouse applicationsMentors and guides less experienced team members.
- Provides support and consultation to ensure system and business requirements are documented and understood during the design and development phase
- Desired Skills and ExperienceEducation, Requirements & CompetenciesBachelors degree in an analytical related field, including information technology, science, or engineering discipline.
- Minimum 5 years\' business intelligence / data warehouse (BI/DW) development experience; Kimball data warehousing methodology preferred; delivering solutions for the insurance industry is a plus.
- Minimum 5 years\' experience using SQL Server 2008R2; 2012 or higher preferred.
- Minimum 3 years\' experience Microsoft SQL Server Integration Services (SSIS) 2008R2 or higher.
- BIML experience is a plus.
- Minimum 3 years\' experience with SSRS and SSAS development, dimensional models, SQL, views and stored procedure development.
- Experience can be concurrentMature self-starter and independent individual with ability to work with minimal supervision.
- Strong analytical, problem solving, and conceptual skills with ability to work across business areas.
- Strong interpersonal skills with the ability to develop rapport with team members and business partners; a team player.
- Strong verbal and written communication skills, with an ability to express business concepts in technical terms, and complex technical solutions in business terms.
- Team focused, with recognition that there are multiple right answers and collaboration leads to solutions that build acceptance and support within the team and with business partners.
- All candidates must be eligible to work in the US without sponsorship or restriction.
Key Skills: