Data Engineering Senior Consultant

This job is posted in multiple locations. When not at a client site, consultants work from their home office. Relocation is not required.

Clarkston Consulting is seeking motivated, self-driven leaders who are energized by team results and interested in joining a firm that values its culture and people as its biggest strengths. Come join us as a Data Engineering Senior Consultant, and in this role, you will deliver creative business solutions to our market-leading clients in the life sciences, consumer products, and retail industries.

Together, we can find the answers to our clients' most challenging business problems through a combination of our industry expertise, business process knowledge, and consulting excellence.

As a Data Engineering Senior Consultant at Clarkston you will:

• Support solution architects, software developers, data analysts, and data scientists on data and analytics initiatives
• Serve in a lead capacity on client initiatives, collaborating with client stakeholders and technical teams to define and deliver data solutions
• Design, develop, and optimize scalable data pipelines and architectures that support client business requirements
• Develop and maintain data models and schemas to support analytics and reporting needs, including designing star and snowflake schemas and applying appropriate data modeling techniques
• Translate business requirements into technical data solutions and communicate technical concepts clearly to both technical and non-technical client stakeholders
• Ensure optimal data delivery architecture is consistent throughout ongoing projects
• Be self-directed and comfortable supporting the data needs of multiple teams, systems, and products
• Identify opportunities to improve data processes, scalability, performance, reliability, and automation
• Lead, grow, and mentor a data engineering team in developing, maintaining, and monitoring data solutions for clients
• Assist in defining client solutions, estimating work, supporting proposals, and managing solution delivery
• Contribute to project planning, status communication, and other consulting activities throughout the engagement lifecycle

Beyond your day-to-day responsibilities, throughout your career at Clarkston you will:

• Receive the support and mentorship of your Clarkston colleagues and leaders
• Expand your existing skillset with internal and external professional development opportunities

An ideal Data Engineer Senior Consultant would have experience:

• Assembling large, complex data sets that meet functional and non-functional business requirements
• Designing and implementing scalable data architectures, pipelines, and data solutions
• Applying data modeling concepts to create effective schemas, including star and snowflake schemas, based on business and analytical requirements
• Working with stakeholders to understand business needs and translate those needs into data and technical solutions
• Communicating recommendations, findings, and technical concepts effectively with client stakeholders and project teams
• Identifying and implementing internal process improvements, including automating manual processes, optimizing data delivery, and redesigning infrastructure for greater scalability
• Leveraging the appropriate infrastructure for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and big data technologies
• Building analytics tools and data solutions that provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics
• Working with cross-functional stakeholders, including Product, Data, Design, and business teams, to address data-related technical issues and support data…