ETL and SQL Developer

What we do:  
Procurated is a ratings and reviews platform for the public sector helping procurement officials pick better suppliers. We have built a product to make public procurement professionals more efficient and improve the lives of citizens they serve. In addition, Procurated offers industry leading suppliers a unique opportunity to engage with buyers making multi-million dollar purchasing decisions. 
We have worked hard to create a company culture where everyone is set up for success. We are extremely proud of the platform and team we have built so far. We think big and solve serious problems but don’t take ourselves too seriously. We believe that a fun, collaborative environment is also the most productive.  
The Opportunity:  
We are looking for an experienced SQL & ETL developer to build out our ETL frameworks and own the process from start to finish.  We are looking for someone who is excited about building a scalable process for integrating disparate data sources arriving in various forms (flat files, csvs, excel, json) and ensuring the critical quality of that data before and after loading into our system. The ideal candidate thrives in an early-stage environment where systems and processes are still being developed and is willing to step into different lanes within our Data Team when the need and opportunity arises.    
What you might do on any given day:  
  • Assess and integrate external data onto our platform 
  • Organize and restructure existing infrastructure to build out data framework 
  • Build a new process for working with a data vendor or partner 
  • Work collaboratively with data, engineering and product teams to determine best processes  
About You:   
  • You live anywhere in the US (read about our remote work environment here)   
  • You have 3+ years SQL experience. Excellent development skills to write complex queries involving multiple tables, ability to develop and maintain stored procedures, user defined functions & reporting views. 
  • You have 2+ years of experience developing and maintaining ETL procedures for RDBMS to process raw data from heterogeneous sources (relational databases, flat files, Excel, CSV, json),  
  • You have some exposure to Alteryx; development experience is a plus. 
  • You’re familiar in MDM, Golden Record, Dimensional Modeling, ER Modeling, Data Marts, Star / Snowflake Schema, FACT and Dimensional tables. 
  • You have a critical eye for data quality assurance 
  • You can create technical, functional documents with detail description and screenshots showing functioning of the packages. 
  • You have experience working on the various phases of Data Warehousing (Staging, Work Area, Dimension and Fact loading etc.) 
  • You have strong written and oral communication skills, self-motivated, focused, creative, quick learner, ability to work with minimal supervision, adaptive to new technologies and platforms, passionate about solving ETL, data QA, and database architecture problems. 
Things you might have done before joining the team:  
  • Worked for a tech startup 
  • Worked to clean up messy data 
  • Played on a really great team  
  • Participated in debate club  

The Procurated Story:  
 Founded in 2019, Procurated provides a way for state and local government, educational, healthcare and non-profit purchasers to write reviews of suppliers they have worked with. These reviews help other procurement professionals make more informed decisions when selecting their next supplier. We work closely with suppliers to help them understand the needs of the public sector and improve performance. In serving two sides of the marketplace, we help to simplify and streamline procurement.   
Procurated is an early-stage startup backed financially by Limerick Hill LLC and MayFive Holdings, Inc. The company’s founder and CEO served as Deputy Secretary for Procurement of the Pennsylvania Department of General Services and brings valuable experience having sat in the chair of a public procurement professional.    
How we assess our candidates:  
All candidates will be assessed using the qualifications that we have outlined on this job description. We are a ratings and reviews company, so scoring and consistency is extremely important to us. When you apply, we want you to honestly assess your strengths that you bring to the role and the things that you might grow into with time.   
Procurated believes that diversity is critical to our success in delivering great workplace experiences and is committed to creating an inclusive, mutually respectful environment which celebrates diversity of our people. We seek to hire on the basis of merit, competence, performance, and business needs. We’re looking for five-star candidates and can’t wait to bring them onto our team!   
Procurated is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, color, family or medical care leave, gender identity or expression, genetic information, marital status, medical condition, national origin, physical or mental disability, political affiliation, protected veteran status, race, religion, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable laws, regulations and ordinances. 

Interested candidates, please email Jess at jobs@procurated.com
  Jess Einstein