This job has expired, please see additional jobs below
Senior Business Intelligence Developer
Horizon Media
New York, NY, United States
Job Details - this job has expired, please see similar jobs below
#20 on “2013 Best Places to Work in New York City” List - Crain’s New York Business
#9 on “2013 125 Largest Privately Held Companies” List - Crain’s New York Business
2013 Media Agency of the Year- thinkLA
We are currently looking to hire a Senior Business Intelligence Developer in our Information Technology Department. The Senior Business Intelligence Developer will be responsible for the organization and validation of all data residing in the data-warehouse. This person will collaborate with other leaders in the group to drive data design within the database systems in support of Horizon’s Information Systems and will need to be able to address issues of Data Migration (Validation, Clean-up and Mapping).This person will understand all data domains that form the pillars of advertising agency business, advocate for data standards and anticipate eventual interactions between data systems (data in storage and data in motion). Mediate, guide, promote and obtain consensus on decision to move project forward with a balanced approach that satisfy long-term architecture goals/objectives while maintain realistic timeline and budgets.
Main Responsibilities:
• Performs detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)
• Defines, executes and interprets complex/nested SQL queries
• Establish standards and best practices for data architecture and related technologies from an enterprise perspective.
• Creates data models from given business requirements
• Responsible for developing, testing, monitoring the deployment of ETL Jobs
• Responsible for dimensional modeling and develop cubes/reports from given business reporting requirements
• Responsible for reports development using SSRS and/or ASP.net
Key Relationships:
Internal: This position will require an individual who can work with minimal supervision on a wide range of projects interfacing with development teams, business analysts, management and members of the business community in all operational departments within Horizon: Activations team, DR, Human Resources, Legal, and Shared Services.
External: Direct collaboration with of various third party partners and venders is required for the successful implementation of company wide solutions.
Requirements:
• 5+ yrs. experience developing Business Intelligence (BI) solutions (ETL, reports, dashboards, scorecards, etc.) using Microsoft technology in a data warehousing environment
• MS SQL Server Integrated Services (SSIS)
• Full Life Cycle Experience in Model, Design, Development of Data warehouse/ETL/BI Solutions
• Strong in database concepts
• Experience creating complex queries, and stored procedures
• Very Familiar with Front-end web development using ASP.net, and AJAX
• Excellent organizational skills, attention to detail and quality
• Proficient with Windows SQL Server
• Ability to multi-task in fast-paced environment
• Customer service focused to both internal & external clients