MENU
Go Back
2016-10-13 08:57:41
Key Skills:
BI Engineer – Datawarehouse/ETL Loc: Chicago, IL
2016-10-13 08:57:41
Job Type:
Full Time only
Budget $: 100,000 - 200,000
Budget $: 100,000 - 200,000
- Create and maintain OLAP and warehousing databases in MS SQL Server.Create both T-SQL to support application and/or reporting requirements.
- Analyze and tune development and production databases (including Index Creation/Modification and/or Query rewrites to optimize SQL plan selection) to create performing systems using SQL Profiler and other means.
- Create and maintain ETL packages in SSIS.Create, maintain and tune cubes in SSAS.Create and maintain reports in SSAR.Create deployment scripts for databases when moving from development to staging and production.
- Communicate effectively with business users when direction is necessary for project completion.
- 4 Years experience working with a technical development team to develop Business Intelligence ApplicationsCollege degree (Information Systems or Computer Science)Microsoft Certified ProfessionalOther Technical Certification related to BI considereAdvanced SQL query writing skillsRelational Database conceptual knowledgeFamiliarization with source control/versioning concepts and creating release scriptsExperience with very large databases and/or data warehousingDatabase performance tuning using SQL Profiler/DTA etc.
- SQL Server Integration Serevices (SSIS) strong knowledgeSQL Server Analysis Services (SSAS) strong knowledgeSQL Server Reporting Services (SSRS) report writing skillsStrong analytical ability (troubleshooting data discrepancies and errors)Attention to detailTeam-oriented, ability to build relationships effectivelyStrong verbal and written communication skills.
- Ability to manage time effectively and prioritize projects based on benefitXML knowledgeMore advanced relational db knowledge including partitioning4 Years experience working with a technical development team to develop Business Intelligence ApplicationsCollege degree (Information Systems or Computer Science)Microsoft Certified ProfessionalOther Technical Certification related to BI considereAdvanced SQL query writing skillsRelational Database conceptual knowledgeFamiliarization with source control/versioning concepts and creating release scriptsExperience with very large databases and/or data warehousingDatabase performance tuning using SQL Profiler/DTA etc.
- SQL Server Integration Serevices (SSIS) strong knowledgeSQL Server Analysis Services (SSAS) strong knowledgeSQL Server Reporting Services (SSRS) report writing skillsStrong analytical ability (troubleshooting data discrepancies and errors)Attention to detailTeam-oriented, ability to build relationships effectivelyStrong verbal and written communication skills.
- Ability to manage time effectively and prioritize projects based on benefitXML knowledgeMore advanced relational db knowledge including partitioning
Key Skills:
