Senior / Lead Database Engineer
FreedomPay
full-time
Posted on:
Location Type: Hybrid
Location: Philadelphia • Pennsylvania • United States
Visit company websiteExplore more
Job Level
About the role
- Design, develop, and optimize relational database objects and data models using Microsoft SQL Server and Snowflake.
- Build and maintain scalable ETL/ELT pipelines for batch and streaming data using tools such as SSIS and cloud-native solutions.
- Integrate and utilize Redis for caching, session management, and real-time analytics.
- Develop and maintain data visualizations and reporting solutions using Sigma Computing, SSRS, and other BI tools.
- Collaborate with engineering, analytics, and product teams to deliver data solutions that meet business requirements.
- Ensure data security, governance, and compliance across all platforms.
- Participate in Agile Scrum ceremonies and contribute to continuous improvement of data engineering processes.
- Support database deployments using modern DevOps practices, including version control (Git) and CI/CD pipelines, include Azure DevOps, Flyway, Octopus, SonarQube.
- Troubleshoot and resolve performance, reliability, and scalability issues across data platforms.
Requirements
- Strong understanding of current Microsoft development technologies.
- Strong English reading and writing communication skills, with an ability to express and understand complex technical concepts. As other languages are a requirement, that will be explicitly noted during the recruitment process.
- Strong analytical, problem-solving, and conceptual skills.
- Ability to work in teams and strong interpersonal skills.
- Ability to work under pressure and meet tight deadlines.
- Ability to anticipate potential problems and determine and implement solutions.
- Relevant training in principles and techniques of database development and modeling. Be familiar with systems concepts, design, and standards. Provide expertise in software usage, functionality, performance, security, aesthetics, resilience, reuse, comprehensibility, and economic and technological tradeoffs.
- Bachelor Degree in Software Engineering, Computer Science, or related discipline; or, 7-years equivalent work experience.
- At least a BS/BA Degree in MIS, Computer Science, Engineering, or related field.
- A minimum of 7 years of experience as a SQL Developer/Engineer.
- Experience working within an AGILE Scrum or SafAgile software development environment.
- Strong written and verbal interpersonal communication skills in the English language.
Benefits
- Competitive benefits and compensation
- Business casual atmosphere
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Microsoft SQL ServerSnowflakeETLELTSSISRedisSigma ComputingSSRSGitCI/CD
Soft Skills
analytical skillsproblem-solving skillsinterpersonal skillscommunication skillsteamworkability to work under pressuretime managementanticipation of problemssolution implementationconceptual skills
Certifications
Bachelor Degree in Software EngineeringBachelor Degree in Computer ScienceBachelor Degree in MISBachelor Degree in Engineering