Entry Level ETL Developer

Job Description

We have an opening for a dynamic Entry Level ETL Developer who is passionate about what they do and looking to gain a wealth of experience with different database and development technologies. This position will primarily support our Enterprise Data Store processes and internal business analytic operations. We are a data driven company and are excited about the limitless use for actionable insights that can be achieved through skillful data manipulation. Come be part of a team that makes a real difference helping to shape the direction of the company through the health and well-being services provided to our customers. We offer a pleasant, safe, and secure working environment combined with a competitive compensation and benefits package.

About Us

Abacus Health Solutions is an innovative health management company with a strong history in the development and management of chronic condition programs. Utilizing the latest in healthcare technologies, Abacus translates evidence-based medicine into real world interventions. Our programs for diabetes and hypertension are built to foster high rates of adoption, resulting in healthier, more productive employees.

Abacus values diversity and is committed to creating an inclusive environment for all employees. We believe in creating teams made up of individuals with various backgrounds, experiences, and perspectives. This results in greater innovation and collaboration, leading to better solutions. As such, we seek to recruit, develop, and retain the most talented people from a diverse candidate pool. Abacus offers a competitive benefits package and a hybrid work schedule allowing work from home and in-office work.

Company Background

From its inception in 1988 and at its core, Abacus Health Solutions has been a research and development firm. Today Abacus translates evidence-based medicine to real world interventions for our clients and their employees.

A strong behavioral science background shapes the development of all our solutions. Abacus uses these strengths and an experienced team of healthcare experts, technologists, and clinicians to develop and deploy innovative health behavior change tools and targeted programs to help employers control rising healthcare costs and provide high quality health benefits that optimize the health and productivity of their workforce. Abacus works with every client to develop a program that fits the needs and goals of each unique organization. We are excited and passionate about the work we do and the success of our programs has enabled our recent growth.

Job Responsibilities:

• Work with SFTP processes and data file collection, storage, and organization
• Use Extract, Transform, and Load (ETL) tools to load data into our data warehouse
• Assistance with ETL process development and data standardization for new file structures
• Provide support for data analytics and reporting
• Perform testing and data validation
• Documentation of key workflows and processes
• Maintain appropriate security standards with respect to data storage and communications
• Be available to assist with other exciting projects as needed

The ideal candidate will possess SOME of the following skills and have a desire to learn about the others:

• Working knowledge of SQL syntax and database design fundamentals
• Experience with Transact-SQL for writing queries or stored procedures
• Exposure to SQL Server Integration Services (SSIS) packages
• ETL process experience, including working with text file manipulation or data mapping
• Understanding of Data Warehouse topics (ETL, analysis tools, etc…)
• Microsoft Power BI experience or exposure
• Familiarity with Business Intelligence and Analytic Workflows
• Knowledge of Microsoft Fabric or other cloud-based data management platforms

Job Requirements:

• BA/BS or other equivalent degree or experience
• Excellent written and oral communication abilities
• Solid interpersonal skills and demonstrated capacity to work in a small team or independently as necessary
• Accuracy and precision in work are a must
• Strong Analytical Problem-Solving Skills

Abacus Health Solutions, LLC is an equal opportunity employer.

Job Type: Full-time

Pay: $55,000.00 - $65,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Tuition reimbursement
• Vision insurance

Work Location: Hybrid remote in Cranston, RI 02920