Full Job Description
Dimagi is a social enterprise and Benefit Corporation that builds software solutions and provides technology consulting services to improve the quality of essential services for underserved populations. Headquartered in Cambridge, Massachusetts, Dimagi partners alongside governments, leading NGOs, and foundations such as the Bill & Melinda Gates Foundation, USAID, and the World Bank to tackle complex health and social inequities. Our open source technology platform, CommCare, is the world’s most widely-used and researched mobile data collection platform for frontline workers. To date, Dimagi’s team of project managers, engineers, and health experts have supported over 2,000 projects in 80 countries.
When COVID-19 came to the US, Dimagi sprung into action. We were among the first on the scene to support efforts in the United States, rolling out a web-based contact tracing system for the City of San Francisco in a few weeks. Today, our COVID-19 Response team works in some of the hardest-hit areas of the United States to roll out statewide and local contact tracing technology.
About the Position
To support this work, Dimagi is seeking an ambitious candidate with a technical and product management background to join our US Health Team. This position can be based out of our office in Cambridge, MA, but is also open to remote employment within the United States. This is a 12-month, fixed-term position.
As the COVID-19 Data Warehouse Product Manager, you will play a critical role in helping local governments extract greater insight from their COVID-19 case investigation and contact tracing data. You will lead the design and maintenance of a data warehouse system that will be the source for a variety of analytics and visualization work. In this role, you will work in an agile environment overseeing the development and implementation of various technical deliverables against tight timelines, including detailed project plans and documentation, stakeholder presentations, and application updates.
Due to the nature of the COVID-19 response, the work will be challenging, but in the right ways - you'll have an opportunity to quickly dive into and learn from multiple project areas, all while making a real, positive impact. We are looking for both leaders and teachers. You will chart the team’s strategic direction while making time for project management guidance, training, and mentoring to improve the project's effectiveness.
Oversee the design and implementation of data warehouse architecture in Snowflake, including the creation of data lakes, data warehouses, and data marts to meet business objectives around reporting and data sharing
Ensure adherence to best practices for security and HIPAA compliance (e.g., encryption of data at rest and in transit, secure storage and rotation of encryption keys, IP-whitelisting, role-based access control, query logging and auditing, backup, etc.)
Manage addition of users and assigning appropriate permissions
Monitor and improve data warehouse performance and manage budget
Work with public health experts and local governments to determine key performance indicators for contact tracing operations; explore data and oversee the creation of efficient SQL queries to extract insights on operational trends
Collaborate with and manage external technology partners to optimize technology architecture with a focus on security, performance, flexibility, cost, and maintenance
Create and maintain aesthetically pleasing and intuitive visualizations of KPIs using BI software
Introduce external data sources to data warehouse to generate more comprehensive operational insights for local governments
Develop a product strategy for Dimagi’s data sharing, analytics, and visualization capabilities, giving thought to pricing and tiered offerings
Understand the positioning of key stakeholders (various teams in Dimagi, local governments, patients, contacts, technology partners, etc.) and be able to collaborate with them to achieve business objectives effectively
At the core of this position, we are looking for smart, capable, and impact-driven individuals. For that reason, please consider the following requirements listed as general “guidelines” vs. strict qualifications:
3+ years of experience in database or data warehouse development (AWS, RDS, Redshift, BigQuery, Snowflake)
Solid understanding of analytic data architecture and data modeling concepts and principles, including data lakes, warehouses and marts
Experience with SQL and different kinds of data management technologies, from standard RDBMS to newer big data tools
Excellent written and verbal communication skills
Self-directed - must be able to break down high-level objectives into actionable steps and execute
Quick learner who can pick up new technical concepts
Highly organized, able to multitask, and detail-oriented - whether in collecting requirements, testing applications, putting together a deliverable deck, etc.
Results-oriented team player who also can coordinate and lead dynamic teams
Demonstrated expertise in collecting and managing requirements from different stakeholders and delivering solutions that meet business goals and objectives
Have an incredibly analytical mindset - someone who isn’t afraid to get messy in SQL tables or working to figure out what part of an application isn’t right due to a bug
Must be eligible to work in the United States
Experience in relevant visualization software (e.g., Tableau, Power BI)
Experience delivering enterprise software systems and/or working within project management for software developers
At Dimagi, we aim to make a difference, not just as a company, but as an employer as well. The benefits we offer are geared towards having a strong impact on our staff’s well being. A few of our key benefits are outlined below:
100% employer-sponsored medical insurance paired with a generous Health Reimbursement Account (HRA) fund
Access to voluntary dental and vision insurance plans
A 401K plan with up to a 4% employer match
30 days paid time off inclusive of holidays
Unlimited sick time, excellent parental leave policy, and a strong focus on work-life balance
Access to a flex-time policy that allows employees to work based on a flexible work schedule
Access to an Employee Assistance Program (EAP) through Magellan Healthcare
Occasional opportunities to travel internationally
Dimagi is an Equal Opportunity Employer. We celebrate and support diversity and are committed to providing a work environment that is inclusive and free of discrimination and harassment. All employment decisions are based on individual qualifications without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, family or parental status, veteran, or disability status.