Principal Consultant - AWS+ Snowflake

RZS Recruitment; Beaverton (OR); On-site; USD 110,000 - 130,000; Full time

Job summary

A technology recruitment firm seeks a Principal Consultant - AWS+ Snowflake in Beaverton, Oregon. This full-time role is for a mid-senior level candidate with 7+ years of experience. Responsibilities include designing and building analytics products, collaborating with business stakeholders, and troubleshooting data issues. Ideal candidates will have strong problem-solving skills, experience with cloud data solutions, and communication abilities. Competitive salary ranges from $110,000 to $130,000, reflecting the applicant's experience and skills.

Qualifications

• 7+ years of experience in relevant technical fields.
• Hands-on experience with data transformation and analytics functions.
• Able to effectively influence and communicate with stakeholders.

Responsibilities

• Design and build reusable components for analytics products.
• Implement product features in collaboration with stakeholders.
• Optimize data for ingestion and consumption.

Skills

Data structures and algorithms

Solution design

Problem solving

Communication

Cloud scalable data lake solutions

Data management

ETL and data transformation

AWS services

SQL

Python

Education

Bachelor's Degree

Tools

AWS EMR

Apache Airflow

GitHub

Snowflake

Tableau

Jenkins

Job description

About the job Principal Consultant - AWS+ Snowflake

Role: Principal Consultant - AWS+ Snowflake
Location: Beaverton, Oregon, United States
Relocation Assistance Available: No
Interview Travel Reimbursed: No

Compensation: USD $110,000 to $130,000
Experience: 7+ to 10 years
Seniority Level: Mid-Senior
Minimum Education: Bachelor's Degree
Willingness to Travel: Never
Security Clearance Required: No
Visa Candidate Considered: No
On-site role: Yes
Industry: Retail / Wholesale - Other
Job Category: Information Technology - Computer Network Security
Job type: Full-time

Responsibilities

• Design and build reusable components, frameworks, and libraries at scale to support analytics products.
• Design and implement product features in collaboration with business and technology stakeholders.
• Identify and solve issues concerning data management to improve data quality.
• Clean, prepare and optimize data for ingestion and consumption.
• Collaborate on the implementation of new data management projects and restructure of the current data architecture.
• Implement automated workflows and routines using workflow scheduling tools.
• Build continuous integration, test-driven development, and production deployment frameworks.
• Analyze and profile data for designing scalable solutions.
• Troubleshoot data issues and perform root cause analysis to proactively resolve product and operational issues.

Requirements

• Strong understanding of data structures and algorithms.
• Strong understanding of solution and technical design; strong problem solving and analytical mindset.
• Able to influence and communicate effectively, both verbally and written, with team members and business stakeholders.
• Able to quickly pick up new programming languages, technologies, and frameworks.
• Experience building cloud scalable, real-time and high-performance data lake solutions.
• Fair understanding of developing complex data solutions; experience working on end-to-end solution design.
• Willing to learn new skills and technologies.
• Has a passion for data solutions.

Required and Preferred Skill Sets

• Hands-on experience in AWS – EMR [Hive, Pyspark], S3, Athena or equivalent cloud.
• Familiarity with Spark Structured Streaming.
• Minimum experience working with Hadoop stack dealing with huge volumes of data in a scalable fashion.
• Hands-on experience with SQL, ETL, data transformation and analytics functions; hands-on Python experience including batch scripting, data manipulation, distributable packages.
• Experience working with batch orchestration tools such as Apache Airflow; preferred knowledge of Airflow.
• Experience with code versioning tools such as GitHub or BitBucket; expert-level understanding of repo design and best practices.
• Familiarity with deployment automation tools such as Jenkins.
• Hands-on experience designing and building ETL pipelines; expert with data ingest, change data capture, data quality; hand-on experience with API development.
• Designing and developing relational database objects; knowledge of logical and physical data modelling concepts; some experience with Snowflake.
• Familiarity with Tableau or Cognos use cases.
• Familiarity with Agile; working experience preferred.

The actual offer, reflecting the total compensation package plus benefits, will be determined by a number of factors including but not limited to the applicant’s experience, knowledge, skills, abilities, geographic location, and internal considerations.