The Socially Determined team is located at:
1000 Maine Avenue SW
Washington, DC 20024
To reach a member of our team, send a message using this form.
Join Our Team
Senior SQL/ETL Developer
Posted June 14, 2019
We seek an experienced Senior SQL/ETL Developer to help design, implement and operate a scalable, automated high-performance data collection and ingestion service in our healthcare data analytics environment. The optimum candidate will be experienced in working with large clinical EHR data sets and extracts from systems like EPIC and Cerner. The optimum candidate will have a thorough understanding of the relationship between EHR data and adjudicated claims data, and will be comfortable organizing data to optimize the exploration of EHR charges and claims payments. Using AWS services and integrated tools, the ideal candidate will leverage best-practice techniques for acquiring, organizing, and preparing raw CSV and JSON healthcare data to be loaded into our data model. The SQL and ETL Data Engineer will be fluent in SQL and creating scripts to create and update complex schemas, tables, and relationships in AWS Aurora PostgreSQL and other RDBMS. The SQL and ETL engineer will also understand MongoDB JSON databases and how to organize data effectively in JSON documents to achieve high scalability and performance. The optimum candidate will have geospatial experience, specifically PostGIS and Tiger.
What you’ll do:
Help lead the data architecture and data model design supporting our data science, data analytics, and data visualization functions.
Acquire and organize raw healthcare data in CSV, TXT, JSON and other formats from our clients using AWS S3 buckets in a data lake organizational model.
Create automated ETL processes to transform raw CSV, TXT, JSON and other raw data formats into a consistent data model supporting data science, data analytics, reporting and data visualization functions.
Perform geospatial manipulation and calculations using PostGIS, Tiger, and other geospatial technologies.
Create scripts for creating schemas, databases, tables, views and other constructs in PostgreSQL.
Create scripts for automating permissions and roles in PostgreSQL. Configure security logging.
Design and configure AWS DocumentDB MongoDB database for JSON document storage.
Design process for converting relational data to appropriate JSON documents.
Maintain an exceptional level of quality, efficiency, and effectiveness in the deliverables of each product sprint
What you’ll need:
5+ years of direct experience in designing large and complex data models specific to healthcare EHR data in relational and NoSQL technologies.
5+ years of hands-on experience designing, creating and implementing SQL and ETL scripts and processes, especially in a secure AWS environment
2+ years of experience with PostgreSQL administration, including security and performance management and logging
Experience performing PostGIS geospatial data manipulation and calculations
Experience in configuring MongoDB and JSON document sets, especially in AWS DocumentDB
Experience working in fast-moving startup environments with rapidly evolving priorities
Programming skills in Python is a plus
Healthcare specific experience working with clinical and claims data is a differentiator
Socially Determined offers a competitive salary and benefit package including access to gym facilities. Socially Determined is an equal opportunity and affirmative action employer M/F/Disability/Veteran. Send your resume and cover letter to Seret Medhani, Director of Operations.