• Commercial IT Principal Data Analyst

    Insight Global (Mount Pleasant, NY)


    Job Description

    Insight Global is looking for a Marketing Data Specialist who will sit 3 days/ week in Sleepy Hollow NY and 2 days remote for a large pharmaceutical client. This role will be joining the Commercial IT team and the underlying data infrastructure. This role is focused on ensuring that high-quality, governed data (including customer, promotional and HCP engagement information) is readily available, accurately managed, and structured for advanced analytical modeling. The specialist will help maintain data governance, data pipeline health, and learn to apply the stringent privacy requirements of pharmaceutical marketing (e.g., HIPAA, CCPA) on the job . 80% of this role will be Data Enablement and Pipeline Health. This means that the specialist will contribute to core data functionality, starting with Data Preparation & Feature Engineering where they will collaborate with Data Scientists to identify, extract, and transform raw marketing (from multiple sources and formats) data into high-value features for analytical models and segmentation strategies. They will be responsible for Data Quality & Governance and they will assist in developing and maintaining automated data quality checks, reconciliation processes, and audit trails for all critical marketing data sources (e.g., Veeva, Claims, email, web, owned and 3rd party Digital Engagement). They will do this to be helping to flag and resolve data inconsistencies. They will be responsible for pipeline management where they will support the operation and troubleshooting of data ingestion, processing, and consumption pipelines within the Cloud Data Platform (e.g., Snowflake, Azure, GCP, Salesforce), utilizing SQL, Python, and ETL/ELT tools. Lastly, they will do data documentation which requires contributing to comprehensive and up-to-date documentation, including metadata, data dictionaries, and data lineage maps, for all data assets consumed by the team.The other 20% of the role will be Cross-Functional Orchestration & Compliance. This role will be the technical bridge and liaison across the organization and with external partners. Cross-Functional Alignment requires the specialist to partner with Marketing/Brand teams, omnichannel teams, Insights & analytics, Commercial IT, and IT Infrastructure to understand business needs, translate requirements into technical specifications, and ensure end-to-end data integrity. Critically, the specialist will support the day-to-day data and technical work with their 3rd party. This includes ensuring accurate requirements capture, rigorous documentation within the Alation data catalog, and verifying their deliverables meet quality standards and align with internal architecture. In terms of Privacy & Compliance, the specialist will learn and apply standards to ensure all data handling, storage, and processing practices adhere strictly to internal compliance policies and external regulations (e.g., de-identification, access controls). Lastly, for System Integration Support, they will assist with the integration of new marketing technology products (like Salesforce Marketing Cloud or CDP/Data Cloud) by verifying data flows and ensuring proper structure for downstream analytics. Pay is around 70/hr

     

    We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

     

    Skills and Requirements

     

    -10+ years’ experience as a Commercial IT Principal Data Analyst

     

    -5+ years of recent SQL experience writing SQL queries for data extraction and manipulation ideally within snowflake

     

    -Strong recent experience programming with Python or R for data analysis and scripting work

    -Recent direct, hands-on experience supporting data pipelines and governance

    -Expert in one of the following platforms (e.g., Salesforce Data Cloud, Dataiku, Databricks, and Snowflake),

     

    Strong understanding of Data Warehousing concepts, ETL/ELT methodologies, and dimensional modeling

     

    -Some pharma background/ knowledge