Data Engineer II
About The Position
Essential Functions: Creates and debugs ETL/ELT packages using SQL Server Integration Services (SSIS), Pentaho, or other open-source programs. Creates, debugs, and optimizes stored procedures, views, and functions. Collaborates with Data Architect and other stakeholders to understand requirements, relation between various data sets, and frequency of updates. Defines metrics and calculations along with the corresponding updates to the semantic layer. Collaborates with the business community to identify, analyze and document data engineer’s needs. Collaborates with internal team members in the design and development of reports and dashboards for various business units. Assists in the definition of business intelligence (BI) strategy within the IT Department. Maintains documentation for data engineer processes and procedures. Collaborates with team to create proof of concept (POC) using Amazon Web Services (AWS). Performs other related duties and projects as business needs require at direction of management. Education and Experience: Bachelor’s Degree in Computer Technology required. Minimum five (5) years of relevant work experience in the areas below, or any equivalent education and/or experience from which comparable knowledge, skills and abilities have been demonstrated/achieved: Experience in TSQL Experience in Business Objectives, Data Transformation Services (DTS) /SQL Server Integration Services (SSIS) and 3rd party ETL/ELT tools. Experience in an open source language such as Python, Java, PHP, or Ruby. Minimum one (1) year of relevant cloud base technology experience such as Amazon Web Services (AWS).
Requirements
- Bachelor’s Degree in Computer Technology required.
- Minimum five (5) years of relevant work experience in the areas below, or any equivalent education and/or experience from which comparable knowledge, skills and abilities have been demonstrated/achieved:
- Experience in TSQL
- Experience in Business Objectives, Data Transformation Services (DTS) /SQL Server Integration Services (SSIS) and 3rd party ETL/ELT tools.
- Experience in an open source language such as Python, Java, PHP, or Ruby.
- Minimum one (1) year of relevant cloud base technology experience such as Amazon Web Services (AWS).
Responsibilities
- Creates and debugs ETL/ELT packages using SQL Server Integration Services (SSIS), Pentaho, or other open-source programs.
- Creates, debugs, and optimizes stored procedures, views, and functions.
- Collaborates with Data Architect and other stakeholders to understand requirements, relation between various data sets, and frequency of updates.
- Defines metrics and calculations along with the corresponding updates to the semantic layer.
- Collaborates with the business community to identify, analyze and document data engineer’s needs.
- Collaborates with internal team members in the design and development of reports and dashboards for various business units.
- Assists in the definition of business intelligence (BI) strategy within the IT Department.
- Maintains documentation for data engineer processes and procedures.
- Collaborates with team to create proof of concept (POC) using Amazon Web Services (AWS).
- Performs other related duties and projects as business needs require at direction of management.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
1,001-5,000 employees
