Cuesta Partners is a technology strategy consulting firm that supports organizations throughout their technology journey. Our Focus - We help firms consider or prepare for acquisition by improving their data posture. - We assist in developing new products, revitalizing existing ones, restructuring teams, or adopting new practices and tools, including modern data technologies. - We guide leadership in developing vision, direction, and scalable strategies for their technology business, including implementing comprehensive data programs. We believe in the power of technology to create sustained, differentiated advantage for our clients. We are a dynamic, innovative firm that challenges convention, moves quickly, and fosters ongoing personal growth. About the Role We are seeking a senior data engineer with an interest in consulting to work with our diverse client base on various projects, delivering data environments efficiently using modern technologies and best practices. This role involves shaping and developing new areas, making a lasting impact on our clients' data landscape. You will collaborate closely with leadership to ingest data for strategic business domains, enabling analytical insights. Your expertise in developing and optimizing data pipelines will be crucial for advancing our data initiatives. Key Responsibilities Technical Expertise - Develop data pipelines: create code for data ingestion, following best practices, company standards, and data models, with design recommendations as needed. - Maintain effective communication with team members for best practices and continuous improvement. - Triage and diagnose system or performance issues, supporting critical business operations. - Propose solutions, outline dependencies, and escalate issues when necessary. Development Leadership - Establish communication with project teams. - Support business during critical system events. - Follow IT auditing and access control policies. - Assist with troubleshooting, bug fixing, and escalation processes. - Mentor junior developers to enhance team skills. We are looking for a highly skilled Senior Data Engineer to join our team. If you have a passion for data engineering and consulting, we encourage you to apply. Requirements - 8-12 years of relevant experience in data engineering. - Extensive SQL development and querying experience. - Experience with ETL tools such as Keboola, FiveTran, Matillion, DBT, SSIS, Alteryx, etc. - Experience with Snowflake, SQL Server, or other data warehouse technologies like BigQuery, AWS Redshift, Microsoft Synapse, or Oracle. - Expertise in relational databases, database design, systems design, data management, and data warehousing; advanced programming skills. - Proficiency in scripting languages such as Python or R. - Knowledge of data modeling and various data structures. - Critical thinking and problem-solving skills. - Excellent communication and interpersonal skills. - Bachelor's degree in computer science, software engineering, or related fields. - Big data tools experience such as Spark, Hadoop, NoSQL is a plus. Please note that occasional travel within the United States may be required for critical sessions.