Data Architect & Modeler

At Air Products, our purpose is to bring people together to reimagine what’s possible, collaborate and innovate solutions to the world’s most significant energy and environmental sustainability challenges. Grow with us as we embark on building tomorrow together by being the safest, most diverse and most profitable industrial gas company in the world.  

Reimagine What’s Possible 

Job Overview:

In the capacity of Senior Data Architect & Modeler, you will be responsible for the overall data architecture design and management needed for the reporting, decision making, and data presentation of the organization. You will be required to combine data from several sources such as SAP, SharePoint, Lists, and APIs and work with business users for their requirements. Also, you will use your experience to build strong and scalable databases to meet the needs of the organization and ensure analytics and reporting can be conducted appropriately.

Key Responsibilities:

• Database Architecture and Modeling along with developing ETL Pipelines for seamless data integration
• Implement and design scalable and secured data architectures tailored to the specified organizational requirements.
• Support business strategies by developing and maintaining data models such as conceptual, logical, and physical.
• Keep databases in best practices by ensuring they satisfy the set performance standards.
• Facilitate data model development by liaising with stakeholders that outline and interpret data requirements.

SQL & Power BI Server Management

• Configure, install and maintain SQL server databases to ensure high performance that is both reliable and available at all times.
• Design, optimize, test and develop advanced SQL procedures like triggers, schedule procedures and complex queries.
• Oversee and implement strategies necessary for data backup and recovery in case of a disaster.
• Ensure all databases are tuned and performant meaning that all queries execute as expected.

• Technical Skills:

  
  
• Advanced knowledge of PowerApps, Power Automate, SQL Server, Power BI
• Proficiency in languages such as Python & SQL
• Familiarity with data warehousing and data mining techniques.
• Must be familiar with API connectivity

•  Nice To have:

  
  
• Data Analytics concepts
• Power BI Dashboard creations
• Machine Learning & predictive algorithms.

We are the world’s largest hydrogen producer with over 80 years of industrial gas experience. We are hydrogen and industrial gas experts delivering safe, end-to-end solutions, investing in real, clean energy projects at scale, and driving the industry forward to generate a cleaner future. 

At Air Products, we work in an environment where we put safety first, diversity is essential, inclusion is our culture, and each person knows they belong and matter. To learn more, visit About Air Products.