Mindlance · 2 days ago
DATA ENGINEER
Boston, MA
Full-time
Onsite
Mid Level
3+ years expMindlance is seeking to hire an experienced SQL Data Engineer to support the Department of Mental Health and Department of Public Health Hospitals. The Data Engineer will design, develop, maintain, and optimize data pipelines and integration processes, ensuring data accuracy and accessibility for key stakeholders.
Human Resources
Responsibilities
Design, build, and maintain ETL/ELT pipelines using Informatica to move and transform data from various source systems into Snowflake
Ensure data handling and storage comply with HIPAA, HITECH, and organizational privacy/security standards
Support the development of data models, schemas, and views in Snowflake to enable efficient data querying and analytics
Support interoperability and data exchange initiatives using healthcare standards such as HL7, FHIR, and X12 EDI
Implement data ingestion, transformation, and quality processes to ensure consistent, trusted data across environments
Monitor and troubleshoot data pipelines to ensure high performance and reliability
Collaborate with data analysts, data scientists, other data engineers, and business users to understand data requirements and deliver solutions
Develop and maintain documentation for data flows, metadata, and transformation logic
Assist with data security, access control, and governance within Snowflake and Informatica
Participate in testing, deployment, and release management for new data workflows and enhancements
Qualification
Required
3–5+ years of experience in SQL based data engineering or ETL development
Hands-on experience with Snowflake Cloud Data Platform, including SQL development and data modeling
Hands-on experience with Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS) for ETL/ELT design and implementation
Strong experience in SQL language, complex procedures and understanding of data warehousing concepts
3 to 5 years of experience with SQL and scripting languages
3 to 5 years of experience in development with strong knowledge of the procedures and techniques involved in designing, coding, testing, documenting, and maintaining database systems, processes and programs written from detailed specifications
3 to 5 years of experience with the Software Development Life Cycle (SDLC), specifically Scrum and Agile methodology and DevOps practices
Experience integrating structured and semi-structured data (e.g., JSON, XML, CSV)
Familiarity with cloud platforms (AWS, Azure, or GCP) and storage services (e.g., S3, Blob Storage)
Understanding of data governance, data quality, and metadata management principles
Bachelor's degree in computer science, Information Systems, Data Engineering, Health Informatics, or related field or equivalent experience
Snowflake or Informatica certifications are a plus
Preferred
Experience with Python for scripting and automation
Knowledge of Informatica Data Quality (IDQ) or Data Catalog tools
Exposure to CI/CD pipelines, Git, and Agile/Scrum environments
Strong analytical and problem-solving skills
Excellent communication and collaboration with cross-functional teams
Detail-oriented, with a focus on data accuracy and process improvement
Eager to learn new tools and technologies in a fast-paced data environment
Company
Mindlance
Mindlance is a Staffing and Recruiting company which provides multi-vertical staffing services
1001-5000 employees
H1B Sponsorship
Mindlance has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (71)
2024 (53)
2023 (37)
2022 (72)
2021 (36)
2020 (40)
Funding
Current Stage
Late StageLeadership Team
R
Rajat Paul Dhall
Co-Founder & Managing Director
V
Vik Kalra
Co-Founder and Managing Director
Recent News
2025-11-19
Kelly Services, Inc.
2025-05-17
2025-04-14
Company data provided by crunchbase