Senior Database Engineer
symplr
·Today
- Location
- Bangalore, KA, IN
- Type
- Full-time
- Department
- Engineering
- Seniority
- Senior
- Experience
- 8+ years
- Education
- Master
- Closing date
- Today
- Source
- iCIMS
Description
Overview
Position Summary:
We are looking for an experienced Senior Data Engineer to design, develop, optimize, and maintain scalable data engineering solutions for healthcare analytics and SaaS platforms.
The ideal candidate will have strong expertise in SQL, Python, ETL/ELT development, data warehousing, database optimization, and AWS cloud services. The candidate will be responsible for building reliable data pipelines, integrating data from multiple healthcare systems, and enabling high-performance data processing and analytics.
The role will work closely with Data Scientists, Software Engineers, Product Managers, and Business Intelligence teams to build robust data platforms that support advanced analytics, predictive modeling, AI/ML initiatives, and enterprise reporting.
Duties & Responsibilities
- Design, develop, and maintain scalable ETL/ELT pipelines for processing large volumes of structured and semi-structured data.
- Build robust data ingestion and transformation frameworks using Python, SQL, and cloud-native data engineering tools.
- Develop reusable data processing components to support multiple healthcare products and customer implementations.
- Integrate data from multiple sources, including relational databases, APIs, healthcare systems, and external data providers.
- Implement data validation, reconciliation, cleansing, transformation, and error-handling mechanisms.
- Optimize data processing workflows for performance, reliability, and scalability.
- Design and maintain data warehouse architecture, data marts, and analytical data models.
- Develop complex SQL queries, stored procedures, functions, and database objects.
- Perform SQL query optimization, indexing, partitioning, and database performance tuning.
- Work with large-scale databases such as SQL Server, PostgreSQL, Amazon Redshift, and other relational or analytical databases.
- Design efficient data models, including dimensional modeling, star schemas, snowflake schemas, and fact/dimension tables.
- Implement data lifecycle management, archival, and retention strategies.
- Ensure data consistency, integrity, availability, and security across data platforms.
Skills Required
Education: Desired Bachelor's or Master's Degree in Computer Science, lnformation Systems, or other related field or equivalent work experience.
Required Skills & experience:
- 8+ years of experience in software engineering, data engineering, ETL development, or database engineering.
- Strong hands-on experience with Python for data processing, automation, and pipeline development.
- 6+ years of strong SQL development experience, including complex queries, stored procedures, functions, and performance tuning.
- Hands-on experience designing and developing ETL/ELT pipelines and data integration frameworks.
- Strong understanding of data warehousing concepts, dimensional modeling, data lakes, and analytical data architecture.
- Experience with relational databases such as SQL Server, PostgreSQL, or MySQL.
- Practical experience with AWS data services, particularly S3, Redshift, Glue, Lambda, and RDS.
- Experience working with large datasets and optimizing data processing performance.
- Strong understanding of data integration patterns, APIs, REST services, XML, JSON, and distributed data processing.
- Experience developing data pipelines for reporting, business intelligence, and analytical applications.
- Exposure to Power BI or similar reporting and visualization platforms.
- Understanding healthcare data standards, particularly HL7 and FHIR, is highly desirable.
- Experience with data quality, data validation, data governance, and metadata management.
- Familiarity with Git, CI/CD, automated testing, and deployment practices.
- Exposure to AI/ML data engineering requirements and Generative AI data preparation workflows.
- Strong analytical, debugging, and problem-solving skills.
- Excellent communication and collaboration skills.
Good to Have
- Healthcare IT experience, particularly hospital systems, clinical applications, healthcare analytics, and quality management solutions.
- Experience working with InterSystems IRIS, InterSystems Caché, or healthcare integration engines.
- Knowledge of healthcare data models, including patient, encounter, clinical, operational, and financial datasets.
- Experience with Apache Spark, PySpark, or other distributed data processing frameworks.
- Exposure to orchestration tools such as Apache Airflow or AWS Step Functions.
- Experience implementing data lake and lakehouse architectures.
- Understanding of Medallion Architecture (Bronze, Silver, Gold).
- Experience building multi-tenant SaaS data platforms.
- Exposure to AWS Bedrock, SageMaker, vector databases, and AI/ML data pipelines.
- Experience with Power BI data modeling and semantic models.
- Knowledge of healthcare data privacy and security standards, including HIPAA where applicable.
- AWS certifications in Data Engineering, Solutions Architecture, or Cloud Practitioner are an advantage.