Job Summary
About Dimagi:
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.
About the Position:
Dimagi is seeking a Data Architect to join our US Health Division's Technology Team. This is a full time position open to remote employment from anywhere within the United States or can be based out of our office in Cambridge, MA.
As the team's Data Architect, you will play a critical role in helping local governments & clients extract greater insight from their healthcare systems & data. As the leader of our division's data workstream, you will report directly to the US Health Team's Director of Technology to develop our approach to data system deliverables while mentoring and developing the capacity of other team members. You will be responsible for developing architectures and leading the design of complex data services and capabilities to address complex business issues.
In this role, you will lead the design and management of data warehouses, lakes & marts that will be the source for a variety of analytics and visualization work. 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.
Responsibilities:
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
Design and build infrastructure and platform components to support complex data ETL pipelines ingesting disparate data from multiple internal and external data sources and processing
Ensure data system architectures comply with divisional best practices for security and compliance (e.g., HIPAA compliance, 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.)
Guide and mentor junior team members and oversee the work of external vendors.
Work with public health experts and local governments to determine key performance indicators for project operations; explore data and oversee the creation of efficient SQL queries to extract insights on operational trends
Introduce external data sources to data warehouses to generate more comprehensive operational insights for local governments
Support in the development of the future product strategy for Dimagi's data sharing, analytics, and visualization capabilities, giving thought to pricing and tiered offerings
Consult with clients to develop a holistic data and integration strategy. Lead in technical design and overall structure of integrations between CommCare and third-party systems
Required Experience and Skills:
5+ years of experience in database and/or data warehouse development
Familiarity with common data warehousing/management platforms and tools (e.g., AWS, RDS, SQL Server, Oracle, Snowflake)
Experience in data architecture, data engineering, DevOps or consulting in data operations, analytics, or BI
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
Experience with Dimensional Modeling (e.g., Star schema vs. Snowflake, OLAP cube, Kimball, etc.)
Self-directed: must be able to break down high-level objectives into actionable steps and execute
Demonstrated expertise in collecting and managing requirements from different stakeholders and delivering solutions that meet business goals and objectives
Capable of autonomously driving deliverables and independently making key decisions
Fluent in oral and written English
Must be eligible to work in the United States (this position is not eligible for visa sponsorship)
Bonus Skills:
Experience with agile methodologies & tools such as JIRA/Asana
Experience in relevant visualization software (e.g., Tableau, Power BI)
Experience delivering enterprise software systems and/or working within project management for software developers
Benefits Provided:
We aim to make a difference, not just as a company, but as an employer as well. Given our social mission, our budgeted salary scale is more in-line with that of a non-profit organization. However, 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 and excellent parental leave policy
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
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, ethnicity, gender identity and expression, national origin, family or parental status, veteran or disability status.
