Associate- BIM

As a driven business analyst in the area of pharma/life sciences, your role will involve working on complex Analytical problems to support better business decision making. You will be responsible for the following key tasks: - Write Pyspark queries for data transformation needs. - Participate in ETL Design using any python framework for new or changing mappings and workflows, and prepare technical specifications. - Write complex SQL queries with a focus on performance tuning and optimization. - Demonstrate the ability to handle tasks independently and lead the team when necessary. - Coordinate with cross-functional teams to ensure project objectives are met. - Collaborate with data architects and engineers to design and implement data models. For this role, the qualifications required include: - BE/B.Tech or Master of Computer Application degree. - Advanced knowledge of PySpark, python, pandas, numpy frameworks. - Minimum 4 years of extensive experience in design, build, and deployment of Spark/Pyspark for data integration. - Deep experience in developing data processing tasks using PySpark, such as reading data from external sources, merging data, performing data enrichment, and loading into target data destinations. - Create Spark jobs for data transformation and aggregation. - Spark query tuning and performance optimization, with a good understanding of different file formats (ORC, Parquet, AVRO) to optimize queries/processing and compression techniques. - Deep understanding of distributed systems (e.g., CAP theorem, partitioning, replication, consistency, and consensus). - Experience in Modular Programming & Robust programming methodologies. - ETL knowledge and experience in ETL development using any python framework. - Preference for experience working with Databricks/Snowflake in the past. In addition to the technical competencies required for the role, key behavioral competencies sought after include Ownership, Teamwork & Leadership, Cultural Fit, Motivation to Learn and Grow. This position also values problem-solving skills, life science knowledge, and effective communication.,