FreedomPay
SQL Developer
FreedomPay, Phila, Pennsylvania, United States, 19117
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 is looking for a high caliber database and ETL developer to help us build and maintain our data movement (ETL), visualization (reporting), and database development.
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 runs on the Microsoft SQL Server 2022 stack.
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. You will work independently and in small teams building SQL Server database objects and processes that support all of FreedomPay's products.
Qualifications:
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.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.Possess good organizational skills.Ability to anticipate potential problems and determine and implement solutions.Education/Experience:
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, 6-years equivalent work experienceAt least a BS/BA Degree in MIS, Computer Science, Engineering, or related fieldA minimum of 3 years of experience as a Database Developer/EngineerExperience working within an AGILE Scrum software development environmentStrong written and verbal interpersonal communication skills in the English languageTechnical Expertise:
Mastery of relational database concepts including but not limited to tables, keys, indexes, etc.Five or more years of experience developing the full range of objects in Microsoft SQL 2016 (or better) databases using SQL and T-SQLFour or more years of experience creating and maintaining ETL packages with SQL Server Integration Services (SSIS)Ability to provide relevant experience with the following Microsoft data concepts:SSIS:Parameters, variables, expressions, parallelism, data flow development, export and import feeds to either OLTP or OLAP systemsSSRS:Drill down, graphs, expressions, parameters, solution/project organization, data setsSQL/T-SQLCan construct queries, DML and DDL statements that perform on large multi-terabyte databases.Working knowledge of Snowflake cloud data warehouse and Sigma Computing analytics platform is preferredTwo or more years collaborating with team members on SQL, T-SQL, SSIS, and SSRS performance tuning problems to resolutionWorking knowledge of deployments utilizing Database Projects, MS-ISPACs and DACPACs preferredBasic C# applied (non-academic) programming experience knowledge a plusFamiliarity or experience with Azure SQL, Azure Data Factory is a plusExperience with version control, preferably GITExperience with work management tools such as Jira or Azure DevOpsExperienced with troubleshooting complex problemsProficient in SDLC process and able to follow through the lifecycle of a processAttributes
Professional and positive approachSelf-motivatedStrong in building relationships and able to communicate at all levelsTeam player as well as being able to work on own initiatives.Ability to collaborates with team members inside and outside of database development group to develop solutions and solve problemsPresents ideas clearly in written and verbal communicationExecutes tasks independentlyContinually develops skills as it applies to positionAbility to learn quickly, adapt work processes to adhere with best practicesAbility to work on multiple tasks and projects at once, with the ability to properly prioritize one's own work and the work of others
As the fastest growing commerce company in the industry, we offer the opportunity for tremendous upward mobility within the company as well as development and professional growth opportunities. FreedomPay's fulltime roles provide exceptional benefits including medical, prescription, dental and vision coverage, Life Insurance, Retirement Plans with company match, commission sharing plan, flexible hybrid working environment, and great parental and other leave programs. All positions must be able to successfully pass a background check as well as a credit check.
FreedomPay is experiencing explosive growth and is looking for a high caliber database and ETL developer to help us build and maintain our data movement (ETL), visualization (reporting), and database development.
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 runs on the Microsoft SQL Server 2022 stack.
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. You will work independently and in small teams building SQL Server database objects and processes that support all of FreedomPay's products.
Qualifications:
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.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.Possess good organizational skills.Ability to anticipate potential problems and determine and implement solutions.Education/Experience:
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, 6-years equivalent work experienceAt least a BS/BA Degree in MIS, Computer Science, Engineering, or related fieldA minimum of 3 years of experience as a Database Developer/EngineerExperience working within an AGILE Scrum software development environmentStrong written and verbal interpersonal communication skills in the English languageTechnical Expertise:
Mastery of relational database concepts including but not limited to tables, keys, indexes, etc.Five or more years of experience developing the full range of objects in Microsoft SQL 2016 (or better) databases using SQL and T-SQLFour or more years of experience creating and maintaining ETL packages with SQL Server Integration Services (SSIS)Ability to provide relevant experience with the following Microsoft data concepts:SSIS:Parameters, variables, expressions, parallelism, data flow development, export and import feeds to either OLTP or OLAP systemsSSRS:Drill down, graphs, expressions, parameters, solution/project organization, data setsSQL/T-SQLCan construct queries, DML and DDL statements that perform on large multi-terabyte databases.Working knowledge of Snowflake cloud data warehouse and Sigma Computing analytics platform is preferredTwo or more years collaborating with team members on SQL, T-SQL, SSIS, and SSRS performance tuning problems to resolutionWorking knowledge of deployments utilizing Database Projects, MS-ISPACs and DACPACs preferredBasic C# applied (non-academic) programming experience knowledge a plusFamiliarity or experience with Azure SQL, Azure Data Factory is a plusExperience with version control, preferably GITExperience with work management tools such as Jira or Azure DevOpsExperienced with troubleshooting complex problemsProficient in SDLC process and able to follow through the lifecycle of a processAttributes
Professional and positive approachSelf-motivatedStrong in building relationships and able to communicate at all levelsTeam player as well as being able to work on own initiatives.Ability to collaborates with team members inside and outside of database development group to develop solutions and solve problemsPresents ideas clearly in written and verbal communicationExecutes tasks independentlyContinually develops skills as it applies to positionAbility to learn quickly, adapt work processes to adhere with best practicesAbility to work on multiple tasks and projects at once, with the ability to properly prioritize one's own work and the work of others
As the fastest growing commerce company in the industry, we offer the opportunity for tremendous upward mobility within the company as well as development and professional growth opportunities. FreedomPay's fulltime roles provide exceptional benefits including medical, prescription, dental and vision coverage, Life Insurance, Retirement Plans with company match, commission sharing plan, flexible hybrid working environment, and great parental and other leave programs. All positions must be able to successfully pass a background check as well as a credit check.