Hajoca Career Banner 1000x200

Cloud Data Architect

2001 Joshua Rd, Lafayette Hill, PA 19444, USA Req #1154
Wednesday, June 16, 2021
Since 1858, Hajoca has been blending the strengths and clout of a large company with freedom and opportunity for employees. The company will continue to grow and prosper because our fundamental business philosophy works: emphasis on entrepreneurial spirit, expert knowledge, strong incentives for our employees, and devotion to Hajoca’s proven business principles of “Service, Integrity, Reliability."

With over 450 locations nationwide serving customers in 50 states, Hajoca is the largest privately owned wholesale distributor in the plumbing industry. We balance the resources of a large company with the opportunities and agility of a small one. Fundamental to the heart of our family of businesses is a National Support Center where Centers of Excellence work to make our operations run seamlessly across our independent profit centers, each providing unparalleled service and integrity to residential, commercial, and industrial customers. 

Our Technology team is at the forefront of keeping our business on the front edge of the future of supply chain and distribution. We have a technology roadmap that will transform our business and we are growing our team to lead this effort.

Job Summary

Hajoca Corp is interested in hiring a Cloud Data Architect who is passionate about data, cloud data services, and governance. You will work hand-in-hand with the application and infrastructure teams to surface a vision of data services and governance. You will be responsible for architecting end to end data solutions including data collection and storage, data modeling, and data consumption with Azure based data warehouse and analytic tools. You will recommend cloud architecture and database structures based on the storage and data retrieval needs within the company.

Job Duties

  • Responsible for attaining in depth knowledge of source system data and gathering data requirements needed for new reporting and analytic applications.
  • Determines database structural requirements by analyzing client operations, applications, and programming and evaluating current systems.
  • Develops database solutions by designing proposed system, defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
  • Participate in the analysis and design of enterprise data warehouse and/or databases by applying current data warehouse methodologies and data modeling techniques.
  • Owns and makes contributions in architecting, designing and planning BI / AI solutions, configuring services, aggregating data from multiple sources into a data repository.
  • Design conceptual and logical data models and flowcharts including source-to-target mappings, transforms, and data lineage.
  • Design, develop, optimize, maintain and support ETL/ELT processes using Microsoft data integration cloud tools.
  • Able to clearly evaluate, articulate, and illustrate designs that further the understanding of data storage and retrieval architectures.
  • Responsible for assisting in developing, planning, and organizing procedures and testing scenarios to ensure the integrity of data integration processes and validation of job outputs. Seeks to innovate and optimize the existing system whenever possible.
  • Work with business users for continuous improvement of existing reporting and analytics to drive effective business improvement.
  • Provide end-user support, including direct interaction with users, service desk support, and development of documentation, job aids and training guides.
  • Provides oversight and coaching to team members. 

Education, Training, Experience


  • Bachelor’s Degree in Information Technology or related field.
  • 2-5+ years' experience in a data analysis or management role
  • Strong knowledge of database, storage, collection and aggregation models, techniques, and technologies and how to apply them in business.
  • Experience with database modeling, design, and implementation especially for data lakes / data marts / data warehouses
  • Experience working in a Microsoft data cloud technology environment.
    • Azure Data Factory
    • Azure Data Lake
    • Azure Synapse Analytics
  • Experience building /Operating high available, distributed systems of data extraction, ingestion, and processing large data sets.
  • Experience working with high volume data exchange and integrating large structured and unstructured data in multiple formats, character sets, and delivery methods.
  • Experience with cloud architecture, Microsoft SQL Server, and complex data structures.
  • Experience working with a relational database using SQL (MS SQL preferred).
  • Solid verbal, written, and presentation communications skills.
  • Team player who is passionate about data architecting and wants to evangelize the knowledge and its application across IT.
  • This is not a remote position.    

The benefits of working with us:
Although Hajoca is a large company, we work in a decentralized environment where each of our locations, called Profit Centers, is run by the Profit Center Manager as if it was their own small business. We give you the tools you need to succeed, investing in your personal and professional growth through targeted training programs, and reward team success through our profit-sharing opportunities and generous benefits package which includes: 

  • Medical, dental, vision, and prescription coverage 
  • 401 (k) and retirement cash account 
  • Life insurance 
  • Pre-tax accounts for healthcare and dependent care 
  • Paid vacation, holidays, and sick time

Hajoca Corporation is an Equal Opportunity/Affirmative Action Employer (Equal Opportunity Employer/Veterans/Disabled). 

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity/expression, national origin, age, veteran status, disability, or any other protected category pursuant to federal, state or local laws and will not be discriminated against on the basis of any such categories/status. Hajoca values diversity, equity and inclusion and this policy applies to all employment practices at Hajoca.  Hajoca is committed to providing reasonable accommodations for qualified individuals with disabilities including, but not limited to, during the application process.  Please let us know if you need assistance or an accommodation due to a disability.

We are a drug free workplace. Employment is contingent upon pre-employment drug screening, and successful completion of a background investigation subject to any federal, state and local laws.

Other details

  • Pay Type Salary
  • Required Education Bachelor’s Degree
  • 2001 Joshua Rd, Lafayette Hill, PA 19444, USA