Piper Companies

Sr. Cloud Data Engineer

Job description

Piper Companies is looking for a Sr. Cloud Data Engineer to join a financial services company based in Denver on a team that operates 100% remotely.


Responsibilities

  • The focus of this position will be on data warehouse, database and ETL activities.
  • You will have a “business as usual” set of responsibilities that will involve working around a traditional on-prem SQL setup of data lineage (SQL Server, SSIS, OLAP, OLTP, Star Schemas)
  • Set road map items as we prepare to migrate from on-prem SQL Server to cloud native hosting and tooling.
  • We’re in the process of moving to cloud based solutions and you will play a vital role in helping us in this transition.


Requirements:

  • 7+ years of total experience
  • Experience with SQL Server and Data Warehouse management, SSIS, relational data modeling and ETL development
  • Adept at solving complex data problems through ETL and data pipelining.
  • Cloud native data experience – ideally either Azure or AWS.


Terms/Compensation/Benefits:

  • Salary: $155,000
  • Comprehensive benefit package; Medical, Dental, Vision, 401, PTO
  • 100% Remote


Keywords:, data engineer, data warehouse, sql server, ssis, ssrs, olap, oltp, data vault, star schema, data lake, aws, redshift, azure, data factory, synapse, kinesis, prometheus, s3, glacier, aws glue, msk, etl, postgres, sql, remote, wfh, pto, benefits.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.