Principal Data Engineer

ViziRecruiter,LLC.; Merrimack (NH); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Competitive salary

401k plans

Medical insurance

Paid time off

Job summary

A tech solutions company located in Merrimack, NH, is looking for a Principal Data Engineer to lead complex data integration projects. This role involves developing database solutions, mentoring junior developers, and collaborating with various departments to enhance IT systems. Ideal candidates should have advanced skills in SQL programming, experience with cloud data solutions like Databricks, and familiarity with tools such as SSIS and Microsoft Power BI. The position offers competitive benefits and supports remote work options.

Qualifications

• Advanced SQL Programming skills required.
• Experience with cloud data solutions like Databricks is a must.
• Proficient in using data integration tools such as SSIS.

Responsibilities

• Develop database integration solutions with clear specifications.
• Analyze data and create logical solutions to problems.
• Lead technical initiatives and mentor other developers.

Skills

SQL Programming Language skills

SQL Server knowledge

Cloud data solutions

Data integration tools

Source Control Applications

Application development process

System integration techniques

Database design concepts

Business Intelligence application

Effective communication

Tools

SQL Server Integration Services (SSIS)

Databricks

Microsoft Power BI

Job description

Introduction

Elegant solutions to sophisticated problems. That’s what you deliver. Surround yourself with the team, resources, and support you need to design and build world-class IT solutions.

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.

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.

Working under general supervision of the Senior Director, Data Engineering, relying on experience and judgement to plan and accomplish goals, the Principal Data Engineer performs complex data and application integration activities as the highest technical level in support of all corporate information systems across multiple database platforms. Responsibilities include working with business partners on solution design for new or modified database systems as well as integrating database systems. The Principal functions as a lead in technical design and development on large projects by providing direction to other resources and promoting the goal of process improvement. Trains and mentors less experienced developers via formal knowledge transfer workshops and one-on-one sessions. Leads complex production support initiatives and applies long term solutions as appropriate.

Responsibilities

• Develops database integration solutions including requirement specifications, impact analysis, functional and technical design, programming, documentation, testing, data conversion, and implementation.
• Analyzes functional requirements to design and build technical solutions.
• Analyzes data and develop logical solutions to problems.
• Establishes development estimates and meet agreed-upon target dates.
• Provides accurate scope analysis and estimates for large projects.
• Completes 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.
• Leads complex production support initiatives and applies long term solutions as appropriate.
• Leads development initiatives as technical lead; fills in for the manager as needed
• Leads technical resources on major projects, including design sessions and development activities
• Provides technical leadership and mentoring to help developers improve their skills.
• Conducts knowledge transfer sessions and technical walk-throughs.
• Provides project status reports and attends team meetings to keep project leads and managers apprised of work progress.
• Provides on-call support for the database integration solutions; develops long-term solutions to minimize recurring support calls.
• Identifies opportunities for process improvements and lead efforts to implement solutions.
• Tracks project hours in time management software.
• Performs all other duties or special projects as assigned.

Requirements

• Advanced working knowledge of SQL Programming Language skills.
• Advanced working knowledge of SQL Server and/or Oracle Relational Database Systems knowledge as well as cloud data solutions such as Databricks.
• Advanced working knowledge of multiple data integration tools such as SQL Server Integration Services (SSIS), Databricks Transformation capabilities and replication engines.
• Strong working knowledge of Source Control Applications such as GIT or Bitbucket.
• 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.
• Exposure to all major PCC database systems and business processes.
• Strong working knowledge of Business Intelligence application such as Microsoft Power BI.
• Self-motivated with ability to work independently while adhering to company policies and standards.
• Effective verbal and written communication skills with ability to interface effectively and cooperatively with business partners and co-workers.
• Manages multiple projects concurrently.