Sr Data Engineer

Connection; Merrimack (NH); Hybrid; USD 120,000 - 170,000; Full time

Benefits offered by this job

Free therapy visits

Mental health resources

Wellness time off

Generous paid time off

Job summary

Connection is seeking a Senior Data Engineer to design, develop, and deploy data integration and migration solutions across corporate information systems. You will collaborate with the Manager of Data Engineering and IT teams to ensure robust data pipelines and timely delivery.

You will mentor juniors, lead production support initiatives, and maintain documentation while applying best practices for SQL Server/Oracle, SSIS, Databricks, and BI tools like Power BI.

Qualifications

• Strong SQL programming skills with experience in relational databases.
• Experience with SQL Server or Oracle and cloud data solutions.
• Proficiency in SSIS and Databricks transformation capabilities.
• Familiar with version control tools such as GIT or Bitbucket.
• Ability to lead production support initiatives and mentor others.

Responsibilities

• Develops database integration solutions from requirements through implementation.
• Designs and supports new or modified database systems with partners.
• Provides technical leadership and mentoring to developers.
• Leads complex production support initiatives and long-term solutions as appropriate.
• Provides on-call support for database integration solutions.
• Tracks project hours in time management software.
• Performs all other duties or special projects as assigned.

Skills

SQL programming

Data modeling

Analytical thinking

Mentoring

Communication

Tools

SQL Server

Oracle

SSIS

Databricks

GIT

Bitbucket

Power BI

Job description

Introduction

Be part of the team that drives our company forward, transforming ideas into real-world tools and platforms that support the business and spur innovation.

Overview

What We Do: We calm the confusion of IT by guiding the connection between people and technology. If a customer is looking for a better way to manage their warehouse inventory, equip their workforce, or secure their data, we make it happen. All it takes is finding the right combination of tech hardware, software, cloud solutions, and support services. That's what we do. We're the IT Department's IT Department.

Who We Are: Our team is made stronger by a multitude of backgrounds, experiences, and perspectives. It's what makes Connection unique-what drives us to innovate and create technology solutions that stand apart from the crowd. We'd love for you to be a part of that fabric, to share your ideas and experiences with a team that thrives on fresh thinking, creativity, and helping others.

Why You Should Join Us: You'll find supportive teammates and a rewarding career at Connection-plus great benefits. We take pride in supporting employees with a total rewards package that provides financial, emotional, and physical resources for you and your family. Our compensation, 401k plans, medical insurance, and other benefits are progressive and competitive. We value the importance of our employees' emotional well-being. To support employees, we provide free therapy visits, mental health coaching and tools, and meditation resources. You'll also enjoy a generous paid time off package that includes not only vacation and sick time, but also Wellness and Volunteer Time Off days.

Working under general supervision of the Manager, Data Engineering, relying on experience and judgment to plan and accomplish goals, the Senior Data Engineer performs data and application integration activities in support of all corporate information systems across multiple database platforms. Responsibilities include designing, developing, unit testing and deploying data integration and data migration solutions, including the documentation of technical specifications, deployment documents and support procedure manuals. Establishes and maintains partnerships with various lines of business to facilitate system design and support activities as well as working closely with all IT teams to facilitate collaboration on projects and production support. Provides training and mentoring via formal knowledge transfer workshops and one-on-one sessions. Leads complex production support initiatives and applies long term solutions as appropriate.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time.

Responsibilities

• Develops database integration solutions including requirement specifications, impact analysis, functional and technical design, programming, documentation, testing, data conversion, and implementation.
• Works with business partners, analysts and project managers to design and support new or modified database systems.
• Provides technical leadership and mentoring to help developers improve their skills.
• Leads complex production support initiatives and applies long-term solutions as appropriate.
• Provides on-call support for the database integration solutions.
• Tracks project hours in time management software.
• Performs all other duties or special projects as assigned.

Requirements

• Strong working knowledge of SQL Programming Language.
• Strong working knowledge of SQL Server and/or Oracle Relational Database Systems knowledge as well as cloud data solutions such as Databricks.
• Strong working knowledge of Source Control Applications such as GIT or Bitbucket.
• Strong working knowledge of multiple data integration tools such as SQL Server Integration Services (SSIS), Databricks Transformation capabilities and replication engines.
• Strong working knowledge of Principles and techniques of the application development process.
• Strong working knowledge of Principles and techniques of system integration and software dependencies.
• Strong working knowledge of Logical and physical database design concepts.
• Basic working knowledge of Business Intelligence application such as Microsoft Power BI.
• Analyzes functional requirements to design and build technical solutions.
• Analyzes data and develops logical solutions to problems.
• Establishes development estimates and meet agreed upon target dates.
• Leads complex production support initiatives.
• Provides accurate scope analysis and estimates for large projects.
• Conducts knowledge transfer sessions and technical walk-throughs.
• Works independently while adhering to company policies and standards.
• Interfaces effectively and cooperatively with business partners and co-workers.
• Effective verbal and written communication skills.
• Flexible with ability to manage multiple projects concurrently.