Global Technology Division Team
United States

Senior Enterprise Data Architect

Apply Now

Overview

Senior Enterprise Data Architect

United States

Global Technology Division Team - Full-time

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 Senior Enterprise 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 Senior Enterprise 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 team, 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, as well as providing technical leadership. 

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.

As a Senior Enterprise Data Architect you will: 

  • 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.)
  • Lead and mentor a team of junior resources to complete work deliverables
  • 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
  • Collaborate with and manage external technology partners to implement the technology solutions
  • 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 

  • 8+ years of experience in database or data warehouse development (AWS, RDS, SQL Server, Oracle, Snowflake)
  • Rich experience in data architecture, data engineering, software engineering / DevOps, or consulting in data operations, analytics, or BI
  • 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
  • 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
  • Highly organized, able to multi-task, and detail-oriented - whether in collecting requirements, testing applications, putting together a deliverable deck, managing multiple project tracks and work-streams, etc. 
  • Results-oriented team player who also can coordinate and lead dynamic teams
  • Ability to support and develop the skills of more junior team members
  • Demonstrated expertise in collecting and managing requirements from different stakeholders and delivering solutions that meet business goals and objectives 
  • Experience delivering enterprise software systems and/or working within project management for software developers
  • Capable of autonomously driving deliverables and independently making key decisions
  • Demonstrated initiative and comfort with unstructured problems in a diverse environment
  • Innovative and creative problem solver with good analytical capability
  • Excellent time management and efficient working practices
  • Quick learner, collaborative, and client-oriented
  • Able to quickly adopt the use of Dimagi systems and tools e.g., Google Calendar, Google Docs, Dropbox, Skype, WhatsApp
  • 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) 

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.

Apply Now