Lead Ecommerce Data Analyst

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're currently seeking a Lead eCommerce Data Analyst that will drive the design, development, and implementation of data, BI & analytic solutions and systems, including: business process analysis, database design, core data architecture, data process development and enhancement, and report/dashboard design & development. This senior level role will take responsibility for project work from requirements to implementation, and be able to guide, support, and measure team activities towards completion of project goals. Must be comfortable working in autonomous roles and providing quality/consistent communications with team members and senior management.

How you will contribute:

• Data modeling and database design.

• Data processing within SQL Server BI-stack architecture & development.

• Query and performance analysis.

• Development and requirement gathering related to all of the above, which may include extensive interaction with business unit and technology team members and leadership.

What you will bring and skills that excite us:

• Bachelor's degree Computer Science, MIS, or related.

• 10+ years experience with data/analytics development and architecture.

• 5+ years experience development lead & mentoring.

• Advanced experience with hands on development in SQL Server Technologies: T-SQL, SSIS.

• Recent experience working in a project management, database architect, or development lead role on data/analytics related projects.

• Strong understanding of data architecture, design and structures, data processing/ETL & analytics (big data, reports/dashboards, data warehouse).

• Experience designing SQL Server databases, including physical storage and data architecture concepts.

• Design, implement, and support enterprise-level BI tools.

• Experience acting in a lead, senior-level developer, and/or mentoring role.

• Experience working with vendors/partners implementing inter-organization data integrations/interfaces.

• Dimensional modeling and design, including slowly changing dimensions of various types.

• Big data and/or enterprise data warehouse (cloud analytics preferred).

• Evaluate and document organizational needs around data analysis and current data scenarios.

• Comprehensive understanding of relational database design principles.

• Must have excellent communication skills and be able to communicate technical issues to non-technical people.

• Must be able to handle multiple projects at one time.

• Create and maintain reports summarizing data to be used by Management and Executives.

• Experience documenting complex data architectures and data systems.

• Microsoft MCP (BI-relevant) Certification(s).

• Tableau Platform architecture & development.

• Excellent verbal and written communication skills are a must for this role.

• Experience working in a senior developer or lead capacity (preferred).

• Experience working on large, enterprise-scale projects, with diverse project teams.

• Willingness to work non-business hours related to support and project requirements.

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, and Toastmaster's memberships, a Peer Recognition Program, Product Discounts and more!

The Bradford Exchange is an Equal Opportunity Employer.

#LI-Hybrid