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 youre passionate about leading impactful data initiatives optimizing data workflows and supporting the pharmaceutical industrys data needs we invite you to apply. Immediate Joiners are preferred.
Key Responsibilities:
- 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.
integration,snowflake,databricks,sql & database optimization,business & technical collaboration,cloud platforms (snowflake),leadership & mentorship,management,analytics,data architecture,data architecture & design,data integration & pipelines,cloud,etl, elt, & custom data transformation,data governance & quality assurance