Data Transformation Specialist

3 weeks ago


Boston, Massachusetts, United States Center For Health Information And Analysis Full time
Job Summary

We are seeking a skilled Data Transformation Specialist to join our ETL Development team at the Center for Health Information and Analysis (CHIA). This role involves designing and implementing ETL processes for extracting and transforming data from diverse sources, including databases and flat files.

The ideal candidate will have experience working with Gartner Magic Quadrant leading ETL tools, such as IBM DataStage and Qlik Talend. They should also be proficient in database technologies like Snowflake, PostgreSQL, and SQL Server, as well as scripting languages like SQL, Bash, and Python.

This is a key opportunity to work on developing compelling content and rollout campaigns that play a pivotal role in evidence-based decision-making. Our team is committed to promoting transparency in our health care system, and we need your expertise to help us achieve this goal.

About the Role
  • Design and implement ETL processes for extracting and transforming data from various sources.
  • Work with multiple database technologies, including Snowflake, PostgreSQL, and SQL Server.
  • Develop required database tables using database technologies mentioned above.
  • Collaborate with team members to understand source system structures and data retrieval methods/techniques.
  • Support the development of data transformation logic using ETL tools or scripting languages.
  • 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
  • Bachelor's degree in computer science, information technology, or a related field.
  • Experience working for a health data organization performing ETL Development activities.
  • Experience with ETL tools like IBM DataStage or Qlik Talend.
  • Experience with Linux and Windows systems.
  • Experience with database technologies like Snowflake, PostgreSQL, and SQL Server.
  • Experience with scripting languages like SQL, Bash, and Python.
  • Ability to work independently in a fully remote, hybrid, or in-person work environment.
  • Demonstrated knowledge of SDLC models.
  • Working knowledge and understanding of HIPAA policies and working with PII and PHI sensitive data.
  • Demonstrated success working collaboratively on an IT team with diverse skillsets.
  • Effective communication skills: verbal and written, along with excellent documentation skills.
  • Ability to stay well organized, detailed, and process-oriented when under pressure to meet deadlines.
What We Offer

We foster a flexible, collaborative environment that offers a hybrid model balancing in-person and remote work. Our team is committed to promoting transparency in our health care system, and we need your expertise to help us achieve this goal.

We offer a competitive salary range of $105,000 - $115,000 for this position, commensurate with experience. Additionally, we provide a comprehensive benefits package that adds to the overall value of your compensation package.

As a member of our team, you will have the opportunity to work on challenging projects that make a meaningful impact in health care. You will also be part of a collaborative environment that values diversity, equity, and inclusion.

Equal Opportunity Employer

The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law.



  • Boston, Massachusetts, United States KIPP Massachusetts Public Charter Schools Full time

    Transform Education in MassachusettsWe are seeking a dedicated and passionate Transformation Specialist to join our team at KIPP Massachusetts Public Charter Schools.About UsKIPP Massachusetts is a network of public charter schools that provide high-quality education to students from underserved communities in Lynn and Boston. Our mission is to create an...


  • Boston, Massachusetts, United States Center For Health Information And Analysis Full time

    The Center For Health Information And Analysis is seeking a skilled ETL Developer to join our Data Operations and Technology team. As a key member of the software development organization, you will have the opportunity to design and implement ETL for extracting and transforming data from diverse sources, including databases and flat files.SalaryOur...


  • Boston, Massachusetts, United States Rose International Full time

    We are seeking a Digital Transformation Specialist to drive business growth through innovative solutions. As a key member of our Applications Operations team, you will play a crucial role in designing and implementing digital transformation strategies that meet the evolving needs of our clients.Primary Responsibilities:Analyze and document business...


  • Boston, Massachusetts, United States Bow Salon Full time

    Job Title: Hair Transformation SpecialistWe are seeking a skilled Cosmetologist to join our team at Bow Salon. As a Hair Transformation Specialist, you will be responsible for transforming customers' physical appearance by cutting, styling, and coloring hair, as well as providing beauty treatments and makeup application techniques.This is a unique...


  • Boston, Massachusetts, United States Manatt Venture Fund Full time

    Company OverviewAt Manatt Venture Fund, we strive to harness the power of innovative solutions to transform the healthcare landscape. Our organization is dedicated to providing cutting-edge consulting services that help our clients navigate the complexities of the healthcare industry. With a strong focus on collaboration and a commitment to excellence, we...


  • Boston, Massachusetts, United States RIT Solutions, Inc. Full time

    About the RoleWe are looking for a highly motivated and experienced Transformational Change Initiatives Specialist to work with our clients on transformational change initiatives.This role requires a strong understanding of organizational issues and challenges, as well as the ability to prepare people for technology change.The ideal candidate will have a...


  • Boston, Massachusetts, United States Freshworks Full time

    Unlock Enterprise Potential with Strategic PartnershipsFreshworks is a leading provider of cloud-based software solutions, empowering businesses to deliver exceptional customer and employee experiences. Our innovative platform enables organizations to optimize their operations, streamline processes, and drive growth.We are seeking an experienced Enterprise...


  • Boston, Massachusetts, United States Slalom Consulting Full time

    About UsSlalom Consulting is a purpose-led, global business and technology consulting company. Our approach is fiercely human, combining strategy and implementation to deliver practical, end-to-end solutions that drive meaningful impact.We deeply understand our customers and their customers, partnering with over 400 leading technology providers to help...


  • Boston, Massachusetts, United States Galen Full time

    Career Opportunities at GalenWe are seeking a skilled and motivated Technical Data Archival Consultant to join our team at Galen Healthcare Solutions. As a key member of our technical services group, you will work closely with clients to extract data from legacy systems, transform it for long-term record retention, and ensure high-quality results.The ideal...


  • Boston, Massachusetts, United States RLDatix Full time

    Job Title:Data Conversion SpecialistAbout the Position:We are seeking a highly skilled Data Conversion Specialist to join our team at Roland and Lynch Datix (RLDatix). This position involves extracting data from previous Electronic Health Records (EHRs) and ancillary healthcare IT systems, transforming the data into new formats, and importing the data into...


  • Boston, Massachusetts, United States Fidelity TalentSource Full time

    Job Overview:Fidelity TalentSource is seeking a Business Transformation Expert to join our team. This individual will play a critical role in driving business growth and success through strategic planning and analysis.About the Role:This position requires a highly motivated and experienced individual with a strong background in business transformation and...


  • Boston, Massachusetts, United States Tbwa ChiatDay Inc Full time

    Overjet's Data & Analytics team is looking for an experienced Data Scientist to help drive business growth through data-driven insights. The successful candidate will collaborate with cross-functional teams to gather requirements, design analytical solutions, and deliver actionable insights to support business objectives.The ideal candidate will have strong...


  • Boston, Massachusetts, United States Blue Altair Full time

    Unlocking Digital PotentialAt Blue Altair, we believe that our employees are the stars that make up our vibrant constellation. Just as stars illuminate the night sky, our team members light up the business and technology world with their talent, creativity, and dedication.Our journey began in 2015, when we founded Blue Altair as a trusted partner in digital...


  • Boston, Massachusetts, United States Ambient Full time

    Unlock the Future of SleepAmbient is revolutionizing the sleep industry with its cutting-edge technology. As a Digital Sleep Transformation Specialist, you will play a pivotal role in driving our marketing strategies for the pre-launch and launch phases.About UsWe are a team of trailblazing designers and engineers from the robotics space and consumer tech...


  • Boston, Massachusetts, United States Upstream USA Full time

    About Upstream USAUpstream USA is a national nonprofit organization dedicated to ensuring that equitable, patient-centered contraceptive care is available to all patients. As a Practice Transformation Director Lead, you will play a key role in helping us achieve our mission.Job OverviewIn this role, you will be responsible for leading the development and...


  • Boston, Massachusetts, United States Quantis Full time

    Overview of Quantis">We are a global leader in sustainability consultancy, dedicated to transforming businesses and enabling them to thrive within planetary boundaries.Our team of experts partners with organizations across various industries to develop and implement cutting-edge sustainability strategies.Sustainability Expert – Climate Risk Job...


  • Boston, Massachusetts, United States Point B Full time

    Unlock human potential and drive business growth with Point B, a trusted consulting firm that specializes in business transformation and technology services.As a Business Transformation Expert, you will lead projects from inception to completion, improving productivity, increasing efficiencies, reducing costs, and mitigating risk. You will collaborate with...


  • Boston, Massachusetts, United States MDD Forensic Accountants Full time

    About the RoleMDD Forensic Accountants is seeking a highly skilled Database Analyst to join our team. As a key member of our accounting team, you will be responsible for maintaining data storage, assessing database design, and gathering, organizing, and interpreting statistical information based on the data in the database.Key ResponsibilitiesOversee ad hoc...


  • Boston, Massachusetts, United States Quantis Full time

    Company OverviewQuantis is a leading sustainability consultancy pioneering approaches to solve critical environmental challenges. For nearly two decades, our dynamic and visionary team of talent has partnered with leading organizations across the globe to transform their industries and pave the way for a planetary economy that aligns business with...


  • Boston, Massachusetts, United States DGT Associates Inc Full time

    About the JobWe are looking for a Geospatial Data Specialist to join our team at DGT Associates Inc. In this role, you will be responsible for performing office CAD processing work in support of survey operations, including data research, drafting, and report preparation. This is an excellent opportunity to utilize your technical skills and experience in a...