Principal Consultant

About the Job

Role:
We are seeking a highly skilled Principal Consultant - AWS+ Snowflake to join our team at Staffworthy. As a Principal Consultant, you will be responsible for designing and building reusable components, frameworks, and libraries at scale to support analytics products. You will also 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, and troubleshoot data issues and perform root cause analysis to proactively resolve product and operational issues.

Requirements:
To be successful in this role, you will need a strong understanding of data structures and algorithms, a strong understanding of solution and technical design, a strong problem-solving and analytical mindset, the ability to influence and communicate effectively, both verbally and written, with team members and business stakeholders, and the ability to quickly pick up new programming languages, technologies, and frameworks. You will also need experience building cloud scalable, real-time, and high-performance data lake solutions, a fair understanding of developing complex data solutions, experience working on end-to-end solution design, and a willingness to learn new skills and technologies. Additionally, you will need 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.

What We Offer:
We offer a competitive salary range of USD $115,000 to $135,000, full-time benefits, relocation assistance available, no commission compensation, no bonus eligible, no overtime eligible, and interview travel reimbursed. We also offer a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation.

---