Apply on Employer Site

Clarkston Consulting · 4 hours ago

Data Engineer Senior Consultant

Philadelphia, PA

Full-time

Hybrid

Senior Level

5+ years exp

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. In this role, you will deliver creative business solutions to clients in the life sciences, consumer products, and retail industries, supporting data and analytics initiatives while leading a data engineering team.

ConsultingConsumer GoodsInformation TechnologyLife ScienceRetail

Growth Opportunities

H1B Sponsor Likely

Responsibilities

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

Qualification

Data EngineeringSQLBig Data TechnologiesMicrosoft FabricData Pipeline OptimizationAzureAWSPythonAnalytic SkillsProject Management

Required

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

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

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

Company

Clarkston Consulting

Glassdoor4.0

Companies in life sciences, consumer products, and retail, partner with Clarkston to promote business growth and implement new technology.

Founded in 1991

Durham, North Carolina, USA

201-500 employees

http://clarkstonconsulting.com/

H1B Sponsorship

Clarkston Consulting has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (1)

2022 (1)

2021 (1)

2020 (3)