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:

Charlotte compensation for this role is between $80,000 to $104,000 per year. Actual compensation within that range will be dependent upon the