Syms Strategic Group, LLC (SSG)

Design, develop, and optimize complex database systems and data warehouses to support organizational needs. | Extensive experience with database management systems, SQL, data modeling, ETL, security, and performance tuning, along with relevant certifications and security clearance. | Syms Strategic Group (SSG) is seeking a talented Senior Database Engineer Location: Remote Department: Veterans Affairs Type: Full Time Min. Experience: Experienced Security Clearance Level: Public Trust (MBI) Military Veterans are highly encouraged to apply! Essential Duties and Responsibilities Establish database management systems, standards, requirements, guidelines, and quality assurance for database deliverables, such as conceptual design and architecture, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan, and security policy Work with clients to translate business requirements into a logical model that will accurately support and represent the client’s entity relationship and flow of data Develop the appropriate database framework to convert the logical model into a physical model including the creation and maintenance of schemas containing windows, screens, tables, and columns and reports that support the model Make recommendations to maximize operating efficiency, support storage requirements and vendor software updates, enforce data governance, and ensure recovery is maintained Participate in quality assurance and develop test application code in client server environment Required Skills and Experience A proven track record of working with complex database systems and data warehousing solutions Experience with database design, architecture, and data modeling Proficiency in Structured Query Language (SQL) programming and query optimization Strong knowledge of database management systems (DBMS) such as Microsoft SQL Server, Oracle, MySQL, or PostgreSQL Experience with performance tuning, indexing, and database query optimization techniques An ability to write and troubleshoot complex SQL queries, stored procedures, and triggers Familiarity with Extract, Transform, and Load (ETL) processes and tools (e.g., SQL Server Integration Services (SSIS), Informatica, Talend) An understanding of data warehousing concepts and technologies Knowledge of backup and recovery processes Experience with database security, user roles, and permissions Proficiency in scripting languages such as Python or PowerShell for database automation tasks Strong analytical and problem-solving skills Excellent communication and collaboration abilities Capability to work independently and as part of a team Attention to detail and commitment to high-quality work Ability to prioritize multiple tasks and meet deadlines A strong understanding of business processes and requirements gathering Ability to mentor and provide technical guidance to junior developers Experience in a high paced DevOps environment Experience in large scale Enterprise environments U.S. Citizenship required for this position Professional Certifications None required but advanced certifications in database management systems (e.g., Microsoft SQL Server, Oracle Certified Professional) are preferred Years of Professional Experience Eight (8) or more years of relevant experience Five (5) or more years of experience in SQL development and database management Desired experience Electronic Data Interchange X.12 (EDI) Medical Claims X.12 medical claims (837, 834, 277, etc) Experience in a high paced DevOps environment Experience working with remote U.S. based teams (Not Offshore teams) Familiarity with cloud database solutions (e.g. Amazon Web Services Relational Database Service (AWS RDS) and Azure SQL Database) Experience with version control systems (e.g. Git) Familiarity with Agile development methodologies Formal Education Bachelor’s degree in Computer Science, Electronics Engineering, or a related technical discipline (Eight plus (8+) years of additional relevant experience may be substituted for education Citizenship Requirement U.S. Citizenship required for this specific opportunity Security Clearance Requirements Must possess or qualify for a Public Trust (MBI) CRITICAL NOTES: SSG will not make assumptions regarding your qualifications. Your answers to the mandatory screening questions must be supported by the information on your resume. Applications with inconsistencies will not be considered. Recruiters or Third parties will not be considered. This is a 100% U.S. based remote position. However, candidates from CA, CO, IL, NJ or NY will not be considered. This can be a W-2 or a 1099 position All interviews will be conducted on Microsoft Teams with your camera on; there will be no exceptions As part of our screening process, you will be requested to provide a link to your LinkedIn profile U.S Citizenship is required for this specific opportunity. Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information and be able to obtain a government-granted security clearance. Individuals may also be subject to a background investigation including, but not limited to criminal history, employment and education verification, drug testing, and creditworthiness. Syms Strategic Group, LLC is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, marital status, disability, veteran status, sexual orientation, or genetic information.

Lead business process analysis and improvement initiatives, coordinate with stakeholders and technical teams, conduct gap and benchmarking analyses, deliver presentations and training, and mentor junior analysts. | Requires 5+ years of business analysis or related experience, proficiency in process modeling and documentation tools, strong communication skills, and ability to lead complex projects and cross-functional teams. | Syms Strategic Group (SSG) is seeking a talented Senior Business Process Analyst Location: Remote Department: Veterans Affairs Type: Full Time Min. Experience: Experienced Security Clearance Level: Public Trust (MBI) Military Veterans are highly encouraged to apply! Essential Duties and Responsibilities • Provide expertise on continuous process improvement strategies, organization redesign, change management projects, and performance measures for basic business process engagements • Define and develop business processes, policies, roles and responsibilities, and performance metrics • Conduct analysis of business processes, including (1) current state analysis, (2) gap analysis, (3) benchmarking, (4) best practices identification, (5) organizational assessment, and (6) other related tasks • Plan and implement process improvements, including (1) future state design, (2) change management, and (3) transition planning • Interface with all project areas, including (1) customer, (2) computer services, and (3) client services • Provide oversight into the development and maintenance of quality programs, systems, processes, and procedures to ensure compliance and performance quality • Provide expertise and guidance in interpreting policies, regulatory and/or governmental regulations, and agency guidelines to ensure compliance • Work with operating entities to provide continuous process analyses oversight to enforce requirements and meet guidelines • Coordinate with business and technology teams to ascertain system requirements • Conduct client interviews • Deliver presentations and training courses on measurement, analysis, improvement, and control • Perform cost benefit analysis • Establish goals to meet outline objectives • Provide direction to employees according to established policies and management guidelines • Ensure that objectives have been met prior to review by management • Provide technical solutions to a wide range of difficult problems where analysis of data requires evaluation of identifiable factors • Ensure solutions are imaginative, thorough, practicable, and consistent with organization objectives • Independently determine and develop approach to solutions • Select methods and techniques for obtaining solutions • Translate technical information into business language for non-technical stakeholders • Collaborate with cross-functional teams and stakeholders • Lead and mentor junior analysts and team members Required Skills and Experience • A complete understanding of technical principles, theories, and concepts in the field • A proven track record of successfully leading and delivering complex projects • Expertise in eliciting and documenting business requirements, business processes, and workflows • Proficiency in creating functional specifications, user stories, use cases, and process flow diagrams • Experience with business modeling techniques and tools (e.g., UML, BPMN) • Proficiency in using documentation tools such as Microsoft Visio, Lucidchart, or similar • Familiarity with software development methodologies (e.g. Agile, Waterfall) • Proficiency in using data analysis tools (e.g., Excel, SQL, Power BI, Tableau) • Excellent verbal and written communication skills as well as presentation skills • Experience managing and coordinating cross-functional project teams Professional CertificationsNone requiredYears of Professional ExperienceFive (5) or more years of experience in business analysis or a related roleDesired experienceElectronic Data Interchange X.12 (EDI) Medical Claims • X.12 medical claims (837, 834, 277, etc) Advanced certifications such as (1) Certified Business Analysis Professional (CBAP), (2) Project Management Professional (PMP), (3) Six Sigma Certification, and/or (4) Certified Scrum Master (CSM)Formal EducationBachelor's Degree or higher in Business Administration, Information Technology, Finance, or a related fieldCitizenship RequirementU.S. Citizenship required for this specific opportunitySecurity Clearance RequirementsMust possess or qualify for a Public Trust (MBI)CRITICAL NOTES: • SSG will not make assumptions regarding your qualifications. Your answers to the mandatory screening questions must be supported by the information on your resume. Applications with inconsistencies will not be considered. • Recruiters or Third parties will not be considered. • This is a 100% U.S. based remote position. However, candidates from CA, CO, NJ or NY will not be considered. U.S Citizenship is required for this specific opportunity. Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information and be able to obtain a government-granted security clearance. Individuals may also be subject to a background investigation including, but not limited to criminal history, employment and education verification, drug testing, and creditworthiness. Syms Strategic Group, LLC is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, marital status, disability, veteran status, sexual orientation, or genetic information.