Sr. Data Engineer

Join to apply for the Sr. Data Engineer role at Sierra7, Inc. Join to apply for the Sr. Data Engineer role at Sierra7, Inc. Get AI-powered advice on this job and more exclusive features. Brief Description Sierra7, Inc. is seeking a Sr. Data Engineer to join our team and work with the Veterans Health Information Systems and Technology Architecture Blood Establishment Computer Software (VBECS) team for the Department of Veterans Affairs (VA). In this position, the engineer would be primary to the team as a POC for the migration of VBECS data into the electronic health records modernization (EHRM) within the VA records management system. Brief Description Sierra7, Inc. is seeking a Sr. Data Engineer to join our team and work with the Veterans Health Information Systems and Technology Architecture Blood Establishment Computer Software (VBECS) team for the Department of Veterans Affairs (VA). In this position, the engineer would be primary to the team as a POC for the migration of VBECS data into the electronic health records modernization (EHRM) within the VA records management system. Position Responsibilities Develop stored procedures, triggers, views, and custom functions Write and optimize complex SQL queries to manipulate and retrieve data efficiently Design and modify relational database schemas to support application features Collaborate with software developers to integrate databases into applications Build and maintain ETL processes for data ingestion, transformation, and migration Debug and troubleshoot data issues and performance bottlenecks Ensure database code complies with security, privacy, and governance standards Attend all meetings necessary to facilitate requirements for VA and stakeholders Analyze areas for process improvement and identify technical solutions Requirements Comfortability working with a team to formulate solutions to complex problems Strong analytical capabilities and technical knowledge by providing supportable technical solutions Proficiency in SQL and procedural extensions (e.g., T-SQL) Experience with relational database systems like SQL Server AlwaysOn Knowledge of normalization, indexing strategies, and query optimization Familiarity with version control tools and Agile development workflows Experience building ETL scripts or using tools like SSIS, PowerShell Strong analytical and logical thinking Clear written and verbal communication Detail-oriented with a focus on code maintainability Collaborative and able to adapt to shifting business needs Education & Experience Bachelor's degree in Operations Research, Mathematics, Computer Science, Cost Accounting, Business or related technical discipline (8 years of additional relevant experience may be substituted for education) Minimum of 8 years of relevant experience Experience working in VA or other Government agency [a plus] Ability to obtain a Government public trust clearance. Why Join Sierra7? Sierra7 is a Small Disabled Veteran Owned Business. We were founded in 2009 with the mission of serving those who serve". We are a Service-Disabled Veteran-Owned Small Business (SDVOSB) and CMMI-SVC Level 3-appraised member of the government technology and services industry. We are a proud recipient of the 2024 Gold HIRE Vets Medallion Award from the US Department of Labor, which recognizes employers who successfully recruit, hire, and retain Veterans. Benefits Medical/Dental/Vision FSA (Flexible Spending Account) HSA (Health Savings Account) Life Insurance, Voluntary Life Insurance, Voluntary Short- and Long-Term Disability Additional Supplemental Medical Benefits Critical Care, Hospital Indemnity, Legal Plan, Pet Insurance, Accident 401K Legal Assistance Financial Wellness Paid Time Off (PTO) Federal Holidays Education Reimbursement LinkedIn Learning Employee Referral Program Summary This posting is for prospective candidates only. Unsolicited third-party resume submissions will be considered property of Sierra7, Inc. and will not be acknowledged or returned. We will never send communications through any other domain, including @, @ or @. ALL communications will come from a @ domain. We will never request payment from you, nor will we send payment to you, prior to your start date. If you have been asked to send or receive any payment, or if you have any doubt about whether you have been contacted by a Sierra7 employee, please contact us at Talent.Acquisition@ Disclaimer As required by local law, Sierra7 provides reasonable ranges of compensation for hired roles based on labor costs in the states of California, Colorado, Hawaii, Illinois, Maryland, Minnesota, New York, Washington, and the District of Columbia. The base pay range for this position in these locations is shown below. Compensation for roles at Sierra7 varies depending on a wide array of factors, including but not limited to office location, role, skill set and level of experience. The pay range for the states of California, Colorado, Hawaii, Illinois, Maryland, Minnesota, New York, Washington, and the District of Columbia is: $125,000 - $158,000 USD The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. Sierra7 will not provide sponsorship for employment-based immigration benefits for this position. To be considered for this position all candidates must be a US Citizen. This position is not a C2C opportunity. Sierra7 is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to any status protected by federal, state, or local law. Equal Opportunity Employer Veterans Disabled Seniority level Seniority level Mid-Senior level Employment type Employment type Full-time Job function Job function Information Technology Industries Technology, Information and Internet Referrals increase your chances of interviewing at Sierra7, Inc. by 2x Get notified about new Senior Data Engineer jobs in McLean, VA . Solutions Architect, Data Engineering & Lakehouse Lake District of Columbia, United States $150,000.00-$210,000.00 4 days ago Senior Data Mining and Analytics Engineer (Security Clearance Required) - Remote work - Local DC Metro or FL Arlington, VA $107,936.00-$183,491.00 8 hours ago Arlington, VA $100,000.00-$118,000.00 4 months ago Reston, VA $98,124.00-$201,840.00 1 week ago Herndon, VA $200,000.00-$210,000.00 1 month ago Washington, DC $120,000.00-$190,000.00 3 weeks ago McLean, VA $130,000.00-$140,000.00 1 week ago McLean, VA $80,000.00-$100,000.00 1 week ago Senior Engineer- Data Efficiency/Datalakehouse Chevy Chase, MD $100,000.00-$200,000.00 4 days ago Herndon, VA $111,850.00-$131,735.00 2 weeks ago Springfield, VA $95,000.00-$215,000.00 1 day ago Germantown, MD $140,000.00-$180,000.00 17 hours ago Washington, DC $136,000.00-$204,000.00 1 week ago Bethesda, MD $145,000.00-$200,000.00 5 days ago Washington, DC $140,000.00-$180,000.00 1 week ago Arlington, VA $137,000.00-$153,000.00 3 weeks ago McLean, VA $130,000.00-$150,000.00 2 weeks ago Senior Software Engineer (Data-Oriented) Reston, VA $89,203.00-$151,646.00 1 week ago Montgomery County, MD $137,439.00-$167,981.00 1 week ago Senior Software Developer I - Full Stack Washington, DC $115,000.00-$135,000.00 1 month ago We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr