Senior SQL Developer
- $100,000 - $135,000
- Philadelphia, PA
This is a hybrid role with an established and stable company in the fintech space. They have excellent benefits, a great bonus program as well as documented examples of significant pay raise and upward growth opportunity.
A bit about us:
Excellent company with a track record of stability and excellent sales performance and growth!
Why join us?
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
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
Job Details
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
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