Database Engineer Jobs At LPL Financial

- 3235 Jobs

Senior Database Architect
LPL Financial Services 4.7
Database Engineer Job At LPL Financial
Are you a team player? Are you curious to learn? Are you interested in working in meaningful projects? Do you want to work with cutting-edge technology? Are you interested in being part of a team that is working to transform and do things differently? If so, LPL Financial is the place for you! Job Overview: The Database Architect's role will be responsible for relational database architecture, collaborating with the data engineering and development teams to provide exceptional customer service and technical expertise. The Database Architect will help align business goals with technical design, focusing on performance tuning for new and existing database systems as well as lead in the design and process for database migrations to the cloud. This is a "hands-on" position requiring solid technical skills with advanced skillsets with SQL Server performance and query optimization, as well as excellent interpersonal and communication skills. This role will also interact with other database platforms. Responsibilities: * Data Architect that specializes in SQL Server performance with heavy collaboration with development organization regarding SQL coding standards and TSQL optimization. * Handon providing best practice and guidelines for the cloud based implementation (PostgreSQL, MongoDB) * Excellent understanding of database design and development * Experience with very large databases and/or data warehousing * Familiarity with RDBMS principles, database design and normalization * Possess the ability to learn how applications work by analyzing schema, querying data, and reviewing SQL * Perform problem determination (root cause analysis) and document the source of problems and their resolution. * Apply Microsoft Best Practices with regards to developing T-SQL queries and stored procedures. * Apply Microsoft Best Practices with regards to database maintenance thresholds for consistency checks, index fragmentation, statistics * Advanced level of reviewing execution plans and not only determine possible indexing changes, but also know how to refactor T-SQL statements to achieve optimal performance. * Ability to become the expert on a specific domain of technology and provide technical consultation to others * Knowledge of SQL Server subsystems and internals * Experience in developing high volume, scalable, data-intensive systems * Entrenched skill in designing and developing highly optimized database code * Highly skilled in urgent real time troubleshooting * Experience working with extended events/SQL profiler and other troubleshooting tools. * Working knowledge of DBMS hardware, including RAM, CPU, Permanent Storage, I/O, and other capacity related resources * Ability to create or review architecture and specification documents ensuring database security, integrity, and performance * Excellent visual, written, and verbal communications with the ability to intuitively put ideas into tangible form * Demonstrated ability in moving a software product through the full development lifecycle * Self-starter who able to articulate the current SQL server Schema/Data modeling complexity and propose the creative/innovative way to unpack the Tech-debt. * Collaborate with architecture and development teams to advise on data platform best practices * Deliver Data Architecture in alignment with our Enterprise Architecture standards and advocate for Enterprise Architecture models and patterns. * Acquire and maintain top quality technical skills in a broad range of DBMSs, technology, and techniques * Facilitate the reuse of code, components, and proven patterns supporting data and modern architecture * Collaborate with business, product, and technology teams early in the M&A and product lifecycle to infuse end-to-end architecture thinking, including functional and non-functional aspects, into the conversation. Craft a high-level design early in the lifecycle and elaborate it to lower levels of detail as the conversation progresses. What are we looking for? We want strong collaborators who can deliver a world-class client experience. We are looking for people who thrive in a fast-paced environment, are client-focused, team oriented, and are able to execute in a way that encourages creativity and continuous improvement. Requirements: * Bachelor's Degree in Computer Science or Information Systems or equivalent work experience * 5+ years of hands-on design and implementation experience on Microsoft SQL Server version (2005-2022) * 3+ years of hands-on experience in cloud-based implementation of complex systems (AWS preferred) * 5+ years of experience in hands-on design and implementation of complex systems, including data and reporting. * 3+ years of experience in the following technical disciplines: application development, middleware, database management or operations, security, integration Core Competencies: * Experience with query and indexing best practices, data partitioning * Excellent knowledge of system views and system stored procedures using T-SQL. * Excellent communication skills that translate business problems into technical solutions * Consult with customers to solve business problems by adapting current technology and/or capitalizing on emerging technology for competitive advantage to meet the strategic objectives * Conduct demonstrations and presentations to executive management of prototypes and proof-of-concepts. * Understanding of agile methods (SAFe) and processes, and capability of supporting agile product teams by providing advice and guidance on opportunities, impact and risks, taking account of technical and architectural debt Preferences: * Microsoft certification, or training from industry-leading consultants, such as Brent Ozar or SQLskills * Experience with Oracle and PostgreSQL * AWS Certification * Proven experience in developing conceptual, logical and physical data model for customer and product domains. * Experience with advanced SQL Server features, such as service broker, resource governor, query store, openjson, table-valued parameters, etc. Pay Range: $105,600-$176,000/year Actual base salary varies based on factors, including but not limited to, relevant skill, prior experience, education, base salary of internal peers, demonstrated performance, and geographic location. Additionally, LPL Total Rewards package is highly competitive, designed to support your success at work, at home, and at play - such as 401K matching, health benefits, employee stock options, paid time off, volunteer time off, and more. Your recruiter will be happy to discuss all that LPL has to offer! Company Overview: LPL Financial Holdings Inc. (Nasdaq: LPLA) was founded on the principle that the firm should work for advisors and institutions, and not the other way around. Today, LPL is a leader in the markets we serve, serving more than 23,000 financial advisors, including advisors at approximately 1,000 institutions and at approximately 580 registered investment advisor ("RIA") firms nationwide. We are steadfast in our commitment to the advisor-mediated model and the belief that Americans deserve access to personalized guidance from a financial professional. At LPL, independence means that advisors and institution leaders have the freedom they deserve to choose the business model, services, and technology resources that allow them to run a thriving business. They have the flexibility to do business their way. And they have the freedom to manage their client relationships, because they know their clients best. Simply put, we take care of our advisors and institutions, so they can take care of their clients. Join LPL Financial: Where Your Potential Meets Opportunity At LPL Financial, we believe that everyone deserves objective financial guidance. As the nation's leading independent broker-dealer, we offer an integrated platform of cutting-edge technology, brokerage, and investment advisor services. Why LPL? * Innovative Environment: We foster creativity and growth, providing a supportive and responsive leadership team. Learn more about our leadership team here! * Limitless Career Potential: Your career at LPL has no limits, only amazing potential. Learn more about our careers here! * Unified Mission: We are one team on one mission-taking care of our advisors so they can take care of their clients. Learn more about our mission and values here! * Impactful Work: Our size is just right for you to make a real impact. Learn more here! * Commitment to Equality: We support workplace equality and embrace diverse perspectives and backgrounds. Learn more here! * Community Focus: We care for our communities and encourage our employees to do the same. Learn more here! * Benefits and Total Rewards: Our Total Rewards package goes beyond just compensation and insurance. It includes a mix of traditional and unique benefits, perks, and resources designed to enhance your life both at work and at home. Learn more here! Join the LPL team and help us make a difference by turning life's aspirations into financial realities. Please log in or create an account to apply to this position. Principals only. EOE. Information on Interviews: LPL will only communicate with a job applicant directly from ******************** email address and will never conduct an interview online or in a chatroom forum. During an interview, LPL will not request any form of payment from the applicant, or information regarding an applicant's bank or credit card. Should you have any questions regarding the application process, please contact LPL's Human Resources Solutions Center at **************. EAC1.22.25
$105.6k-176k yearly 14d ago
Database Administrator
Motion Recruitment 4.5
Chicago, IL Jobs
Our client a s a major international retail group is hiring for a Database Administrator to join their team in Chicago, Illinois. This is a HYBRID 10-month contract to hire position. As their Database Administrator you will design and implement strategies, manage database migrations and manage and maintain PostgreSQL databases on Azure. The ideal candidate will 5+ years of Azure experience. Responsibilities: - Manage and maintain PostgreSQL databases on Azure Flexible Server. - Ensure database performance, integrity, and security. - Manage database migrations and version control using Flyway. - Collaborate with development and operations teams to deploy resources using code. - Develop and maintain ARM templates and Azure DevOps pipelines. - Monitor and optimize database performance metrics. - Implement and manage backup and recovery processes. - Troubleshoot and resolve database issues. - Maintain database documentation and standards. - Stay updated with the latest database technologies and trends. Required Skills: - Proven experience as a PostgreSQL DBA. - Strong understanding of database architecture and design. - Experience with Azure Flexible Server and other Azure services. - Proficiency in disaster recovery planning and implementation. - Expertise in performance tuning and database optimization. - Experience with Flyway for database migrations. - Familiarity with ARM templates and Azure DevOps pipelines. - Proficiency in SQL and database scripting. - Working knowledge of other databases such as SQL Server, Cosmos DB, and Informix. - Strong problem-solving skills and attention to detail. - Excellent communication and collaboration skills. Preferred Skills: - Experience with database automation and scripting. - Knowledge of data protection regulations and compliance. - Ability to work under pressure and meet deadlines.
$68k-93k yearly est. 29d ago
System Engineer
Net2Source Inc. 4.6
Everett, WA Jobs
Net2Source is a Global Workforce Solutions Company headquartered at NJ, USA with its branch offices in Asia Pacific Region. We are one of the fastest growing IT Consulting companies across the USA and we are hiring “Systems Engineer" for one of our clients. We offer a wide gamut of consulting solutions customized to our 450+ clients ranging from Fortune 500/1000 to Start-ups across various verticals like Technology, Financial Services, Healthcare, Life Sciences, Oil & Gas, Energy, Retail, Telecom, Utilities, Technology, Manufacturing, the Internet, and Engineering. Systems Engineer Location: Everett, WA Duration: 12 months Pay Rate: $85-$100/hr. Position Responsibilities: Use modeling, simulation and data analytics methodologies & tools including statistical and probabilistic analyses. Serve as a technical specialist supporting other functional design groups during all stages of the airplane product development and support lifecycle. Responsible for aiding in determining program technical performance measures (TPMs) such as schedule reliability, airplane operational availability & maintenance cost. Provide support in the following areas: Design for Reliability & Safety (airplane and system design reliability requirements validation & verification, reliability requirements allocation to suppliers, failure modes, rates, effects, propagation and detection analysis, architecture & operational provisions, safety & certification analysis, certification support, reliability & durability testing), Design for Maintainability (airplane and system design maintainability requirements validation & verification, task time analysis, maintainability evaluation of design using digital maintainability tools including virtual and augmented reality tools), requirements for and assessment of airplane technical performance measures (TPMs) such as schedule reliability, airplane operational availability & maintenance costs, TPM guarantee analysis. Interaction with airplane system suppliers, business partners, airline customers, airplane development program leaders, and functional management is typical, as is a high level of communication between the rest of the R&M Engineering internal organization, program teams, and functional design areas. Team involvement and individual effort, problem solving, and managing multiple actions and assignments will be regular duties for an R&M engineer. This position must meet Export Control compliance requirements, therefore a “US Person” as defined by 22 C.F.R. § 120.15 is required. “US Person” includes US Citizen, lawful permanent resident, refugee, or asylee Basic Qualifications (Required Skill/Experience): Bachelor of Science degree or higher from an ABET (or similar) accredited course of study in an engineering discipline, computer science, mathematics, physics or chemistry. 8-14 or more years' related work experience in an engineering field 5 or more years of Reliability Engineering experience in commercial aviation Experience in airplane systems design or engineering analysis (e.g. Propulsion, Electrical Power, Mechanical, Network, Fuels, Pneumatic, Interiors, Flight Controls, Hydraulics, Avionics, Fuels, etc.) Fault Tree Analysis (FTA) experience in commercial airplane certification. Proficient in FTA software tools such as CAFTA, ReliaSoft or FaultTree+. Experience in FTA integration for commercial airplanes.
$85-100 hourly 10d ago
System Engineer
Links Technology Solutions 4.0
Linthicum, MD Jobs
Links Technology is currently seeking a motivated and skilled Systems Engineer II to join our client's team in Linthicum, MD. Our client is a cutting-edge organization focused on growing Cyber Security projects that significantly impact the DOD/Intel community. This is a full-time role offering the opportunity to work on highly classified and impactful national security operations, with a focus on Offensive Cyber Operations (OCO) and Defensive Cyber Operations (DCO) activities. Responsibilities of the Systems Engineer II: Perform traditional System Engineering and Vulnerability research. Support assessments of large-scale weapons systems and other national security operations. Analyze needs, derive system-level requirements, and contribute to the design, development, implementation, and maintenance of computer networks and systems. Perform System Engineering of secure command, control, communications, and intelligence (C3I) systems. Engage in microelectronics engineering, integrated circuit design, and integrated circuit reverse engineering. Collaborate with diverse organizations and teams to accomplish system engineering tasks. Qualifications of the Systems Engineer II: Minimum of eight (8) years of experience in relevant fields (Electrical/Computer/Software Engineering, Computer Science, Math, or Information Systems). (Education and technical certifications, such as DAWIA Level 2 SPRD&E, can substitute for up to six (6) years of experience). At least 2 years of experience as a Systems Engineer, including leading and collaborating with diverse teams. Experience with System Engineering of secure C3I systems. Experience analyzing needs, deriving system level requirements, and contributing to the design, development, and implementation and maintenance of computer networks and systems. Microelectronics Engineering, integrated circuit design and integrated circuit reverse engineering skills. Active TS/SCI with Full Scope Polygraph clearance required. Strong analytical and problem-solving skills. Excellent communication and collaboration skills. Desired Additional Skills: Familiarity with NIST SP 800-160 systems security engineering considerations. Familiarity with INCOSE defined lifecycle systems engineering processes. Proven ability to learn new technologies independently. Experience defining a system of systems architecture. Experience with independent verification & validation of security requirements. Familiarity with weapons system development, sustainment, and security operations. Knowledge of reliability and/or safety engineering methods. Experience incorporating systems resiliency and security engineering concepts into acquisition documents. Experience in technical evaluations of contractor proposals for systems resiliency, security, and cyber security considerations. Familiarity with embedded systems and RF concepts. Familiarity with space-based systems and/or space support ground systems. Familiarity with DoD tactical networking. Experience with Systems Theoretic Process Analysis (STPA). Knowledge of hardware, software, supply chain, systems vulnerabilities, anti-tamper and exploitation approaches. Experience in vulnerability discovery, and analysis tools, fuzzing tools, and dynamic system analysis. Benefits of the Systems Engineer II: Comprehensive health, dental, and vision insurance. Matching 401k. 10 Days PTO. Opportunity to work on cutting-edge cybersecurity projects. Significant impact on the DOD/Intel community. Challenging and rewarding work environment. Pay Range: $168,000 - $178,000
$168k-178k yearly 23d ago
Power Systems Engineer
PTS Advance 4.0
Houston, TX Jobs
Job Title: ELECTRICAL POWER ENGINEER - PROTECTION & CONTROL General Description Our client is a nationally recognized electrical power and control systems engineering firm and is seeking a qualified Electrical Power Engineer focused in protection and control in Alpharetta, GA, or Houston, TX to aid the growing electrical power offerings. Key Experience & Skills 4-8 years' Experience with programming and configuring SEL RTACs, including developing HMI interfaces, logic, and data concentrator functionality. Experience in integrating electrical SCADA system with knowledge of OSI AspenTech or similar platforms for real-time monitoring and control. Experience with electrical power relay settings generation and implementation - GE Multilin and SEL preferred In-depth knowledge of communication protocols such as DNP3, MMS and GOOSE & familiarity with IEC 61850 family of standards. Experience in the development of electrical construction packages comprised of at least the following: Single Line Diagrams Three Line Diagrams Schematics/Elementary Diagrams Interconnection Diagrams Logic Diagrams Knowledgeable of the requirements detailed in National Electrical Code (NEC), National Electrical Safety Code (NESC) and IEEE 3000 Series (formerly known as color books) preferred Experience with power system modeling tools - ETAP, SKM, or EasyPower preferred Adept at the use of Microsoft Office Suite, particularly Microsoft Excel Highly effective at written and verbal communications Education Bachelor's degree in electrical engineering Fundamentals of Engineering (FE) Exam Completion Responsibilities Development of settings files for SEL protection relays and other similar devices Development of settings files for SEL RTACs, including data concentration, HMI, and logic Integrating electrical SCADA information with OSI AspenTech or similar platforms Perform onsite programming, field testing, and commissioning of electrical protection, control, and SCADA systems Development of comprehensive electrical construction packages sufficient for installation of protection, control, and SCADA systems. Maintain detailed documentation of relay settings, RTAC configurations, and system integration processes. Provide best possible response after hours support for internal/external clients as occurs Work with applicable Project Manager(s) to ensure overall quality of commercial deliverables, budget maintenance, etc. Keep the Project Manager(s) informed of technical progress, issues, need for change orders, etc. Assist Project Manager(s) in developing cost estimates and proposals for new project opportunities - providing technical expertise and guidance in applying cost to labor, expense, and procurement items Travel +/- 40% with willingness to travel via air Core Competencies Safety: Applies safety policies; displays enthusiasm for safety; is proactive in safety matters; attends company safety meetings Accountability: Works required days; works required hours; follows company check-in check-out procedure Attitude: Exhibits a positive 'can do' attitude; shows initiative; demonstrates dependability, commitment, and involvement; accepts direction from qualified sources Teamwork: Interacts well with co-workers; displays a willingness to cooperate with team; assists team members; shows respect for all team members Knowledge: Applies the specific requirements of the job; displays the ability to perform the technical skills required by the job; knows and applies company policies Quantity and Quality of Work: Work performed meets or exceeds company standards of acceptability; has the ability to manage multiple tasks Problem Solving and Action: Analyzes problems and takes action based upon decisions made with good judgment Communication: Demonstrates ability to clearly, effectively, and respectfully communicate with clients and fellow coworkers; communications are timely and intelligent whether written or verbal Benefits Competitive salary with a discretionary bonus for hours worked in excess of 80 hours in a two-week pay period Benefit Time Off (BTO) that can be used as paid vacation, sick time, holiday funding, or can be taken as cash Employee Stock Ownership Plan (ESOP) 401(k) Matching Company funded health insurance Health club sponsorship
$87k-117k yearly est. 10d ago
Systems Engineer
Kellymitchell Group 4.5
SeaTac, WA Jobs
Our client is seeking a Systems Engineer to join their team! This position is located in SeaTac, Washington. Act with advanced knowledge of the implementation and maintenance of company's IT infrastructure Apply advanced skills in multiple technical areas such as containerization, automation, cloud platforms, hardware/software administration, enterprise architecture, and security and compliance to improve operational reliability and IT maturity Partner with Enterprise Architecture, maintaining the strategy and vision of AAG's technology systems and ensuring alignment of forward-looking strategies and roadmaps Take initiative to research, develop, and communicate technology roadmaps, opportunities, and constraints to IT leadership Apply industry best practices to the continuous process improvement life cycle that drives operational excellence Participate in the team's on-call rotation schedule Desired Skills/Experience: Bachelor's degree in a relevant field 2+ years of technical IT experience or a related field Proven experience working in data center environments, including but not limited to Active Directory (AD), VMware, Citrix, NetApp, Cisco, F5, and SCCM Hands-on experience with hosted cloud environments such as Microsoft Azure, Amazon Web Services (AWS), or Google Cloud Platform (GCP) Proficiency with enterprise operating systems, including Windows Server, Windows 10, and Enterprise Linux Demonstrated experience in implementing automation, effective monitoring, and infrastructure-as-code (IaC) solutions Strong ability to automate operational processes with precision, ensuring compliance with security requirements and alignment with customer service standards, while minimizing errors and enhancing efficiency Benefits: Medical, Dental, & Vision Insurance Plans 401K offered $29.71 - $42.44 (est. hourly)
$98k-129k yearly est. 12d ago
System Engineer
Yochana 4.2
Everett, WA Jobs
Minimum 2- 5+ years of experience in Avionics with system engineering background. Working experience on SR&O and SCD requirements. Performing requirements validation, which describes how the requirements will be shown to be complete and correct. Performing requirements verification, which defines the processes and Criteria to be applied when showing how the implementation satisfies its requirements. Requirement closure includes Reviews. Completeness of design verification activities. Experience working on DOORS and ITRACS A series of four Process Assurance Reviews (PARs) are required for 777X requirements planning, development, validation and verification: 1. Planning review(PAR1) 2. Validation review(PAR2) 3. Verification review(PAR3) 4. Final review(PAR4) System Testing and execution on Test equipment. Knowledge of DO178B/C Working experience on projects will be added advantage Knowledge of Avionics systems.
$85k-115k yearly est. 10d ago
System Engineer - MBSE
John Galt Staffing 3.9
Lexington, MA Jobs
3+ Year Contract that comes with full benefits. requires obtaining a Department of Defense Secret Clearance. US Citizenship required W2 only and must be able to work on site 4 days a week The selected candidate will work on a team performing systems engineering activities for a large program. Responsibilities include developing, flowing down and tracking requirements, architecting systems, developing an MBSE model of the systems and their interfaces, planning and leading verification and validation activities, and identifying risks and defining risk mitigation strategies. The successful candidate should have: • A Bachelors Degree in Physics, Mechanical, Electrical, Aero/Astro, Software Engineering, or related fields and at least 5 years of relevant experience with systems engineering for space or airborne systems. A MS degree or PhD can be substituted for years of experience. • The ability to support a full range of systems engineering activities for multiple programs • The ability to use a systems perspective to identify needed technology development efforts • Excellent written and verbal communication skills, including the ability to produce and present professional written reports and presentations • Experience with SysML Model-Based Systems Engineering (MBSE) tools is required. Preferred: • Experience with MagicDraw. • Experience with integration of hardware and software is helpful
$77k-109k yearly est. 30d ago
System Engineer (Signaling - Rail Industry)
Hitachi Rail 4.4
Pittsburgh, PA Jobs
Hitachi Rail is looking for an enthusiastic self-motivated Signaling System Engineer who thrives in a fast-paced environment. The position is based in Pittsburgh, PA. About us: A career at Hitachi Rail will help create a legacy. With operations in every corner of the world, our work goes to the cutting-edge of digital transformation and technology. From the multi-cultural strength of our global organization to the sustainable and innovative ways we work to bring people together, there's something for everyone to get stuck into. And that's where you come in. Accountabilities: Ensure the identification, the management and the traceability of Overall Signaling System Requirements for the entire life cycle of the project (Design and Testing) Ensure the apportionment of Overall Signaling System requirements to each of the subsystems which constitute the Signaling system. Ensure the Signaling System Design and ATC Gap Analysis from a define version to achieve proper Signaling System Functionalities and performances. Ensure the identification, management and resolution of all the interfaces between the Signaling Subsystem and the Other Subsystems (e.g. Rolling Stock, TLC) as well as the internal interfaces within the Signaling Subsystem. Ensure the definition of the Physical Architecture of the Signaling part and Integrate it within the Overall Physical Architecture of the overall System. Ensure that the Development of the Products complies with the Requirements and Interfaces of a project. Ensure the delivery of the assigned tasks on time, on budget and quality. Ensure efficiency and standardization of signaling systems across different projects (e.g. Design specifications). Ensure the definition of signaling system integration test procedures, the implementation of any requested test improvement, the execution of such tests and the preparation of final test dossier. Ensure the definition of lab test procedures, the implementation of any requested test improvement, the execution of such tests and the preparation of final test dossier Understands and integrates applicable CMMI, CENELEC, AREMA, IEEE, IPC, etc standards. Responsible for the Engineering Solution Contribute to system configuration activities, to requirement management activities and Data preparation for ERTMS systems. Required Skills/Knowledge: From 3 up to 5 years of Engineering expertise in Signaling Systems Conventional signaling control designs CBTC (Communication based train control) systems and designs Extensive understanding and/or prior experience with engineering lifecycles, delivery, and HW/SW integration lifecycle and demonstrate the ability to deliver solutions to closure Prior experience managing small-medium sized projects and project teams Strong prior experience with Microsoft Office suite, requirements management systems, product lifecycle management systems, defect tracking tools, and software configuration tools Demonstrated ability to lead, engage, and manage tasking of cross-functional teams of varying skills/experience Builds effective relationships and has exceptional communication and leadership skills Ability to acquire deep understanding of new technologies with minimal guidance Ability to communicate complex ideas to peers, management, and customers in a simplified manner Strong technical troubleshooting and problem solving abilities Strong prior experience applying fundamental Systems Engineering concepts: V-lifecycle, System Architecture Requirements Management, Configuration Management, Interface Management, Deep competency in interactions between mechanical, electrical, and software components in complex electromechanical systems Success with multi-tasking across multiple projects at given time Detail oriented with excellent organizational skills Rail or rail transit domain experience Desired Skills/Knowledge: Prefer Expertise in any ONE or more of the following: High Speed Railways System and designs Power systems including traction power and medium to low voltage designs EMI / EMC system integration and validation Telecoms and Network designs Automated control design and development systems Prior experience collaborating with a diverse, cross-functional team across multiple geographic locations Education: Electrical, Electronic, or Computer Engineering or Information Technology Qualifications/ University Degree or Equivalent Technical Background Language: English-Proficient Benefits: Hitachi Rail employees enjoy a comprehensive benefits package including Competitive Pay, Medical, Dental and Vision Insurance, Short & Long Term Disability, Life & Accident Insurance, Flexible Spending Accounts, a Retirement Savings Plan, and Paid Vacation. We also offer a number of Work/Life Programs such as Flextime and a variety of Training and Development opportunities. We thank all applicants for their interest; however, only those under consideration will be contacted. Join us at *************************** It is our commitment at Hitachi Rail to create a diverse environment and we are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. We would be delighted if you would be one of our followers! Have a glance at our LinkedIn page ********************************************* Equal Opportunity Employer (EOE)-Females/Minorities/Protected Veterans/Individuals with Disabilities If you need a reasonable accommodation to apply for a job at Hitachi, please send the nature of request and contact information to ******************************. Queries other than accommodation requests will not be responded to. In accordance with the DOT's FRA and FTA programs, Hitachi's substance screening program tests pre-employment candidates and current employees, as required for safety-sensitive positions.
$84k-115k yearly est. 29d ago
System Engineer
Acro Service Corp 4.8
Lexington, MA Jobs
Job Title: Systems Engineer Duration: 36 months contract on W2 (possible extension) Candidates should have an active Secret Clearance Required Minimum Bachelors of Computer Science or relevant technical field of study Experience providing support for RHEL & Ubuntu workstation and server Experience utilizing Ansible Automation Platform to support Linux systems Experience utilizing Satellite and Landscape to support Linux systems Experience with bash/shell, Python or Perl scripting Understanding of Linux troubleshooting to include the boot process, Kickstart building, systemd, monitoring of system resources, kernel tuning, system performance troubleshooting, system calls and tracing Experience configuring storage for Linux systems (LVM, file systems, RAID, storage encryption, SAN, NAS and NFS) Package development and deployment (rpm, yum, dnf, apt) Strong overall network skills (package captures, NIC latency tuning, route tables and tracing, subnetting, firewall/iptable, TCP/UDP/IP protocols) Ability to work independently toward delivery of goals as well as collaborate in team efforts Excellent customer service skills Excellent presentation, verbal and written communication skills Demonstrate the ability to learn new technologies and disciplines quickly Preferred Experience supporting DevSecOps environments (with Github, Jfrog, Jenkins, GitLab, Fortify, Docker, Kubernetes, or SonarQube) Experience supporting software deployment on Linux Experience supporting AWS cloud infrastructure. Clearance: Candidates should have an active clearance (secret/top secret, etc.) in order to be considered for this position due to the nature of the work being done. Do not submit candidates if they do not meet this requirement. Work schedule: This position is VIRTUAL. The candidate can work remotely but they MUST live within 100 miles of Lexington so that they can come into the Lab if necessary for the needs of the program. The onsite work will not be regular.
$100k-130k yearly est. 24d ago
Frontend Software Engineer
Consensus 4.5
San Francisco, CA Jobs
Consensus is an AI search engine for scientific research. We use LLMs to help millions of users find and analyze research papers, easily. Our Series A was led by USV, with major participation from top AI investors like Nat Freidman and Daniel Gross. Consensus has been featured in The Wall Street Journal, The Atlantic, The New York Times, Nature, and a16z as one of the world's most exciting new AI search engines. Our mission is to make expert knowledge discoverable and consumable for all. Help us build the future of research. Role We are seeking a Frontend Engineer to design, build, and maintain the user-facing elements of our high-traffic web search engine application. You will work closely with our design, product, ML, and backend teams to craft delightful experiences and ensure our users can discover and consume scientific research effortlessly. Responsibilities Develop user-facing features using React, Next.js, and TypeScript, ensuring performance and responsiveness across devices. Collaborate with design teams to transform wireframes, mockups, and user insights into intuitive interfaces with a keen eye for aesthetics. Leverage Tailwind CSS to implement clean, scalable, and maintainable styles that deliver a cohesive visual language. Implement and maintain frontend observability through logging, monitoring, and testing to ensure a stable user experience. Work alongside the backend engineering team to integrate APIs and services seamlessly, managing data flows in a performant and secure manner. Optimize frontend builds and workflows, contributing to the continuous integration and delivery (CI/CD) pipelines. Stay current with emerging frontend technologies and best practices to continuously improve our application's user experience. Must Haves 5+ years of frontend web development experience, with a focus on modern JavaScript frameworks (React, Next.js). Strong proficiency in TypeScript and familiarity with best practices for scalable codebases. Demonstrated ability to create beautiful, intuitive interfaces using CSS (preferably Tailwind CSS). Experience with frontend observability: setting up logging, performance monitoring, error tracking, and automated testing. Familiarity with CI/CD pipelines and version control (Git) in a professional environment. Nice to Haves Experience with design systems or advanced CSS methodologies. Familiarity with server-side rendering and SEO optimizations in Next.js. Knowledge of backend fundamentals to facilitate close collaboration with backend teams. An eye for UX/UI design Why You'll Succeed Attention to detail and craft: You care about pixel-perfect UIs and cohesive user experiences. Track record of high-velocity delivery: You move fast, but don't break things. Interest in scientific research, AI/LLMs, and a passion for leveraging technology to advance human knowledge.
$108k-149k yearly est. 29d ago
System Engineer
Stevendouglas 4.1
Aurora, CO Jobs
Title: System Engineer Work Requirements: US Citizen This role is not open to third party vendors. We are seeking a motivated Sr. Systems Engineer to join a dynamic team supporting one of our client's premier programs. In this pivotal role, you will leverage your expertise in clarifying requirements, conducting systems engineering analyses, developing algorithms, defining interfaces, and performing validation and verification. This is a hands-on opportunity to directly influence key technical decisions and ensure mission success. RESPONSIBILITIES • Technical Analysis and Use Cases: Conduct in-depth analyses, create system use cases, and determine how the system will function in various scenarios. • Requirements Decomposition and Interface Definition: Break down complex requirements, define system interfaces, and guide the test team on validation and verification strategies. • Engineering Support and Test Execution: Provide technical direction for test processes, including test architecture design, baseline definition, and subsequent verification and validation activities. • Regression Testing and Baseline Management: Oversee regression testing across multiple deliverable releases, maintaining strict adherence to project baselines. • Technical Collaboration: Participate in technical reviews and interchanges, bringing forward innovative solutions and ensuring alignment across cross-functional teams. REQUIREMENTS • Education and Experience: Bachelor's degree in a STEM field (Science, Technology, Engineering, or Mathematics) with at least 5 years of relevant experience • Security Clearance: Active Top Secret/SCI clearance (U.S. citizenship required) • Systems Engineering Lifecycle: Demonstrated experience in areas such as operations concept development, requirements management, functional analysis or synthesis, interface definition or control, and verification and validation • Government Contracting: Proven track record on government contracts with familiarity in Agile and DevSecOps environments • Technical Skills: Proficiency in the Microsoft Office suite (Word, Excel, PowerPoint, etc.) PREFERRED QUALIFICATIONS • Communication and Teamwork: Strong oral and written communication and collaboration skills • Satellite and Mission Management: Experience in satellite command or control, mission management, or planning • Agile Toolsets: Familiarity with JIRA, Confluence, BitBucket, and other Agile platforms • Requirements Tools: Experience working with DOORS or similar requirements databases • DevOps or DevSecOps: Background in iterative development processes • Scripting: Knowledge of Python or similar scripting languages If you are ready to excel in a fast-paced environment and make a real impact on a high-profile program, we encourage you to apply.
$72k-102k yearly est. 12d ago
System Engineer
Long Wave Inc. 4.2
Oklahoma City, OK Jobs
***US Citizenship REQUIRED*** ***NO VISA SUPPORT or C2C*** ***On-Site in OKC REQUIRED*** ***Active DoD Secret Clearance or higher is Preferred*** Primary Function: Long Wave is seeking a highly skilled Systems Engineer with a strong background in Model-Based Systems Engineering (MBSE), requirements management, and Department of Defense (DoD) experience. The ideal candidate will be responsible for designing, developing, and managing complex systems and ensuring they meet all specified requirements within schedule. Essential Responsibilities: Model-Based Systems Engineering (MBSE): Apply MBSE methodologies to support system requirements, design, analysis, verification, and validation activities. Requirements Management: Develop, document, and manage system requirements throughout the project lifecycle. Ensure traceability and compliance with DoD standards. System Design and Integration: Lead the design and integration of complex systems, ensuring they meet performance, reliability, and safety standards. Verification and Validation: Develop and execute test plans to verify and validate system performance against requirements. Technical Documentation: Create and maintain detailed technical documentation, including system specifications, design documents, and test plans. Collaboration: Work closely with cross-functional teams, including software, hardware, and project management, to ensure successful project delivery. Compliance: Ensure all systems and processes comply with DoD regulations and standards. Must be able to communicate effectively in the English language. Perform other duties as assigned. Work Conditions: Employee will be working within an office environment. Employee may be expected to travel on occasion to locations where specific PPE or attire is necessary. Job Requirements: Minimum Requirements: Education: Bachelor's or Master's degree in Systems Engineering, Electrical Engineering, Computer Science, or a related field. Experience: 5-10 years of experience in systems engineering, with a focus on MBSE, requirements management, and DoD projects. Technical Skills: Proficiency in MBSE tools (e.g., MagicDraw, Cameo Systems Modeler), requirements management, and systems engineering methodologies. Security Clearance: Active DoD Secret clearance or higher is preferred. US Citizenship and Eligibility for a DoD Clearance is required. Preferred Requirements: Experience: Previous experience with DoD acquisition processes and lifecycle management. Tools: Familiarity with simulation and modeling tools, and experience with Agile development methodologies. Position Benefits As a full-time employee of Long Wave, you are eligible for our benefits package including: Competitive Salary Medical, Dental & Vision coverage 401k Educational Assistance Life Insurance Employee Assistance Programs & Work/Life Solutions Paid Time Off This position's standard work schedule is a 9/80. The 9/80 schedule allows employees who work a nine-hour day Monday through Thursday to take every other Friday off. EOE AA M/F/Vet/Disability
$65k-88k yearly est. 16d ago
Frontend Software Engineer
Consensus 4.5
Fremont, CA Jobs
Consensus is an AI search engine for scientific research. We use LLMs to help millions of users find and analyze research papers, easily. Our Series A was led by USV, with major participation from top AI investors like Nat Freidman and Daniel Gross. Consensus has been featured in The Wall Street Journal, The Atlantic, The New York Times, Nature, and a16z as one of the world's most exciting new AI search engines. Our mission is to make expert knowledge discoverable and consumable for all. Help us build the future of research. Role We are seeking a Frontend Engineer to design, build, and maintain the user-facing elements of our high-traffic web search engine application. You will work closely with our design, product, ML, and backend teams to craft delightful experiences and ensure our users can discover and consume scientific research effortlessly. Responsibilities Develop user-facing features using React, Next.js, and TypeScript, ensuring performance and responsiveness across devices. Collaborate with design teams to transform wireframes, mockups, and user insights into intuitive interfaces with a keen eye for aesthetics. Leverage Tailwind CSS to implement clean, scalable, and maintainable styles that deliver a cohesive visual language. Implement and maintain frontend observability through logging, monitoring, and testing to ensure a stable user experience. Work alongside the backend engineering team to integrate APIs and services seamlessly, managing data flows in a performant and secure manner. Optimize frontend builds and workflows, contributing to the continuous integration and delivery (CI/CD) pipelines. Stay current with emerging frontend technologies and best practices to continuously improve our application's user experience. Must Haves 5+ years of frontend web development experience, with a focus on modern JavaScript frameworks (React, Next.js). Strong proficiency in TypeScript and familiarity with best practices for scalable codebases. Demonstrated ability to create beautiful, intuitive interfaces using CSS (preferably Tailwind CSS). Experience with frontend observability: setting up logging, performance monitoring, error tracking, and automated testing. Familiarity with CI/CD pipelines and version control (Git) in a professional environment. Nice to Haves Experience with design systems or advanced CSS methodologies. Familiarity with server-side rendering and SEO optimizations in Next.js. Knowledge of backend fundamentals to facilitate close collaboration with backend teams. An eye for UX/UI design Why You'll Succeed Attention to detail and craft: You care about pixel-perfect UIs and cohesive user experiences. Track record of high-velocity delivery: You move fast, but don't break things. Interest in scientific research, AI/LLMs, and a passion for leveraging technology to advance human knowledge.
$107k-148k yearly est. 29d ago
Model Based System Engineer
Infomatics, Inc. 3.8
Sterling Heights, MI Jobs
Responsibilities to Anticipate/Expect: Provides technical direction to MBSE Systems and Software Engineers for the execution of engineering projects within a SysML model using the Cameo Enterprise Architecture tool. Coordinate with program office personnel in the development of proposals, scopes of work, program plans, statements of work, and work breakdown structures concerning the role of MBSE on the program to help define the program. Define “how” Engineering will execute all aspects of the System Engineering using MBSE to include the development and review of requirements, requirements flow down, system architecture, opportunity and risk management, trade studies, technical performance measures, testing, interface control, cost control, weight management, technical program review preparation, system integration, verification, and validation. Prepare appropriate plans to capture these activities which includes ownership and responsibility of MBSE staged elements Support the SEM, SEIT Lead, and Chief Engineer in their role to Define and Review the Technical Product solution that resides in the MBSE Define, Develop, and Manage the MBSE elements of a program into a defined SysML configuration. Areas include staging Requirements, Behavior, Structure, Interfaces, and Parametric elements in an MBSE tool for a program. Guide the program team using the MBSE model in the development of requirement decomposition for Functional and Non-functional requirements from the System Specification to the allocated baseline of HWCI and SW CSCI requirements. Guide the program in the use of MBSE structures for functional decomposition from System Functions to component functions. Establish the structure and staging in the model for building and linking SysML artifacts in the generation of Activity Diagrams, State Machines, Sequence Diagrams, Block Definition Diagrams (BDDs), Internal Block Diagrams (IBDs) and their associated derived requirements. Guide the program team in the development of MBSE interfaces and the generation of proper Data Architecture Model Libraries (DAML) and Domain Specific Data Models (DSDM) according to the Ground Combat System (GCS) Common Infrastructure Architecture (GCIA) models and documentation. Build and maintain MBSE-based metrics for the programs' TPMs, Trades, Risks, and Design Decision Memorandums (DDMs). Provide program metrics on the maturation of the MBSE environment in compliance with the contract, program requirements, and GCIA implementation. Define and Stage the MBSE for consumption of program CDRLs into the SysML model as required by the contract to digitize the engineering environment. Support the Digital Engineering (DE) initiative of digitally connecting tools such as Teamcenter, Cameo, MADe, Capital Harness, SLICWave, etc. to provide a seamless integrated environment that supports a single Source of Truth initiative for all engineering products. Develop Style Guides for each area of the MBSE. I am responsible for other duties as assigned. Minimum Qualifications / What you must have · Bachelor's Degree in an Engineering Discipline. Similar technical degrees may be considered if experience aligns with this job function. · Minimum of 10+years of related engineering experience. · Strong Vehicle System engineering experience required. · Proficient in Microsoft Office Suite. Must have Cameo experience
$80k-102k yearly est. 10d ago
Systems Engineer - LLJP00001663
Softworld, a Kelly Company 4.3
Lexington, MA Jobs
The selected candidate will work on a team performing systems engineering activities for a large program. Responsibilities include developing, flowing down and tracking requirements, architecting systems, developing an MBSE model of the systems and their interfaces, planning and leading verification and validation activities, and identifying risks and defining risk mitigation strategies. The successful candidate should have: A bachelor's degree in physics, Mechanical, Electrical, Aero/Astro, Software Engineering, or related fields and at least 5 years of relevant experience with systems engineering for space or airborne systems. A MS degree or PhD can be substituted for years of experience. The ability to support a full range of systems engineering activities for multiple programs. The ability to use a systems perspective to identify needed technology development efforts. Demonstrated experience leading multi-disciplinary teams. Excellent written and verbal communication skills, including the ability to produce and present professional written reports and presentations. Experience with SysML Model-Based Systems Engineering (MBSE) tools is required. Preferred: Experience with Magic Draw. Experience with the integration of hardware and software is helpful Skill Matrix: Qualification Assessment Must Have Degree Level Bachelor's Degree Yes Engineering Systems Engineering 5 years Systems Model based systems engineering 5 years SysML experience 2 years Nice to Have Systems Hardware and Software Integration 0 years Magic draw 0 years Systems Analysis 0 years Systems Integration 0 years ** 3rd party and subcontract staffing agencies are not eligible for partnership on this position. 3rd party subcontractors need not apply. This position requires candidates to be eligible to work in the United States, directly for an employer, without sponsorship now or anytime in the future. This client is a US Federal Government contractor and is legally required to hire US Citizens. US Citizens will only be considered for this role. Due to the nature of the work, a United States Government Clearance is required to be eligible for the position. **
$81k-105k yearly est. 30d ago
Software Engineer
W3R Consulting 4.1
Austin, TX Jobs
Top 3 Requirements: 5+ years of experience with AWS Lambda & DynamoDB (NoSQL) in a serverless environment. 5+ years of Event-Driven Development (EDD) & Event-Driven Architecture (EDA) using AWS EventBridge & Step Functions. 5+ years of hands-on experience with ReactJS, Java, Spring Boot. Key Responsibilities: Design & develop components using Java (Spring Boot), AWS Lambda, EventBridge, Step Functions & DynamoDB. Establish coding standards, conduct code reviews, and manage deployments. Collaborate with cross-functional teams & provide technical expertise in Java and AWS cloud technologies. Build & optimize frontend UX using ReactJS. Use Cases (Pharmacy Industry Focus): Customer: Search for medications, place orders, track deliveries, manage prescriptions. Pharmacist: Verify prescriptions, manage inventory, dispense medications, provide support. Delivery: Handle order transportation, update statuses, manage returns. Skills & Technologies: Required: Java, ReactJS, AWS Lambda, Spring Boot, EventBridge, Step Functions, DynamoDB, Jenkins, UX Design. Additional: Microservices, Serverless Architecture, B2B Software, Coding Best Practices.
$71k-96k yearly est. 5d ago
C++ Software Engineers
Softworld, a Kelly Company 4.3
Tempe, AZ Jobs
Job Title: C++ Software Engineers Onsite Requirements: C++ Linux Communication systems Job Description: The MUOS team, under our Space, Cyber & Intelligence Systems (SC&I) line of business, assists in the management and operation of the orbiting satellites through the deployment of the MUOS ground system. The system includes four ground station facilities positioned worldwide, each equipped with three freestanding antennas that act like cellphone switches, receiving radio calls relayed through the MUOS satellites. Client provides the user-entry and integrated ground segments for the system, which will replace the military's current narrowband tactical communications system. MUOS covers everywhere, supporting warfighters worldwide on patrol in hostile environments, whether urban, canyon, mountains, or jungles - or even the Arctic Circle. The system provides a familiar cellular phone-like service, allowing forces on the ground to communicate directly with others at higher levels of quality and much greater capacity than available through the current system. Not only do we maintain the current live system, but GD added new capabilities, enhancements, and replaces end-of-life components. Currently, it is the largest program within SC&I. Education Requirements: Requires a Bachelor's degree in Software Engineering, or a related Science, Engineering or Mathematics field. Also requires 5+ years of job-related experience, or a Master's degree plus 3 years of job-related experience. Agile experience preferred. Clearance Requirements: Department of Defense SECRET security clearance is preferred at time of hire. Candidates must be able to obtain a SECRET clearance within a reasonable amount of time from date of hire. Applicants selected will be subject to a U.S. Government security investigation and must meet eligibility requirements for access to classified information. Due to the nature of work performed within our facilities, U.S. citizenship is required. ROLE AND POSITION OBJECTIVES: As a MUOS Software Engineer in the Space, Cyber & Intelligence Systems business area, you'll be a member of a cross-functional team responsible for development and test of specialized solutions that are used by our warfighters worldwide on patrol in hostile environments, whether urban, canyon, mountains, or jungles - or even the Arctic Circle. The system provides a familiar cellular phone-like service, allowing forces on the ground to communicate directly with others at higher levels of quality and much greater capacity than available through the current system. Not only do we maintain the current live system, but you will help add new capabilities, enhancements, and replace end-of-life components. We encourage you to apply if you have any of these preferred skills or experiences: Experienced with C++ constructs, classes, objects, inheritance, polymorphism, operator overloading Experience using gcc and toolchains in Linux Experience Developing in Linux environment Familiar with using IDEs such as Visual Studio Code Use of Gitlab and Gitlab runner for building Familiar with AWS Familiar with JSON and XML a plus. ** 3rd party and subcontract staffing agencies are not eligible for partnership on this position. 3rd party subcontractors need not apply. This position requires candidates to be eligible to work in the United States, directly for an employer, without sponsorship now or anytime in the future. This client is a US Federal Government contractor and is legally required to hire US Citizens. US Citizens will only be considered for this role. **
$76k-99k yearly est. 18d ago
Software Engineer
Softworld, a Kelly Company 4.3
Montgomery Village, MD Jobs
Job Title: Software Engineer Onsite Requirements: ACTIVE Secret Clearance Software Development in C/C++ and automating testing 5+ years in network protocols, packet processing, socket programming, messaging libraries and scheduling Job Description: Company Overview: EchoStar Corporation (NASDAQ: SATS) is a premier global provider of satellite communication solutions. Headquartered in Englewood, Colo., and conducting business around the globe. EchoStar is a pioneer in communications technologies through its Client Network Systems and EchoStar Satellite Services business segments. For more information, visit echostar.com. Follow @EchoStar on Twitter. Brands: EchoStar, Client, DISH TV, Sling TV, Boost Infinite, Boost Mobile, DISH Wireless, OnTech, and GenMobile. Position Overview: EchoStar has an exciting opportunity for a Software Engineer (Contract) in our Client Network Systems division with an Active Top Secret Clearance. Candidate must have C/C++ skills, is energetic, creative, and team-oriented to work on the latest SATCOM modem and networking technologies. The individual will be part of an engineering team that develops embedded networking and application software using the latest toolchains in an agile software development environment. The position is based in our Germantown, Maryland office. Responsibilities: Software design, development, integration, and support activities. Actively participate in software development. Complete development tasks within agreed timebox. Analyze and resolve software issues. Requirements: Must be capable of obtaining and holding a U.S. government TS clearance. Bachelor's degree in Computer Science, Computer Engineering, or a related field. 5+ years of software development experience in C/C++ and automated unit testing. 5+ years of experience in network protocols, packet processing, socket programming; messaging libraries and scheduling. ** 3rd party and subcontract staffing agencies are not eligible for partnership on this position. 3rd party subcontractors need not apply. This position requires candidates to be eligible to work in the United States, directly for an employer, without sponsorship now or anytime in the future. This client is a US Federal Government contractor and is legally required to hire US Citizens. US Citizens will only be considered for this role. Due to the nature of the work, a United States Government Clearance is required to be eligible for the position. **
$75k-96k yearly est. 13d ago
Senior Database Architect
LPL Financial Services 4.7
Database Engineer Job At LPL Financial
Are you a team player? Are you curious to learn? Are you interested in working in meaningful projects? Do you want to work with cutting-edge technology? Are you interested in being part of a team that is working to transform and do things differently? If so, LPL Financial is the place for you! Job Overview: The Database Architect's role will be responsible for relational database architecture, collaborating with the data engineering and development teams to provide exceptional customer service and technical expertise. The Database Architect will help align business goals with technical design, focusing on performance tuning for new and existing database systems as well as lead in the design and process for database migrations to the cloud. This is a "hands-on" position requiring solid technical skills with advanced skillsets with SQL Server performance and query optimization, as well as excellent interpersonal and communication skills. This role will also interact with other database platforms. Responsibilities: * Data Architect that specializes in SQL Server performance with heavy collaboration with development organization regarding SQL coding standards and TSQL optimization. * Handon providing best practice and guidelines for the cloud based implementation (PostgreSQL, MongoDB) * Excellent understanding of database design and development * Experience with very large databases and/or data warehousing * Familiarity with RDBMS principles, database design and normalization * Possess the ability to learn how applications work by analyzing schema, querying data, and reviewing SQL * Perform problem determination (root cause analysis) and document the source of problems and their resolution. * Apply Microsoft Best Practices with regards to developing T-SQL queries and stored procedures. * Apply Microsoft Best Practices with regards to database maintenance thresholds for consistency checks, index fragmentation, statistics * Advanced level of reviewing execution plans and not only determine possible indexing changes, but also know how to refactor T-SQL statements to achieve optimal performance. * Ability to become the expert on a specific domain of technology and provide technical consultation to others * Knowledge of SQL Server subsystems and internals * Experience in developing high volume, scalable, data-intensive systems * Entrenched skill in designing and developing highly optimized database code * Highly skilled in urgent real time troubleshooting * Experience working with extended events/SQL profiler and other troubleshooting tools. * Working knowledge of DBMS hardware, including RAM, CPU, Permanent Storage, I/O, and other capacity related resources * Ability to create or review architecture and specification documents ensuring database security, integrity, and performance * Excellent visual, written, and verbal communications with the ability to intuitively put ideas into tangible form * Demonstrated ability in moving a software product through the full development lifecycle * Self-starter who able to articulate the current SQL server Schema/Data modeling complexity and propose the creative/innovative way to unpack the Tech-debt. * Collaborate with architecture and development teams to advise on data platform best practices * Deliver Data Architecture in alignment with our Enterprise Architecture standards and advocate for Enterprise Architecture models and patterns. * Acquire and maintain top quality technical skills in a broad range of DBMSs, technology, and techniques * Facilitate the reuse of code, components, and proven patterns supporting data and modern architecture * Collaborate with business, product, and technology teams early in the M&A and product lifecycle to infuse end-to-end architecture thinking, including functional and non-functional aspects, into the conversation. Craft a high-level design early in the lifecycle and elaborate it to lower levels of detail as the conversation progresses. What are we looking for? We want strong collaborators who can deliver a world-class client experience. We are looking for people who thrive in a fast-paced environment, are client-focused, team oriented, and are able to execute in a way that encourages creativity and continuous improvement. Requirements: * Bachelor's Degree in Computer Science or Information Systems or equivalent work experience * 5+ years of hands-on design and implementation experience on Microsoft SQL Server version (2005-2022) * 3+ years of hands-on experience in cloud-based implementation of complex systems (AWS preferred) * 5+ years of experience in hands-on design and implementation of complex systems, including data and reporting. * 3+ years of experience in the following technical disciplines: application development, middleware, database management or operations, security, integration Core Competencies: * Experience with query and indexing best practices, data partitioning * Excellent knowledge of system views and system stored procedures using T-SQL. * Excellent communication skills that translate business problems into technical solutions * Consult with customers to solve business problems by adapting current technology and/or capitalizing on emerging technology for competitive advantage to meet the strategic objectives * Conduct demonstrations and presentations to executive management of prototypes and proof-of-concepts. * Understanding of agile methods (SAFe) and processes, and capability of supporting agile product teams by providing advice and guidance on opportunities, impact and risks, taking account of technical and architectural debt Preferences: * Microsoft certification, or training from industry-leading consultants, such as Brent Ozar or SQLskills * Experience with Oracle and PostgreSQL * AWS Certification * Proven experience in developing conceptual, logical and physical data model for customer and product domains. * Experience with advanced SQL Server features, such as service broker, resource governor, query store, openjson, table-valued parameters, etc. Pay Range: $105,600-$176,000/year Actual base salary varies based on factors, including but not limited to, relevant skill, prior experience, education, base salary of internal peers, demonstrated performance, and geographic location. Additionally, LPL Total Rewards package is highly competitive, designed to support your success at work, at home, and at play - such as 401K matching, health benefits, employee stock options, paid time off, volunteer time off, and more. Your recruiter will be happy to discuss all that LPL has to offer! Company Overview: LPL Financial Holdings Inc. (Nasdaq: LPLA) was founded on the principle that the firm should work for advisors and institutions, and not the other way around. Today, LPL is a leader in the markets we serve, serving more than 23,000 financial advisors, including advisors at approximately 1,000 institutions and at approximately 580 registered investment advisor ("RIA") firms nationwide. We are steadfast in our commitment to the advisor-mediated model and the belief that Americans deserve access to personalized guidance from a financial professional. At LPL, independence means that advisors and institution leaders have the freedom they deserve to choose the business model, services, and technology resources that allow them to run a thriving business. They have the flexibility to do business their way. And they have the freedom to manage their client relationships, because they know their clients best. Simply put, we take care of our advisors and institutions, so they can take care of their clients. Join LPL Financial: Where Your Potential Meets Opportunity At LPL Financial, we believe that everyone deserves objective financial guidance. As the nation's leading independent broker-dealer, we offer an integrated platform of cutting-edge technology, brokerage, and investment advisor services. Why LPL? * Innovative Environment: We foster creativity and growth, providing a supportive and responsive leadership team. Learn more about our leadership team here! * Limitless Career Potential: Your career at LPL has no limits, only amazing potential. Learn more about our careers here! * Unified Mission: We are one team on one mission-taking care of our advisors so they can take care of their clients. Learn more about our mission and values here! * Impactful Work: Our size is just right for you to make a real impact. Learn more here! * Commitment to Equality: We support workplace equality and embrace diverse perspectives and backgrounds. Learn more here! * Community Focus: We care for our communities and encourage our employees to do the same. Learn more here! * Benefits and Total Rewards: Our Total Rewards package goes beyond just compensation and insurance. It includes a mix of traditional and unique benefits, perks, and resources designed to enhance your life both at work and at home. Learn more here! Join the LPL team and help us make a difference by turning life's aspirations into financial realities. Please log in or create an account to apply to this position. Principals only. EOE. Information on Interviews: LPL will only communicate with a job applicant directly from ******************** email address and will never conduct an interview online or in a chatroom forum. During an interview, LPL will not request any form of payment from the applicant, or information regarding an applicant's bank or credit card. Should you have any questions regarding the application process, please contact LPL's Human Resources Solutions Center at **************. EAC1.22.25
$105.6k-176k yearly 14d ago