SQL Server / SSIS / ETL Developer opening in KC

Qualifications:


• Bachelor's degree in computer technology discipline desirable.
• Strong knowledge of Data Warehousing methodologies and concepts, including and not limited to: star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools
• 3 + years of experience in dimensional modeling, cube design and development using SQL Server Analysis Services (SSAS)
• 5 + years DTS / SQL Server Integration Services (SSIS)
• Experience with Oracle Business Intelligence Enterprise Edition (OBIEE)
• Experience Multidimensional Expression (MDX) queries and Data Mining Expression (DMX) queries for analysis services
• Good working experience with OLAP and Reporting Services/MS Excel combination
• Strong data modeling experience and key understanding of relational database development.
• Significant experience in extracting data from multiple sources including a data warehouse environment.
• Ability to comprehend complex technical and logical concepts and adapt quickly to changes.
• Strong quantitative, analytical, problem solving, organizational, communication and interpersonal skills are required.
• Attention to detail and maintaining high quality standards is a must.
• Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision.

Responsibilities:

• Analyze business and technical requirements, as well as data warehouse data models, to understand the detailed data management requirements
• Collaborate on the global data architecture design and planning for the physical structure and implementation of data warehouses and data marts.
• Design, document and build physical database environments from table, column, index and view definitions to storage requirements and drive spacing and growth accommodations.
• Work with developers and data analysts to identify, design and implement solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of reporting, decision support and analysis.
• Develop scripts for the creation of the physical data warehouse database schema(s), data security and protection, managing performance, performing backups/ restores, and archiving data.
• Document and standardize data structures, procedures and processes.
• Manage, Monitor and Administer database and system performance. Including optimization and tuning of data loads, extractions and recommending appropriate procedure, query or package changes and optimizations to ensure and improve system performance and reliability.
• Strong ad-hoc SQL query development skills, working knowledge of relational databases and MS Word, PowerPoint, Access, Visio
• Superior data mining, extraction, transformation, modeling, validation testing, and presentation skills are mandatory
• Reporting, technical writing and documentation experience

Contact Information:

Ryan Mac Donald
Senior Staffing Consultant

Midwest Consulting Group
9401 Indian Creek Parkway - Suite 1120
Overland Park, KS 66210
913-693-8200-Office
913-522-0179-Cell
http://www.mcginfo.com
ryanm@mcginfo.com

Partial list of MCG Employment openings link:
http://midwestconsultingryanmacdonald.blogspot.com/