Senior Data Engineer (North America)

Cuesta Partners; Chicago (IL); Remote; USD 90,000 - 150,000; Full time

Job summary

An innovative technology strategy consulting firm is seeking a Senior Data Engineer to join their dynamic team. This remote role offers the chance to lead data-driven initiatives, develop scalable data solutions, and mentor junior developers. You will play a pivotal role in shaping the data landscape for a diverse range of clients, utilizing your expertise in modern data technologies and best practices. If you are passionate about leveraging data to drive strategic decisions and enjoy working in a collaborative environment, this opportunity is perfect for you. Join a forward-thinking company that values personal growth and challenges convention.

Qualifications

• 8-12 Jahre Erfahrung in der Datenengineering-Branche, insbesondere in Data Warehousing.
• Erfahrung in SQL-Entwicklung und Abfragen sowie ETL-Tools.

Responsibilities

• Entwicklung von Datenpipelines und Code für Datenaufnahme-Schnittstellen.
• Mentoring von Junior-Entwicklern zur Verbesserung der Teamleistung.

Skills

Data Engineering

SQL

ETL Tools

Data Warehousing

Python

Spark

Data Modeling

Problem Solving

Communication Skills

Tools

Keboola

FiveTran

Matillion

DBT

SSIS

Alteryx

Snowflake

SQL Server

Databricks

BigQuery

AWS Redshift

Microsoft Synapse

Oracle

Job description

Senior Data Engineer

Remote, US or Canada

Cuesta Partners is looking for a data and digital technology expert with an interest in consulting to work with our broad base of clients on various engagements ranging from larger portfolio company strategy to specific data analyses. As a delivery lead/manager, this role is responsible for leading teams to deliver data environments quickly using modern technologies and best practices.

About Cuesta Partners

Cuesta is a technology strategy consulting firm supporting organizations of various sizes throughout their technology journey. We help firms:

1. Consider or prepare for acquisition – often by improving the company’s data posture.
2. Navigate new product development or re-invigoration, new team structures, or adopting new practices and tools – including the use of modern data technologies.
3. Guide leadership teams in developing vision, direction, and scalable strategies for their technology business – including implementation of comprehensive data programs.

We believe in the power of technology to create sustained, differentiated advantages for our clients. We are a unique, energetic firm that believes in challenging convention, moving quickly, and seeking ongoing personal growth. Every team member has agency in helping to build the firm where they've always wanted to work. Sound like you?

As a member of our data service line, you will have the unique opportunity to shape and build various green field areas, making a lasting impact on our clients’ data landscape. Collaborating closely with leadership, you will play a key role in establishing technology best practices to deliver analytical insights for customers in strategic domains. Your mission will be to deliver end-to-end data solutions, leveraging your expertise to unlock valuable insights and drive actionable decisions. As the driving force behind the acquisition and transformation of data sets, your contribution will be key to unlocking analytics insights from our client’s data. You will ensure that data models are reusable, data pipelines are scalable, and data visualizations are impactful. Your expertise in choosing, developing, and optimizing data technology environments will be instrumental in driving our data-driven initiatives forward. This leadership role ensures that development follows standards, specifications, controls, audits, and procedures to ensure data integrity, quality, accuracy, usefulness, and timeliness. While the role is remote, occasional though infrequent travel may be required for some critical sessions.

What We're Looking For

1. 8-12 years of relevant experience as a Data Engineering Professional with emphasis in data warehousing or data lake applications.
2. Significant development and querying experience in SQL.
3. Experience with ETL tools such as Keboola, FiveTran, Matillion, DBT, SSIS, Alteryx, etc.
4. Experience with data warehousing technologies such as Snowflake, SQL Server, Databricks, BigQuery, AWS Redshift, Microsoft Synapse, or Oracle.
5. Expertise in relational databases, database structures and design, systems design, data management, and data warehouse; advanced programming skills.
6. Proficiency in Python, Spark.
7. Expertise in data modeling, including knowledge of various data structures and their advantages and disadvantages in certain use cases.
8. Capability to think critically and solve problems.
9. Excellent communication and interpersonal skills.

What You'll Do

Technical Expertise

1. Develop data pipelines: develop code for data ingestion interfaces to meet specifications required by analytics teams, following best practices, company standards, and adhering to data models outlined by data architects – making design recommendations as appropriate.
2. Stay abreast of emerging technologies and industry trends, identifying new tools and practices that can help the company achieve its strategic goals.
3. Establish close communication with team members to align best practices, exchange information effectively, and collaborate for continuous improvement.
4. Quickly triage and diagnose system or performance issues and support the business during critical downtimes and releases.
5. Act as the technical expert, proposing solutions to roadblocks, outlining dependencies/constraints, and escalating problems as appropriate.

Development Leadership

1. Establish consistent communication mechanisms with project delivery teams.
2. Support the business during critical downtimes and releases.
3. Follow all IT auditing and systems access control processes.
4. Support interfaces as necessary through troubleshooting, bug-fix, and escalations.
5. Mentor junior developers to improve team performance and empower others.
6. Establish relationships across the organization to build networks and leverage experts.