Data Engineer II

About Dimagi Dimagi is an award-winning social enterprise and a certified B-corp and Benefit Corporation. We build software solutions and provide technology consulting services to improve the quality of essential services for underserved populations. Our open-source technology platform, CommCare , is the world’s most widely-used and researched mobile data collection platform for frontline workers. Our choice to be a certified B-Corp and to legally incorporate as a Benefit Corporation sends a clear signal to our partners, our team members, and our communities that we not only believe but also take action in using business as a force for good. This approach combines our passion and commitment to tackle complex health and social inequities and work towards a brighter future for all. About the Position Dimagi is looking for a Data Engineer II to join our US Solutions Division. This position will be affiliated with our Cambridge, MA office but is open to remote employment within the United States. This is a 12-month fixed-term position with the possibility of renewal based on business requirements and mutual interest. The Data Engineer II will be part of Dimagi’s US Solutions Division Data & Analytics team, a group of engineers and data specialists responsible for building, maintaining, and evolving Dimagi’s Data Platform in support of current and future project work. The primary technologies used by the current data platform are Snowflake, Tableau, and various AWS cloud tools. In this role, you will contribute hands-on to the design, implementation, and operation of data pipelines, warehouse transformations, data visualizations, and supporting infrastructure, while working closely with technical leadership to ensure platform reliability, scalability, and alignment with business needs. The data systems you help build and maintain will directly support public health and human services programs, enabling frontline teams and government partners to deliver care and services more effectively. This position is well suited for someone who enjoys hands-on technical work in a small, collaborative environment. As a member of a lean team, you will be expected to work across functional areas, adapt quickly to new problem spaces, and contribute meaningfully to data systems that support real-world service delivery and decision-making. This role assumes comfort using AI-assisted tools to support analysis, documentation, troubleshooting, and learning in a complex technical environment. Responsibilities Contribute to the technical integrity and evolution of the Data Platform tech stack, working closely with other Data Engineers, the Director of Technology, and the USS Tech Lead. Design and implement core features and enhancements within the Data Platform, including contributing to technical specifications, conducting targeted technical research, and translating requirements into production-ready solutions. Responsible for executing and maintaining DevOps workflows supporting the Data Platform, including performance monitoring, platform upgrades, deployment frameworks, and operational improvements, with guidance and mentorship from more senior Data Engineers as needed. Use AI-assisted tools thoughtfully to accelerate development, debugging, documentation, and operational analysis, while understanding and validating outputs to ensure correctness, reliability, and security. Build and maintain robust data extraction, loading, and transformation processes for both Dimagi managed (i.e. CommCare) and external data sources, enabling efficient, reliable data pipelines and their long-term development and operation using both SQL and Python scripting. Design and develop data warehouse transformations, using SQL-based approaches and supplementary tools such as dbt. Collaborate with internal teams and external partners on the design and implementation of enterprise data architectures based on industry standards and partner specific analytics needs. Conduct ad h