Data Engineer in Salt Lake City, UT at ConsultNet

Date Posted: 10/17/2020

Job Snapshot

Job Description

Data Engineer

Salt Lake City, Utah

Direct Hire

Looking for a Sr. Data Engineer to design, develop data solutions on MS SQL Server platform. The Sr. Data Engineer will use SSIS, Python, and Stored Procedures to build, optimize data pipelines for key data and analytics consumers. This would enable faster access to quality data and vastly improved time-to-solution analytic and operational initiatives. The Sr. Data Engineer will collaborate with Database Administrators, ETL Developers, data science teams, and business owners in a fast-paced, dynamic environment.

Responsibilities:

  • Build and maintain ETL pipelines, data warehouse/Lake data architecture, data workflows and analytic/Client feature engineering.
  • IT & CX organizations
  • Design and implement SSIS/Python packages that pull data from internal and external Web Services/APIs, SFTPs etc.
  • Perform complex database programming by writing SQL procedures on large-scale databases
  • Develop new database objects and/or review existing objects to improve storage efficiency and access
  • Troubleshoot production issues during and after business hours to ensure SLAs are properly met
  • Analyze and address query/job performance issues/resource bottlenecks
  • Act as an information resource/subject matter expert for assigned areas of responsibility

Required Skills:

  • 5 years of experience working with relational databases (SQL Server)
  • 2 years of experience working in a data engineering role, designing, developing, and shipping software
  • Experience with SQL, Data architecture, SQL DBA
  • Experience developing database applications using stored procedures and functions
  • Experience delivering solutions in a scrum/two week iteration setting
  • Demonstrated ability to fail fast, regroup and improve
  • Experience working in a fast-paced, enterprise environment
  • Experience in BI projects converting business needs to data warehousing and reporting solutions

Bonus Skills:

  • Excellent diagramming, Sprint project management and organizational skills
  • Strong programming abilities in Unix/Python3/C#
  • Experience in SalesForce and Snowflake data migration

Be a part of the ConsultNet difference. As a leading national provider of IT staffing and solutions, ConsultNet delivers exceptional services to startup, midmarket and Fortune 1000 companies across North America. Since 1996, we've partnered with clients to create rewarding opportunities for our consultants, successfully building teams that have surefire results.
In the past two years alone, we have placed more than 1,500 consultants in contract, contract-to-hire, or direct placement opportunities. We understand communication is key to finding the right job that matches your skills and career goals. For us, it's not just the work that we do; it's how we do the work. Our breadth of offerings extends to multiple IT positions in major markets throughout the country, see more at www.consultnet.com