Senior Data Engineer

We are seeking a Senior Data Engineer who has experience loading databases using modern data integration tools. The ideal candidate should be proficient with creating tables, writing stored procedures, functions and building ETL/ELT jobs to load data from disparate systems. The Sr Data Engineer will be loading data to and from a variety of sources including data marts and transactional applications with conventional ETL/ELT patterns as well as modern data streaming or messaging patterns.

Position Summary:-

• Develop and maintain high-performance code based on SQL Server stack, including Stored Procedures, Views, Functions, and table design for transactional and analytic purposes.
• Develop and maintain Extract Transform Load jobs (ETL/ELT) and other data integrations with real-time streaming and API based sources.
• Develop new data solutions and migrate existing on-premise data solutions to cloud platforms including Azure Databricks and pyspark.
• Create Continuous Integration and Continuous Delivery (CI/CD) pipelines to automate delivery of solutions
• Provide support for data solutions, including remediation of failed ETL jobs,integrations and investigation of data quality issues.
• Data modeling for transactional and analytical platforms.
• Work directly with stakeholders to gather requirements and provide status updates and solution support
• Ensure data solutions meet or exceed enterprise regulatory and compliance requirements.

Required Skills:-

• Bachelor's degree in business, computer science, computer engineering, electrical engineering, system analysis or a related field of study, or equivalent experience.
• 5+ years experience using Microsoft SQL Server
• 5+ years experience building data integrations leveraging ETL tools such as SSIS or Talend
• Familiarity with data integration patterns including ETL/ELT, event messaging and APIs
• Familiarity with database change capture tools including Change Tracking and Change Data Capture
• Familiarity with data modeling patterns
• Familiarity with Master Data Management concepts and platforms
• Familiarity with data product Software Development Lifecycle (SDLC)
• Excellent communications skills.
• Excellent analytical and technical skills.
• Excellent planning and organizational skills.
• The ability to work in a collaborative team environment.

Good to have:-

• Master's degree in business, computer science, computer engineering, electrical engineering, system analysis or a related field of study, or equivalent experience.
• 10+ years experience with Microsoft SQL stack
• Experiencing with an Enterprise Architecture and Service Delivery model, such as TOGAF and ITIL
• Certification in a cloud data engineering curriculum