Data Architect

Accepting applications until: May 1, 2026 at 11:59 PM EST

Location: Arlington, VA 22201

Pay Rate: $130,000.00 - $155,000.00 Annually

Department: Information Technology

Job Status: Full-Time

Work Shift: 9:00 AM - 5:00 PM

Days Worked: Mon., Tue., Wed., Thu., Fri.

Hour Per Week: 40

Status: Accepting Applications

Position Description

Summary

Rios Partners is a mission-driven consulting firm creating positive change by delivering value for our clients, investing in our employees, and solving tough problems that benefit our local and global communities. We ground our approach in empathy, enabling our team members to hear our customers’ challenges better and work together to develop effective solutions. As a team, we know what it takes to move organizations forward with measurable, sustainable results. Our primary consideration when evaluating candidates is alignment with our Mission and Values.

Job Description

As a Data Architect, you will play a critical role in designing and implementing scalable data solutions that power analysis and visualization across public sector projects. Your primary focus will be on ingesting, transforming, and preparing complex data sets for use in reporting, analytics, and decision-making tools such as Tableau or Power BI.

You will develop robust data pipelines, architect efficient data storage and processing frameworks, and ensure the availability, accuracy, and integrity of data for analysis. This role requires deep technical expertise in modern data platforms, a strong understanding of data modeling and integration, and the ability to translate business requirements into scalable data solutions. This is a contingent role.

As the Data Architect, your core responsibilities will include:

• ETL Planning and Implementation: Develop and implement comprehensive ETL plans aligned with the business objectives. Collaborate with cross-functional teams to understand data requirements and provide guidance on data-related projects (e.g., dashboard development), including estimates of level of effort and planning of ETL work so that it may be completed on schedule.
• Data Modeling and Design: Design and implement robust, scalable, and efficient data models that meet business requirements. Ensure the integrity, security, and performance of data architecture through effective design principles and best practices.
• Data Integration and Migration: Oversee the integration of data from various sources into a unified and coherent architecture. Lead data migration efforts, ensuring seamless transition and minimal disruption to business operations.
• Metadata Management: Establish and maintain a comprehensive metadata management framework. Define and implement standards for metadata to ensure data quality, lineage, and accessibility.
• Data Governance and Compliance: Develop and enforce data governance policies and procedures. Ensure compliance with data protection regulations and industry standards.
• Collaboration and Communication: Collaborate with business stakeholders, data scientists, and IT teams to understand data needs and requirements. Communicate complex technical concepts to non-technical stakeholders and contribute to a data-driven culture within the organization.
• Performance Optimization: Monitor and optimize the performance of databases and data infrastructure. Troubleshoot, document, and resolve issues related to data architecture, ensuring high availability and reliability.
• Documentation Maintenance: Rigorously document data architectures, models, and ETL processes, ensuring clarity and accessibility for both technical teams and business stakeholders.

What You’ll Need to Succeed:

Basic Qualifications:

• 3 years using Python, SQL, and/or Relational Database Management Systems (RDBMS)
• Experience optimizing database solutions for scalability, performance, and security
• Knowledge of data migration strategies from legacy systems to new solutions
• Experience working with various AWS services such as S3, RedShift, ECS, ECR, CloudFormation, Lambda, CloudWatch, EventBridge, etc
• Experience working with Microsoft technologies (e.g., Azure SQL, Azure Data Lake, Azure Data Factory, Fabric)
• Experience working with Docker, dbt, Pydantic, and/or CDK
• Experience working on Analytics and Business Intelligence focused initiatives, preferably in a consulting capacity
• Experience working with backend databases
• Experience working with version control repositories (e.g., GitHub, Azure DevOps) and task management software (e.g., Jira)
• Strong problem-solving and communication skills, with the ability to translate perceived needs into technical requirements
• Bachelor’s degree in Computer Science, Data Science, Information Technology or STEM-related discipline

Preferred Qualifications:

• Familiarity with Python data science libraries such as Pandas, NumPy, SciPy, Matplotlib, etc.
• Familiarity with CI/CD processes (e.g., CodePipeline or GitHub Actions) and setting up pre-commit hooks and/or CI/CD testing
• Familiarity designing and building APIs
• Experience working with public sector data (expenditures, healthcare, etc.,)
• Master’s degree in Computer Science, Data Science, Information Technology or STEM-related discipline

Additional requirements

U.S. work authorization.

Ability to obtain and maintain Public Trust clearance.

Additional Information

Benefits Information:

• Profit-sharing/Performance Bonus: Rios Partners is committed to ensuring the success of the organization benefits the entire team. As such, a portion of profits is paid out to employees. The total amount of Profit-Sharing/Performance Bonus distributed to the team may vary year to year and will depend on numerous factors, including market conditions, company performance, and individual performance.

• Retirement plan: Rios Partners offers a 401(k) and contributes an amount equivalent to 3% of the employee’s base salary each month to the designated fund. Employees may choose to contribute additional money into the 401(k) from their paycheck each month. The plan is administered through Fidelity.

• Health insurance: Rios Partners Offers health benefits through an Individual Coverage Health Reimbursement Arrangement (ICHRA). This option empowers employees with more personalized healthcare options. With ICHRA, Rios Partners contributes tax-free dollars toward your health insurance premiums, giving you the flexibility to choose a plan that best fits your needs—rather than being limited to a traditional group plan.

• Vision insurance: Rios Partners offers a vision plan through MetLife that covers eye exams, glasses, contacts and other vision related services.

• Dental insurance: Rios Partners covers the premium for both the employee and their dependents for a dental insurance plan through MetLife, employees can purchase up to a higher-level plan.

• Disability insurance: Rios Partners will pay 100% of the premium for both short-term and long-term disability insurance provided through MetLife.

• Paid Time Off (PTO) and holidays: You will be eligible for three weeks of PTO (15 days) with an additional PTO based on service time as well as 12 paid holidays each year. In addition to accrued PTO, Rios Partners provides additional time off for both expected and unexpected events (e.g., Bereavement Leave, Jury Duty, Voting).

• Maternity, Paternity, and Adoption Leave: Rios Partners celebrates employees’ choice to become parents. We are also aware that pregnancy and caring for an infant or a newly adopted child may cause additional life complexities. As such, we provide employees twelve (12) weeks of paid leave in association with the birth of an employee’s own child or the placement of a child with the employee in connection with adoption or foster care. To be eligible for Maternity/Paternity/Adoption Leave Program, team members must: 1) Have worked at Rios Partners full-time for a minimum of 12 continuous months. 2) Be in good employment standing with Rios Partners (i.e., not on probation). 3) Request leave a minimum of 30 days in advance if possible. If this is not possible, please place your request as soon as possible once you become aware of it. Regardless of eligibility for the Rios Partners Maternity/Paternity/Adoption Leave Program, all Rios Partners employees are eligible for the Department of Labor’s Family and Medical Leave Act entitlements as well as Rios Partners Short Term Disability plan.

• Employee Assistance Program: Rios Partners cares about the mental health of our employees. Through our employee assistance program, Health Advocate, we offer sessions to address personal issues such as relationship struggles, substance abuse, parenting challenges and grief. Health Advocate also provides Healthcare related, mental and personal as well as Work/Life support and resources for every eligible employee.

• Training and Development: Rios Partners is committed to helping you achieve your highest potential. Our personal view is that this is best accomplished through a combination of client engagements, opportunities to take on new roles within the team, and internal (team) / external (expert) training.

Disclaimer

Equal Opportunity Employer

Rios Partners is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.

Rios Partners is an E-Verify Employer. Click here for more information on E-Verify.