Piper Companies is looking for a Database Architect who would like to join an industry leader in the financial services sector located in Philadelphia, PA
This is a Remote Opportunity!
Responsibilities for the Database Architect include:
You will be responsible for providing leadership and hands-on expertise in assessing, designing, planning and implementing enterprise-wide databases and software systems used to support corporate and department level processes
Qualifications for the Database Architect include:
- At least 5 years of experience and a solid working knowledge of:
o Large Relational Database Management Systems (e.g. MS SQL Server, MySQL, Oracle)
o Relational Database Management, Architecture, Design, Implementation, Migration, Upgrades, etc.
o Writing of complex Stored Procedures, Views, Functions, Triggers, as well as advanced query techniques, report writing and the import/export of data.
o Managing all database maintenance activities from Backup/Recovery, Indexing, Database Integrity and Consistency Checks, to Disaster Recovery and High Availability.
- 2-3 years of experience with Dynamics CRM Online
- Experience managing and maintaining various types of data from many different sources by way of ETL/ELT best practices in SSIS, T-SQL, and Microsoft Azure (e.g. Azure Data Factory/Databricks)
- Ability to assess needs and requirements for enterprise-wide software systems, including systems used to support Enterprise Resource Management (ERP), Manufacturing Resource Planning (MRP), Customer Relationship Management (CRM), Service Management (SM) and the Quality Management System (QMS)
- Ability to facilitate discussion, to teach, and to train concepts related to data retrieval, data analysis, data integrity, and analytical information systems in RDBMS environments
- Expertise in Data Warehouse Architecture & Design, Dimensional Modelling, and Data Profiling.
- Skilled in working with the Microsoft BI stack (SSIS, SSAS, SSRS, Power BI)
- Experience working in a regulated environment ideally medical device company experience preferred
- MCSA or MCSE Microsoft SQL Certification preferred
- BS in Computer Technology or equivalent experience
Compensation and Benefits for the Database Architect:
- Pay is 155K dependent on experience
- Direct Hire, Remote opportunity
- Comprehensive Medical benefits: Medical, Dental, Vision, 401K
Keywords: database engineer, database administrator, database architect, database solutions, enterprise-wide, data solutions, Enterprise Resource Management, ERP, Manufacturing Resource Planning, MRP, Customer Relationship Management, CRM, Service Management, SM,Quality, database design, Management System, QMS, Azure, PaaS, IaaS, SaaS, Azure certified, ETL, ELT, data sources, data extraction, data modeling, SSIS, T-SQL, Oracle NetSuite, SSAS, SSRS, Power BI, data integrity, RDBMS, relational database, data integrity, Azure Data Factory, Azure Data Bricks, Microsoft Azure, Micrsosoft BI, MCSE, MCSA, Stored Procedures, Views, Functions, Triggers, high availability, dimensional modeling, Dynamics CRM, Dynamics 365, data warehouse, remote, benefits, equity, remote job, work from home, medical device
Let us know
Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:
LOAN IQ DEVELOPER_______________________________________________________________________________________LOCATION: Remote in USHIRE TYPE: Full-timeVERTICAL: Financial Markets_______________________________________________________________________________________Role SummaryeClerx i
About UsOrange Kiwi Solutions provides affordable & responsive Prophet 21 expert support to distributors across North America.As a IT Support Technician for Orange Kiwi Solutions, you are responsible for solving complex advanced challenges related to Prophet 21 implementations an
TradesMax is an innovative Fintech company based in Los Angeles, offering U.S. fundamental equity research, real-time financial big data and news. We empower individuals to take control of their financial futures by providing the data tools and services they need to meet their ne
OverviewWe are hiring an experienced Business Intelligence Analyst to join the growing Information Systems team at Hyland. In this role, you will be responsible for understanding business/department needs and goals and will create data-driven analysis and insight to support manag
LOAN IQ BUSINESS ANALYST_______________________________________________________________________________________LOCATION: Remote in USHIRE TYPE: Full-timeVERTICAL: Financial Markets_______________________________________________________________________________________Role Summarye
More jobs by this company
Piper Companies is looking for a Manager, Front-End Engineering who would like to join an industry leader in the financial services sector located in Philadelphia, PAThis is a Remote Opportunity!Responsibilities for the Manager, Front-End Engineering include:You will be responsib
Piper Companies is currently seeking a Python Developer for a new project supporting a federal client. This position will be 100% remote.Duties of the Python Developer:Designing and Developing new software systems to meet client requirements.Performing QA work on the code for pee
Piper Companies is currently seeking a React Software Engineer for a full time position with a Remote first, innovative and modern SaaS company based out of San Francisco, CA. The React Engineer will help support the main application. Responsibilities of the React Software Engine
Piper Companies is looking for a ColdFusion Developer for a Cloud Services company.Responsibilities for the .ColdFusion DeveloperMust have significant experience with ColdFusion, should also have Lucee (open source CFML-generator), ideally experience migrating ColdFusion to Lucee
Piper Companies is presently looking for a Technical Sourcing Specialist for a large commercial retail organization to represent their Software Engineering and Product Management departments. The Technical Sourcing Specialist will create Boolean searches to recruit candidates who
Piper Companies is seeking a 100% remote- Sr. Front End Software Engineer for an opportunity based in San Francisco, California! The Sr. Front End Software Engineer will be responsible for supporting and being a technical lead in an agile environment!Responsibilities of the Sr. F
Piper Companies is currently seeking a Senior Business Intelligence Analyst for a fully remote opportunity in the EST time zone. The BI Analyst will design and implement data reports and visualization, build dashboards for executive leadership, and collaborate with internal teams
Piper Companies is currently seeking a Senior Software Engineer for a 100% remote opportunity! As a Senior Software Engineer, you will utilize your extensive background in web development (C#, and ASP.NET) to contribute to a company culture where change is welcomed and there is c
Piper Companies is seeking a Remote Full Stack Developer for a well-known technology organization in the Raleigh-Durham, NC area. The Full Stack Developer will be responsible for developing and maintaining internal applications. The ideal candidate for the Full Stack Developer ro
Piper Companies has an opportunity for a Java Developer supporting our client who specializes in the development of advanced software solutions for customers across a broad range of industries, from Logistics, Maritime and Aviation to Metals and Manufacturing.Responsibilities for
Piper Companies is seeking a Remote Sr. Digital Applications Developer for a well-known technology organization in the Raleigh-Durham, NC area. The Sr. Digital Applications Developer will be responsible for designing and implementing web applications. The ideal candidate for the.
Piper Companies is looking for a ColdFusion Engineer who would like to join an industry leader in the financial services sector located in Philadelphia, PAThis is a Remote Opportunity!Responsibilities for the ColdFusion Engineer include:You will be responsible for planning, organ
Piper Companies is looking for a Dell Boomi Integration Developer for a leading Financial Services firm in Philadelphia, PAThis is a FULLY REMOTE opportunity! Responsibilities for the Dell Boomi Integration Developer include:You will work with internal and external customers, arc
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 Enterprise Solutions is seeking a Remote Storage/Backup Developer to assist in a large, multi-year project. The Remote Storage/Backup Developer must possess strong skills with NetAPP ONTAP in BFS and Windows multiprotocol environments, be experienced with CommVault Backup,.
Piper Companies is currently seeking a .Net Software Developer for a remote fulltime opportunity in the EST timezone. The Software Developer will participate in the creation and delivery of cloud-based software for web applications, build and integrate REST APIs, and aid in the d
Piper Companies is currently looking for a Remote Senior UI/UX Front End Developer will be responsible for contributing to overall product design, design and implement UI portion of product features, and work with other Service Fabric engineering teams to support and maintain pro
Piper Companies is currently seeking an Senior Web Applications Developer for a REMOTE fulltime opportunity in the EST time zone. The Web Applications Developer will collaborate to design and deploy desk-top web applications in a full-stack context and support the development of.
Piper Companies is looking for an Jr. PowerBI Developer for an managed service provider focused in the financial services industry. This role is 100% remoteResponsibilities for the Jr. PowerBI Developer:Design and develop BI solutions and process documentation for real world data
Piper Companies is currently seeking a Remote C/C++ Developer for a REMOTE opportunity. The Remote C/C++ Developer would be responsible for helping with the development of new features and contributing to ongoing projects for a major networking company.Responsibilities for the Re
Piper Companies is currently seeking a Remote Python Developer to support a major networking company. This position requires a Remote Python Web Developer who will manage data exchange between the server and the users. You will be primarily focused on the development of all serve
Piper Companies is currently seeking a React Native Developer for a REMOTE opportunity for a leading SaaS based company. The React Native Developer will be responsible for working on a variety of different projects across multiple industries. Responsibilities of the React Native.
Piper Companies is looking for a Data Analyst in Horsham, PA (100% remote) for a leading Mortgage solutions company.This position is 100% remote.Key responsibilities for the Data Analyst include:Analyze data, identify, and document PII in the databases.Writing complex SQL queries
Piper Enterprise Solutions is searching for a Software Developer for a client in the healthcare industry. This is a 100% remote position.Responsibilities for the Software Developer:Responsible for the design, deployment, testing and overall management of software applicationsBuil
Piper Companies is seeking a Remote QA Engineer for a growing technology organization. The Remote QA Engineer will join small test team testing web and mobile software solutions. The Remote QA Engineer will plan, create, and manage the overall quality planning strategy.Responsibi
Piper Companies is currently seeking a Sr. Java Developer for a full-time, fully remote 12 month contract opportunity with the Federal Government . The Sr. Java Developer will partake in engineering and developing features of an existing platform. The incumbent can be based anywh
Piper Companies is seeking a Remote Sr. DevOps Engineer for a leading technology organization voted best places to work in the world. The Remote Sr. DevOps Engineer will need to work east coast-based hours and will have the opportunity to work fully remote. The Remote Sr. DevOps.
Piper Companies is looking for an Data Engineer for a financial services firm. This role is 100% remote.Responsibilities for the Data Engineer:Design and develop SSIS solutions and process documentation for real world data applicationsLead reconciliation efforts to ensure data is
Piper Companies is seeking a REMOTE Digital Product Manager for a global organization. The REMOTE Digital Product Manager would be responsible for solving problems using new technologies. In addition the Digital Product Manager would act as a liaison between internal and external
Piper Enterprise Solutions is searching for Associate Director of Data Engineering for a pharmaceutical publishing company. This is a 100% remote position.Responsibilities for Associate Director of Data Engineering: Responsible for analytical reporting using client data, as well.