Today, Lonza is a global leader in life sciences operating across three continents. While we work in science, theres no magic formula to how we do it. Our greatest scientific solution is talented people working together, devising ideas that help businesses to help people. In exchange, we let our people own their careers. Their ideas, big and small, genuinely improve the world. And thats the kind of work we want to be part of.

The Sr. Data Architect is primarily responsible for leading the design, development, implementation and continuous improvement of various analytics repositories for use in Business Intelligence applications and/or other applications. This includes data lakes, data warehouses and virtual databases, etc. This role has the challenging and rewarding opportunity to play a key role in helping to lay foundation for and shape the direction of analytics for the Business Analytics Program and Lonza as a whole.

Responsibilities

Lead the design, development, implementation and continuous improvement of end-to-end data integration solutions, which are scalable, dynamic and stable.
Collaborate with, lead and influence developers, analysts and business stakeholders to design, develop, maintain and enhance analytics solutions.
Design and develop automated dashboards, reports and visualizations utilizing BI applications, such as Looker and/or PowerBI.
Apply and advocate for industry best practice in data movement, data quality, data cleansing and other data integration activities to ensure continuous improvement, scalability and reusability.

Requirements

Minimum five years of professional experience in data analytics, data integration or related discipline.
Minimum Bachelors degree in Information Systems, Analytics or related discipline. Masters preferred.
Database Management and Data Integration development experience, including at least 5 years of experience as a Data Engineer, or similar, working with Data Integration technologies.
Experience with Master Data Management, ETL, Data Quality, Data Profiling, Streaming Data, and Change Data Capture (CDC).
Experience and detailed knowledge of OLTP, SQL, and working with large relational or multi-dimensional data sets.
Experience with design methods and tools used for the transformation of operational data with JSON and Web Services (REST, SOAP) based delivery.
Experience with Data Governance, Data Ownership and Data Security.
Experience developing automated reporting and dashboarding solutions utilizing Business Intelligence applications, such as Looker or PowerBI.
Key Technologies: Microsoft SQL Server, Adeptia ETL, Looker Business Intelligence, Power BI, Denodo Data Virtualization, Microsoft Azure (or similar technologies)

Preferred

GMP Manufacturing and/or Biotech experience (or similar regulated environment)
Business Intelligence Platforms: Looker, Power BI (or similar)
Active Directory (SAML,LDAP), Linux and Windows Server Management
Data Virtualization: Denodo (or similar)
Microsoft Cloud: Azure Data Factory, Azure Synapse and/or Azure DataLake Storage
Visual Studio (ASP.net, VB.net, C#)
Java, XML and/or HTML.
Project Management Skills: PMP or Similar
Familiarity with basic Statistics and Mathematics.
Lean Six Sigma Knowledge or Certification

Every day, Lonzas products and services have a positive impact on millions of people. For us, this is not only a great privilege, but also a great responsibility. How we achieve our business results is just as important as the achievements themselves. At Lonza, we respect and protect our people and our environment. Any success we achieve is no success at all if not achieved ethically.

People come to Lonza for the challenge and creativity of solving complex problems and developing new ideas in life sciences. In return, we offer the satisfaction that comes with improving lives all around the world. The satisfaction that comes with making a meaningful difference.

Lonza is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a qualified individual with disability, protected veteran status, or any other characteristic protected by law.