Job Details

ID #49594861
State Rhode Island
City Portsmouth
Job type Permanent
Salary USD Depends on Experience Depends on Experience
Source DATAECONOMY
Showed 2023-03-31
Date 2023-03-30
Deadline 2023-05-29
Category Et cetera
Create resume

Data Solution Architect/ Lead (SSIS)

Rhode Island, Portsmouth, 02871 Portsmouth USA

Vacancy expired!

Job DescriptionThe candidate will primarily be working with data ingestion, querying, sanitizing and monitoring. He/she would offer a combination of strong SQL and ETL capabilities and help shape our large-scale data platform.

Responsibilities:
  • Design, develop and support Extract Transform Load (ETL) processes using SSIS
  • Optimize and tune ETL applications to manage high volume batch data transfer.
  • Troubleshoot data issues, recommend, test and implement solutions.
  • Assist with data analysis and investigation.
  • Document technical requirements and solutions
  • Engage in project planning and delivering to commitments.
  • Interact with cross-functional teams to ensure complete delivery of solutions.
  • Assist with configuration and deployment.
  • Work with other developers to provide datasets which would drive Tableau views and SSRS reports.
  • Partake in weekly planning and review sessions.
Required Skills:
  • Bachelor’s degree required, preferred in Computer Science, Engineering
  • 5-7 years of T-SQL programming experience
  • 4+ years of ETL experience
  • Experience with SQL Server 2008/2012/2014/2017 and component services SSIS, SSRS
  • Experience importing and exporting data from Excel and delimited flat files.
  • Experience troubleshooting and resolving database integrity and performance issues.
  • Experience with implement business rules/calculations in stored procedures and functions
  • Experience with AWS RedShift and other tools in the AWS ecosystem is a plus.
  • Experience with Python is a plus.
  • Experience with credit card or other heavy transaction loading processed is a plus.
  • Excellent verbal and written communication skills
  • Strong problem-solving and multi-tasking abilities

Vacancy expired!

Subscribe Report job