Develop, implement and maintain high-performance data pipelines using Microsoft and open source technologies.
Integrate data systems to both internal and external platforms using SQL, message queues, APIs (SOAP, REST) and batch processes.
Perform traditional ETL/ELT functions such as data cleansing, quality inspection and transformation to supply data warehouses and lakes.
Develop SQL scripts and objects to support application functionality and performance.
Function as a subject matter expert to other application and database developer groups providing guidance for optimization, data modeling and data platform architecture.
Ensure systems meet required standards for PCI and other organization compliance and security guidelines.
The drive to work in a fast-paced environment
Experience with Microsoft SQL Server stack
SSIS, SSRS and general DDL and DML T-SQL development
Experience with Windows PowerShell, .Net Core, Python, Go, and other languages to build scalable data solutions
Experience with modeling data structures in both transactional and analytical platforms
The ability to troubleshoot, tune and remediate issues in production environments
The ability to communicate with other technical and non-technical users
The ability to work in a collaborative team environment
The ability to participate in an on-call rotation for production support
Experience with high transaction databases
Experience with relational and non-relational data stores
Experience with big data tools (Hadoop, Hive, Spark, Kafka)
Familiarity of functional programming languages and data access protocols
Familiarity of source control providers such as GIT or TFS
Knowledge of PCI compliance
Experience with Continuous Delivery for database systems