Database Architect (Contract)

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% • Reports to: Vice President of Product Design Job Summary: 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. • Support implementation teams (DBAs and developers) in deploying data systems into production environments. The above duties and responsibilities are not an all-inclusive list but rather a general representation of the duties and responsibilities associated with this position. The duties and responsibilities will be subject to change based on organizational needs and/or as deemed necessary by the supervisor. 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. • Preferred: Azure certifications (e.g., Azure Data Engineer Associate, Azure Solutions Architect Expert). Education and Experience: • 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. • Experience implementing data lakes, data warehouses, or cloud-first data platforms in Azure. Contact (Internal/External): • Collaborates with the Technology & Product team, data engineers, developers, analysts, and compliance staff. Physical and sensory demands: • This position involves extended periods of computer-based work. • Must be able to focus for long durations and manage multiple architectural priorities. Working environment: • Remote position with core hours of 9:00 AM to 5:00 PM CST (flexible for time zones). • Occasional local and national travel may be required (up to 10%). Who you are: • 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 • You demonstrate Awareness: An ability to understand how your attitudes & actions impact others and adapt your approach accordingly Why Choose Indigenous Pact? 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. • Transformation drives us to continuously grow—both as a company and as people. It’s about not being afraid to change and to keep pushing forward in the pursuit of excellence. Visit our Careers page (https://www.indigenouspact.com/careers) where we encourage you to learn more about the characteristics that are important to us (and we hope you bring them as well) such as Healthcare-focused, growth mindset, self-motivated, collaborative, resilient and adaptable. 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 • A development-focused environment where you have autonomy to drive your career path Indigenous Pact is an equal opportunity employer and we are dedicated to fostering an inclusive and barrier-free work environment for all employees and candidates. Preference will be given to qualified native applicants; however, all qualified individuals are encouraged to apply. Must be able to provide Indian Preference documentation if claimed. If accommodation is required during any stage of the recruitment process, please contact any member of our HR team. We thank all applicants for their interest; however, only those selected for interviews will be contacted.