Data Engineer focused on building and maintaining data pipelines using SQL Server and T - SQL. Designing data solutions for reporting and analytics from various internal and third - party systems.
About the role
- Senior Data Engineer Consultant delivering innovative solutions for life sciences, consumer products, and retail clients. Mentoring teams and optimizing data engineering processes.
Responsibilities
- **What You’ll Do**
- As a Data Engineer Senior Consultant at Clarkston, you will:
- Support our solution architects, software developers, data analysts, and data scientists on data and analytics initiatives
- Serve in a lead capacity on client initiatives
- 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
- Be excited by the prospect of building our company’s data engineering capabilities to support our next generation of products and data initiatives
- Lead, grow, and mentor a data engineering team in developing, maintaining, and monitoring data solutions for clients
- Assist in defining client solutions and support managing their delivery
Requirements
- *What We’re Looking For:*
- An ideal Data Engineer Senior Consultant candidate will have experience:
- Assembling large, complex data sets that meet functional / non-functional business requirements
- Identifying, designing, and implementing internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
- Leveraging the appropriate infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and ‘big data’ technologies.
- Building analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics
- Working with stakeholders - including the Product, Data, and Design teams - to assist with data-related technical issues and support their data infrastructure needs
- Additional Qualifications:
- Hands-on experience designing, developing, and optimizing data solutions using Microsoft Fabric
- 5+ years of experience in a Data Engineer role
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
- Experience building and optimizing ‘big data’ data pipelines, architectures and data sets
- Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
- Strong analytic skills related to working with unstructured datasets
- Knowledge of build processes that support data transformation, data structures, metadata, dependency, and workload management
- Successful history of manipulating, processing and extracting value from large, disconnected datasets
- Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores
- Skilled in project management, including managing project plans, timelines, and deliverables
- Experience supporting and working with cross-functional teams in a dynamic environment
- Demonstrated ability with big data tools including Databricks, Spark, Snowflake, Airflow, and Kafka
- Expertise with Azure or AWS cloud services
- Experience with object-oriented/object function scripting languages such as Scala, Python, Java, and / or C++
- Graduate degree in Computer Science, Statistics, Informatics, Information Systems or an equivalent field
Benefits
- *Our benefits include: *
- Comprehensive Health and Wellness Benefits (Medical, Dental, Vision, and more)
- 401k with company contributions
- Paid vacation, personal days, holidays, and sick leave
- Paid Parental Leave and Family Building Benefits (Adoption, Surrogacy, and Infertility Support)
- Life and Disability Insurance
- Training and Professional Development investments, Tuition Assistance, and more
- Visit Careers at Clarkston to learn more about our culture, benefits, and opportunities.
- Clarkston Consulting is an equal opportunity employer. We are committed to ensuring our firm is rich in diverse skills, competencies, strengths, personalities, and culture. We foster an inclusive environment that embraces the unique contributions of our people to further our purpose. Please visit Diversity @ Clarkston to learn more about our diversity initiatives.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Data Engineer developing innovative data driven solutions to simplify organization and enhance customer value. Leading design and delivery of scalable data architectures and pipelines for business success.
Data Engineer responsible for building scalable data solutions and collaborating with various teams. Focused on data extraction, transformation, and maintaining optimal architecture.
Data Engineer designing and automating data engineering pipelines at VP level in financial services. Building scalable data architecture and contributing to innovative customer experiences.
undefined
Senior Data Engineer building near real - time data solutions for Aircall's customer communications platform. Joining a collaborative engineering team focused on scalability and performance optimization.
Senior Data Engineer managing analytics and event platform stack at Aircall. Building features for over 22,000 customers and unlocking the value of data.
Staff Data Engineer designing next - gen data platforms and pipelines at CommBank. Integrating data sources and ensuring high - quality, scalable data products while collaborating with Business Banking technology teams.
Senior Data Engineer optimizing and industrializing data pipelines for AI products, ensuring data quality and performance across the lifecycle. Collaboration with cross - functional teams is crucial for this role.
Senior Data Engineer supporting critical banking insights at Smile. Driving data solutions and reporting in a collaborative environment across Brussels' financial sector.