Job description

Principal Data Solutions Architect (Hiring Immediately) job at Jobot. 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. This Jobot Job is hosted by: Alex Dickinson Are you a fit? Easy Apply now by clicking the Apply button and sending us your resume. Salary: $100,000 - $135,000 per year 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 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 Interested in hearing more? Easy Apply now by clicking the Apply button.

Requirements