Full-time hire: Microsoft DW/BI Engineers paying $80 - 100K + bonus up to 25% + H1b transfer + Green Card sponsorship + relocation to Michigan (Detroit). Our client is a $1 billion, Financial Services, company that has ranked, for the last 9 years, one of the "Best Companies To Work For In America."
H1B visa holders - PLEASE READ before you apply:
(1) You must live in the USA and have an H1b (do NOT apply if you live overseas).
(2) You must have a minimum of 2 years left on your H1b (counting all extensions).
4 + years experience with SQL Server 2005/2008 T-SQL Coding
2+ years experience with SQL Server 2005/2008 Database Administration Microsoft SQL Management Studio, Query Analyzer, or SQL Profiler Advanced knowledge of Transact SQL and query optimization
Advanced knowledge of SSIS
A deep understanding of SQL Server as a developer
Stored Procedure and Index creation/optimization
The main responsibilities will include creating stored procedures for complex queries, monitor system performance and implement query and table optimizations where appropriate, and mentoring software engineers on query and schema design.
By working closely with business analysts and software engineers, this solution oriented individual will turn the requirements for our applications into a highly scalable and fast performing transactional system that helps meet business goals.
While working closely with the technology team and the reporting specialist, this team player will gain the knowledge necessary to build and maintain all schema changes that the business requires on our own internal platforms.
The position will create new and maintain the existing ETL, SSIS, and other data transfer jobs which feed our existing database from other systems, as well as overall database administration duties.
Monitoring and managing all ETL, SSIS, and other data transfer jobs.
Optimizing all new database schema changes and reviewing them with the BI Team.
Read, understand and provide estimates for business requirements to be completed during the Agile Iteration(s).
Validate data to ensure the integrity of all reports.
Work directly with the business users and software engineers to understand and clarify their requirements.
Find and implement new technologies to optimize the database performance.
Creating routine reports for how the database is performing which will be used to prioritize changes. Implementing database unit tests to ensure that all business requirements are met.
. Base salary: $80 - 100K.
. Year-end bonus up to 25%
. Excellent, Fortune 100, benefits including 401K
. Relocation assistance
Please go to our web site to view all our jobs - www.careerbrokers.com/jobs.php.