Creative Solutions Services, LLC
ETL Data Engineer : Charter Communications
Creative Solutions Services, LLC, Stamford, Connecticut, United States, 06925
Location:
100% on site in Stamford, CT
Visa:
usc/gc/gc-ead
Notes:
The Network Intelligence team is responsible for developing BI reporting focused on Charter's network, plant, infrastructure, and device performance with regard to the overall customer impact. Our team is growing in order to develop reporting insights for our business partners.
Core Competencies:
Expert - Strong problem solving and communications skills
Expert - SQL coding without use of tools (Informatica, etc.)
Moderate - Data warehousing standards
Moderate - Teradata
Nice to have - Snowflake application
Nice to have - Telecom or network operations experience
Description: As part of the Business Intelligence team, the ETL Developer 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:
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
Perform other duties as requested by supervisor
Required Qualifications: Skills/Abilities and Knowledge:
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
Solid understanding of Microsoft Office Suite (Word, Excel, Visio, MS Project, etc.)
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
Strong knowledge of SQL and Stored Procedures
Strong understanding of BI/DW architecture and concepts
Strong understanding of how data governance plays a role in BI
Strong understanding of how multiple data sources can be consolidated together to produce BI Solutions
Education: Bachelor's degree or foreign equivalent in Information Technology or business related field, or equivalent experience
Related Work Experience:
4+ years of SQL Query Design in large-scale data warehouse environments
4+ years of data integration development using ETL methodology
4+ years of data collection and database/report design
4+ years of work experience in delivering IT/BI solutions
Preferred Qualifications:
Experience with Teradata and/or other MPP data warehouse platforms
Experience working with Telecom/Cable MSO data and applications
Experience working with MicroStrategy, Tableau
Experience working with ETL workflow and scheduling applications (Informatica, One Automation, UC4, Composite)
#J-18808-Ljbffr
100% on site in Stamford, CT
Visa:
usc/gc/gc-ead
Notes:
The Network Intelligence team is responsible for developing BI reporting focused on Charter's network, plant, infrastructure, and device performance with regard to the overall customer impact. Our team is growing in order to develop reporting insights for our business partners.
Core Competencies:
Expert - Strong problem solving and communications skills
Expert - SQL coding without use of tools (Informatica, etc.)
Moderate - Data warehousing standards
Moderate - Teradata
Nice to have - Snowflake application
Nice to have - Telecom or network operations experience
Description: As part of the Business Intelligence team, the ETL Developer 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:
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
Perform other duties as requested by supervisor
Required Qualifications: Skills/Abilities and Knowledge:
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
Solid understanding of Microsoft Office Suite (Word, Excel, Visio, MS Project, etc.)
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
Strong knowledge of SQL and Stored Procedures
Strong understanding of BI/DW architecture and concepts
Strong understanding of how data governance plays a role in BI
Strong understanding of how multiple data sources can be consolidated together to produce BI Solutions
Education: Bachelor's degree or foreign equivalent in Information Technology or business related field, or equivalent experience
Related Work Experience:
4+ years of SQL Query Design in large-scale data warehouse environments
4+ years of data integration development using ETL methodology
4+ years of data collection and database/report design
4+ years of work experience in delivering IT/BI solutions
Preferred Qualifications:
Experience with Teradata and/or other MPP data warehouse platforms
Experience working with Telecom/Cable MSO data and applications
Experience working with MicroStrategy, Tableau
Experience working with ETL workflow and scheduling applications (Informatica, One Automation, UC4, Composite)
#J-18808-Ljbffr