Senior Data Architect

Plan A Technologies, Inc.; Snowflake (AZ); Remote; USD 120,000 - 160,000; Full time

Job summary

Plan A Technologies is seeking a Senior Data Architect to lead the design and implementation of on-premises data warehouse solutions. The role involves extensive collaboration, management of ETL processes, and working with big data technologies. The ideal candidate will have a strong background in PostgreSQL and a solid foundation in data privacy best practices while working in a supportive environment.

Benefits

Generous vacation schedule

Brand new laptop

Upbeat work environment

Work From Home option

Qualifications

• Minimum of 5 years of experience as a Data Architect.
• 7-10 years of experience as a Data Engineer preferred.
• Proven experience in designing and implementing data warehouse solutions.

Responsibilities

• Design and implement data warehouse architectures to ensure scalability and performance.
• Manage ETL workflows for real-time data integration and migration.
• Collaborate with teams to translate data requirements into effective solutions.

Skills

PostgreSQL

ETL processes

Apache Airflow

DBT

Apache Spark

Hadoop

Data privacy compliance

Problem-solving

Communication skills

Education

Bachelor’s or Master’s degree in Computer Science

Tools

Cloud data platforms

Oracle

AWS

Azure

Databricks

Job description

Plan A Technologies is looking for a highly skilled Senior Data Architectto lead the design and implementation of robust, on-premises data warehouse (DWH) solutions. The ideal candidate will have extensive experience with PostgreSQL, ETL processes utilizing Apache Airflow and DBT, and big data technologies such as Apache Spark and Hadoop. Experience with cloud platforms like Snowflake or Databricks is a plus.

Please note: you must have at least 5+ years of experience as a Data Architect to be considered for this role.

JOB RESPONSIBILITY

Design, develop, and maintain complex on-premises data warehouse architectures, ensuring scalability, performance, and reliability.

Implement and manage ETL workflows using Apache Airflow and DBT for real-time data integration, ingestion, and migration.

Utilize big data technologies, including Apache Spark and Hadoop, to process and analyze large datasets efficiently.

Collaborate with cross-functional teams to understand data requirements and translate them into effective data solutions.

Ensure data accuracy, consistency, and reliability through the implementation of robust data validation and quality checks.

Design efficient and scalable database schemas and relationships to support business intelligence and analytics needs.

Maintain and optimize relational and NoSQL databases for performance and scalability.

Stay abreast of data privacy, compliance, and security best practices, ensuring all solutions adhere to relevant regulations.

Provide technical leadership and mentorship to junior data engineers and architects.

EXPERIENCE

Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.

Minimum of 5 years of experience as a Data Architect and 7-10 years as a Data Engineer.

Proven experience in implementing complex data warehouse solutions, particularly on-premises.

Strong proficiency in PostgreSQL and experience with ETL tools such as Apache Airflow and DBT.

Hands-on experience with big data technologies like Apache Spark and Hadoop.

Familiarity with cloud data platforms such as Snowflake or Databricks is a plus.

Deep understanding of data privacy, compliance, and security best practices.

Ability to design efficient and scalable database schemas and relationships.

Proficiency in structuring, optimizing, and maintaining both relational and NoSQL databases.

Excellent problem-solving skills and the ability to work independently and collaboratively in a team environment.

Good communication skills, and the ability to talk with technical, non-technical resources, as well as management

Be flexible to change, and willing to adapt to the client and team needs

Ability to work with engineers in multiple countries

Must have an organized and analytical working style, and the ability to plan your own work

Initiative and drive to do great things

Preferred Skills

Experience with cloud providers such as Oracle, AWS, Azure, Snowflake, or Databricks.

Strong communication skills to effectively collaborate with stakeholders and present technical information to non-technical audiences.

Certifications in relevant technologies or platforms are advantageous.

ABOUT THE COMPANY/BENEFITS

Plan A Technologies is an American software development and technology advisory firm that brings top-tier engineering talent to clients around the world. Our software engineers tackle custom product development projects, staff augmentation, major integrations and upgrades, and much more. The team is far more hands-on than the giant outsourcing shops, but still big enough to handle major enterprise clients.

Read more about us here: www.PlanAtechnologies.com

Location:Work From Home 100% of the time, or come in to one of our global offices. Up to you.

Great colleagues and an upbeat work environment: You'll join an excellent team of supportive engineers and project managers who work hard but don't ever compete with each other.

Benefits: Vacation, Brand New Laptop, and More: You’ll get a generous vacation schedule and other goodies.

If this sounds like you, we'd love to hear from you!