Data Engineer
New York, NY, United States
Full Time Senior-level / Expert USD 90K - 116K
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. We guide their projects and initiatives in strategy, business transformation, IT...Company Description
Sia Partners is a next-generation management consulting firm. We offer a unique blend of AI and design capabilities, augmenting traditional consulting to deliver superior value to our clients. Counting 3,000 consultants in 19 countries, we expect to achieve USD 420 million in turnover for the current fiscal year. With a global footprint and expertise in more than 30 sectors and services, we optimize client projects worldwide. Through our Consulting for Good approach, we strive for next-level impact by developing innovative CSR solutions for our clients, making sustainability a lever for profitable transformation.
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.
Tags: Airflow APIs AWS Azure Big Data BigQuery Computer Science Consulting Consulting firm Dagster Data pipelines Data quality Data visualization Data warehouse Engineering ETL GCP Google Cloud Machine Learning ML models MPP NoSQL Pipelines Python Redshift Snowflake SQL Step Functions Teradata
Perks/benefits: Career development Cell phone stipend Equity / stock options Fitness / gym Flex hours Flex vacation Health care Medical leave Parental leave Salary bonus
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.