Job Description :
To assist in designing, creation and debugging of MS SQL ETL packages (SSIS, SP, Views, etc) as well as exploring existing/new Amazon Web Services (AWS
The ideal candidate would be driven, self-motivated, have a “can do” attitude, and be eager to learn new technology as they will be assisting in transitioning/creating ETL’s on the AWS platform.
Education and Experience:
Bachelor’s Degree in Computer Technology required.
Experience in open source language such as Python, Java, PHP, Ruby
Experience with Redshift, Tableau, and AWS services
General experience in Business Objectives and Data Transformation Services (DTS) /SQL Server. Integration Services (SSIS), a plus
Essential Functions:
Contributes to creating Extract, Transform, and Load (ETL) tools using SQL Server Integration Services (SSIS), or other open-source languages such as Python, Java Script, and GO programming language to extract data from transactional or staging databases under the guidance of management.
Collaborates with Data Architect and other stakeholders to understand requirements, relation between various data sets, and frequency of updates.
Demonstrates basic understanding of data origin to ensure consistent and accurate data.
Assists in identifying and implementing any transformation or conversions necessary to provide consistency and usability of data.
Identifies and resolves inefficiencies and gaps in existing Business Intelligence solutions.
Defines metrics and calculations along with the corresponding updates to the semantic layer under the supervision of management.
Collaborates with the business community to identify, analyze and document BI needs.
Supports with the design and development of reports and dashboards for various business units.
Assists in the definition of Business Intelligence strategy within the IT Department.
Maintains up-to-date business domain knowledge and technical skills in the BI technologies and methodologies under the supervision of management.
Maintains documentation for BI processes and procedures.
Performs other related duties and projects as business needs require at direction of management.