For the given job description <<Allergan Data Labs is on a mission to transform the Allergan Aesthetics beauty business at AbbVie, one of the largest pharmaceutical companies in the world. Our iconic brands include BOTOX Cosmetic, CoolSculpting, JUVDERM and more.

Allergan Data Labs is on a mission to transform the Allergan Aesthetics beauty business at Abbvie, one of the largest pharmaceutical companies in the world. Allergan Aesthetics brands include Botox, CoolSculpting, Juvderm and many more. The medical aesthetics business is ripe for disruption and we're building a high performing Data Science and Engineering team to do just that.

Our team has successfully launched a new and innovative technology platform, All, which serves millions of consumers, tens of thousands of aesthetics providers, and thousands of colleagues throughout the US. Since its launch in November 2020, All has delivered curated promotions, personalized experiences, and millions of consumers use it as part of their beauty journey.

We're looking for a Senior Data Engineer interested in working within a startup-oriented environment while having the backing of a very large company. If that's you, please read on.

You Will
Work with cross functional partners - Data Scientists, Engineers, Product Managers to understand and deliver data needs.Champion code quality, reusability, scalability, security and help make strategic architecture decisions with the lead engineerDesign, build and launch extremely efficient and reliable data pipelines to move data across a number of platforms including Data Warehouse, online caches and real-time systems.Build product-focused datasets and scalable, fault-tolerant pipelines.Build data quality checks, data anomaly detection, and optimize pipelines for ideal compute and storage.Develop APIs and Microservices to expose and integrate data products with software systems
Required Experience & Skills
5+ years of experience as a Data Engineer writing code to extract, ingest, process and store data within SQL, NoSQL and MPP databases like SnowflakeStrong development experience with Python (or ScalaJava)Experience with complex SQL, batch and streaming pipelines with Apache Spark framework.Knowledge of relational and dimensional data modelingExperience with data quality checks, data validation and data anomaly detection.Experience with workflow management engines like AirflowExperience with Git, CICD pipelines, Docker, KubernetesExperience with architecting solutions on AWS or similar public clouds.Experience with Microservices and Event Driven Architecture
Additional Desired Competencies
Experience with offline and online feature engineering solutions for Machine LearningPrevious domain knowledge in the digital marketingExperience with API development to expose data productsExperience with building Data and ML platforminfrastructure
Perks
Competitive salary.Competitive annual bonus targets.401k with dollar-for-dollar match, up to 6% of eligible earnings (base, bonus). Plus, additional company contribution.RSU grants (Long Term Incentives) for approved roles.Comprehensive medical, dental, vision and life insurance.17 paid holidays per year, including 3 floating holidays.Annual Paid Time Off (PTO), with separate sick daysGenerous discounts on SkinMedica skin care products.Discounted aesthetic treatment days multiple times a year.$600 worth of Alle benefits each year to use towards aesthetic treatments and products.Eligible for donation matching to over 1.5 million nonprofit organizations.
Applicable only to applicants applying to a position in any location with pay disclosure requirements under state or local law:
The compensation range described below is the range of possible base pay compensation that the Company believes in good faith it will pay for this role at the time of this posting based on the job grade for this position. Individual compensation paid within this range will depend on many factors including geographic location, and we may ultimately pay more or less than the posted range. This range may be modified in the future.We offer a comprehensive package of benefits including paid time off. (vacation, holidays, sick), medicaldentalvision insurance and 401(k) to eligible employees.This job is eligible to participate in our short-term incentive programs.This job is eligible to participate in our long-term incentive programs.
Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested and determinable. The amount and availability of any bonus, commission, incentive, benefits, or any other form of compensation and benefits that are allocable to a particular employee remains in the Company's sole and absolute discretion unless and until paid and may be modified at the Company's sole and absolute discretion, consistent with applicable law.

Compensation Range (Minimum - Maximum)

$109,500$208,000 USD

Core Values
Be Humble: You're smart yet always interested in learning from others.Work Transparently: You always deal in an honest, direct and transparent way.Take Ownership: You embrace responsibility and find joy in having the answers.Learn More: Through blog posts, newsletters, podcasts, video tutorials and meetups you regularly self educate and improve your skill set.Show Gratitude: You show appreciation and return kindness to those you work with.
Perks For Our Full Time Employees
Competitive salary.Competitive annual bonus targets.401k with dollar for dollar match, up to 6% of eligible earnings (base, bonus). Plus additional company contribution.RSU grants (Long Term Incentives) for approved roles.Comprehensive medical, dental, vision and life insurance.17 paid holidays per year, including 3 floating holidays.Annual Paid Time Off (PTO), with separate sick days12 weeks paid Parental LeaveCaregiver LeaveAdoption and Surrogacy Assistance PlanFlexible workplace accommodations.We celebrate our wins with opportunities to attend Lakers, Knicks, Anaheim Ducks, Anaheim Angels and NY Rangers games.Opportunities to attend concerts, festivals and other live entertainment events in recognition of delivering great work.Tuition reimbursement.Attend a tech or marketing conference of your choice each year.A MacBook Pro and accompanying hardware to do great work.A modern productivity toolset to get work done: Slack, Miro, Loom, Lucid, Google Docs, Atlassian and more.Generous discounts on SkinMedica skin care products.Discounted aesthetic treatment days multiple times a year.$600 worth of Alle benefits each year to use towards aesthetic treatments and products.Eligible for donation matching to over 1.5 million nonprofit organizations.Attend AWS Re:Invent in person (Las Vegas) or virtually each year (for certain roles)>> the resume: <<Summary➢ Over twelve (12) years of experience in the Automotive industry with expertise in Controls Systems, Application Development, Manufacturing Intelligence & Process Control Solutions.Proven ability to work with individual and multiple project teams.Technology experience involves Project management / Factory information systems / Hardware installation / Controls design.Efficient Electrical / Control Systems Engineer with work standards and specification based on quality, integrity, efficiency and continuous improvement.Extensive knowledge in Rockwell and Allen Bradley, Siemens, Mitsubishi software, also worked with ABB and FANUC machines and robots.Experienced with equipment and machine design and manufacturing, documentation, installation, specializing in PLC application software per specifications and standards.Capable of working in diverse cultural environments.Great team player, self-motivated and enthusiastic and customer service oriented.Very flexible and able to perform under high stress conditions.Excellent Team Motivation techniques & strong ability for team building and problem solving.Ability to work under stringent deadlines with teams as well as independently.Excellent analytical, communication, organizational and interpersonal skills.Fast grasping power and versatility to change, learn and deploy new technologies.
HighlightsIndustrial Software : RS Logix 5000, RS Logix 5, RS Logix 500,RS View Studio, Panel Builder 32, 1200, 1400e,Softlogix,  RS Linx Enterprise, Siemens, Mitsubishi, Kepware, Wonderware Solutions, Activplant, Factory Information Systems (FIS)Industrial Hardware : Allen Bradley Products, Mitsubishi, Siemens, Telemecanique, Fanuc Robots,Systems: ActivPlant, Wonderware, Rockwell products, Andon Systems, I-Gear Systems, FIS, POSMONOperating System’s: Dos/ UNIX / Windows 95, 98, NT, 2000, 2003, XP.Databases: MS SQL Server, MS Access, Oracle.Reporting Tools: Crystal Reports, MS Excel, MS Access and XML.Desktop Application: Microsoft Office, CAD,Project Management Tools: Microsoft Project, Microsoft Visio, MS PowerPoint and MS Excel.Certifications :  ITIL (Information Technology Infrastructure Library)Training : PMP (Project Management Professional Certification)
ExperienceManufacturing Electrical Engineer A,02/2012-CurrentDentsu Aegis Network–,,A Role: Project Lead / Project- Senior Control Engineer ➢ Analyze, plan and implementation for various small to moderate size project in various Industrial projects. ➢ Supervise the system development and release management processes. Supports all phases from planning and execution through project closeout work with clients to ensure that project requirements are fulfilled. ➢ Develop and manage detailed project plan, schedules, which including objectives, goals, risks, timeframe, and resource distribution. ➢ Provide guidance to team based on management direction. ➢ Familiarize the team with customer needs, specifications, design targets, the development process, design standards, techniques and tools to support task performance. ➢ Coordinate meetings with the project team and functional management to discuss project impediments, needed resources or issues/delays in completing the task. ➢ Coordinate with internal and external customers as necessary to get a clear scope and the specification of the project details. ➢ Provide the team with a vision of the project objective which will enable then to focus on the goals. ➢ Based on customer needs, discuss with the team to get project specifications, design targets, the development process, design standards, techniques and tools to support task performance, evaluate and implemented them. ➢ Initiate sub-groups or sub -teams as appropriate to resolve issues and perform tasks in parallel. ➢ Act as an focal point to communicate and resolve interface and integration issues with other teams ➢ Provide status reporting of team activities against the program plan or schedule ➢ Work with the OEMs/Customer to come up with the agenda for the project implementation. ➢ Design, develop and implemented many custom applications using various Industrial softwares. ➢ Conduct training classes on the custom application developed as per client's requirements.Project Lead,04/2007-02/2012Dentsu Aegis Network–San Francisco,CA,Role: Project Lead / Project- Senior Control Engineer ➢Analyze, plan and implementation for various small to moderate size project in various Industrial projects.Supervise the system development and release management processes. Supports all phases from planning and execution through project closeout work with clients to ensure that project requirements are fulfilled.Develop and manage detailed project plan, schedules, which including objectives, goals, risks, timeframe, and resource distribution.Provide guidance to team based on management direction.Familiarize the team with customer needs, specifications, design targets, the development process, design standards, techniques and tools to support task performance.Coordinate meetings with the project team and functional management to discuss project impediments, needed resources or issues/delays in completing the task.Coordinate with internal and external customers as necessary to get a clear scope and the specification of the project details.Provide the team with a vision of the project objective which will enable then to focus on the goals.Based on customer needs, discuss with the team to get project specifications, design targets, the development process, design standards, techniques and tools to support task performance, evaluate and implemented them.Initiate sub-groups or sub –teams as appropriate to resolve issues and perform tasks in parallel.Act as an focal point to communicate and resolve interface and integration issues with other teamsProvide status reporting of team activities against the program plan or scheduleWork with the OEMs/Customer to come up with the agenda for the project implementation.Design, develop and implemented many custom applications using various Industrial softwares.Conduct training classes on the custom application developed as per client's requirements.Project Lead,06/2006-04/2007Technico–,,Role: Project Lead / Senior Control Engineer ➢ Supervise the system development and release management processes. Supports all phases from planning and execution through project closeout work with clients to ensure that project requirements are fulfilled. ➢ Conducts various procedures to validate and ensure the implemented Industrial software. ➢ Extensive experience and knowledge in various controls technologies, which include Rockwell application, PLC programming software, Wonderware, Activplant, Computer Architectures and Operating Systems. ➢ Design, develop and implemented many custom applications in various Panel Builder softwares. ➢ To analyze the scope of the project and work with the OEMs/Customer to come up with the agenda for the project implementation. ➢ Working with internal and external customers as necessary to understand the scope of the project. ➢ Facilitate problem solving and collaboration. ➢ Install, configure and implement VisualPlant, OPC servers and all project related services and softwares ➢ Recommend / configure application security and database security. ➢ Configure VisualPlant Server / Collector / Terminal. ➢ Recommend / configure Disaster Recovery models including SQL server backup / restore procedures. ➢ Evaluate network requirements and test performance. ➢ Plan and implement appropriate Disaster recovery models, implement and test them. ➢ Created Custom Layouts / Production Views / Detailed views / Reports with charts. ➢ Programmed ActivPlant data to be transferred automatically to ERP systems and back. ➢ Created monitoring / archival and cleanup utilities in various applications as required in the project scope. ➢ Co-ordinate PLC programmers to help program the PLC Ladder programs to facilitate our implementation ➢ Provide Training as required by the project. ➢ Trained users and system administrators of the software.Controls/Implementation Professional,10/2003-06/2006WelcomeIT.net, LLC–,,Role: Control Engineer / Programmer Analyst ➢ Design, develop and implemented many custom applications in RS View, Versa View, Wonderware, Panel Builder 32. ➢ Analyzed and implemented custom ladder logic program for various Factory Information Systems. ➢ Work closely with the OEM developers to meet the standard to implement various applications. ➢ Install, configure and implement VisualPlant (and service updates) - all versions since VP 3.2 SP1. ➢ Install and configure OPC servers including but not limited to creating items / topics. ➢ Recommend / configure application security and database security. ➢ Configure VisualPlant Server / Collector / Terminal. ➢ Programmed ActivPlant data to be transferred automatically to ERP systems and back. ➢ Created monitoring / archival and cleanup utilities in ActivPlant. ➢ Recommend / configure Disaster Recovery models including SQL server backup / restore procedures. ➢ Recommend, suggest and create database(s) models with necessary size for database and transaction logs. ➢ Plan and implement appropriate Disaster recovery models, implement and test them. ➢ Create and modify stored procedures for custom programming requests. ➢ Created Custom Layouts / Production Views / Detailed views / Reports with charts. ➢ Programmed ActivPlant data to be transferred automatically to ERP systems and back. ➢ Created monitoring / archival and cleanup utilities in ActivPlant. ➢ Co-ordinate PLC programmers to help program the ActivPlant Block's in the PLC Ladder programs. ➢ Provide ActivPlant Training. ➢ Recommend, present and deploy software solutions related to client requirements. ➢ Installation of SQL Server 7.0 / SQL Server 2000. ➢ Responsible for converting old data and migrating / converting it to the new system. ➢ Evaluate network requirements and test performance. ➢ Work with timelines and deadlines
EducationMaster of Science:Electrical & Computer Engineering,Expected in-Wayne State University-Detroit,MichiganGPA:Status-Master of Science in Electrical & Computer Engineering 09/2000-12/2002 Wayne State University, Detroit, MichiganBachelor of Engineering:Electrical & Electronics Engineering,Expected in-University of Madras-Madras,GPA:Status-Bachelor of Engineering in Electrical & Electronics Engineering 08/1996-05/2000 University of Madras, Madras, IndiaProfessional Diploma:Software Technology and Systems Management,Expected in-National Institute of Information Technology-Plymouth,MichiganGPA:Status-Professional Diploma in Software Technology and Systems Management	08/1997-05/2000 National Institute of Information Technology, Madras, India CLIENT EXPOSURE US: Tower Automotive GKN Sinter Metals McLean Vehicle Systems Hayes Lemmerz International City of Wyoming (Water Plant) TRW Automotive FCA (FIAT Chrysler Automobiles)	Ford Motor Company Visteon INDIA: IGCAR Lucas TVS CLIENT PROJECT SUMMARY ➢ Chrysler: Andon, FIS, ActivPlant ITM Powertrain Implementation for Detroit Axle Plant, GEMA Engine Plant. ➢ Ford: FIS implementation at Dearborn Truck Plant, Chicago Assembly Plant & Kansas Truck Plant ➢ Tower Automotive: ActivPlant and Controls Implementation at Plymouth, Michigan and Murfreesboro, TN ➢ Hayes Lemmerz International: Controls implementation for Recipe Management and ActivPlant at Gainesville, GA and Indiana facilities. ➢ TRW Automotive: Controls and TPA(Throughput Analyzer) for all the lines for process and performance enhancements.
SkillsEngineer, Training, Clients, System Development, Industrial Projects, Integration, Integrator, Project Plan, Electronics Engineering, Database, Disaster Recovery, Employee Resource Group, Enterprise Resource Planning, Erp, Ms Sql Server, Opc, Panel Builder, Security, Sql, Sql Server, Wonderware, Electrical Engineer, Mechanical/electrical Engineer, Analyzer, Assembly, Assembly Plant, Automotive, Axle, Chrysler, Engine Plant, Fca, Powertrain, Systems Management, Ladder Logic, Oem, Solutions, Sql Server 2000, Stored Procedures, Allen-bradley, Plc Programming, Problem Solving, Abb, Access, Allen Bradley, Application Development, Application Software, Automotive Industry, C++, Continuous Improvement, Control Systems, Controls Systems, Crystal Reports, Customer Service, Customer Service Oriented, Databases, Documentation, Dos, Excel, Fanuc, Hardware Installation, Information Technology Infrastructure Library, Itil, Machine Design, Machine Design/fabrication, Microsoft Project, Microsoft Visio, Microsoft Windows, Ms Access, Ms Excel, Ms Powerpoint, Networking, Oracle, Pmp, Powerpoint, Process Control, Project Management, Receptionist, Reporting Tools, Retail Sales, Rs Logix, Siemens, Systems Engineer, Team Building, Team Player, Technology Infrastructure, Telemecanique, Ug Designer, Unix, Visio, Visual Basic, Windows 95, Xml>>. The result is, 

Fit assessment: No Fit