BI ETL Developer III

Stamford, Connecticut
Spectrum
JOB SUMMARY
As part of the Business Intelligence team, the ETL Developer III plays a key role in designing, developing and supporting new and existing BI solutions for our users. The ETL Developer’s primary contribution to the team involves transforming data into meaningful and accurate information which the business can consume.

MAJOR DUTIES AND RESPONSIBILITIES
Actively and consistently supports all efforts to simplify and enhance the customer experience

Participate in active discussions with team members and users to understand business requirements

Work closely with IT, Architecture, Business Analysts and Report Developers to achieve business objectives

Design, develop, implement, and support new and existing data integration jobs using Teradata Stored Procedures

Understand and Implement best practice solutions per development standards

Produce Ad Hoc Reports to answer business questions quickly and thoroughly

Develop technology documentation to support production deployments as well as ongoing maintenance of reporting and data solutions

Troubleshoot, diagnose and resolve data quality and performance issues

Communicate complex topics and analyses to non-technical business personnel

Provide accurate level of effort estimates for data integration development to management

Work independently with minimal guidance

Perform other duties as assigned

REQUIRED QUALIFICATIONS
Required Skills/Abilities and Knowledge
Ability to read, write, speak and understand English
Ability to communicate orally and in writing in a clear and straightforward manner
Ability to communicate with all levels of management and company personnel
Ability to handle multiple projects and tasks
Ability to make decisions and solve problems while working under pressure
Ability to prioritize and organize effectively
Ability to show judgment and initiative and to accomplish job duties
Ability to work with others to resolve problems, handle requests or situations
Ability to perform detailed business analysis and design
Ability to transform business requirements into a technical solution.
Knowledge of different ETL design and development methodologies.
Demonstrated knowledge of SQL and Stored Procedures
Demonstrated knowledge of BI/DW architecture and concepts
Demonstrated understanding of how data governance plays a role in BI
Demonstrated understanding of how multiple data sources can be consolidated together to produce BI Solutions

Required Education
Bachelor’s degree or foreign equivalent in Information Technology or business related field, or equivalent experience

Required Related Work Experience and Number of Years
SQL Query Design in large-scale data warehouse environments – 5+ w/ Masters 7+ w/o Masters
Data integration development using ETL methodology – 5+ w/ Masters 7+ w/o Masters
Data collection and database/report design – 5+ w/ Masters 7+ w/o Masters
Work experience in delivering IT/BI solutions – 5+ w/ Masters 7+ w/o Masters

PREFERRED QUALIFICATIONS
Preferred Skills/Abilities and Knowledge
Experience with Teradata and/or other MPP data warehouse platforms
Experience working with Telecom/Cable MSO data and applications
Experience working with MicroStrategy, Tableau

Preferred Related Work Experience and Number of Years
Experience with Teradata and/or other MPP data warehouse platforms
Experience working with Telecom/Cable MSO data and applications
Experience working with MicroStrategy, Tableau

WORKING CONDITIONS
Office environment

BBLBR