Job Description
Sr. Data Engineer / Database Developer
100% Remote
Databricks Experience Required
Mergers & Acquisition Experience Preferred
Excellent Benefits including Day1 Medical, Dental & Vision Insurance
Our enterprise client is looking for a Sr. Data Engineer & Database Developer. We are looking for someone who has experience loading databases using modern data integration tools. The ideal candidate should be familiar 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.
Responsibilities:
- 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.
- Develop new data solutions and migrate existing on-premise data solutions to cloud platforms such as Azure or GCP.
- 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.
Qualifications:
- 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.
- 2-3 years experience with Databricks.
- 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.
Preferred Qualifications:
- 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.
- Experience with an Enterprise Architecture and Service Delivery model, such as TOGAF and ITIL.
- Certification in a cloud data engineering curriculum.