Sr. ETL Developer

2 weeks ago

Niles, United States The Bradford Hammacher Group Full time
Impassioned...Emboldened...Infinitely Curious: The Bradford Exchange, part of The Bradford Hammacher Group family of brands, is a world leader in new product development. We have been selling joy for the last 50 years Our global organization consists of 8 business divisions ranging from jewelry, apparel, collectible coins, home decor to holiday and so much more. We concept, create, design and market our creative products directly to our customers, and leverage licenses with the biggest names in entertainment and sports to bring unique and curated products to our customers across the globe.

We are hiring a Senior ETL Developer who will create, implement, and enhance ETL processes for a variety of data sources using standard SQL, SSIS or ETL equivalent tools. Apply proven communication, analytical, and problem-solving skills to fully support the development process, and ensure that project deliverables are met according to specifications and within the project timelines.

How you will contribute:
  • Participate in the design, development, and analysis of data integration projects and tasks throughout the product life cycles. Locate, analyze and profile source data to assess the quality, and inform business logic. Design and execute highly complex integration workflow tasks that cover multiple business, technical, and/or application areas.
  • Contribute to database design and data modeling efforts.
  • Design and develop queries for a high-performance environment. Evaluate and fine-tuning SQL queries for performance and monitor latencies during processes.
  • Implement and monitor the deployment of data integration projects
  • Provide performance analysis and improvement guidance for ETLs
  • Identifying data quality issues and offering potential solutions to cleanse or improve data quality
  • Troubleshoot data issues, validate result sets, recommend and implement process improvements
  • Creating/updating related documentation
  • Available to provide operational support during non-standard business hours, and participate in an on-call rotation for production support of related technical systems.
What you will bring and skills that excite us:
  • Bachelor's degree computer science or related
  • 7-10 years of related industry experience
  • SQL Server Integration Services (SSIS)
    • SSIS project design and analysis
    • Performance tuning of SSIS packages
    • Experience with most SSIS components, tasks, and transformations
    • Execute Script tasks using .net and stored procedures
  • General ETL Skills
    • Full and Incremental loads; De-duplication of records; Transforming data;
    • Creating and processing junk dimensions, bridge tables, and degenerate dimensions
    • Aggregate tables, staging, upsert/merge, surrogate key management
    • Working with an established ETL Framework or architectural model
  • SQL Server Skills & Experience (other)
    • Deploying SSIS packages, and working with Integration Services Catalog
    • Documenting SSIS packages, DB maintenance, programs and systems
    • SQL Server 2014, 2016, and above
    • Database performance & query tuning analysis
    • Database Administrator experience
  • Excellent verbal and written communication skills
  • Participate on large, enterprise-scale projects, with diverse project teams
BHG at a glance:
  • Our scale: We have over 400 employees based out of our global headquarters right outside of Chicago, we have marketing operations in over 10 countries worldwide, and have over 32 million customers served.
  • Compensation and benefits: We offer a competitive compensation plan and great benefits, with some benefits starting from day 1
  • We own the company: BHG is Employee Stock Ownership Plan (ESOP) which allows you to not only derive the benefits of working as an employee at The Bradford Hammacher Group, but also gain the benefits of being an owner.
  • Professional Development: There is always room to learn We offer a Professional Development Program, a Mentor Program, and LinkedIn Learning to our teams as well as additional hands-on training and development. Our teams utilize a continuous performance management and development structure for feedback, no dreaded annual reviews. We meet quarterly to focus on the future
  • Our values: Honesty. Innovation. Respect. Teamwork. Giving back. These are just some of the core values that drive our team members. Our team strives to build a culture of continuous feedback where anyone can share and create our "next big idea," among diverse and inclusive teams.
  • Flexibility and wellness: Whether it's offering hybrid environment (onsite/remote) for our corporate staff, to a generous, front-loaded PTO and holiday package to all staff and corporate wellness initiatives like WW, an annual health fair and an onsite gym, we are committed to our team members well-being. New hires start with 16 days of PTO and 8 paid holidays per year.
  • Perks and more: We have a Business Casual Work Environment, Health and Dental Insurance, Life Insurance, Disability Insurance, Paid Time Off (PTO) Program, Direct Deposit, Credit Union, Flexible Spending Accounts, Employee Assistance Program, Employee Referral Bonus Program, 401(k), Profit Sharing, Tuition Reimbursement, onsite fitness center, Cafe providing complimentary lunch, a Peer Recognition Program, Product Discounts and more


The Bradford Exchange is an Equal Opportunity Employer.

#LI-Hybrid

  • Sr. ETL Developer

    5 days ago

    Niles, United States The Bradford Exchange Ltd Full time

    Overview: ImpassionedEmboldenedInfinitely Curious: The Bradford Exchange, part of The Bradford Hammacher Group family of brands, is a world leader in new product development. We have been selling joy for the last 50 years! Our global organization consists of 8 business divisions ranging from jewelry, apparel, collectible coins, home decor to holiday and so...

  • Sr. ETL Developer

    2 weeks ago

    Niles, Illinois, United States The Bradford Hammacher Group Full time

    Overview: Impassioned…Emboldened…Infinitely Curious: The Bradford Exchange, part of The Bradford Hammacher Group family of brands, is a world leader in new product development. We have been selling joy for the last 50 years! Our global organization consists of 8 business divisions ranging from jewelry, apparel, collectible coins, home decor to vacation...

  • ETL Developer

    1 week ago

    Niles, United States Hirewell Full time

    Senior ETL DeveloperJoin our team as a Senior ETL Developer, where you'll take the lead in crafting, implementing, and refining ETL processes across various data sources using standard SQL, SSIS, or equivalent ETL tools. Leverage your stellar communication, analytical prowess, and problem-solving skills to seamlessly support the development lifecycle,...

  • ETL Developer

    1 week ago

    Niles, United States Hirewell Full time

    Senior ETL DeveloperJoin our team as a Senior ETL Developer, where you'll take the lead in crafting, implementing, and refining ETL processes across various data sources using standard SQL, SSIS, or equivalent ETL tools. Leverage your stellar communication, analytical prowess, and problem-solving skills to seamlessly support the development lifecycle,...

  • Engineer Sr, DevOps

    1 week ago

    Niles, United States Shure Incorporated Full time

    Engineer Sr, DevOpsJob ID 2024-3592Category Software EngineeringJob LocationsUS-IL-NilesWorkplace Arrangement RemoteOverviewReady to Rock the Cloud? Join Shure's DevOps All-Stars! For over 95 years, Shure has been the top pick for professional audio technology, ensuring exceptional performance in every note. Our global partner network spreads our...

  • Engineer ll, Corporate Quality

    5 days ago

    Niles, United States Shure Incorporated Full time

    Engineer ll, Corporate Quality Job ID 2023-3575 Category Engineering Job Locations US-IL-Niles Workplace Arrangement Hybrid Overview Under general supervision of the Sr. Manager CQE, provides Quality Engineering services to Manufacturing, Engineering, Sales, Service, and Plant Quality....

  • Engineer ll, Corporate Quality

    4 weeks ago

    Niles, United States Shure Full time

    Overview: Under general supervision of the Sr. Manager CQE, provides Quality Engineering services to Manufacturing, Engineering, Sales, Service, and Plant Quality. Plans, develops, implements, and maintains quality standards for Shure products. Ensures that quality standards and requirements are met. Responsibilities: Develops and implements quality...

  • Buyer

    3 weeks ago

    Niles, United States Woodward Full time

    Job Description - Buyer (2101575) **Job Description** Buyer - 2101575 **Description** **Position Purpose** Under the direction of COE Procurement, the Buyer creates, reviews and maintains valid plans of material and manages the supply base in order to meet customer demand. Will consider hiring either a Buyer or a Senior Buyer, depending on experience. ...