Skip to Main Content

Data Engineer

Sia Partners
Palo Alto, CA
  • Expired: over a month ago. Applications are no longer accepted.
Job Description
Company Description

ABOUT SIA PARTNERS

Sia Partners is a next-generation consulting firm focused on delivering superior value and tangible results to its clients as they navigate the digital revolution. Our global footprint and expertise in more than 40 sectors and services allow us to enhance our clients’ businesses worldwide. We guide their projects and initiatives in strategy, business transformation, IT & digital strategy, and Data Science.

 

WHY JOIN THE SIA VILLAGE? 

Excellence | Entrepreneurship | Innovation | Teamwork | Care & Support | Employee Wellbeing

These are the six core values that guide all our actions. As an expression of our values, our Sia Village concept describes our commitment to fostering a sense of community within and among our offices. We believe that knowledge sharing is the key, not only to innovation, but to the growth and development of our people.

Job Description

Sia Partners is looking for a talented Data Engineer to support our activities within the Data Science Business Unit. You will be working alongside with our Data Science consultants and our clients on Data Engineering topics, including creating relevant data models, developing powerful data pipelines, exposing them through various mechanisms including APIs, and using data visualization tools to efficiently present data.

You will also contribute to internal Data Science projects posted on Heka, our internal accelerator for Data Science projects. As part of the global Data Science team you will contribute to the development of various solutions designed to address our clients' needs.

Key Responsibilities 

  • Partner with our client’s leadership teams, engineers, program managers and data analysts to understand data needs.
  • Design, build and launch efficient and reliable data pipelines transforming data into useful report ready datasets.
  • Communicate at scale, through multiple mediums: presentations, dashboards, client-wide datasets, bots and more.
  • Use your data and analytics experience to ‘see what’s missing,’ identifying and addressing data gaps, build monitors to detect data quality issues and partner to establish a self-serve environment.
  • Broad range of partners equates to a broad range of projects and deliverables, including ML Models, datasets, measurements, services, tools and process.
  • Leverage data and business principles to automate data flow, detect business exceptions, build diagnostic capabilities, and improve both business and data knowledge base.
  • Build data expertise and own data quality for your areas.
Qualifications

  • At least 4+ years' of advanced SQL experience (including at least one SQL DBMS and one noSQL).
  • 4+ years' of Python development experience.
  • 3+ years' of experience with workflow management engines (i.e. Airflow, Luigi, Prefect, Dagster, digdag.io, Google Cloud Composer, AWS Step Functions, Azure Data Factory, UC4, Control-M).
  • 3+ years' experience with Data Modeling.
  • Experience analyzing data to discover opportunities and address gaps.
  • 4+ years' experience in custom ETL design, implementation and maintenance.
  • Experience working with cloud or on-prem Big Data/MPP analytics platform (i.e. SnowFlake, Netezza, Teradata, AWS Redshift, Google BigQuery, Azure Data Warehouse, or similar).
  • BSc/BA in Data Science, Computer Science, Engineering.

Preferred Experience with:

  • Experience with more than one coding language.
  • Knowledge of Docker, CI/CD pipelines, and Kubernetes.
  • Experience in designing and implementing real-time pipelines.
  • Experience with data quality and validation.
  • Experience with SQL performance tuning and e2e process optimization.
  • Experience with anomaly/outlier detection.
  • Experience with notebook-based Data Science workflow.
  • Experience querying massive datasets, using Spark, Presto, Hive, Impala, etc.

 



Additional Information

Please be aware that Sia Partners requires all employees in this position to be fully vaccinated against COVID-19 as a condition of employment.  “Fully vaccinated” means that the individual can provide acceptable proof that the individual has received, at least fourteen (14) days prior to the individual’s start date, either the second dose of a two-dose COVID-19 vaccine, or one dose of a single-dose COVID-19 vaccine.  Vaccines must be authorized and/or approved by the FDA.  Individuals needing an exemption to this requirement due to medical, disability-related, or religious reasons may request an exemption during the recruiting process. The Company will engage in an interactive process to determine if an exemption to this requirement as a reasonable accommodation is appropriate.

Benefits:

  • Entrepreneurial journey
  • Career advocacy program that supports achieving professional development goals through guidance, and real-time feedback
  • Continuous learning & development opportunities
  • Diversity, equity, and inclusion programs with an ever-growing list of global affinity initiatives
  • Healthcare coverage that includes medical, dental, vision and life insurance policies
  • College save-up plan & college loan repayment plan
  • Generous vacation, sick, floating, and holidays, including parental leave
  • 401(k) matching
  • Annual seminar, an in-person value-add experience that allows you to network with colleagues throughout North and South America 
  • Compensation range is between $94,000-152,000 annually

Our Commitment to Diversity

Diversity, equity, inclusion, and belonging (DEIB) are part of Sia Partners’ DNA. Thanks to our expertise in several sectors and our international growth, our teams include a variety of experiences and cultures. We’re confident that promoting DEIB creates an environment in which everyone can reach their full potential.

Our global network, DEIB@Sia Partners, brings together our people worldwide to facilitate local and global progress, focused on the following areas:

  • Gender equality (global Gender Equality Index score of 91/100 for FY19-20)
  • LGBTQ+
  • Race & Ethnicity
  • Working Parents
  • Disabilities

Sia Partners is an equal opportunity employer. All aspects of employment, including hiring, promotion, remuneration, or discipline, are based solely on performance, competence, conduct, or business needs.

To learn more about our mission, values, and business sectors, please visit our website.

*Candidates must be located within commute distance of one of our three West Coast offices, San Francisco, Seattle and Denver. 

Sia Partners is an equal opportunity employer. All aspects of employment, including hiring, promotion, remuneration, or discipline, are based solely on performance, competence, conduct, or business needs. 

Sia Partners

Address

Palo Alto, CA
USA

Industry

Technology

View all jobs at Sia Partners