Lead SQL Developer

Published date Posted on Indeed on Nov 24, 2021 (4 d ago)

Piper Companies is looking for a Lead SQL Developer for a leading financial lender located in Oaks, PA.


This position is 100% remote.


Essential Functions/Responsibilities:



  • Lead in defining, documenting and developing software, software applications, as well as contributes to architecture and technical design discussions, code reviews and technical design/specifications in collaboration with the project team
  • Independently responsible for development, enhancement, testing, support, maintain and troubleshoot/ debug software applications that support business units or support functions.
  • Create thorough, professional quality project documentation and technical specifications
  • Assesses the impact of software changes and new development on other systems; conducts integration tests to mitigate risks
  • Mentor junior team members, and participates in and promotes a knowledge-sharing environment


Specific Job Skills and Experience:

  • 8 or more years of related experience; or equivalent combination of education and experience
  • Experience with the full software development life cycle, including design, testing, deployment, and documentation activities (including agile and scrum patterns)
  • Creating complex queries and stored procedures
  • Performance tune complex queries and query optimization
  • Developing Dynamic SQL and stored procedures
  • Using indexes to speed up the SQL queries
  • Experience in creating database schemas that represent and support business processes
  • Extensive knowledge and hands on experience designing and developing objects and components of relational and non-relational database
  • Experience with SSRS report development
  • Developing ERD – both physical and logical
  • Strong experience with Agile methodologies
  • Knowledge and understanding of SDLC, with a strong preference for Agile experience
  • Skill for writing reusable functions, views and database objects
  • Excellent written/verbal communication, presentation, and listening skills
  • Excellent collaboration/teamwork skills
  • Understanding of fundamental design principles for building a scalable application
  • Familiar with various design and architectural patterns


Benefits:


  • Comprehensive Benefits: Medical (Cigna), Dental, Vision and 401K
  • 100% remote during and after Covid

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Jobvite Jobvite |
|
2 d ago

#Description#Jobvite is an end-to-end Talent Acquisition Suite that takes a marketing-first approach to intelligently attract dream candidates, automatically screen for the highest quality, engage employees invested in the future, and retain the people who care the most about you

Alvaria employs a team of passionate individuals who are changing the face of customer engagement. Over our 40-year history we have empowered employees by creating an inspired community that values Urgency, Accountability & Results. Our ability to think big has enabled us to

Remote Opportunity Main responsibilities:Create visualizations and analyses that provide business insights for our global customers.Build prototypes for demonstration and illustration purposes for peer groups, Business partners, or senior leaders.Expertise in SQL can independentl

Description:Le’fant is a rapidly growing CVE Certified, Service Disabled Veteran Owned Small Business specializing in management consulting for the federal government. Our compensation and benefits plans are designed to attract and retain the industries best talent to provi

The connection has a fantastic opportunity through our Technical Staffing division for a Senior Informatics BA. This is a permanent position with our end client.This is a remote position.Responsibilities:Prepare business requirements document by performing various analyses and in

Location:North America›RemoteJob Type:Full-timeFunctional Area:SalesJob Level:Mid-Senior LevelBecome a Principal Business Analyst in an Innovative High-Tech Security CompanyJob ID: HID2033Location: Remote, USTravel: Up to 20%#Securing your Future!Business analysts (BAs) ar

IQVIA IQVIA |
2 d ago

The IQVIA Data Management and Analysis team (DMA) is part of the market-leading Contract Performance Solutions group which helps manufacturers with all aspects of government and commercial drug rebate programs. We create value for our clients by analyzing and validating pharmaceu

More jobs by this company

Piper Companies Piper Companies |
2 d ago

Piper Companies is looking for a Sr. Data Product Manager to join a digital transformation organization 100% remotely, who has experience leading product teams in regard to data modeling solutions within a financial domain.Responsibilities:Interpret requirements and analyze data.

Piper Companies Piper Companies |
|
3 d ago

Piper Companies is looking for a Sitecore Developer who would like to join a leading Financial Services firm located in the Philadelphia areaThis is a Remote Opportunity!Responsibilities for the Sitecore Developer include:You will be designing and developing software solutions in

Piper Companies Piper Companies |
4 d ago

Piper Companies is currently looking for a Remote Front-End Developer who will work closely with product designers, product owners and your technical peers to make sure we think up, develop and deliver best-in-class aerial intelligence productsResponsibilities for the Remote Fron

Piper Companies Piper Companies |
4 d ago

Piper Companies is currently looking for a Remote Java Developer to help build and maintain our geospatial data analytics applications. Experience in building and maintaining Rest API driven web applications is required.Responsibilities for the Remote Java Developer include: Coll

Piper Companies Piper Companies |
4 d ago

Piper Companies is looking for a Project Manager for a leading financial lender located in Oaks, PA.This position is 100% remote. They are looking for candidates in the PA, NJ, DE, MD area.Qualifications for the Project ManagerBachelor of Science in Engineering or Computer Scienc

Piper Companies is seeking a Fully Remote Sr. DevOps Engineer to join a technology company specialized in internet-related security and connectivity. The Sr. DevOps Engineer will concentrate on AWS infrastructure management and be responsible for production support and troublesho

Piper Companies is looking for a Software Engineer to be part of a financial lending organization. This role is 100% remote.Responsibilities of the Software Engineer:Deliver technology solutions within AWS for system integrations applicationsContribute to the company’s over

Piper Companies Piper Companies |
5 d ago

Piper Companies is currently seeking a Lead Software Engineer for a remote opportunity based out of Durham, North Carolina (NC). The Lead Software Engineer is a versatile self-starter with a background in Python development. The Software Engineer’s responsibilities include

Piper Companies Piper Companies |
|
5 d ago

Piper Companies is seeking a Manager of Data Engineering for a growing technology driven organization. The Manager of Data Engineering role is a 100% remote role that can reside anywhere in the United States. The Manager of Data Engineering will be working with a team primarily b

Piper Companies Piper Companies |
|
6 d ago

Piper Enterprise Solutions is searching for a Power BI Developer for a client in the mortgage services industry. This is a 100% remote position.Responsibilities for the Power BI Developer:Responsible for the creation of visually appealing and engaging dashboards, providing releva

Piper Companies Piper Companies |
|
6 d ago

Piper Enterprise Solutions is searching for Software Engineers for multiple positions with a client in the financial service industry. These are 100% remote positions.Responsibilities for the Software Engineers:Responsible for the design, deployment, testing and overall managemen

Piper Companies Piper Companies |
7 d ago

Piper Companies is looking for a Sr. Software Engineer to work 100% remotely with a digital transformation organization, who is experienced in creating full stack solutions via microservice development.Responsibilities:Work with our team in collaboration with external resources a

Piper Companies is currently seeking a Remote Full Stack Software Engineer - React/Node for an opportunity fast growing organization based on the east coast. The Remote Full Stack Software Engineer’s role is to build and maintain a digital platform. To ensure success in thi

Piper Companies Piper Companies |
9 d ago

Piper Companies is seeking a Fully Remote .NET Developer to join a growing Healthcare Technology Company. The .NET Developer will develop new modules and perform maintenance on application solutions.Responsibilities .NET Developer include:Engage the team and organizational collea

Piper Companies Piper Companies |
9 d ago

Piper Companies is looking for a Senior UX Consultant for a leading retirement and wealth management analytics firm in the Philadelphia, PA area.Remote Opportunity!Responsibilities for the Senior UX Consultant include:This role would focus heavily on Information Architecture, Use

Must be eligible to obtain a DoD Secret clearance (no active clearance required)Do you want to be part of a team where your suggestions and ideas are heard by your management? Do you look for an organization where culture, work life balance, and transparency are topics that the C

Piper Companies is currently seeking a Senior UI Developer for a remote fulltime opportunity for a national software-as-a-service corporation. The Senior UI Developer will participate in the creation and delivery of cloud-based software for web applications, consume and develop R

Piper Companies Piper Companies |
10 d ago

Piper Companies is currently seeking a OpenShift RedHat Engineer for a remote opportunity for a leading SaaS company. The OpenShift RedHat Engineer will participate in the creation of cloud-based solutions and support the delivery of cutting-edge platform technologies. Responsibi

Piper Companies Piper Companies |
11 d ago

Piper Companies is looking for a Frontend Developer for a Insurance/Risk Institution REMOTEResponsibilities for the Frontend DeveloperDevelop features and improvements to the products in a secure, well-tested, and performant wayYou’ll work with Product Management and other

Piper Companies is currently seeking a Technical Product Manager for a fully remote role. The Technical Product Manager will have the opportunity to work on building out ecommerce products to serve enterprise-level clientele at a subscription-based software company.Responsibiliti

Piper Companies Piper Companies |
15 d ago

Piper Companies is currently seeking a Java Software Engineer for a direct hire opportunity for a custom API design company based out of Raleigh, North Carolina. This is a 100% remote position Responsibilities of the Software Engineer:Build application accessing large data sets.I

Piper Companies is currently seeking a Software Engineer with an extensive Ruby on Rails background for a direct-hire opportunity with an innovative company in Raleigh, North Carolina (NC). The Software Engineer will help support SaaS technologies by developing and maintaining se

Piper Companies is currently seeking a Director of Android Software Enginnering for a growing Advertising Technology company. Responsibilities of the Director of Android Software Engineering:Strategize and plan for re-development and re-deployment of a mission based platformRevie

Piper Companies is seeking a REMOTE Full Stack Javascript Developer for an award winning software organization based in the Charlotte, North Carolina area. The REMOTE Full Stack Javascript Developer will join a growing team building out highly scalable and secure cloud native app

Piper Companies Piper Companies |
15 d ago

Piper Companies is seeking a Remote Sr. Java Developer for a growing software company. The Remote Sr. Java Developer can sit 100% remote and will be contributing towards greenfield development.Responsibilities for the Remote Sr. Java Developer include: Design, develop, and implem

Piper Companies Piper Companies |
15 d ago

Piper Companies is seeking a REMOTE Network SRE for a world leading technology organization. The REMOTE Network SRE will need to work east coast based hours and will have the opportunity work fully remote. The REMOTE Network SRE will have more networking responsibilities to begin

Piper Companies is looking for a Accounting Business Analyst who would like to join an industry leader in the financial services sector located in PhiladelphiaThis is a Remote Opportunity!Responsibilities for the Accounting Business Analyst include:You will be a servant leader th

Piper Companies Piper Companies |
15 d ago

Piper Companies is looking for a Remote IT/Technical Recruiter who would like to join an industry leader in the online retail sector.This is a Remote Opportunity!Responsibilities for the Remote IT/Technical Recruiter include:You will work as a true business partner spearheading t

Piper Companies Piper Companies |
16 d ago

Piper Companies is currently seeking a Sr. Full Stack Developer for a full-time opportunity with a leading Healthcare provider based in North Carolina (NC). The Sr. Full Stack Developer will partake in engineering and developing features of an existing platform, as well as new so

Piper Companies is currently seeking a Senior UI Developer for a remote fulltime opportunity for a national software-as-a-service corporation. The Senior UI Developer will participate in the creation and delivery of cloud-based software for web applications, consume and integrate