Data Engineer II
Position Overview:
Alterman, Inc.
is currently seeking an experienced Data Engineer II to join our Data and Analytics team.
The Data Engineer II role is a key technical resource for Alterman's data pipelines and will help contextualize and provide easy access to data for the entire organization.
As a Data Engineer, you will play a key role in growing and transforming our analytics landscape.
In addition to your strong analytical mind, you will bring your inquisitive attitude and your ability to translate the stories found in data.
You will leverage your abilities to design, build, and deploy data solutions that capture, explore, transform, and utilize data to support and drive business initiatives.
Job Duties and
Responsibilities:
Construct new data pipelines and optimize existing ones to ensure resiliency and scalability.
Maintain stored procedures and organize schedules to prevent concurrency overlap.
Create ETL jobs from various sources and manage internal and third-party schedules.
Combine, cleanse, and organize data for use in analytics software and system integration.
Use available tools together with custom scripting to make data accessible from other sources and optimize the organization's developing data ecosystem.
Create reports for analysts to model and distribute.
Developing various types of data loads (e.
g.
, incremental, history/full, survivorship rules).
Implementing change data capture (CDC).
Test and implement new analytic tools and/or plugins, maintaining analytic tool registrations.
Testing and debugging ETL functions.
Qualifications:
5-7 years of related experience engineering and operationalizing data pipelines with large and complex datasets.
5-7 years of related experience with Data Modeling, ETL, and Data Warehousing.
Extensive experience working with various data sources (e.
g.
, SQL, flat files - csv, delimited, Web API, XML).
Proven experience in a data integration role.
Takes initiative to learn corporate processes, standards, and technologies.
Strong knowledge of:
Database storage concepts; Data Lake, Relational Databases, NoSQL, Graph, Data Warehousing.
Development security standards and protocols.
Application administration lifecycle management.
Software development life cycle management (SDLC).
Programming, scripting, and query languages such as Python, PHP, JavaScript, SQL, and Power Query.
API Management and API Management platforms.
Emerging trends and industry practices.
Personal customer service skills are strongly desired, such as:
Ability to communicate effectively with non-technical users; Ability to work independently with limited supervision; Ability to properly prioritize when faced with multiple projects and timelines; Ability to write business documentation professionally and effectively; Ability to cross-train with other system owners and administrators to ensure adequate coverage across platforms; and Strong focus on continuous improvement of self, team, and process.
Recommended Skills Administration Analytical Business Process Improvement Communication Computer Programming Curiosity Estimated Salary: $20 to $28 per hour based on qualifications.
Alterman, Inc.
is currently seeking an experienced Data Engineer II to join our Data and Analytics team.
The Data Engineer II role is a key technical resource for Alterman's data pipelines and will help contextualize and provide easy access to data for the entire organization.
As a Data Engineer, you will play a key role in growing and transforming our analytics landscape.
In addition to your strong analytical mind, you will bring your inquisitive attitude and your ability to translate the stories found in data.
You will leverage your abilities to design, build, and deploy data solutions that capture, explore, transform, and utilize data to support and drive business initiatives.
Job Duties and
Responsibilities:
Construct new data pipelines and optimize existing ones to ensure resiliency and scalability.
Maintain stored procedures and organize schedules to prevent concurrency overlap.
Create ETL jobs from various sources and manage internal and third-party schedules.
Combine, cleanse, and organize data for use in analytics software and system integration.
Use available tools together with custom scripting to make data accessible from other sources and optimize the organization's developing data ecosystem.
Create reports for analysts to model and distribute.
Developing various types of data loads (e.
g.
, incremental, history/full, survivorship rules).
Implementing change data capture (CDC).
Test and implement new analytic tools and/or plugins, maintaining analytic tool registrations.
Testing and debugging ETL functions.
Qualifications:
5-7 years of related experience engineering and operationalizing data pipelines with large and complex datasets.
5-7 years of related experience with Data Modeling, ETL, and Data Warehousing.
Extensive experience working with various data sources (e.
g.
, SQL, flat files - csv, delimited, Web API, XML).
Proven experience in a data integration role.
Takes initiative to learn corporate processes, standards, and technologies.
Strong knowledge of:
Database storage concepts; Data Lake, Relational Databases, NoSQL, Graph, Data Warehousing.
Development security standards and protocols.
Application administration lifecycle management.
Software development life cycle management (SDLC).
Programming, scripting, and query languages such as Python, PHP, JavaScript, SQL, and Power Query.
API Management and API Management platforms.
Emerging trends and industry practices.
Personal customer service skills are strongly desired, such as:
Ability to communicate effectively with non-technical users; Ability to work independently with limited supervision; Ability to properly prioritize when faced with multiple projects and timelines; Ability to write business documentation professionally and effectively; Ability to cross-train with other system owners and administrators to ensure adequate coverage across platforms; and Strong focus on continuous improvement of self, team, and process.
Recommended Skills Administration Analytical Business Process Improvement Communication Computer Programming Curiosity Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
