SSIS ETL Developer with Data Modeling (Remote)

1 month ago
$55 - $65/hourRemoteRandstad
job summary:
Randstad Technologies has an immediate opportunity with one of our long-standing customers, a leading non profit organization in Dallas.

6+ month engagement. Will initially be mostly work from home, but some trips into the Dallas office are expected in the near future, and will likely be 3-4 days onsite in the coming weeks.

Required Skills:

- 8+ years of SQL Development experience

- 5+ years strong SSIS development

- strong Data Modeling experience

- Advanced to Expert level with T-SQL (window functions, temporal tables)

- Proficient with Source control tools

- Ability to be highly producting working remotely with little oversight

- Proficient with source controls tools

- Proficient working in an Agile environment

- Some experience with Tableau or PowerBI or similar

Preferred Skills:

- Salesforce integration and managing data in SFDC

- T-SQL Unit testing experience

- BIML experience

- C# or Web API experience related to building SSIS solutions

- OLAP or Tabular Data Models

- Service Broker or other message queue experience specifically building SSIS solutions around them

Responsibilities:

SQL Data Modeling and Development for Data Hub and Data warehouse environments.The tasks performed include working on new development, bugs, enhancements, troubleshooting activities, configuring environments, suggesting process improvements, and completing documentation.

Provide development using T-SQL, SSIS, SSAS, SSRS, and SQL Server and associated skillsets. Will also likely use Source Control tools, C#, Alteryx/Tableau experience on an as needed basis.

Design, write code, debug, perform system and applications testing, and support the operations team with builds to QA and production release in the Data Hub and Data warehouse environments.

Unit test functionality developed, check against business requirements and adhere to guidelines and best practices.

Data Lake Creation Conversion from Workato to SSIS Projects from within the DR work stream

Reporting/Alerting/Monitoring projects for the Salesforce platform


location: Dallas, Texas
job type: Contract
salary: $55 - 65 per hour
work hours: 8am to 5pm
education: Bachelors

responsibilities:
Responsibilities:

SQL Data Modeling and Development for Data Hub and Data warehouse environments.The tasks performed include working on new development, bugs, enhancements, troubleshooting activities, configuring environments, suggesting process improvements, and completing documentation.

Provide development using T-SQL, SSIS, SSAS, SSRS, and SQL Server and associated skillsets. Will also likely use Source Control tools, C#, Alteryx/Tableau experience on an as needed basis.

Design, write code, debug, perform system and applications testing, and support the operations team with builds to QA and production release in the Data Hub and Data warehouse environments.

Unit test functionality developed, check against business requirements and adhere to guidelines and best practices.

Data Lake Creation Conversion from Workato to SSIS Projects from within the DR work stream

Reporting/Alerting/Monitoring projects for the Salesforce platform


qualifications:
  • Experience level: Experienced
  • Minimum 8 years of experience
  • Education: Bachelors
  •  
    skills:
  • ETL (6 years of experience is preferred)
  • ssis (5 years of experience is required)
  • Data Warehouse (2 years of experience is required)
  • SQL (8 years of experience is required)
  • TSQL (8 years of experience is required)

  • Other ETL contracts

    Remote
    0
    USD
    /hr

    0 ETL contracts