The All Children Excel (ACE) Nashville Data Wrangler, as an employee of Meharry Medical College’s Office for Research, will build and refine the data pipeline of the ACE Nashville Data Hub, supported by Meharry Medical College’s Office for Research, and in collaboration with the ACE Nashville Continuous Data Collection and Quality Improvement workgroup (CQI). ACE Nashville is a collective impact initiative using a public health approach to address the problem of adverse childhood experiences (ACEs). Meharry’s Office for Research is a Backbone agency of ACE Nashville. Primary activity will be optimizing the collection and flow of data from and between ACE Nashville cross-sector partner agencies and organizations. These entities are diverse in their sectors of activity, with representatives from non-profit service providers (i.e. counselling services, human and social services, and healthcare providers), legal consultants and advocates, local government agencies (i.e. public schools, public health, and the justice network), institutions of higher education and research, and for-profit, socially invested firms and corporations. In addition to technical proficiency in data flow optimization, the ideal candidate has a basic understanding of social and human services, public and civic agencies, and other organizations related to the public goods space. The successful candidate will be able to navigate the wide variety of data sophistication present among member organizations of ACE Nashville. The Data Wrangler will aid the CQI in data sharing agreements and data governance structures, and will build or improve the data pipelines between these organizations.
Required Skills
- Able to commit to the mission and values statements of ACE Nashville
- Cognizant of ethical concerns balancing data privacy and usability in relation to protecting and supporting underserved and exploited populations
- Excellent verbal and written communication skills and good at developing interpersonal relationships
- Highly motivated to achieve, collaborate, and innovate
- Good understanding and relevant experience with big data technologies, architecture and tools, such as Hadoop, MapReduce, HDFS, Spark, Hive, Pig, Sqoop, Spark, Kafka, etc.
- Experience with relational SQL and SQL/NoSQL databases: Netezza/Oracle/SQL server/Teradata/Cassandra/MongoDB
- Good understanding of data modeling. Proficient in SQL queries and database operations
- Theoretical or professional experience with cloud services: Azure, AWS, GoogleCloud, etc.
- Experience with scripting languages: Python/Java/Scala/Shell Scripting
- Familiar or experience to DevOps tools such as Jira, Confluence, Jeken, Git, BitBucket etc.
Required Experience
- Minimum requirement: Bachelor’s degree related to either Computer and Information Sciences or Social and Public Service with educational or work exposure to the converse discipline.
- Master’s Degree as above preferred
- Experience in healthcare, non-profit consulting, social work, or government services preferred
- 3+ years of experience direct work experience in related technical field
- Experience in developing processes supporting data transformation, data structures, metadata, dependency and workload management
- Experience in developing and optimizing ‘big data’ data flow and data sets
- Experience in performing root cause analysis on internal and external data and processes
- A successful history of manipulating, processing and extracting value from large disconnected datasets
- Experience supporting and working with cross-functional, multi-sector teams in a human or social services environment
- Remote work may be possible with occasional local travel.
- Manual dexterity
- Visual and auditory acuity.