BI ETL Developer III

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

1. Actively and consistently supports all efforts to simplify and enhance the customer experience.
2. Participate in active discussions with team members and users to understand business requirements.
3. Work closely with IT, Architecture, Business Analysts and Report Developers to achieve business objectives.
4. Design, develop, implement, and support new and existing data integration jobs using Teradata Stored Procedures.
5. Understand and implement best practice solutions per development standards.
6. Produce Ad Hoc Reports to answer business questions quickly and thoroughly.
7. Develop technology documentation to support production deployments as well as ongoing maintenance of reporting and data solutions.
8. Troubleshoot, diagnose, and resolve data quality and performance issues.
9. Communicate complex topics and analyses to non-technical business personnel.
10. Provide accurate level of effort estimates for data integration development to management.
11. Work independently with minimal guidance.
12. Perform other duties as assigned.

REQUIRED QUALIFICATIONS

Required Skills/Abilities and Knowledge

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

Required Education

1. Bachelor's degree or foreign equivalent in Information Technology or business-related field, or equivalent experience.

Required Related Work Experience and Number of Years

1. SQL Query Design in large-scale data warehouse environments - 7+
2. Data integration development using ETL methodology - 7+
3. Data collection and database/report design - 7+
4. Work experience in delivering IT/BI solutions - 7+

PREFERRED QUALIFICATIONS

Preferred Related Work Experience

1. Experience with Teradata and/or other MPP data warehouse platforms.
2. Experience working with Telecom/Cable MSO data and applications.
3. Experience working with MicroStrategy, Tableau.
4. Experience working with ETL workflow and scheduling applications (Informatica, One Automation, UC4, Composite).

WORKING CONDITIONS

1. Office environment.