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 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

 


  • 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...

  • Sr. ETL Developer

    4 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...

  • 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,...


  • Illinois City, United States Dice Full time

    Dice is the leading career destination for tech experts at every stage of their careers. Our client, TOPSYSIT, is seeking the following. Apply via Dice today! Role: Sr Python developer with AWS Expertise Location: Multiple Locations in IL, NY, TX & VA(Onsite) Python.Core, AWS Cloud Development Kit, AWS Lambda, AWS Simple Queue Service, Amazon DynamoDB,...


  • Illinois, United States CLEAResult Full time

    Job Description SummaryCLEAResult’s Energy Transition practice is driving toward a high efficiency, low carbon economy. The Sr. Practice Manager will be an expert in the energy transition markets of CLEAResult’s East and Canada regions and will use this expertise to inform the evolution of our electrification and distributed energy resource products and...

  • jr software developer

    1 month ago


    Illinois City, United States Infospear Technologies LLC Full time

    6 months of strong hands-on SQL development experience specifically T-SQL (creating/writing stored procs etc.) and tables. 6 months experience with SSIS and ETL (Power BI preferred). Understands the components and functionality of Azure. Understands recovery plans and backups/restores using SQL Management Studio. Can effectively move data from one system...


  • Chicago, Illinois, United States Burwood Group, Inc Full time

    Job Description What You’ll Do The Sr. ServiceNow Engineer is a key member of our Intelligent Operations team, building ServiceNow integrations and automating IT processes to enable clients to become more efficient & effective, and ultimately provide a better user experience for our client’s end-users. The team works directly with clients and with...

  • Engineer Sr, DevOps

    7 days 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...


  • Chicago, Illinois, United States Network Perception Full time

    About Us Network Perception was launched in 2014 at the University of Illinois at Urbana-Champaign Research Park. Founded by a team of experts on network security and critical infrastructure protection, Network Perception delivers a pioneering solution that enables corporate compliance and cyber security managers to gain a complete view of their network...


  • Rockford, Illinois, United States Elite Sourcing LLC Full time

    Elite Sourcing LLC is a renowned company in the construction industry and we are currently seeking a highly skilled and experienced Sr. Structural Engineer to join our team. As a Sr. Structural Engineer at Elite Sourcing LLC, you will be responsible for designing and analyzing structural systems for various projects. You will work closely with architects,...


  • Loves Park, Illinois, United States Elite Sourcing LLC Full time

    Elite Sourcing LLC is working with a leading architecture firm and is seeking a highly skilled and experienced Sr. Structural Engineer to join their team. As a Sr. Structural Engineer you will be responsible for designing and analyzing structural systems for a variety of projects. You will work closely with architects, contractors, and other engineers to...

  • Sr. Web methods BPM

    3 weeks ago


    Rosemont, Illinois, United States Two95 International Inc. Full time

    Title: Sr. Web Methods BPM Location: Rosemont, Illinois Duration: Full Time Salary: Market Requirements REQUIRED SKILLS AND EXPERIENCE Experience with webMethods Integration Server, MWS, UM, Designer, Optimize for process version 9.8 Experience designing complex BPM process models, develop corresponding IS services Experience...


  • Chicago, Illinois, United States Attadale Partners, LLC Full time

    Attadale serves some of the most sophisticated and successful companies in the world. We are at the forefront of Machine Learning solutions that influence tangible business outcomes. Our clients engage Attadale because our work drives change that increases profitability and improves decision support, all while delighting employees and customers. Attadale is...


  • Chicago, Illinois, United States McDonald's Corporation Full time

    Job Description Work with a great deal of autonomy to own the development and execution of the function’s strategic plans, ensuring that people are positioned to get results. Work in close partnership with the Sr Director, Center HR to establish the foundational functional people strategies to enable current Technology portfolio and also plan for growth...


  • Woodstock, Illinois, United States ITW Medical Full time

    Job Description Conveniently located 15 minutes North of Woodstock, IL off of IL-47 in Hebron, IL. This position is eligible for a hybrid work schedule (1-2 days remote per week) This position will be part of the New Product Development group and will report directly to the New Product Development Manager. The primary responsibility will be to drive the...

  • Data Analyst

    4 weeks ago


    Mettawa, Illinois, United States AbbVie Full time

    Job Description Key Responsibilities   Responsible for compliance with applicable Corporate and Divisional Policies and procedures. Manage multiple projects and write Business Requirements Documents (BRDs) and technical design Documents (TRDs). Use appropriate tools to collect, correlate and analyze data. Record and maintain technical data for use in...


  • Chicago, Illinois, United States TEKRRA1 Full time

    Rate: $70/hr (C2C) Location: Remote (US Based) Work Auth USC & GC Only We are currently seeking a highly skilled SQL Developer with PowerBI expertise for a remote position. This is an excellent opportunity for an experienced professional to contribute to data management and data integrity projects while utilizing their SQL and PowerBI skills. Key...

  • Sr Talent Advisor

    3 weeks ago


    Bolingbrook, Illinois, United States ATI Physical Therapy Full time

    Overview: The Sr. Talent Advisor provides full cycle recruitment expertise for a variety of assigned positions which may include recruitment requests for specialized customers and openings that are challenging to fill. This role will work with leaders to understand ATI strategic business needs and build sophisticated recruitment strategies for designated...

  • B.I. Developer

    7 days ago


    Barrington, Illinois, United States Ortho Molecular Products Full time

    Overview: We are seeking a Business Intelligence Developer, who will support and participate in the design and development process for creating and maintaining SQL Server BI stacks (SSIS, SSAS, SSRS) and SQL Server BI Databases. The position will work with a team to maintain/enhance the existing company-wide Business Intelligence Platform and implement the...