This job has expired, please see additional jobs below
BI Engineer – Datawarehouse/ETL
Tribune Company
Chicago, IL, United States
Job Details - this job has expired, please see similar jobs below
The position is responsible for creating and maintaining a data warehouse , performance tuning, package creation and cube creation. In addition, the role creates and maintains extract, transform and load (ETL) processes for the data warehouse from transaction processing systems and other external sources. The role is expected to create tables, complex stored procedures and views using Microsoft T-SQL and ETL packages using SSIS according to architectural standards and technical specifications.
Responsibilities:
• 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.
Qualifications:
• 4 Years experience working with a technical development team to develop Business Intelligence Applications
• College degree (Information Systems or Computer Science)
• Microsoft Certified Professional
• Other Technical Certification related to BI considere
• Advanced SQL query writing skills
• Relational Database conceptual knowledge
• Familiarization with source control/versioning concepts and creating release scripts
• Experience with very large databases and/or data warehousing
• Database performance tuning using SQL Profiler/DTA etc.
• SQL Server Integration Serevices (SSIS) strong knowledge
• SQL Server Analysis Services (SSAS) strong knowledge
• SQL Server Reporting Services (SSRS) report writing skills
• Strong analytical ability (troubleshooting data discrepancies and errors)
• Attention to detail
• Team-oriented, ability to build relationships effectively
• Strong verbal and written communication skills.
• Ability to manage time effectively and prioritize projects based on benefit
• XML knowledge
• More advanced relational db knowledge including partitioning
Tribune Media Company(NYSE: TRCO) is home to a diverse portfolio of television and digital properties driven by quality news, entertainment and sports programming. Tribune Media is comprised of Tribune Broadcasting’s 42 owned or operated local television stations reaching more than 50 million households, national entertainment network WGN America, whose reach is approaching 80 million households, Tribune Studios, and Gracenote, one of the world’s leading sources of video, music and sports metadata, powering electronic program guides in televisions, automobiles and mobile devices. Tribune Media also includes Chicago’s WGN-AM and the national multicast networks Antenna TV and THIS TV. Additionally, the Company owns and manages a significant number of real estate properties across the U.S. and holds other strategic investments in media. For more information please visit www.tribunemedia.com.