Data Engineer

Company Overview

Bethlehem Shared Services provides professional services exclusively for Cigars International, CIGAR.com, Pipes & Cigars, Thompson Cigar, Meier & Dutch, Cigarbid.com and its affiliates. We are the fastest growing cigar company in the country, and leading online and direct marketer of fine cigars, premium pipe tobaccos, luxury gifts and accessories, and more.

While our roots are in direct marketing, we have a strong eCommerce and growing brick and mortar retail presence. We have 4 retail locations in Pennsylvania, 5 in Texas, 3 in Florida, 1 in Tennessee and soon to be more.

ABOUT THE ROLE –

The Data Engineer ensures that the infrastructure handles diverse sources of data seamlessly, understands data analysis, end-user requirements analysis, and business requirements analysis to develop a clear understanding of the business needs and to incorporate these needs into technical solutions. S/he will design, develop, and maintain data pipelines, integrate with new technologies, and oversee the development of new data managed processes that support key customer facing functions.   This role will ensure data pipelines are scalable, repeatable, and secure, and can serve multiple business units within the organization. You will facilitate data collection and movement between a variety of different sources, analyze data from the various sources and produce meaningful reports and/or presentations.  Delivery from this team will be based on DevOps model where it is not only about delivering business value but also about reliability, agility, and scalability.

WHAT WILL YOU BE RESPONSIBLE FOR?

• Implement data integration projects, including developing a data model, maintaining a data warehouse and analytics environment, and writing scripts for data integration and analysis.
• Build and maintain optimized and highly available data pipelines that facilitate deeper analysis and reporting by the Data and Analytics department.
• Analyze, transform, and prepare data for large scale migration projects.
• Identify and work on master data consolidation and management as part of data migration.
• Develop automated workflows to perform data migrations using both on-premises and cloud-based technologies
• Create complex stored procedures, views, materialized views, functions, and other database objects using TSQL as required.
• Design, implement, test, deploy, and maintain stable, secure, and scalable data engineering solutions and pipelines in support of data and analytics projects, including integrating new sources of data into the central data warehouse, and moving data out to applications and affiliates.
• Produce scalable, replicable code and solutions that help automate repetitive data management tasks.
• Perform one-off data manipulation and analysis
• Implement and monitor best in class security measures in our data warehouse and analytics environment, with an eye towards the evolving threat landscape.
• Design robust integration solution error handling, monitoring, and reporting ensuring early detection and resolution of issues.
• Perform in-depth data analysis to validate system behavior, identify problems, and support business users
• Collaborate with application and IT system administration teams as required and make recommendations on SQL Server sizing and configuration, database design and features, or T-SQL query tuning/best practices

WHAT SKILLS AND EXPERIENCE WILL BE REQUIRED?

• Bachelor’s degree in computer science, computer engineering, or similar technical discipline or equivalent work experience.
• Intermediate+ proficiency with Python, especially for data manipulation and analysis, and ability to build, maintain and deploy sequences of automated processes.
• 2+ years of experience on MS SQL Server, writing complex stored procedures and functions and working on ETL pipelines.
• Advanced level knowledge of relational databases, database structures and modeling, systems design, data management, data warehouse a plus.
• Proven experience working hands-on with big data systems.
• Extensive experience on writing complex SQL Queries to analyze and transform data sets
• Experience in master data management for large scale implementations
• Experience in debugging and identifying gaps in data elements
• Experience in working on data migration projects with large data sets
• Experience and high proficiency in
  • Microsoft SQL Server        
  • T-SQL query language
  • Python Programming Language a must
  • SQL Server Management Studio (SSMS)
  • JSON and XML
  • Azure Data Bricks / Azure Data Factory is a plus
  • PowerShell is a plus
• Release management (Git, Visual Studio, etc.) is a plus
• Experience with Microsoft Azure a plus.
• Experience with data mapping and various data types
• Excellent communication skills
• Strong logical, analytical, and problem-solving skills
• Can work in a fast paced, ever-changing environment with a growth mindset

WHAT IS ON OFFER?

As a colleague at Scandinavian Tobacco Group, you will receive a comprehensive compensation package as a generous benefits package.

• Comprehensive Health Care, Vision & Dental Plan
• Flexible Spending Account
• Disability Plans
• Basic & Supplemental Life Insurance
• Additional Supplemental Benefits
• Paid Vacation, Paid Time Off (PTO) days, Holidays
• 401(k) Retirement Saving Plan including a generous Company match

ABOUT SCANDINAVIAN TOBACCO GROUP

At Scandinavian Tobacco Group, we always encourage you to craft the career that makes you more. We have a rich heritage that dates back 250 years and have been operating as a Scandinavian Tobacco Group since 1961. We operate in over 100 countries, employing over 10,000 people. We offer a diverse portfolio of iconic brands ranging from Signature, Cohiba, Macanudo, CAO, Partagas and most recently branched into smokeless tobacco through our recent acquisition of XQS. We are on a mission to focus on sustainability and minimizing our environmental footprint. We are committed to creating a culture that allows us to blend our strengths, to go far it takes a winning team, and this is why we pride ourselves on sharing our skills, knowledge and expertise to push each other forward.

Our company uses E-Verify to confirm the employment eligibility of all newly hired employees.  To learn more about E-Verify, including your rights and responsibilities, please visit www.e-verify.gov.