The Data Engineer will design and maintain scalable data pipelines, optimize ETL processes, and ensure data quality for analytics in healthcare.
Allata is a global consulting and technology services firm with offices in the US, India, and Argentina. We help organizations accelerate growth, drive innovation, and solve complex challenges by combining strategy, design, and advanced technology. Our expertise covers defining business vision, optimizing processes, and creating engaging digital experiences. We architect and modernize secure, scalable solutions using cloud platforms and top engineering practices.
Allata also empowers clients to unlock data value through analytics and visualization and leverages artificial intelligence to automate processes and enhance decision-making. Our agile, cross-functional teams work closely with clients, either integrating with their teams or providing independent guidance—to deliver measurable results and build lasting partnerships.
We are seeking a skilled Data Engineer to join our team and contribute to data-driven initiatives within the healthcare industry. This role focuses on designing, building, and optimizing scalable data solutions that support analytics, reporting, and advanced data use cases in regulated environments.
Role & Responsibilities:
- Design, develop, and maintain scalable data pipelines using Databricks (PySpark) and Python.
- Build and optimize ETL/ELT processes within Azure cloud environments.
- Implement data models following modern Data Lakehouse principles (e.g., Medallion architecture).
- Ensure data quality, consistency, and performance across ingestion, staging, and curated layers.
- Collaborate with data architects, analysts, and business stakeholders to translate healthcare data requirements into technical solutions.
- Develop reusable data transformation logic and modular processing components.
- Support deployment processes following CI/CD and DevOps best practices.
- Monitor and optimize data workflows for performance, scalability, and reliability.
- Contribute to data governance, security, and compliance practices relevant to healthcare environments.
Hard Skills - Must have:
- Current knowledge of an using modern data tools like (Databricks,FiveTran, Data Fabric and others); Core experience with data architecture, data integrations, data warehousing, and ETL/ELT processes
- Applied experience with developing and deploying custom whl and or in session notebook scripts for custom execution across parallel executor and worker nodes
- Applied experience in SQL, Stored Procedures, and Pysparkbased on area of data platform specialization.
- Strong knowledge of cloud and hybrid relational database systems, such as MS SQL Server, PostgresSQL, Oracle, Azure SQL, AWS RDS, Auroraor a comparable engine.
- Strong experience with batch and streaming data processing techniques and file compactization strategies.
Hard Skills - Nice to have/It's a plus:
- Strong hands-on experience with Databricks in Azure environments.
- Advanced proficiency in Python and PySpark for distributed data processing.
- Experience building and optimizing data pipelines in Azure (Azure Data Factory, Azure SQL, Data Lake Storage, etc.).
- Solid understanding of data warehousing, data lakehouse concepts, and ETL/ELT frameworks.
- Experience working with relational databases such as SQL Server, PostgreSQL, Oracle, or similar.
- Knowledge of batch and streaming data processing patterns.
- Experience working with large, complex datasets in cloud-based distributed environments.
Soft Skills / Business Specific Skills:
- Strong analytical and problem-solving skills.
- Ability to work effectively in cross-functional and distributed teams.
- Clear communication skills, with the ability to explain technical concepts to non-technical stakeholders.
- Proactive mindset with a strong sense of ownership.
- Commitment to delivering high-quality, reliable data solutions.
At Allata, we value differences.
Allata is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
Allata makes employment decisions without regard to race, color, creed, religion, age, ancestry, national origin, veteran status, sex, sexual orientation, gender, gender identity, gender expression, marital status, disability or any other legally protected category.
This policy applies to all terms and conditions of employment, including but not limited to, recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
Top Skills
Aurora
Aws Rds
Azure
Azure Sql
Databricks
Ms Sql Server
Oracle
Postgres
Pyspark
Python
SQL
Similar Jobs
Big Data • Information Technology • Software • Analytics • Energy
The Senior-to-Principal Analyst will deliver consulting services, analyze data, and develop models for the energy industry, ensuring client satisfaction and driving actionable insights.
Top Skills:
Enverus PrismGenerative AiPower BIPythonSpotfireSQLTableauVBA
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Conduct research on mobile threats, analyze cyber campaigns, reverse engineer malware, produce intelligence reports, and collaborate with teams for threat detection.
Top Skills:
DebuggersDecompilersDisassemblersMalware AnalysisPythonReverse Engineering
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
The Internal Billing Analyst supports timely and accurate billing operations, analyzes work, generates invoices, assists collections, mentors others, and ensures compliance with company policies.
Top Skills:
ExcelOutlookWord
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
