Sr. ETL Developer

Posted on May 16, 2024 by The Bradford Exchange
Niles, IL
Other
Immediate Start
Annual Salary
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 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 vacation 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



Reference: 157201975

https://jobs.careeraddict.com/post/90928473

This Job Vacancy has Expired!

Sr. ETL Developer

Posted on May 16, 2024 by The Bradford Exchange

Niles, IL
Other
Immediate Start
Annual Salary
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 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 vacation 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


Reference: 157201975

CareerAddict

Alert me to jobs like this:

Amplify your job search:

CV/résumé help

Increase interview chances with our downloads and specialist services.

CV Help

Expert career advice

Increase interview chances with our downloads and specialist services.

Visit Blog

Job compatibility

Increase interview chances with our downloads and specialist services.

Start Test