Solution/Data Architect

About the Role:

 Introduction: We are seeking an experienced and highly skilled Solution Architect to lead strategic projects focused on Pharma Commercial Data Eco-Systems. This role demands a professional with 10+ years of experience in data architecture (structured and unstructured), data management, ETL, data transformation, and governance, with an emphasis on providing scalable and secure data solutions for the pharmaceutical sector.

 The ideal candidate will bring a deep understanding of data architecture principles, experience with cloud platforms such as Snowflake, and a solid background in building data warehouses, and data lakes. If you're passionate about leading impactful data initiatives, optimizing data workflows, and supporting the pharmaceutical industry's data needs, we invite you to apply. Immediate Joiners are preferred.

Key Responsibilities:

1. 
   
2. Lead Data Architecture and Strategy:

• Design, develop, and implement Data Platforms.
• Define and implement best practices for data architecture, ensuring alignment with business goals and technical requirements.
• Develop a strategic data roadmap for efficient data management and integration across multiple platforms and systems.
• Collaborate with Project/Program Managers in refining project estimates and own solution architecture in pre-sales and during delivery.
• Be a trusted advisor to stakeholders within Improzo and with clients.

Data Integration, ETL, ELT & Transformation:

• Design the best ETL (Extract, Transform, Load) or ELT processes to ensure seamless integration and transformation of data from multiple sources, including commercial, sales, marketing, and regulatory databases.
• Collaborate with data engineers and developers to design efficient and automated data pipelines for processing large volumes of data.
• Lead efforts to optimize data workflows and improve data transformation processes to enhance reporting and analytics capabilities.

Data Governance & Quality Assurance:

• Collate, and enforce data governance standards across the data management ecosystem, ensuring the consistency, accuracy, and integrity of commercial data.
• Develop and maintain policies for data stewardship, data security, and compliance with industry regulations, such as HIPAA, GDPR, and other pharma-specific compliance requirements.
• Work closely with business stakeholders to ensure the proper definition of master data and reference data standards.

Cloud Platform Expertise (Snowflake (critical to have), AWS, Azure):

• Lead the adoption and utilization of cloud-based data platforms, particularly Snowflake, to support data warehousing, analytics, and business intelligence needs.
• Collaborate with cloud infrastructure teams to ensure efficient management of data storage, compute resources, and performance optimization within cloud environments.
• Stay up-to-date with the latest cloud technologies, such as Snowflake, AWS, Azure, or Google Cloud (optional)), and evaluate opportunities for incorporating them into data architectures.

Collaboration with Cross-functional Teams:

• Work closely with business leaders in commercial operations, analytics, and IT teams to understand their data needs and provide strategic data solutions that enhance business operations.
• Collaborate with data scientists, analysts, and business intelligence teams to ensure data is available for reporting, analysis, and decision-making.
• Facilitate communication between IT, business stakeholders, and external vendors to ensure data architecture solutions align with business requirements.

Continuous Improvement & Innovation:

• Drive continuous improvement efforts to optimize data pipelines, data storage, and analytics workflows.
• Identify opportunities to improve data quality, streamline processes, and enhance the efficiency of data management operations.
• Advocate for the adoption of new data management technologies, tools, and methodologies to improve data processing, security, and integration.

Leadership and Mentorship:

• Lead and mentor a team of data engineers, analysts, and other technical resources, fostering a collaborative and innovative work environment.
• Provide leadership in setting clear goals, performance metrics, and expectations for the team.
• Offer guidance on data architecture best practices, ensuring all team members are aligned with the organization's data strategy.

Required Qualifications:

• Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.
• 10+ years of experience in data architecture, data management, and data governance, with a proven track record of leading commercial data management operations projects.
• Extensive experience in data architecture, data integration, ETL/ELT, and data transformation processes, using traditional as well as Self-Serve tools.
• Strong expertise with cloud platforms, particularly Snowflake, AWS, Azure.
• Strong knowledge of data governance frameworks, including data security, privacy regulations, and compliance standards in the pharmaceutical industry (e.g., HIPAA, GDPR).
• Hands-on experience in designing scalable and efficient data architecture solutions to support business intelligence, analytics, and reporting needs.
• Proficient in SQL and other query languages, with a solid understanding of database management and optimization techniques.
• Ability to communicate technical concepts effectively to non-technical stakeholders and align data strategies with business goals.

Preferred Qualifications:

• Experience in the pharmaceutical or life sciences sector, particularly in commercial data management, sales, marketing, or operations.
• Certification or formal training in cloud platforms (e.g., Snowflake, AWS, Azure) or data management frameworks.
• Familiarity with data science methodologies, machine learning, and advanced analytics tools.

Key Skills:

• Data Architecture & Design
• Cloud Platforms (Snowflake – critical to have)
• Data Governance & Quality Assurance
• ETL, ELT, & Custom Data Transformation
• Data Integration & Pipelines, Monitoring
• Pharmaceutical Data Management (Preferred)
• SQL & Database Optimization
• Leadership & Mentorship
• Business & Technical Collaboration

 Benefits:

• Competitive salary and benefits package.
• Opportunity to work on cutting-edge tech projects, transforming the life sciences industry
• Collaborative and supportive work environment.
• Opportunities for professional development and growth.

---