Data Architect

What are we looking for in our Data Architect?

Job Title: Data Architect

Location: Beaverton, OR (WFH Fridays)

Duration: 3 Months

Pay Range: $85-$90/h on DOE

Job Description:

Responsibilities:

• The nature of the work is focused on designing, implementing, and optimizing robust database solutions to support our organization's information management needs.
• Develop and design scalable and efficient database architectures that align with business requirements. Collaborate with stakeholders to understand data needs and ensure data models support current and future use cases. Create logical and physical data models, defining relationships, constraints, and data integrity rules.
• Ensure data models are optimized for performance, scalability, and maintainability. Evaluate and recommend database management systems (DBMS), tools, and technologies based on project requirements. Stay abreast of emerging trends and technologies in the database field.
• Implement strategies to optimize database performance, including indexing, partitioning, and query optimization.
• Monitor and analyze database performance metrics to identify areas for improvement. Integrate security best practices into the database architecture. Collaborate with security teams to implement measures that protect sensitive data and ensure compliance with regulatory requirements.
• Plan and execute data migration projects, ensuring smooth transitions between database systems. Collaborate with teams to facilitate seamless data flows between applications. Maintain comprehensive documentation of database architectures, configurations, and data models.
• Ensure documentation is accessible to relevant stakeholders. Work closely with development teams, system administrators, and other stakeholders to ensure the effective integration of database solutions into the overall technology stack.
  
  

Skills:

• Proficient in Python, SQL, Databricks, Snowflake
• Expertise in setting up Databricks environment - Cluster setup (Schemas, Stages, Volumes, etc), Delta sharing (csv, tableau, SaaS solutions), Unity Catalog policies, RBAC, Data Governance & Compliance policies, Data Lineage, Different Teams, Service Principals, CI-CD, etc.
  
  

Migration: Review current Snowflake-based product layouts, recommend migration strategies, schema conversion, performance tuning, and ensuring data consistency, Backward compatibility strategies.

Rate/Salary: $85-$90/h on DOE