ETL developer

Role:

Boston, MA (Onsite)

Responsibilities

• Design and implement ETL for extracting and transforming data from diverse sources, including databases and flat files.
• Collaborate with major stakeholders in the organization to understand project requirements and design/deliver high quality solutions.
• Design and develop required database tables using Snowflake, PostGreSQL, and SQL Server database technologies.
• Collaborate with team members to understand source system structures and data retrieval methods/techniques, and tools within the organization.
• Lead the development of data transformation logic using ETL tools or scripting languages like SQL, Bash, Python, etc.
• Clean, validate, and transform data to conform to target schema and quality standards.
• Work with the team to execute data quality improvement plans.
• Participate in troubleshooting activities to maintain data integrity and process efficiency.
• Mentor and lead junior developers.

Preferred Qualifications

• More than 6 years of hands-on experience with Qlik Talend or alternatively, IBM DataStage, using these tools in a developer role.
• Bachelor's degree in computer science, information technology, or a related field.
• 6+ years' experience working for an organization performing ETL Development activities with large volumes of data, including PII/PHI data.
• Experience with Linux and Windows systems.
• 6+ years' experience with Snowflake, PostGreSQL, and SQL Server database technologies.
• 6+ years' experience working in cloud computing environments such as Microsoft DevOps / Azure.
• Ability to work independently in a fully remote, hybrid, or in-person work environment.
• 6+ years' experience understanding HIPAA policies and working with PII and PHI sensitive data.
• Demonstrated success working collaboratively on a development team with diverse skillsets.
• Effective at managing competing priorities and can work independently with minimal supervision.
• Excellent communication skills: verbal and written, along with excellent documentation skills