PRINCIPAL CONSULTANT - AWS+ SNOWFLAKE

StaffWorthy; Beaverton (OR); On-site; USD 115,000 - 135,000; Full time

Job summary

A leading tech consulting firm is seeking a Principal Consultant specializing in AWS and Snowflake to design scalable data solutions. The role involves building frameworks for analytics products, collaborating with stakeholders, and ensuring data quality. Candidates should have a Bachelor’s degree, over 7 years of experience, and strong analytical skills. The position is full-time, based in Beaverton, Oregon, with a competitive salary range of $115,000 to $135,000.

Qualifications

• 7+ years of experience in a relevant field.
• Hands-on experience with cloud infrastructure and data management.
• Experience in designing ETL pipelines and data quality frameworks.

Responsibilities

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

Skills

Data structures and algorithms

Solution and technical design

Analytical mindset

Problem-solving

Communication skills

Cloud scalable data lake solutions

SQL, ETL, data transformation

Python for data manipulation

Education

Bachelor's Degree

Tools

AWS - EMR [Hive, Pyspark]

Apache Airflow

GitHub

Jenkins

Snowflake

Job description

About the job PRINCIPAL CONSULTANT - AWS+ SNOWFLAKE

JOB DESCRIPTION

Industry: Retail / Wholesale - Other Job Category: Information Technology - Computer Network Security With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the worlds biggest brands and we have fun doing it. Now, were calling you all who see the world differently and are bold enough to reinvent it.
Transformation happens here. Come, be a part of our exciting journey!
Are you the one we are looking for?
Inviting applications for the role of Principal Consultant - AWS+ Snowflake

Role: Principal Consultant - AWS+ Snowflake

Location: Beaverton, OR (On-site)

Job type: Full-time

Responsibilities: (The primary tasks, functions, and deliverables of the role)

• 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 re-structure 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
• Has a 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 any other equivalent cloud
• Familiarity with Spark Structured Streaming
• Minimum experience working experience with Hadoop stack dealing 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 or equivalent, preferable Airflow.
• Working 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; knowledgeable on logical and physical data modelling concepts; some experience with Snowflake
• Familiarity with Tableau or Cognos use cases
• Familiarity with Agile; working experience preferred.

Security Clearance Required: NoVisa Candidate Considered: No

COMPENSATION

Base Salary - USD $115,000 to $135,000

Full-time benefits - Full

Relocation Assistance Available - No

Commission Compensation - No

Bonus Eligible - No

Interview Travel Reimbursed - No

CANDIDATE DETAILS

7+ to 10years' experience

Seniority Level - Mid-Senior Management Experience Required - No

Minimum Education - Bachelor's Degree

Willingness to Travel - Never

WHY WE'RE A GREAT COMPANYOur company is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. We arecommitted to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation.