What are the responsibilities and job description for the Sr. Database Engineer position at TalentAlly?
The FreedomPay Commerce Platform is the technology of choice for many of the largest companies across the globe in retail, hospitality, lodging, gaming, sports and entertainment, foodservice, education, healthcare and financial services. FreedomPay's technology has been purposely built to deliver rock solid performance in the highly complex environment of global commerce. The company maintains a world-class security environment and was first to earn the coveted validation by the PCI Security Standards Council against Point-to-Point Encryption with EMV standard in North America. FreedomPay's robust solutions across payments, security, identity and data analytics are available in-store, online and on-mobile and are supported by rapid API adoption. The award winning FreedomPay Commerce Platform operates on a single, unified technology stack across multiple continents allowing enterprises to deliver a consistent, repeatable experience on a global scale. FreedomPay is a fast paced, high growth company with a great culture with competitive benefits and compensation with a business casual atmosphere.FreedomPay is experiencing explosive growth and seeks a Senior Data Engineer with expert-level database skills and a passion for technical leadership.
This role offers a clear path to higher-level positions, including Lead Data Engineer and Architect, for candidates who demonstrate initiative, vision, and impact.
This role is with FreedomPay's small but exciting Database Engineering team. This team of data engineers design, build, and maintain all data-related aspects of our products directly or through collaboration with other development teams. This work includes design, creation, and maintenance of Data Structures, Database Objects, ETL processes and reporting visualizations. The primary technology stack runs on the Microsoft SQL Server 2019 and 2022 stacks, as well as Snowflake, CosmosDB, Redis, and additional modern database technologies
In this role, you will collaborate with team members to design, create, and maintain Stored Procedures, ETL packages that are developed with SQL Server Integration Services and reports built through SQL Server Reporting Services. You will work independently and in small teams building SQL Server database objects and processes that support all of FreedomPay's products
Responsibilities
This role offers a clear path to higher-level positions, including Lead Data Engineer and Architect, for candidates who demonstrate initiative, vision, and impact.
This role is with FreedomPay's small but exciting Database Engineering team. This team of data engineers design, build, and maintain all data-related aspects of our products directly or through collaboration with other development teams. This work includes design, creation, and maintenance of Data Structures, Database Objects, ETL processes and reporting visualizations. The primary technology stack runs on the Microsoft SQL Server 2019 and 2022 stacks, as well as Snowflake, CosmosDB, Redis, and additional modern database technologies
In this role, you will collaborate with team members to design, create, and maintain Stored Procedures, ETL packages that are developed with SQL Server Integration Services and reports built through SQL Server Reporting Services. You will work independently and in small teams building SQL Server database objects and processes that support all of FreedomPay's products
Responsibilities
- 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.
- To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below represent the knowledge, skill, and ability required to fulfill the job requirements successfully. Reasonable accommodations may enable individuals with disabilities to perform essential functions.
- 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 solution
- 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
- Expert in designing, optimizing, and scaling relational and cloud-native databases (SQL Server, Snowflake, CosmosDB, Redis
- Proven track record of architecting multi-terabyte, high-performance data solutions
- Advanced proficiency in T-SQL, query optimization, indexing strategies, and database security
- Experience implementing DataOps, CI/CD, and automated testing for database deployments
- Five or more years of experience developing the full range of objects in Microsoft SQL 2019 (or better) databases using SQL and T-SQL
- Five or more years of experience creating and maintaining ETL packages with SQL Server Integration Services (SSIS); At least three years of experience SSIS with SQL Server 2019 (or better) preferred.
- Ability to provide relevant experience with the following Microsoft data concepts:
- Five or more years collaborating with team members on SQL, T-SQL, SSIS, and SSRS performance tuning problems to resolution.
- Working knowledge of deployments utilizing Database Projects, MS-ISPACs and DACPACs preferred
- Basic C# applied (non-academic) programming experience knowledge a plus
- Familiarity or experience with Azure SQL, Azure Data Factory is a plus
- Experience with version control, preferably GIT
- Experience with work management tools such as Jira or Azure DevOps
- Proficient in SDLC process and able to follow through the lifecycle of a process
- Strong collaborative approach to team members inside and outside of database development group to develop solutions and solve problems
- Professional, positive, and self-motivated approach.
- Strong relationship-building, written and verbal communication skills at all levels.
- Ability to work independently and as part of a team, managing multiple tasks and priorities.
- Commitment to continuous learning and adapting to new technologies and best practices.
- Exceptional communication skills, able to articulate complex concepts to technical and non-technical audiences
- Commitment to continuous learning and driving organizational excellence