Consultant (Data Architect)

People are at the heart of our success so we have defined our CARE values framework with a lot of effort and we use it as our guiding light in everything we do. We CARE!

Customer-Centric: Client success is our success. Prioritize customer needs and outcomes in every action.

Adaptive: Agile and Innovative with a growth mindset. Pursue bold and disruptive avenues that push the boundaries of possibilities.

Respect: Deep respect for our clients & colleagues. Foster a culture of collaboration and act with honesty transparency and ethical responsibility.

Execution: Laser focused on quality-led execution; we deliver! Strive for the highest quality in our services solutions and customer experiences.

About the Role:

Introduction: We are seeking an experienced and highly skilled Data Architect to lead a strategic project focused on Pharma Commercial Data Management Operations. This role demands a professional with 7-9 years of experience in data architecture 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 driving commercial data management projects. If youre passionate about leading impactful data initiatives optimizing data workflows and supporting the pharmaceutical industrys data needs we invite you to apply.

Key Responsibilities:

1. Lead Data Architecture and Strategy:
• Design develop and implement the overall data architecture for commercial data management operations within the pharmaceutical business.
• Lead the design and operations of scalable and secure data systems that meet the specific needs of the pharma commercial team including marketing sales and operations.
• 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.
2. Data Integration ETL & Transformation:
• Oversee the ETL (Extract Transform Load) 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.
3. Data Governance & Quality Assurance:
• Implement 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.
4. 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.
5. 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.
6. 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.
7. 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.
• 5-8 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 integration ETL and data transformation processes including familiarity with tools like Informatica Talend or Apache NiFi.
• Strong expertise with cloud platforms particularly Snowflake AWS Azure or Google Cloud.
• 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.
• Knowledge of Agile methodologies for managing data projects.

Key Skills:

• Data Architecture & Design
• Cloud Platforms (Snowflake critical to have)
• Data Governance & Quality Assurance
• ETL & Data Transformation
• Data Integration & Pipelines
• 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.