Junior ETL Developer

Job Description

Ensure Data Solutions is a software as a service platform for organizations engaged in population health management. By leveraging our solutions, our clients improve efficiency, engage patients or members in the management of their health, and enhance the quality and health outcomes.

We are looking for a Junior ETL Developer with experience in healthcare to implement and optimize ETL processes and create efficiencies through automation. You will work with all levels of management and across departments to define requirements and take the lead on operational and technical projects. In this role, you should be able to work independently with little supervision. You should have excellent organization and problem-solving skills. We'd like to meet you if you have hands-on experience in ETL development and agile methodologies. Your goal will be to develop high-quality ETL packages aligned with user needs and business goals.

POSITION SUMMARY: The incumbent will be responsible for the ongoing development, improvement, and maintenance of the ETL processes that run on our MS SQL data warehouse.

RESPONSIBILITIES:

Implement and optimize ETL processes using SSIS packages and Stored Procedures to extract from a variety of sources, including API's, databases and text files.

Responsible for design of ETL data feeds.

Deploy and maintain ETL processes in a development environment.

Perform code optimization and performance tuning of existing ETL processes.

Generate ad-hoc reports for different users.

Re-define ETL process validation, metadata maintenance, data integrity validation process, quality standards, and monitoring standards to ensure data quality.

Provide accurate estimates of the effort required to complete assignments.

Document technical designs with charts, diagrams, schemes, and descriptive software component documentation

Research and advise on emerging technologies with respect to industry best practices, procedures, and concepts.

Manage highly complex projects from start to finish using Agile/SCRUM development methodology and Team Foundation Server (TFS).

Develop and assist Project Managers and Directors with the creation of task-level project plans that detail the specific tasks required to deliver a solution.

Develop, test, and implement system changes and upgrades.

QUALIFICATIONS:

Minimum of 2 years relevant experience.

Skill in collecting, organizing, and analyzing data.

Ability to recognize, analyze, and solve a variety of problems.

Ability to exercise sound judgment in making critical decisions.

The candidate must have knowledge of the following: Visual Studio, SSIS, Team Foundation.

2 years designing, implementing, testing, deploying, and maintaining ETL solutions using Microsoft SQL Server Integration Services (SSIS).

Experience analyzing existing SQL queries and scripts for performance improvements.

Understanding of SQL, relational and analytical database.

Strong analytical skills to understand business needs in terms of business value.

Experience identifying, recommending, and implementing ETL process improvements.

Excellent interpersonal/communication skills with various levels of the organization.

Detail-oriented with the ability to multitask and meet deadlines.

Experience with enterprise databases MS-SQL.

LOCATION

· Miami (office-based position)

Full-time