Data Engineer

Sia Partners is a next-generation consulting firm dedicated to creating state-of-the-art narratives for transformation and innovation and deploying them at scale. Our goal is to deliver superior value and tangible results to our clients as they navigate the digital revolution and achieve transformations which generate a positive impact. 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.

Your experience at Sia Partners will be enriched by a(n):

• 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
• Annual seminar, an in-person value-add experience, that allows you to network with colleagues throughout North America

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.

• 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.

Compensation & Benefits

• Salary + Annual Discretionary Bonus
• Healthcare coverage that includes medical, dental, vision and life insurance policies
• Generous time off
• Parental leave paid at 100% of base pay for all new parents regardless of gender
• Future Moms Program
• 9 Company Holidays + 1 Floating Holiday
• 401(k) matching
• College save-up plan & college loan repayment plan
• Monthly cell phone stipend
• Commuter Benefits
• Gym Reimbursement through firm medical plan

Compensation Information:

California compensation for this role is between $94,000 to $122,000 per year. Actual compensation within that range will be dependent upon the individual’s skills, experience, qualifications, and market location.

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.

Covid-19 Update

Please note that, to the extent permitted by state and local law, 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 both doses of a two-dose COVID-19 vaccine plus all boosters recommended for you, or one dose of a single-dose COVID-19 vaccine plus all boosters recommended for you. Vaccines must be authorized and/or approved by the FDA. The Company will engage in an interactive process to determine if an exemption to this requirement as a reasonable accommodation is appropriate.

Hybrid Workplace Guidelines

Sia Partners maintains its hybrid workplace arrangements and provides a flexible workplace environment that is driven by client and business/market needs. While our firm does support hybrid work, there are times that we may require our consultants to work onsite at one of our Sia offices or a client office full-time. Consultants are expected to have the ability to be flexible with work location depending upon business needs. When in-between client engagements, Consultants typically work onsite at a local Sia office 2+ times per week.

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

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.