Data Engineer overview

Who we are -

• CGD Health is a Digital Health company specialized in developing interoperable products and solutions.

• We transform data from large medical records into actionable knowledge and insights for improving patient care while actively reducing interoperability barriers and improving productivity for health systems.

• The company is directed itself mainly in the areas of interoperability standards, data analytics and data warehouse systems.

• We have strong working experience with universities and research organizations which allows the company to offer complete interoperability tools and solutions.

• It is equipped with talented staff who has created products and provided support to various health-care organizations.

• We meet all procurement requirements set forth for vendors by the research organizations.

Who you are -

• The Data Engineer will assist the Development team, Data Science Team and Project manager in the execution of various projects for clients.

• Specifically, This position requires working with large amounts of sensitive health-care data that need to be standardized and transformed across secure computing environments.

• The position requires working independently, coordinating with team members and clients spread across different time zones.

• The Job requires you to be fluent in English.

Key Responsibilities -

• Develop Data Wrangling and ETL processes to standardize data for Public Health and Health services which are designed, tested, implemented, maintained, and controlled by internal and external stakeholders.

• Develop, Test, and Deploy ETL or ELT pipelines using technical stack - SQL, Python, AWS, DBT, Docker, Apache Air-flow, Air-byte, and Snowflake.

• Develop a deep understanding of patient linkage.

• Monitor transaction activity and assist with database utilization. You have to ensure ETL maintenance.

• Analyze the performance limitations of ETL pipelines and monitor them on a regular basis.

• Design and construct databases and database support tools in support of patient linkage in collaboration with technical management and researcher-clients.

• Walk-through the code and write technical documentation of data manipulation strategies and inform internal and external stakeholders.

• Refine ETL business rules with the help of Data Scientists and assist the team on key technical difficulties.

• Research, prototype and develop new data processing architectures.

• Mentor junior team members as the team expands.

What are we looking for -

(Must have)

• A post-graduate qualification in Computer Science or related field. Alternatively, equivalent experience in health domain may be suitable.

• Full-time relevant work experience of more than 2 years in the design and administration of relational databases and ETL processes in diverse technological environments or similar experience in web or data engineering.

• Advanced programming skills in SQL and Python.

• Strong written and communication skills.

• A deep understanding of data warehouse architecture.

• SQL development including stored procedures, functions, triggers, sequences, and advanced SQL queries.

• ETL development standard practices, such as explicit source-to-target mappings, pattern-based and parameter-driven programming, and thorough version control using Git.

• Database administration experience including database design and configuration, as well as DDL and DML query performance tuning using indexes, partitioning, materialized views and other techniques.

(Nice to have)

• Knowledge of Interoperability standards in health-care.

• Experience in system development life cycle.

• Experience with HL7 messages and interfaces (e.g., Mirth, Iguana, Cloverleaf)

• Data analysis using R Studio.

(Extra points for any of the following)

• Development in Cloud Platform. (GCP, AWS, MS Azure)

• Client facing skills.

• Big Data Experience.

(Success attributes of CGD Health employee; does this describe you?)

• Accountable

• Curious

• Collaborative

• Individualist

• Trustworthy

• Dedicated

Why Join Us -

• Attractive compensation and yearly bonus.

• Start - up culture. The perks of interacting with everyone in the organization and get yourself heard.

• Professional development.

• WFH arrangement.

• Team outing and Team building activities.

At CGD Health, there is no such thing as the 'perfect candidate'. - Important (Please read below.)

Seeing responsibilities and competencies laid out on paper can be confronting. At this stage of the application process, sometimes imposter syndrome can creep in and mess with our confidence.

Please know, that we list these items to give you an opportunity to show us your potential and how you can grow and transform with us.

Your ability to demonstrate that you possess/have the real potential to develop the required capabilities, knowledge, experience and qualifications to perform in our roles is what we would like to hear from you. Where possible, you should support your claims with specific examples of what you have done and how you did it.

However you identify, and whatever background you bring with you, please apply if this is a role that would make you excited to come to work every day!

**Note: Shortlisted candidates need to visit Hyderabad for a face-to-face interview.**