Manager - BIM

Job Description

Technology Leadership

- Independently he/she should be able to design, implement, and deliver complex Data Warehousing/Data Lake, Cloud Data Management, and Data Integration project assignments.

Technical Design and Development Expertise

- Any of the ETL tools (Informatica, IICS, Matillion, Data Stage), and hosting technologies like the AWS stack (Redshift, EC2) is mandatory.
- Any of the BI tools among Tableau, Qlik, Power BI, and MSTR.
- Informatica MDM, Customer Data Management.
- Expert knowledge of SQL with the capability to performance tune complex SQL queries in tradition and distributed RDBMS systems is a must.
- Experience across Python, PySpark, and Unix/Linux Shell Scripting.

Project Management

- Is a must to have.
- Should be able to create simple to complex project plans in Microsoft Project Plan and think in advance about potential risks and mitigation plans as per project plan.

Task Management

- Should be able to onboard the team on the project plan and delegate tasks to accomplish milestones as per plan.
- Should be comfortable in discussing and prioritizing work items with team members in an onshore-offshore model.

Client Relationship

- Manage client communication and client expectations independently or with support of reporting manager.
- Should be able to deliver results back to the Client as per plan.

Education

- Bachelor Equivalent - Other
- PG Diploma in Management

Work Experience

We are hiring for the following roles across Data management tech stacks:

- ETL-Snowflake/AWS/IICS:
- 5-8 years of experience in ETL tools - IICS, Redshift, Snowflake.
- Strong experience in AWS/Snowflake technologies - Redshift / Synapse/ Snowflake.
- Experienced in running an end-to-end ETL project and interacting with users globally.
- Has good knowledge of DW architectural principles and ETL mapping, transformation, workflow designing, batch script development.
- Python/PySpark:
- Expert in Python and should be able to efficiently use Python data-science and math packages such as NumPy, Pandas, and Scikit-learn/ Python web framework.
- Deep experience in developing data processing tasks using pySpark such as reading data from external sources, merge data, perform data enrichment and load into target data destinations.
- Prior experience with Redshift / Synapse / Snowflake.
- AWS Infra Architect:
- 10-15 years of experience as an AWS Cloud Infrastructure administrator role, AWS Cloud Architect, or Solution Architect.
- 2-3 years of experience as AWS Cloud Architect.
- Hands-on experience in debugging AWS services like EC2, EMR, S3, Redshift, Lambda etc.
- Hands-on experience in container orchestration tools like ECS / EKS.
- Hands-on experience in creating infrastructure using IaC like Cloudformation/Terraform.
- Data Modeler:
- 8+ years of experience in commercial Data modeling, data entity defining for developing business insights for life sciences organization.
- Prior experience in client management and have worked across a variety of projects from data engineering to data operations, to help improve and run clients entire system of business processes and operations, implementing cutting-edge automation technologies.
- Azure ADF:
- 5+ years of relevant experience in delivering customer-focused information management solution(s) across Data Lakes, Enterprise Data Warehouses and Enterprise Data Integration projects primarily in MS Azure cloud using Data Factory and Databricks.
- Snowflake Architect:
- 10+ years overall EDW (ETL, BI projects) /Cloud Architecture experience, software development experience using object-oriented languages.
- Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel, and understand how to use these features.
- Business Analyst - Patient Specialty Services:
- 8-10 years of extensive experience in working on Patient level datasets.
- Have a fair understanding of Patient data processing within the HIPAA environment, such as Patient data aggregation, tokenization, etc.
- MDM - Informatica/Reltio:
- 5-8 years of experience should have hands-on experience working on MDM Projects.
- Hands-on experience in industry data quality tools like Informatica IDQ, and IBM Data Quality.