SQL Developer

Join #Ensiteam!

We are a company focused on custom software development and have been in the market for over 19 years. At Ensitech we are dedicated to finding highly specialized talent to work with large companies in the United States, Europe, and Canada.

Each one of our collaborators works with different teams and colleagues around the world, in the design and commercialization of software. We look forward to having you as part of our team in the role of SQL Developer. This is a diverse and fast paced position responsible for creating, maintaining, debugging, and promoting integration packages to Production using various technologies. This "hands-on" position requires solid technical and analytical skills, as well as excellent interpersonal and communication skills. The candidate will be responsible for complex workflows to aid in data movement between on-premises databases, Azure, SFTP, and third-party applications using flat files and REST API calls. The candidate should be a self-starter that is eager to tackle any issue that may arise.

What you will do

Ability to prioritize on-going tasks and projects with distractions while maintaining attention to detail; Ability to meet deadlines and deal with shifting priorities.

Ability to work on multiple projects at once with given priorities and timelines.

Build complex workflows, expressions, queries, and validations with proper error handling and alerting.

Create and maintain complex packages in SSIS using third party plugins, data transformations, slowly changing dimensions, and advanced expressions.

Designing and creating tables, stored procedures, views, indexes, and functions using T-SQL.

Develops and maintains new and existing ETL / integrations adhering to industry standards and established company best practices.

Diagnoses job failures and produce solutions to ongoing issues.

Documenting integration processes, configurations, and workflows for future reference and knowledge sharing.

Ensuring data integrity, accuracy, and security throughout the integration lifecycle.

Maintains a high level of accurate and up to date documentation.

Provides advanced technical assistance and support for end users.

Reporting and data driven subscriptions in SSRS.

Supplemental and backup support for Data Warehouse residing in Azure.

Tracks database schema changes, code changes, and promotion to Production using GIT repos and CI/CD pipelines.

Work on projects independently including coding and debugging while following technical specifications. Requirements

5+ years advanced technical experience with three or more of the following: TSQL, SSIS, SSRS, Azure Data Factory, REST API, JSON.

Bachelor's Degree in related field or 8+ years relevant work experience.

Experience in an environment supporting Windows and/or Azure components.

Must be able to work collaboratively within a multi-disciplinary team.

Must have strong English verbal and written communication skills.

Proficient use of all Microsoft Office Suite programs.

Self-motivated with sharp attention to detail. What do we offer?

100% remote opportunity.

Competitive salary and benefits.

Custom benefit package aligned to your experience and your needs.

Working with foreign clients.