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.