Data Engineer 2
As a Data Engineer 2 on our Enterprise Solution Delivery team, you will have a chance to design intelligent, automated data systems using advanced data engineering knowledge in the data warehousing space to redefine best practices with a cloud-based approach to scalability and automation.
In partnership with other developers and business analysts, you will work backwards from our business questions to build reliable and scalable data solutions to meet the business needs.
You will maintain and support new and existing data pipelines.
By scaling up our data ecosystem around cloud-based CRM, ERP, and data platforms, we will improve speed, lower the total cost of ownership, and provide a unified view of entities.
You will be an integral part of the development team, sometimes investigating new requirements and design and at times refactoring existing functionality for performance and maintainability, but always working on ways to make us more efficient and provide better solutions (data pipelines) to our end customers.
The candidate will perform hands-on activities including design, documentation, development, and test of new functionality.
Candidate must be flexible and willing to switch tasks based on team's needs.
The incumbent in this position is expected to model the following practices daily:
1) Demonstrate alignment with the company's mission and core business values; 2) Collaborate with key internal/external resources; 3) Participate in ongoing self- development.
Essential Functions:
Develop, evaluate, and influence effective and consistent productivity and teamwork to ensure the delivery of Legendary Customer Service (LCS) Model, promote, reinforce, and reward the consistent use of HOLT's Values Based Leadership (VBL) tools, models, and processes to ensure alignment with our Vision, Values, and Mission Design, develop, implement, test, document, and operate mid-scale, high- volume, high-performance data structures for business intelligence analytics Create and propose technical design documentation, which includes current and future ETL functionality, database objects affected, specifications, and flows and diagrams to detail the proposed implementation.
Implement data structures using best practices in data modeling to support on- line reporting, analysis, business intelligence and building a logical abstraction layer against large, multi-dimensional datasets and multiple sources.
Understand existing databases and warehouse structures to best determine how to consolidate and aggregate data in an efficient and scalable way.
Design and code all aspects of data solutions using cloud-based tools to build out a data warehouse.
Design ETL/ELT processes and data pipelines to bring data from various sources into a central data repository.
Work closely with Integration developers, ETL developers, application teams, and vendors to develop optimal solutions.
Analyze new/disparate data sources for integration with existing datasets to tell a comprehensive data story.
Improve business process agility and outcomes, drive innovation, and reduce time to market for our innovative IT solutions.
Works safely always and adheres to all applicable safety policies; complies with all company policies, procedures, and standards.
Performs other duties as assigned.
Knowledge, Skills, and Abilities:
Capable of speaking articulately to a breadth of topics such as RDBMS, NoSQL, Azure data store technologies, ETL, data warehousing, data modeling, role- based access, etc.
Background in supporting business intelligence teams by providing subject matter expertise and guidance in modern data engineering.
Advanced SQL and query performance tuning skills Experience with MPP (massively parallel processing) data Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets.
Ability to work with ambiguous requirements and drive clarity by collaborating with business groups.
Drive and desire to learn and grow both technical and functional skill sets, High energy, stamina, enthusiasm, organization, and curiosity.
Innovative thinker who is positive, proactive, and readily embraces change.
Detail-oriented individual with the ability to rapidly learn and take advantage of new concepts, tools, and technologies; Ability to quickly ramp up new projects, understanding the business needs and support engagements.
Ability to manage workload, multiple priorities, excellent problem solving, and troubleshooting skills.
Mentoring Associate developers as needed.
Experience working in a matrix environment and foster motivation within the project team to meet tight deadlines.
Education and
Experience:
High School diploma or equivalent is required, Bachelor's degree in information technology, or related field preferred.
5
years of experience designing, developing, and deploying data solutions using ETL/ELT/DWH/BI technologies required.
2
years of coding experience with modern programming or scripting languages (Python, C# etc.
) required.
Experience in Informatica IICS and Snowflake required.
Experience in developing/operating large-scale ETL/ELT processes with on-prem and cloud platforms; database technologies; data modeling required Experience developing/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets from multiple systems required.
Experience operating a very large data environment that may include data lake, and/or data warehouse etc.
required.
Experience developing and implementing data models for data warehouse or related data processes for heavy equipment rental and dealership operations required.
Basic programming skills such as JavaScript and PowerShell scripting.
Experience with source control and build technologies (e.
g.
, Azure DevOps, GIT) required.
Data Engineering related certifications preferred.
Experience working in an Agile environment required.
Travel:
Up to 20% with occasionally overnight stay may be expected.
Valid driver's license.
Work Environment:
Works primarily in a professional office environment.
This role constantly uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines.
Frequently works at fast pace with unscheduled interruptions.
Physical Requirements:
This position involves extended periods in a stationary position; additionally, occasional movement inside the office to access office machinery, and file cabinets.
Disclaimer:
Please note that the above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification.
They are not to be interpreted as an exhaustive list of all responsibilities, duties, and skills required of the incumbents so classified.
All incumbents may be required to perform duties outside of their normal responsibilities, as needed.
Equal Opportunity Employer/Protected Veterans/Individuals with DisabilitiesThe contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.
However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.
41 CFR 60-1.
35(c) Recommended Skills Abstraction Layers Agile Methodology Agility Attention To Detail Big Data Business Intelligence Estimated Salary: $20 to $28 per hour based on qualifications.
In partnership with other developers and business analysts, you will work backwards from our business questions to build reliable and scalable data solutions to meet the business needs.
You will maintain and support new and existing data pipelines.
By scaling up our data ecosystem around cloud-based CRM, ERP, and data platforms, we will improve speed, lower the total cost of ownership, and provide a unified view of entities.
You will be an integral part of the development team, sometimes investigating new requirements and design and at times refactoring existing functionality for performance and maintainability, but always working on ways to make us more efficient and provide better solutions (data pipelines) to our end customers.
The candidate will perform hands-on activities including design, documentation, development, and test of new functionality.
Candidate must be flexible and willing to switch tasks based on team's needs.
The incumbent in this position is expected to model the following practices daily:
1) Demonstrate alignment with the company's mission and core business values; 2) Collaborate with key internal/external resources; 3) Participate in ongoing self- development.
Essential Functions:
Develop, evaluate, and influence effective and consistent productivity and teamwork to ensure the delivery of Legendary Customer Service (LCS) Model, promote, reinforce, and reward the consistent use of HOLT's Values Based Leadership (VBL) tools, models, and processes to ensure alignment with our Vision, Values, and Mission Design, develop, implement, test, document, and operate mid-scale, high- volume, high-performance data structures for business intelligence analytics Create and propose technical design documentation, which includes current and future ETL functionality, database objects affected, specifications, and flows and diagrams to detail the proposed implementation.
Implement data structures using best practices in data modeling to support on- line reporting, analysis, business intelligence and building a logical abstraction layer against large, multi-dimensional datasets and multiple sources.
Understand existing databases and warehouse structures to best determine how to consolidate and aggregate data in an efficient and scalable way.
Design and code all aspects of data solutions using cloud-based tools to build out a data warehouse.
Design ETL/ELT processes and data pipelines to bring data from various sources into a central data repository.
Work closely with Integration developers, ETL developers, application teams, and vendors to develop optimal solutions.
Analyze new/disparate data sources for integration with existing datasets to tell a comprehensive data story.
Improve business process agility and outcomes, drive innovation, and reduce time to market for our innovative IT solutions.
Works safely always and adheres to all applicable safety policies; complies with all company policies, procedures, and standards.
Performs other duties as assigned.
Knowledge, Skills, and Abilities:
Capable of speaking articulately to a breadth of topics such as RDBMS, NoSQL, Azure data store technologies, ETL, data warehousing, data modeling, role- based access, etc.
Background in supporting business intelligence teams by providing subject matter expertise and guidance in modern data engineering.
Advanced SQL and query performance tuning skills Experience with MPP (massively parallel processing) data Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets.
Ability to work with ambiguous requirements and drive clarity by collaborating with business groups.
Drive and desire to learn and grow both technical and functional skill sets, High energy, stamina, enthusiasm, organization, and curiosity.
Innovative thinker who is positive, proactive, and readily embraces change.
Detail-oriented individual with the ability to rapidly learn and take advantage of new concepts, tools, and technologies; Ability to quickly ramp up new projects, understanding the business needs and support engagements.
Ability to manage workload, multiple priorities, excellent problem solving, and troubleshooting skills.
Mentoring Associate developers as needed.
Experience working in a matrix environment and foster motivation within the project team to meet tight deadlines.
Education and
Experience:
High School diploma or equivalent is required, Bachelor's degree in information technology, or related field preferred.
5
years of experience designing, developing, and deploying data solutions using ETL/ELT/DWH/BI technologies required.
2
years of coding experience with modern programming or scripting languages (Python, C# etc.
) required.
Experience in Informatica IICS and Snowflake required.
Experience in developing/operating large-scale ETL/ELT processes with on-prem and cloud platforms; database technologies; data modeling required Experience developing/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets from multiple systems required.
Experience operating a very large data environment that may include data lake, and/or data warehouse etc.
required.
Experience developing and implementing data models for data warehouse or related data processes for heavy equipment rental and dealership operations required.
Basic programming skills such as JavaScript and PowerShell scripting.
Experience with source control and build technologies (e.
g.
, Azure DevOps, GIT) required.
Data Engineering related certifications preferred.
Experience working in an Agile environment required.
Travel:
Up to 20% with occasionally overnight stay may be expected.
Valid driver's license.
Work Environment:
Works primarily in a professional office environment.
This role constantly uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines.
Frequently works at fast pace with unscheduled interruptions.
Physical Requirements:
This position involves extended periods in a stationary position; additionally, occasional movement inside the office to access office machinery, and file cabinets.
Disclaimer:
Please note that the above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification.
They are not to be interpreted as an exhaustive list of all responsibilities, duties, and skills required of the incumbents so classified.
All incumbents may be required to perform duties outside of their normal responsibilities, as needed.
Equal Opportunity Employer/Protected Veterans/Individuals with DisabilitiesThe contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.
However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.
41 CFR 60-1.
35(c) Recommended Skills Abstraction Layers Agile Methodology Agility Attention To Detail Big Data Business Intelligence Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
