logo inner

SQL Developer

FreedomPayPhiladelphia, Pennsylvania, United StatesHybrid, Onsite
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 experience
  • At least a BS/BA Degree in MIS, Computer Science, Engineering, or related field
  • A minimum of 3 years of experience as a Database Developer/Engineer
  • Experience working within an AGILE Scrum software development environment
  • Strong written and verbal interpersonal communication skills in the English language

Technical 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-SQL
  • Four 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 systems
  • SSRS:
  • Drill down, graphs, expressions, parameters, solution/project organization, data sets
  • SQL/T-SQL
  • Can 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 preferred
  • Two 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
  • Experienced with troubleshooting complex problems
  • Proficient in SDLC process and able to follow through the lifecycle of a process

Attributes


  • Professional and positive approach
  • Self-motivated
  • Strong in building relationships and able to communicate at all levels
  • Team 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 problems
  • Presents ideas clearly in written and verbal communication
  • Executes tasks independently
  • Continually develops skills as it applies to position
  • Ability to learn quickly, adapt work processes to adhere with best practices
  •   Ability 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.Apply for this job

Life at FreedomPay

Founded in 2000, FreedomPay is a technology and innovation company with a long history as an industry leader and in driving market success for its clients. The FreedomPay Commerce Platform is a multi-patented solution portfolio designed to enable enterprises to deliver a high-performance, secure user experience driven from the Cloud to any device, anytime, anywhere. The platform seamlessly bridges the gap across in-store, web and mobile by multiplexing point of sale systems, payment processors, incentive engines and other disparate systems to a cutting edge transaction superhighway. Quick to incorporate the benefits of Cloud computing, FreedomPay is a Platform-as-a-Service (PaaS) provider enabling value-added services for our global partners. Our unique capabilities harness the power of exceedingly detailed data captured by our patented payment, incentive and loyalty offerings. Essential capabilities that are quickly being adopted across many industries including: retail, gaming, lodging, stadiums, education, healthcare and financial services. And further to our mission to be an industry leader, FreedomPay is the only company in North America with a fully validated P2PE solution with EMV, DCC and NFC support. With full PCI Security Council Validation, our customers are assured they have the most secure solution offered anywhere in the world today. FreedomPay's innovations have led to the granting of three patents, furthering the confirmation of the offerings uniqueness and reinforcing customer confidence in the FreedomPay brand as a technology innovation company. The patents cover transaction networking, real-time discounting and incentive application bolstering the company's position as a forward-thinking leader in a burgeoning global marketplace. The Company is privately held. Shareholders include employees and leading venture capital investors: Blue Run Ventures, Palo Alto and Core Capital Partners, Washington D.C.
Thrive Here & What We Value1. Fast paced, high growth2. Competitive benefits & compensation3. Upward mobility & professional development4. Exceptional employee benefits (medical, dental, vision)5. Life Insurance and retirement plans with company match6. Flexible hybrid working environment7. Strong parental leave programs8. PCI Security Standards Council validation9. EMV standard compliance in North America10. Business casual atmosphere
Your tracker settings

We use cookies and similar methods to recognize visitors and remember their preferences. We also use them to measure ad campaign effectiveness, target ads and analyze site traffic. To learn more about these methods, including how to disable them, view our Cookie Policy or Privacy Policy.

By tapping `Accept`, you consent to the use of these methods by us and third parties. You can always change your tracker preferences by visiting our Cookie Policy.

logo innerThatStartupJob
Discover the best startup and their job positions, all in one place.
Copyright © 2024