CBTS
Senior Data Engineer
CBTS, Ohio City, Ohio, United States, 45874
Job Description
Job Purpose
:
The primary role of the Data Engineer III -- Data Engineering is to be the technical lead on the Analytics - Insights team. This resource will be responsible for designing, building, and maintaining the CBTS Data Lake. This individual will lead the data engineering team to build and maintain critical ETL processes that support the CBTS Data Strategy. This role will serve as an authority on Data Engineering processes and methodologies, and ensure optimal technical delivery of data solutions for CBTS and its customers.
Essential Functions
:Designing, Building - Maintaining AWS Data Lake environment for CBTS data infrastructure. -- 25%Employ a variety of programming languages and tools (i.e. Python, C++, IDE's, etc.) to integrate systems/data packages and infrastructure into AWS Data Lake, SQL/MySQL DBs and Data Stores - 15%Building APIs, Databases and data sets for internal/external for reporting and system consumption. - 15%Lead Data Engineering team, provide coaching, establish data engineering best practices such as code review, optimization, ETL tuning, agile methodology and version control. -- 15%Develop and maintain front end user interfaces for data input/output, optimized for user experience - 15%Collaborate with Analytics - Insights team members on agile approaches to achieving project goals - 15%Education
:
Four years of College resulting in a Bachelor's Degree or equivalent
Certifications, Accreditations, Licenses
:
AWS Data Analytics or Azure Data Engineer -- RequiredAWS Certified Solutions Architect Professional -- PreferredAWS Certified Developer Associate - RequiredMCSE: Cloud Platform and Architecture - PreferredMCSA: SQL 2016 - PreferredMySQL Database Administration - PreferredMCSA: SQL 2016 - PreferredRelevant Work Experience:
8 to 10 years in related field
Special Knowledge, Skills and Abilities
:
7+ plus years in corporate Data Engineering/Data Lake Development6+ years cloud experience, demonstrated proficiency in cloud data lake environments (AWS, Azure) - Required6+ years strong working knowledge with of at least one of the following tech stacks.(S3, Glue, Firehose, Athena, Crawler, Lambda functions, Cloudwatch)(Azure, Blob Storage/Data Lake Storage, Data factory, Event Hub, Data Lake Analytics, Azure Functions and Azure Monitoring). - RequiredDemonstrated proficiency working with APIs, SDKs and Databases - RequiredMicrosoft SQL Server 2012, 2016, 2019Visual Studio or comparable IDEStrong working knowledge of GIT - Preferred2-4+ years of MySQL2-4+ years working knowledge of Python, C#, Node.js, Javascript, ReactExperience with ETL Tools required (e.g. Talend, Pentaho, SSIS) Required2-4+ years working knowledge Strong understanding of Relational Data Structures2+ years of working knowledge of non-relational data structures (e.g. Mongo).Familiarity with Agile methodologiesStrong understanding of APIs and programmatic data extractionFamiliarity with scientific - statistical methodologies -- Required
Supervisory Responsibility
:
This position does not have employee direct reports but does serve as a lead role for others doing similar work
About Us
CBTS serves enterprise and midmarket clients in all industries across the United States and Canada. CBTS combines deep technical expertise with a full suite of flexible technology solutions--including Application Modernization, Managed Hybrid Cloud, Cybersecurity, Unified Communications, and Infrastructure solutions. From developing and deploying modern applications and the secure, scalable platforms on which they run, to managing, monitoring, and optimizing their operations, CBTS delivers comprehensive technology solutions for its clients' transformative business initiatives. For more information, please visit
www.cbts.com .
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, age, disability, religion, sex, sexual orientation, gender identity, gender expression, protected veteran, military status or any other characteristic protected by law.
Due to U.S. Government requirements applicable to foreign-owned telecommunications providers, non-US citizens will be required to submit to an extensive government agency background check which will necessitate disclosure of sensitive Personally Identifiable Information.
Attention California Residents:
https://www.cbts.com/privacy-policy/california-privacy-policy/
Job Purpose
:
The primary role of the Data Engineer III -- Data Engineering is to be the technical lead on the Analytics - Insights team. This resource will be responsible for designing, building, and maintaining the CBTS Data Lake. This individual will lead the data engineering team to build and maintain critical ETL processes that support the CBTS Data Strategy. This role will serve as an authority on Data Engineering processes and methodologies, and ensure optimal technical delivery of data solutions for CBTS and its customers.
Essential Functions
:Designing, Building - Maintaining AWS Data Lake environment for CBTS data infrastructure. -- 25%Employ a variety of programming languages and tools (i.e. Python, C++, IDE's, etc.) to integrate systems/data packages and infrastructure into AWS Data Lake, SQL/MySQL DBs and Data Stores - 15%Building APIs, Databases and data sets for internal/external for reporting and system consumption. - 15%Lead Data Engineering team, provide coaching, establish data engineering best practices such as code review, optimization, ETL tuning, agile methodology and version control. -- 15%Develop and maintain front end user interfaces for data input/output, optimized for user experience - 15%Collaborate with Analytics - Insights team members on agile approaches to achieving project goals - 15%Education
:
Four years of College resulting in a Bachelor's Degree or equivalent
Certifications, Accreditations, Licenses
:
AWS Data Analytics or Azure Data Engineer -- RequiredAWS Certified Solutions Architect Professional -- PreferredAWS Certified Developer Associate - RequiredMCSE: Cloud Platform and Architecture - PreferredMCSA: SQL 2016 - PreferredMySQL Database Administration - PreferredMCSA: SQL 2016 - PreferredRelevant Work Experience:
8 to 10 years in related field
Special Knowledge, Skills and Abilities
:
7+ plus years in corporate Data Engineering/Data Lake Development6+ years cloud experience, demonstrated proficiency in cloud data lake environments (AWS, Azure) - Required6+ years strong working knowledge with of at least one of the following tech stacks.(S3, Glue, Firehose, Athena, Crawler, Lambda functions, Cloudwatch)(Azure, Blob Storage/Data Lake Storage, Data factory, Event Hub, Data Lake Analytics, Azure Functions and Azure Monitoring). - RequiredDemonstrated proficiency working with APIs, SDKs and Databases - RequiredMicrosoft SQL Server 2012, 2016, 2019Visual Studio or comparable IDEStrong working knowledge of GIT - Preferred2-4+ years of MySQL2-4+ years working knowledge of Python, C#, Node.js, Javascript, ReactExperience with ETL Tools required (e.g. Talend, Pentaho, SSIS) Required2-4+ years working knowledge Strong understanding of Relational Data Structures2+ years of working knowledge of non-relational data structures (e.g. Mongo).Familiarity with Agile methodologiesStrong understanding of APIs and programmatic data extractionFamiliarity with scientific - statistical methodologies -- Required
Supervisory Responsibility
:
This position does not have employee direct reports but does serve as a lead role for others doing similar work
About Us
CBTS serves enterprise and midmarket clients in all industries across the United States and Canada. CBTS combines deep technical expertise with a full suite of flexible technology solutions--including Application Modernization, Managed Hybrid Cloud, Cybersecurity, Unified Communications, and Infrastructure solutions. From developing and deploying modern applications and the secure, scalable platforms on which they run, to managing, monitoring, and optimizing their operations, CBTS delivers comprehensive technology solutions for its clients' transformative business initiatives. For more information, please visit
www.cbts.com .
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, age, disability, religion, sex, sexual orientation, gender identity, gender expression, protected veteran, military status or any other characteristic protected by law.
Due to U.S. Government requirements applicable to foreign-owned telecommunications providers, non-US citizens will be required to submit to an extensive government agency background check which will necessitate disclosure of sensitive Personally Identifiable Information.
Attention California Residents:
https://www.cbts.com/privacy-policy/california-privacy-policy/