Data Infrastructure - Sr. Manager

Company: Horizon Therapeutics
Location: Vernon Hills
Posted on: May 14, 2022

Job Description:

Working at Horizon is more than a job - it's personal. For us, success is measured by the numbers that matter most - the number of lives we touch, the number we change and those we work tirelessly to help save. We're a team of agile, out-of-the-box thinkers who are inspired to do more because we know we're a part of something bigger. We strive to build meaningful careers at a company whose values we share because when we live up to our potential, we help others live up to theirs.

Position Summary:

The Senior Manager, Commercial Analytics, Data Infrastructure works cross-functionally to lead the Data Infrastructure team in onboarding and managing all enterprise data assets, providing best practices and coaching on ETL, data management, and data automation to the Data Infrastructure team, as well as provide guidance on application of individual or integrated data sets to key stakeholders.

Responsibilities:

• Manages and guides all Database Specialists in day-to-day operations, maintaining existing and onboarding new data assets, with a critical focus on quality assurance as well as automation
• Assesses, creates, and enforces best practices amongst team members in ETL (Extract Transform Load) processes via SQL Server's SSIS functionality, data structures, relationships, and indexing, as well as Transact-SQL coding
• Assesses, creates, and enforces best practices amongst team for the newer Azure cloud infrastructure (Data Lake, Databricks, Azure SQL)
• Overseas migration of legacy data processes to new Azure cloud platform
• Serves as a liaison between the Database Specialist and the Brand Analytics teams to ensure efficient and effective use of the data warehouse, including management, design, and implementation of a robust pre-processed Analytics Layer
• Incorporates robust data validation, cleansing, and management methodologies with team members
• Manages the documentation of processes and associated business logic
• Works cross-functionally with the CRM team and oversees the data integration between systems
• Liaisons with data and data science team for proper data onboarding and transformation into data warehouses
• Catalogs and provides ownership of all data assets currently utilized across the organization, not solely with Commercial Operations
• Maintains a critical eye on the data needs of the business, making recommendations to the business for new data sourcing or integration to help drive key insights generation
  Qualifications and Skills Required:
  
  • BA/BS required
  • 4-6+ years in the pharmaceutical industry, including experience in Analytics, Market Research and/or Sales Analytics
  • Demonstrated successful cross-functional collaboration and leadership
  • Demonstrated high proficiency in understanding data, data nuances, and application of data to pharmaceutical business needs
  • Highly proficient in all components of data management and enterprise data platforms, SQL Server and Azure SQL specifically:
    • SQL language: Transact-SQL
    • ETL technologies and processes, specifically SQL Server Integration Services and Azure Databricks
    • Tables, keys, and indices
    • Stored Procedures, Functions, Views, and Triggers
    • Azure Data Lake
    • Azure Data Factory
    • Python
    • High degree of independence and exceptional work ethic
    • Excellent written and verbal communication skills
    • Professional, proactive demeanor, and strong interpersonal skills
      Horizon Core Values & Competencies:
      
      Growth
      
      • Manages Ambiguity
      • Strategic Mindset
      • Demonstrates Self-awareness
      • Cultivates Innovation
      • Develops Talent
        
        
        Accountability
        
        • Drives Results
        • Ensures Accountability
        • Decision Quality
          
          
          Transparency
          
          • Courage
          • Collaboration
          • Instills Trust
            
            
            Horizon requires all U.S. employees to be fully vaccinated, as a condition of employment, with either Pfizer (fully approved by the U.S. Food and Drug Administration), Moderna or Johnson & Johnson (currently granted emergency-use authorization by the FDA). "Fully vaccinated" is defined as two weeks after your final dose of the Pfizer, Moderna, or Johnson & Johnson vaccine. Horizon will provide medical and religious accommodations as required by law.
            
            Horizon Therapeutics plc does not discriminate on the basis of race, color, religion, gender, sexual orientation, national origin, age, disability, veteran status, or any other characteristic protected by law. It is our intention that all qualified applications are given equal opportunity and that selection decisions be based on job-related factors. Any individual, who, because of a disability, needs accommodation or assistance in completing this application or at any time during the application process, should contact the Human Resources Department.

Keywords: Horizon Therapeutics, Arlington Heights , Data Infrastructure - Sr. Manager, Executive , Vernon Hills, Illinois