Indigenous Pact PBC, Inc.
Database Architect (Contract)
28 days ago
San Diego
Job Description About Indigenous Pact PBC, Inc: Established in 2017 Indigenous Pact PBC, Inc., a certified B-Corporation, set out on a mission to create health equity for American Indians and Alaskan Natives. As part of a global movement of certified B-Corporations, we aim to balance purpose and profit by meeting the highest social, environmental, legal, and public standards to build a more sustainable and inclusive economy. Indigenous Pact's dedicated, experienced, and knowledgeable team brings decades of experience working in Indian Country. We help strengthen and improve the sustainability of Tribes and Tribal Organizations' health, wellness, and long-term care programs and services. Indigenous Pact specializes in developing customized and turn-key solutions to generate sustainable revenue, increase healthcare access, and improve health outcomes for all Native Americans. Job Description • Job Title: Database Architect, • Base Salary: $57.00 - 67.00/per hour, • Location: USA, Remote, • Work model: 3-month Contract, • Travel Requirements: up to 10% As a Database Architect, you will play a critical role in leading the design and implementation of Indigenous Pact's enterprise data architecture and modern Azure Data Lake environment. You will architect solutions that enable secure, scalable, and high-performing data integration, warehousing, governance, and analytics across healthcare and Tribal systems. Your work will shape the foundation of our cloud-based data infrastructure—ensuring it meets performance, compliance (HIPAA), and business intelligence needs. This position is central to our long-term data strategy and modernization roadmap. Essential Job Functions: • Lead architecture of Indigenous Pact's Azure Data Lake Storage Gen2, including partitioning strategy and data zone design (raw, refined, curated, sandbox)., • Define data ingestion, transformation, and storage patterns, and other efficient data formats., • Develop and enforce data modeling standards, naming conventions, and metadata management strategies., • Collaborate with cross-functional stakeholders to identify, prioritize, and classify data entities for inclusion in the data lake., • Analyze existing data sources, APIs, and reporting tools to map data lineage, quality issues, and integration patterns., • Design scalable Azure Data Factory (ADF) pipelines, CDC strategies, and scheduling/orchestration workflows., • Define and document technical architecture, ETL specifications, capacity plans, and network/data security requirements., • Establish governance frameworks including data stewardship models, privacy and compliance controls (HIPAA, CCPA), and data quality standards., • Develop and manage strategies for data lifecycle, archiving, disaster recovery, and performance optimization., • Guide implementation of data dictionaries, business glossaries, and audit/compliance tracking systems., • Participate in stakeholder validation sessions, technical feasibility reviews, and trial data loads. Required Skills/Abilities: • Strong expertise in Microsoft Azure cloud data services: Azure Data Lake Storage Gen2, Azure Synapse, Azure SQL, Azure Data Factory., • Experience designing data lake architectures, data zones, and cloud-native ETL pipelines., • Proficiency in data modeling, schema design, and governance standards (e.g., master data, metadata)., • Familiarity with compliance frameworks (HIPAA, CCPA) and best practices in data security and auditing., • Ability to analyze complex integration scenarios, APIs, and legacy data structures., • Excellent written documentation and verbal communication skills for stakeholder engagement., • Scripting proficiency using PowerShell, Python, or similar automation tools., • Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience)., • 7+ years of progressive experience in data architecture or enterprise database design., • Hands-on experience with large-scale data environments and healthcare data preferred., • This position involves extended periods of computer-based work., • Remote position with core hours of 9:00 AM to 5:00 PM CST (flexible for time zones)., • You have a Growth Mindset: A belief that abilities can be developed along with a desire to be curious, learn & grow, • You take Initiative: Solve problems by thinking & taking action on solutions rather than waiting for direction, • You take Accountability: Follow through on commitments, take ownership & ensure timeliness, • You Give Back: Leverage your knowledge & expertise to make improvements around you, • You are Resilient: Work through challenges with optimism, agility & adaptability Building a strong culture and exhibiting our core values is important to us. When you join Indigenous Pact, you are joining a team that values: • Empathy is at the heart of everything we do—we listen, we understand, and we put ourselves in the shoes of others, whether it's our teammates, our clients, or the communities we serve., • Wisdom is about learning from experience, being thoughtful in our work and making decisions that are grounded in knowledge and insight. It's about taking the time to get things right., • Bravery is having the courage to take bold risks, challenging the status quo, and knowing that growth happens when we push our limits. Beyond the job opportunity and incredible culture we also offer: • A competitive total rewards package, including 401(k), Medical, Dental, and Vision insurance, • Open, transparent lines of communication with leadership, • Committed to giving back to improve our communities and environmental impact