Senior Data Engineer

Are you a seasoned Senior Data Engineer with experience in AWS Redshift Databases and their automation for delivering data-driven customer portals? Do you delight in designing processes and enhancing data quality for BI reporting? Our Precision Xtract team is seeking a Senior Data Engineer to expand our AWS Redshift and Tableau systems.

THIS IS A FULLY REMOTE OPPORTUNITY, but applicants must presently live in India.

About You:

• You possess a history of working with Redshift as an Enterprise Database and S3 for file stores for data ingestion and transfer to other systems (internal and external facing).
• You have experience in an offshore/onshore model.
• You thrive on developing new process and ETL task automations that enhance data quality and speed of data delivery.

About The Role:

• The Senior Data Engineer is in charge of designing, creating and continuously ensuring the quality of processes and workflows (Data Pipeline, Analytics Platform, Product Delivery) grounded on our technology stack to support Precision products and/or applications dealing with data management and analytics across a range of healthcare information.
• In this position, they will collaborate closely with our Product Management and Delivery teams to understand the needs of our clients (internal and external), the value proposition of our products and design/implement scalable technical solutions to deliver client value. They will actively manage the identification and justification of new data/analytics or automation opportunities for the products they support.

Essential functions of the job include but are not limited to: 

• Capability to translate business requirements into technical requirements
• Collaborate with SMEs to develop ad-hoc data queries and support tools
• Oversee and enhance monthly data operations processes for various product lines
• Active contributor on DevOps platforms to systematically manage code-base
• Assume responsibility for previously built solutions and support future enhancements
• Execute existing and develop new data ETLs for data management
• Administer continuous integration / continuous deployment (CI/CD) pipelines for dashboards and datasets for the organization ensuring change management and version control for data assets
• Conduct risk-based code reviews for solutions created by our development partners
• Collaborate with the Product Team to implement new application enhancements and features
• Interact with end users, internal users, development vendors, data analysts, and other engagement team members.
• Perform internal dev tasks as assigned
• Invest time in automating various data loading and data validation tasks

 QUALIFICATIONS:

Minimum Required:

• At least 4 years’ experience designing and reviewing complex data ecosystems with focus on data analysis systems including data warehousing, reporting, and strategic analytics
• 2 or more years’ experience with cloud-based infrastructure (AWS, Azure, et al.), cloud database management (e.g., Redshift)
• Working Experience with Stored procedures, preferably for ETL automation
• 2+ years of Data modelling and preferably serving as a data architect for complex data ecosystems

Other Required:

• Experience in Life Sciences
• Experience leading technical discussions like technology reviews
• Experience working in an onshore-offshore model

Preferred:

• Experience with the US Healthcare system and its key data sources. Experience with US Pharmaceutical Commercialization including Market Access or Commercial Operations
• Experience as a Tableau Administrator and/or in developing Tableau dashboards/tools
• Experience with Python
• Experience with an ETL tool or an ETL setup
• Experience with other cloud database management systems like Snowflake / Databricks