Senior SQL Developer
Philadelphia, PA/ Las Vegas, NV
Engineering – Software Development /
Full Time /
Hybrid
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 stack runs on the Microsoft SQL Server 2017 and 2019 stacks.
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.
Qualifications:
- 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.
- 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 5 years of experience as a SQL 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.
- Experience with database design patterns, designing and implementing database models to support software engineers.
- Five or more years of experience developing the full range of objects in Microsoft SQL 2016 (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 2016 (or better) preferred.
- Three or more years of experience creating and maintaining ETL routines with SQL Server Reporting Services (SSRS)
- ·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.
- Three 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.
