Job SummaryRecognized subject matter expert Apply advanced statistical data modeling techniques to large data sets to create actionable business insights- Use statistical analysis software packages (SAS, SPSS, etc-) and business intelligence and analytics platforms to create dashboards and reporting capabilities- Design, develop and deploy algorithms through statistical programming that: support complex business decision making, manage large amounts of data and create visualization and insights Manage major/complex large projects and coaches, review and delegate work to entry/intermediate professionAs the Principal Solutions Architect, you will be leading the global data at Avantor Sciences by utilizing the various data assets of Avantor in its quest for business transformation.
Lead data organization in building world class cloud data warehouse by partnering with Analytics and Business teams MAJOR JOB DUTIES AND RESPONSIBILITIES
- Collaborate with the Analytical team to prototype and prove the viability of data solutions
- Design of all aspects of data solutions including modeling, developing, technical documentation, data diagrams and data dictionaries
- Lead development and execution of data solutions involving domain specific analytics
- Provide expertise in the development of standards, architectural governance, design patterns, and practices, evaluate best applicable solutions for different use cases
- Work cross-functionally with product owners, business stakeholders, and management
- Direct people management and leadership experience (budget management, interview, hire, performance management, promotion, etc.
) - Suggest how to design and optimize data architecture for consumption, utilization, and analytics on the Data Warehouse
- Analyze data patterns and optimize data processing Suggest best practice, technology, and process improvements
- Comfortable with rapid prototyping and disciplined software development processes
- Realize and communicate trends related to Data technologies
- Create centralized and streamlined Datawarehouse support processes Provide effective training to team members
- Performs other duties as assigned
QUALIFICATIONS (Education/Training, Experience and Certifications)
- Bachelor's Degree in Engineering (computer science or other equivalent majors) Prefer advanced degree
- 12+ years of architecture or engineering experience in building data pipelines, ETLs, data platforms, data products, distributed data systems or AI/ML, Master Data, Data Quality, Cloud Technologies, etc.
- 12+ year of experience with SQL, shell is a plus
- 3+ plus years of job-related experience in programming languages such as Scala, Python, or similar
KNOWLEDGE SKILLS AND ABILITIES (Those necessary to perform the job competently)
- Expertise in Cloud Data technologies (Snowflake, AWS or GCP)
- Expertise in ETL tools (SAP BODS, Informatica or similar tools)
- SAP functional domain knowledge is big plus (Supply Chain, Finance etc)
- Experience in data governance, data security, data compliance etc
- Large scale projects, process and industry experience is big plus
- Strong organizational skills
- Proven team motivator who can develop talent
- Able to coach team members
- Ability to provide technical direction to data and analytics teams
- Excellent communication skills both verbal and written
ENVIRONMENTAL WORKING CONDITIONS & PHYSICAL EFFORT (Under Typical Conditions)
- Typically works in an office environment with adequate lighting and ventilation and a normal range oftemperature and noise level
- Work assignments are diversified.
Examples of past precedent are used to resolve work problems New alternatives may be developed to resolve problems - A frequent volume of work and deadlines impose strain on routine basis
- Minimal physical effort is required Work is mostly sedentary but does require walking, standing, bending, reaching, lifting, or carrying objects that typically weigh less than 10 lbs.
Additional information for internal applicants:Posting Expires:DISCLAIMER:The above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of employees assigned to this positionAvantor is proud to be an equal opportunity employerEEO Statement:We recognize the value of diverse workforce and aim to create employment opportunities such that all employees achieve their full potential and work in an environment free of discrimination and harassment We are an Equal Employment/Affirmative Action employer.
We do not discriminate in hiring on the basis of sex, gender identity, sexual orientation, race, caste, color, religious creed, ethnicity, national origin, physical or mental disability, protected Veteran status, or any other characteristic protected by central, national, provincial or local laws3rd party non-solicitation policyBy submitting candidates without having been formally assigned on and contracted for a specific job requisition by Avantor, or by failing to comply with the Avantor recruitment process, you forfeit any fee on the submitted candidates, regardless of your usual terms and conditions Avantor works with a preferred supplier list and will take the initiative to engage with recruitment agencies based on its needs and will not be accepting any form of solicitation