Share this Job
Jun 7, 2021

Bethlehem, US, 18015

Sr. Data Engineer


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.

Our Headquarters is located in the heart of the Lehigh Valley in historic Bethlehem, PA. While our roots are in direct marketing and we have a strong eCommerce and growing brick and mortar retail presence. We have three (3) Retail locations in Pennsylvania, two (2) in Texas, two (2) in Florida and soon to be more.



Our organization is all about creating moments of great enjoyment for smokers. This promise has made us a world-leading manufacturer of cigars and traditional pipe tobacco. When you join our company, you will be part of an industry that is constantly changing. It takes a team of quick minds to grow and thrive, even when you deliver high quality, natural products like ours. That’s why we look for smart, tenacious people who will go that extra mile.


In return, we offer you the opportunity to challenge the status quo. We’ll give you the freedom to question the way we do things and room to explore as far as your talent will take you. It is our belief that smoking tobacco involves a health risk and is habitual. Smoking is a choice made by adults, and nobody under the age of 18 should smoke. We welcome both smokers and non-smokers.


Position Description:

The Senior 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. This role will ensure data pipelines are scalable, repeatable, and secure, and can serve multiple business units within the organization. Facilitate data collection and movement between a variety of different sources, analyze data from the various sources and produce meaningful reports and/or presentations.

Primary Responsibilities:

  • Write and edit automated jobs that import and export data between systems.
  • Provide detailed analysis, design, tuning, testing, implementation and documentation of the business intelligence system and data warehouse.
  • Provide expertise in writing and editing queries that read, manipulate, and analyze data from business intelligence, relational databases, and data warehouses.
  • Responsible for business intelligence quality testing, stakeholder approval and user acceptance testing.
  • Create tables and write reports on their findings, validating data output through SQL and simplify highly technical language for end users in the company.
  • Translate business requirements into system requirements and assess where support is needed relative to existing technical system design.
  • Participate in creating strategies and roadmaps for business intelligence and data platforms.
  • Ability to learn and utilize programs to analyze data from different sources and produce meaningful reports and/or presentations.
  • Contribute to the development of standards and processes for integration projects and initiatives.
  • Work with other developers to make sure that all data solutions are consistent.
  • Create data flow diagrams for data management systems.
  • Creation of a data catalog.
  • Work with other development teams to review and approve database changes according to database design standards and principles.
  • Resolve conflicts between models, ensuring that data models are consistent with the ecosystem model (e.g., entity names, relationships, and definitions).
  • Code, test, and document new or modified data systems to create robust and scalable applications for data analytics.



Required Skills


  • Bachelor’s degree in computer science, computer engineering, or similar technical discipline or equivalent work experience.
  • Minimum 2 - 3 years’ experience creating reports using SQL Server Reporting Services (SSRS) writing complex stored procedures and functions. Experience with Tableau or Power BI a plus.
  • Advanced level of programming knowledge (reporting code) and of relational databases, database structures and design, systems design, data management, data warehouse a plus.
  • Advanced knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use cases.
  • Proven experience working hands-on with big data systems.
  • Experience with monitoring, backup, and disaster recovery of data systems.
  • Substantial knowledge of different programming or scripting languages.



We value our employees and in addition to our competitive salaries, we offer a competitive benefit package to our talented team members including:


  • 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


Bethlehem Shared Services, LLC.  is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.


Nearest Major Market: Allentown