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 Senior Data Modeler 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.

What You’ll Do 

As a Senior Data Modeler 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

How You’ll Grow
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

Requirements

What We're Looking For:

An ideal Senior Data Modeler candidate would have experience:

• Re-engineering one or more modules and associated reports within Databricks environment
• Documenting existing data models and designing the future state data models and architecture, following the set guidelines and standards
• Analyzing existing data models, reports and analysis
• Owning delivery of data products specific to a module or functional area
• Designing and developing data models and transformations using notebooks and pipelines within Azure Databricks
• Serving in role of a hands-on Data Engineer
• Applying expertise in Databricks, Azure Data Factory, SQL, PySpark, and Python
• Developing data management solutions using data lake platform tools and technologies
• 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:

• 3+ years of experience in a Data Modeler 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
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• A 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
• Experience supporting and working with cross-functional teams in a dynamic environment
• Experience 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

Travel Requirement
Travel is an integral part of this role and is estimated to average 30-50%. This may vary based upon client and project needs. When not traveling, consultants work from their home office. Relocation is not required.

More About Clarkston

Founded in 1991, Clarkston Consulting delivers technology and management solutions to market leaders in the life sciences, consumer products, and retail industries. At Clarkston, we cultivate success - for our clients, for our people, and for our firm. We utilize a team approach leveraging our collective expertise and industry knowledge to solve our clients’ business challenges.

AI Statement

Clarkston values thoughtful and responsible AI use for resume writing, interview preparation, and research. However, real-time use of AI to generate or script answers during interviews - including video or live conversations - is strictly prohibited and will lead to disqualification. We seek candidates who show authenticity, good judgment, and genuine engagement throughout the process.

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

We strive to ensure that every candidate has an equitable and accessible experience. If you are selected to move forward in the interview process, we will share information about how to request any accommodations. You may also request support at any point during the hiring process.

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.