Sr Data Engineer

Senior Data EngineerWe 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.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.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 wellbeing. 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 judgement 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.MinUSD $97,000.00/Yr.MaxUSD $125,000.00/Yr.Qualifications•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