Data Engineer

Company Description
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

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.

Additional Information
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 $90,000 to $116,000 per year. Actual compensation within that range will be dependent upon the individual's skills, experience, qualifications, and market location.
Work Authorization & Sponsorship
At this time, Sia Partners does not intend to pursue employment with applicants who require/will require sponsorship for work authorization in the United States (i.e., H1-B visa, F-1 visa (OPT), TN visa, or any other non-immigrant status). Applicants for employment must have work authorization that does not now or in the future require sponsorship of a visa for work authorization.
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. At this time, in person requirements are issued by departments (Business Unit/Business Line) and vary by office location. Consultants are expected to have the ability to be flexible with work location depending on business needs and live within a reasonable distance to the office.
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.
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.