Overview
On Site
USD 80,000.00 - 160,000.00 per year
Full Time
Skills
Database design
Advanced analytics
Data governance
Data quality
Data warehouse
Application development
Data integrity
Emerging technologies
Performance tuning
Relational databases
File systems
Apache Airflow
Boomi
Enterprise resource planning
Problem solving
Organizational skills
Life insurance
Leadership
Data
Analytics
Design
Workflow
ELT
Collaboration
Management
Productivity
Optimization
SQL
Microsoft SSIS
Microsoft SSRS
OLAP
OLTP
Writing
Python
HTTP
SaaS
Amazon Redshift
Snow flake schema
Amazon Web Services
Cloud computing
Hosting
API
Salesforce.com
Tableau
Docker
Redis
Continuous integration
Continuous delivery
Health care
FAR
Recruiting
Military
Job Details
Duration: 6+ months
Location: OH-Columbus, Hybrid 1-2 days on site
Overview: Every Turnberry consultant belongs to a practice, an internal group of consultants and leaders with shared experience and expertise. Each of these practices aligns to one of the eight core services Turnberry offers to clients. As a Lead Data Engineer, you will join Turnberry's Data & Insights practice and service. Turnberry's Data & Insights service helps clients who seek visibility into company data, lack a single source of truth for accurate data, desire advanced analytics solutions, have data governance needs to ensure data quality, or have specific data challenges that may require an assessment, proof of concept, or custom solution not available in a typical out-of-the-box analytics methodology.
Responsibilities:
Apply advanced knowledge of technical concepts and principals to design and develop a variety of data warehousing and integration projects
Design, develop, and maintain accurate and timely data models to meet business needs
Develop and maintain extensible integration workflows and ELT jobs connecting internal business applications
Collaborate with application development teams to design and develop integrations that maintain data integrity
Participate in the gathering and refinement of project requirements with product managers and business stakeholders
Oversee deployments and support projects in production after release
Recommend new practices, processes, and procedures to improve quality and productivity
Review and approve changes to models and code
Stay current with emerging technologies and industry trends
Evaluate frameworks, technology, platforms, and tooling solutions
Qualifications:
7+ years of experience contributing to and supporting highly available, scalable, data systems
5+ years of experience with relational database design, implementation, and performance tuning optimization for MS SQL, SSIS, and SSRS
5+ years of experience building both OLAP and OTLP Data Platforms
3+ years of Experience writing data pipelines and tools using Python or similar languages
Experience integrating with Relational Databases, HTTP APIs, File Systems, and SaaS solutions
Experience with Redshift, Snowflake, Big Query, or other Data Warehousing solutions
Proficiency with AWS or other modern cloud hosting platforms
Proficiency with at least one major programing language and API framework
Experience with Apache Airflow is a plus
Experience with iPaaS Solutions such as Dell Boomi, Adeptia, etc is a plus
Experience integrating with ERP Systems, Salesforce, and/or Tableau is a plus
Experience with Docker, Redis, and CI/CD Pipelines is a plus
Strong problem solving and organizational skills
The salary range for this role is $80,000 to $160,000 or the hourly equivalent. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, Turnberry Solutions offers benefits such as a comprehensive healthcare package (medical, dental, vision), disability and group term life insurance, health and flexible spending accounts, a utilization bonus, 401(k) with match, flexible time off for salaried employees, parental leave for salaried employees, and flexible work arrangements (all benefits are subject to eligibility requirements). No matter where or when you begin a career with Turnberry, you'll find a far-reaching choice of benefits and incentives.
At Turnberry, inclusion is one of our core values. We are fully invested in and focused on hiring and growing a diverse team of high performers. We're committed to creating a positive and connected work environment for all. We believe that uniqueness in ideas, experiences, and backgrounds make us a better Turnberry: Turnberry is an Equal Employment Opportunity/Affirmative Action employer, and recruits, employs, trains, compensates, and promotes regardless of age, ancestry, family medical or genetic information, gender identity and expression, marital, military, or veteran status; national and ethnic origin; physical or mental disability; political affiliation; pregnancy; race; religion; sex; sexual orientation; and any other protected characteristics.
Location: OH-Columbus, Hybrid 1-2 days on site
Overview: Every Turnberry consultant belongs to a practice, an internal group of consultants and leaders with shared experience and expertise. Each of these practices aligns to one of the eight core services Turnberry offers to clients. As a Lead Data Engineer, you will join Turnberry's Data & Insights practice and service. Turnberry's Data & Insights service helps clients who seek visibility into company data, lack a single source of truth for accurate data, desire advanced analytics solutions, have data governance needs to ensure data quality, or have specific data challenges that may require an assessment, proof of concept, or custom solution not available in a typical out-of-the-box analytics methodology.
Responsibilities:
Apply advanced knowledge of technical concepts and principals to design and develop a variety of data warehousing and integration projects
Design, develop, and maintain accurate and timely data models to meet business needs
Develop and maintain extensible integration workflows and ELT jobs connecting internal business applications
Collaborate with application development teams to design and develop integrations that maintain data integrity
Participate in the gathering and refinement of project requirements with product managers and business stakeholders
Oversee deployments and support projects in production after release
Recommend new practices, processes, and procedures to improve quality and productivity
Review and approve changes to models and code
Stay current with emerging technologies and industry trends
Evaluate frameworks, technology, platforms, and tooling solutions
Qualifications:
7+ years of experience contributing to and supporting highly available, scalable, data systems
5+ years of experience with relational database design, implementation, and performance tuning optimization for MS SQL, SSIS, and SSRS
5+ years of experience building both OLAP and OTLP Data Platforms
3+ years of Experience writing data pipelines and tools using Python or similar languages
Experience integrating with Relational Databases, HTTP APIs, File Systems, and SaaS solutions
Experience with Redshift, Snowflake, Big Query, or other Data Warehousing solutions
Proficiency with AWS or other modern cloud hosting platforms
Proficiency with at least one major programing language and API framework
Experience with Apache Airflow is a plus
Experience with iPaaS Solutions such as Dell Boomi, Adeptia, etc is a plus
Experience integrating with ERP Systems, Salesforce, and/or Tableau is a plus
Experience with Docker, Redis, and CI/CD Pipelines is a plus
Strong problem solving and organizational skills
The salary range for this role is $80,000 to $160,000 or the hourly equivalent. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, Turnberry Solutions offers benefits such as a comprehensive healthcare package (medical, dental, vision), disability and group term life insurance, health and flexible spending accounts, a utilization bonus, 401(k) with match, flexible time off for salaried employees, parental leave for salaried employees, and flexible work arrangements (all benefits are subject to eligibility requirements). No matter where or when you begin a career with Turnberry, you'll find a far-reaching choice of benefits and incentives.
At Turnberry, inclusion is one of our core values. We are fully invested in and focused on hiring and growing a diverse team of high performers. We're committed to creating a positive and connected work environment for all. We believe that uniqueness in ideas, experiences, and backgrounds make us a better Turnberry: Turnberry is an Equal Employment Opportunity/Affirmative Action employer, and recruits, employs, trains, compensates, and promotes regardless of age, ancestry, family medical or genetic information, gender identity and expression, marital, military, or veteran status; national and ethnic origin; physical or mental disability; political affiliation; pregnancy; race; religion; sex; sexual orientation; and any other protected characteristics.