What are the responsibilities and job description for the BI ETL Developer II position at Dev?
Company Description
Jobs for Humanity is dedicated to building an inclusive and just employment ecosystem. Therefore, we have dedicated this job posting to individuals coming from the following communities: Refugee, Neurodivergent, Single Parent, Blind or Low Vision, Ethnic Minority, and the Previously Incarcerated. If you identify with any of the following communities do not hesitate to register, even if you feel that this particular opportunity is not the right fit for you.
Company Name: Spectrum
Company Name: Spectrum
Job Description
JOB SUMMARY
As part of the Business Intelligence team, the ETL Developer II 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 support 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
Perform other duties as requested by supervisor
REQUIRED QUALIFICATIONS
Required Skills/Abilities and Knowledge
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 - 4
Data integration development using ELT methodology - 4
Data collection and database/report design - 4
Work experience in delivering IT/BI solutions - 4
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
Experience
As part of the Business Intelligence team, the ETL Developer II 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 support 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
Perform other duties as requested by supervisor
REQUIRED QUALIFICATIONS
Required Skills/Abilities and Knowledge
- Ability to read, write and speak the 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
- In-depth 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
- In-depth knowledge of SQL and Stored Procedures
- In-depth understanding of BI/DW architecture and concepts
- In-depth understanding of how data governance plays a role in BI
- In-depth 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 - 4
Data integration development using ELT methodology - 4
Data collection and database/report design - 4
Work experience in delivering IT/BI solutions - 4
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
Experience
ETL Developer
DataFactZ, LLC -
Charlotte, NC
Microsoft SQL Developer
BI-TEK LLC -
Charlotte, NC
BI Developer – Power BI
Nascent Technologies Inc. -
Charlotte, NC
