Information Systems - ETL Developer
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.
The ETL Developer is responsible for performing business intelligence functions related to data warehouse, ETL and reporting designs, business intelligence infrastructure and delivery of business intelligence service to end users, in accordance with company policies and procedures.
Design, develop, optimize, maintain and support ETL processes using Stored Procedures and data integration tools such as Microsoft SSIS.
Develop views, queries, and tables necessary to support analytic need
Develop complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using SQL, SSIS
Work with business users for continuous improvement of existing reporting and analytics to drive effective business improvement.
Develop and configuration of Kourier server for importing data from our ERP into data warehouse.
Education, Training, Experience
- Bachelor’s Degree in Information Technology or related field
- 5+ years of experience in MS SQL SSIS/SSAS Technologies as well as SSRS. Strong background in writing SQL scripts, complex queries and aggregate functions.
- 3+ years in data warehouse concepts/architecture in high volume, real-time transactions and batch ETL jobs.
- Experience working with high volume data exchange and integrating large structured an unstructured data in multiple formats, character sets, and delivery methods.
- Experience with Kourier (Kore) ETL tool
- College degree or equivalent
Hajoca Corporation is a dedicated team of great workers. Our team has been servicing the community for years. We are a close-knit group that works together to provide the best service to both new and existing customers.
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.
- Pay Type Salary
- 2001 Joshua Rd, Lafayette Hill, PA 19444, USA