Kforce - Boston, MA

posted 3 months ago

Full-time - Senior
Hybrid - Boston, MA
Administrative and Support Services

About the position

Kforce is seeking a Senior ETL Developer to join our team in Boston, MA. In this role, you will leverage the Talend ETL toolset to create new ETL jobs that are essential for our data processing needs. You will be responsible for designing and implementing ETL processes that extract and transform data from a variety of sources, including Snowflake, PostgreSQL, and SQL Server databases. Your expertise will be crucial in developing the necessary database tables and constraints to meet project requirements. As a Senior ETL Developer, you will collaborate closely with team members to understand the structures of source systems and the methods used for data retrieval. You will support the development of data transformation logic using ETL tools or scripting languages such as SQL, Bash, and Python. Your role will also involve cleaning, validating, and transforming data to ensure it conforms to target schemas and quality standards. You will work with the team to execute data quality improvement plans and participate in troubleshooting activities to maintain data integrity and process efficiency. This position requires a strong background in ETL development, particularly within health data organizations, and a deep understanding of various database technologies. You will be expected to manage competing priorities effectively and work independently in a hybrid work environment, all while maintaining excellent communication and documentation skills. The role demands a detail-oriented approach, especially when working under tight deadlines, and the ability to create and modify database objects as needed.

Responsibilities

  • Use the Talend ETL toolset to create new ETL jobs.
  • Design and implement ETL for extracting and transforming data from diverse sources, such as Snowflake, PostgreSQL, and SQL Server databases.
  • Design and develop database tables necessary along with the necessary constraints as per the requirement.
  • Collaborate with team members to understand source system structures and data retrieval methods/techniques, and tools within the organization.
  • Support 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.

Requirements

  • Five years of experience using Talend Data Fabric in a professional environment.
  • Five years of experience working for a health data organization performing ETL Development activities.
  • Three years of experience with database, data warehouse, ETL, business intelligence, or software development.
  • Experience in developing projects using Talend with Data Integration and Cloud Integration working with large datasets.
  • Experience with cloud technologies (Azure/AWS) and Microsoft DevOps Git Repos.
  • Experience with Snowflake, PostgreSQL, and SQL Server database technologies.
  • Demonstrable knowledge with the Talend Data Fabric tool, ESB, and MDM development tasks and processes, particularly creating ETL from Technical specifications and converting ETL from other third party ETL tools and frameworks.
  • Working knowledge and understanding of HIPAA policies and working with PII and PHI sensitive data.
  • Effective at managing competing priorities and can work independently with little or no supervision.
  • Excellent communication skills: verbal and written, along with excellent documentation skills.
  • Comfortable working under tight deadlines while maintaining well organized, detailed, and process-oriented work habits.
  • Able to create/modify tables, stored procedures, functions, triggers, and other DB objects.
  • Ability to work independently in a hybrid work environment.

Benefits

  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Health Savings Account (HSA)
  • Flexible Spending Account (FSA)
  • 401(k) plan
  • Life insurance
  • Disability insurance
  • Paid time off for salaried personnel
  • Paid sick leave for hourly employees on Service Contract Act projects
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service