Job Title: Team Lead \xe2\x80\x93 Technology (ETL)

Location: Gurugram, India

About Us ProcDNA is a global consulting firm focused on establishing Commercial Analytics and Technology solutions for life science firms. We work side by side with our clients, partnering to achieve their goals. Our people bring in a strong blend of design thinking, the latest technology, and a client-centric approach to creating a lasting impact. For a firm starting right at the onset of the pandemic, we had stellar growth in 2022. We grew from 2 \xe2\x80\x93 90 people and are continuing with rapid but organic growth. Each of us at ProcDNA (ProcDees) boasts about a healthy blend of learning, new opportunities, and growth, which gives a feeling of swimming in the open waters rather than confining ourselves to a single lane. We invite you to join us and be part of our growth journey. Why considers this role? If you are working in the healthcare/life-sciences consulting domain but not getting a 360-degree view of the industry this might be a good role for you. At ProcDNA, you will work as a client champion and work across various domains to get a holistic understanding of client needs, you will work directly with senior team members and get an accelerated learning path, which of course will ensure fast-paced personal and professional growth. What we are looking for: We are looking for a Team Lead \xe2\x80\x93 Technology to join our team. You are someone who has a good understanding of the pharmaceutical industry, has detailed knowledge of various datasets like LAAD, DDD, XPO, etc., enjoys working on complex data sets to help clients solve diverse real-world problems, and drive business performance, navigate risk, and develop pragmatic strategies through data-driven insights. What you\xe2\x80\x99ll do:

• To collaborate with various teams/regions in driving and facilitating data design, identifying architectural risks and key areas of improvement in the data landscape, and developing and refining data models.
• Technical experience and knowledge in Cloud Data Warehousing, data migration, and transformation- Develop and test ETL components to high data quality and performance standards.
• Hands-on development lead- Familiarity with Data Lakes, Data Warehouses, BI, Dashboards, Design data architecture patterns and ecosystems including data stores (operational systems, data lakes, data warehouses, data marts), ingress patterns (API, streaming, ETL/ELT), and egress patterns (analytics/decision tools, BI tools).
• Experience in leading and delivering data-centric projects with a concentration on Data Quality and adherence to data standards and best practices.
• Experience in data modeling, development, and testing for enterprise-wide data solutions.

Must have:

• 1.5+ years of relevant experience with Technology.
• Bachelor\xe2\x80\x99s or master\xe2\x80\x99s degree in engineering with strong academic performance.
• Ability to work on and manage multiple concurrent projects for multiple stakeholders with a quality-focused approach.
• Able to understand, identify and recommend reporting needs and improvements.
• Strong verbal, written, and collaboration skills with the ability to articulate results and issues to internal and client teams.
• Proven ability to work creatively and analytically in a problem-solving environment with minimal direction.
• Experience in data modeling, development, and testing for enterprise-wide data solutions- Azure cloud experience is a must-have with the familiarity of the services: Azure Databricks, Azure Data Factory, Azure Data Lake, Spark SQL, PySpark, SQL
• Additional exposure to AWS is good to have.
• Key Skill: Azure Databricks, ADF, ETL, Pipeline Dev, SQL, DWH, ADLS.