WHO WE ARE:
Keyrus US is part of the Keyrus entity - a global data analytics consultancy with over 25 years of experience - and over 3,000 consultants in 26 countries. We partner with our clients on advisory and strategy services and complete technical implementation capabilities focusing on data governance, change management, data intelligence, cloud and security, data engineering, visualization, and data science. Keyrus US is at an exciting time! We're aligning with the Keyrus Americas team, including US/Canada/Latam to leverage our offerings, clients, and team members.
THE ROLE:
As a part of the Keyrus team, you will:
Technical/Development: Hands-on independently and/or with Tech Leads, with Cloud-based technologies (i.e., Snowflake, Databricks), creating data pipelines and orchestration to integrate systems.
Gather and clarify requirements from stakeholders.
Lead design and development of data solutions.

• Data extraction and ingestion methods
• Data loading patterns
• Data modelling
• Process orchestration
• Converting business logic to technical specifications
• Data security

Take ownership of technical processes

• Code reviews
• Data platform architecture: Data Security, Data sharing, Role and data object provisioning
• ELT performance tuning
• Data cataloging and lineage

REQUIREMENTS:

• 5 years of experience in data engineering, preferably in consulting
• Data warehouse modelling techniques (star schema, 3rd normal form, data vault, data lakehouse)
• Advanced knowledge of SQL
• Deep knowledge of modern data warehouse platforms (Snowflake, Databricks, Redshift, Azure Synapse)
• Proficiency in developing ELT pipelines (Talend, Glue, ADF)
• Storing, organizing, and archiving data within a data lake (S3, ADLS)
• Cloud platform data services (S3, Lambda, EC2, Step Functions or other cloud equivalents)
• Access control and data sharing
• Excellent communication and organization skills
• Object Oriented Programming experience is a plus (python, scala, java)

Eligibility to work in the US without sponsorship is required.
Compensation Range
The compensation range for this position is 120,000.00 USD - 140,000.00 USD. Our offer will be based on your relevant experience and work location.
Department Data Intelligence Role Senior Consultant Locations Boston, MA, Chicago, Columbus, Los Angeles, CA, Miami, FL, New York, NY, Washington, DC Remote status Fully Remote