Data Architect III

GENERAL PURPOSE OF THE JOB:   

We are seeking an experienced and skilled Data Architect to join our team! Our ideal candidate thrives in a collaborative environment, is a self-starter, and is passionate about data architecture in modern cloud platforms. As part of our data team, you will play a pivotal role in designing and overseeing the transition of our data infrastructure to an Azure Data Lake and Databricks environment.

This role involves designing, developing, and maintaining scalable cloud-based data solutions, including data models, ELT pipelines, and analytics workflows. The Data Architect will work closely with data engineers, data scientists, analysts, and stakeholders to ensure data is efficiently processed, stored, and analyzed for business insights.

This is an exciting opportunity to be at the forefront of a modern cloud data transformation while also maintaining critical business operations in legacy systems. If you have a passion for Azure Databricks, Azure Data Lakehouses, and cloud-based solutions, we’d love to hear from you!

ESSENTIAL DUTIES AND RESPONSIBILITIES: 

• Design and oversee the implementation of scalable data architectures using Azure Data Lake, Azure Databricks, and related technologies.
• Develop and maintain comprehensive data models that support analytics, machine learning, and reporting needs.
• Optimize data processing, storage, and retrieval for high performance and cost efficiency in the cloud.
• Support and guide the transition from legacy data platforms, including SAP BW and SQL Data Warehouse, to modern cloud-based solutions.
• Work with unstructured and structured data, transforming it for analytical use.
• Develop API-based data access solutions to enable real-time data consumption across the organization.
• Continuously monitor and optimize data infrastructure, pipelines, and performance.
• Collaborate with data engineers, data scientists, analysts, and business stakeholders to understand and implement data requirements.
• Stay up to date with Azure Data Engineering advancements and recommend new tools and processes.

EDUCATION: 

Bachelor's or Master’s degree in Information Technology, Computer Science, or a related field.

EXPERIENCE:

• 3+ years of experience in data architecture, data engineering, or related roles.
• Hands-on experience with Azure Data Lake, Azure Databricks, Delta Lake, and PySpark.
• Strong SQL programming skills and experience with relational and NoSQL databases.
• Experience developing and optimizing ELT pipelines using Apache Spark, Python, or Scala.
• Familiarity with SAP BW and SQL Data Warehousing concepts (preferred but not required).
• Knowledge of CI/CD practices for data engineering workflows.

CERTIFICATES, LICENSES, REGISTRATIONS:       

• Microsoft Certified: Azure Solutions Architect Expert
• Databricks Lakehouse Fundamentals Certification
• Certified SQL, Advanced Queries
• Python for Data Science & Machine Learning

OTHER SKILLS AND ABILITIES:

• Proficiency in Python, SQL, and PySpark.
• Strong understanding of data warehousing and data lakehouse architectures.
• Hands-on experience with Azure Synapse, Power BI, or other analytics platforms.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Ability to work independently in a fast-paced environment.

Qualified applicants will receive consideration for employment without regard to their race, color, religion, national origin, sex, sexual orientation, gender identity, protected veteran status or disability.

Tremco Construction Products Group is the industry’s only provider of comprehensive systems and services for all six sides of the building enclosure. Whether new construction or restoration, commercial, residential, in-field or in-plant – structures with CPG systems are easier to build and maintain, virtually impervious to the elements, and can provide any look desired. For restoration and renovation of existing structures, Tremco CPG’s six-sided solutions deliver demonstrable performance at the lowest possible life-cycle costs, and ensure peace of mind through long-term warranties and maintenance programs.

Tremco CPG represents the combined power of Dryvit Systems, Nudura Inc., Willseal and Tremco Incorporated’s Commercial Sealants & Waterproofing, Roofing & Building Maintenance, along with affiliates Weatherproofing Technologies (WTI) and Weatherproofing Technologies Canada.