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