SQL Reporting Specialist

Your Impact:

Challenging Today. Reinventing Tomorrow.

We're invested in you and your success. Everything we do is more than just a project. It's our challenge as human beings, too. That's why we bring a thoughtful and collaborative approach to every one of our partnerships.

At Jacobs, we challenge the status quo and redefine how to solve the world's greatest challenges, transforming big ideas into intelligent solutions for a more connected, sustainable world.

Design your career with a company that inspires and empowers you to deliver your best work so you can evolve, grow and succeed - today and into tomorrow.

Are you passionate about human space exploration, understanding the origins of the universe, and working with a passionate and diverse team to make a difference? If you are, we need you!

We need your talent, teamwork, and energy to help us achieve great things that inspire people all over the globe. We need you to bring creative ideas and diverse backgrounds to help us envision, shape, and deliver systems that will enable the exploration of space while benefiting people here on Earth. We are excited about what we do, and we need you on our team as we take on exciting challenges for NASA's pursuits in deep space exploration. As NASA's largest engineering solutions provider working together with NASA at centers across the United States.

We have an exciting opportunity for a SQL Reporting Specialist to join the team with our Business Management Office.

This is a temporary, remote opportunity not to exceed 26 weeks.

• ?As a SQL Reporting Specialist, you will maintain a legacy Microsoft Access system with a finance-related focus (approximately 35% effort) and manage SQL data quality projects (approximately 65% effort).

• Finance-Related Access System Maintenance (approximately 35%):

• Ensure the stability, performance, and reliability of the existing Microsoft Access system in a finance-related context, leveraging advanced VBA (Visual Basic for Applications) skills.

• Provide technical support, troubleshoot issues, and implement solutions to maintain system functionality for NASA customers.

• Perform regular backups and manage data integrity.

• Follow and understand procedure logic within the legacy system to support ongoing maintenance and enhancements. (200 subqueries/functions many which push data to SQL)

• SQL Data Quality Projects (approximately 65%):

• Optimize SQL queries for performance and efficiency.

• Develop and maintain SQL procedures to replace ad-hoc queries used in reports.

• Create consistent and standardized SQL queries to be utilized across multiple reports.

• Monitor and ensure data accuracy, completeness, and consistency through data quality checks and audits.

• Implement data cleansing and validation processes.

• Collaborate with cross-functional teams to address data quality issues and improve processes.

• Perform other similar or related duties as required.

Here's what you'll need :

Requisition Qualifications

• ?Typically requires a bachelor's degree in a related area and a minimum of 5 years of valuable experience in the field or in a related area.

• Strong organization and communication skills, both written and verbal.

• Demonstrate strength in problem solving, leading to recommended solutions, and using a team-oriented approach.

• At least 3 years of experience with SQL, preferably in the SSMS environment.

• At least 3 years of demonstrating advanced knowledge of VBA, preferably in Microsoft Access.

Requisition Preferences

• At least 1 year of experience with MS SSRS report development and maintenance.

• At least 1 year of experience with MS Power Query development.

• A minimum typing speed of 40 words per minute. ?

Why Join Our Team?

Click on the below links to view just a small sample of all that we do! Come join our team and be part of our future. We look forward to seeing you!

See What We Do (~~~)

Aerospace Solutions Overview (Please view in Chrome or Microsoft Edge)

In addition to exciting career opportunities, we also have:

• Excellent personal and professional career growth

• 9/80 work schedule (every other Friday off), when applicable

• Onsite cafeteria (breakfast & lunch)

• Much, much more!

For more information on our partnership with NASA at Johnson Space Center (JSC), please visit ~~~

• Proof of U.S. Citizenship or US Permanent Residency may be a requirement for this position.

• Must be able to complete a U.S. government background investigation.

• Management has the prerogative to select at any level for which the position is advertised.

Essential Functions

Work Environment

Generally, an office environment, but can involve inside or outside work depending on task.

Physical Requirements

Work may involve sitting or standing for extended periods (90% of time). May require lifting and carrying up to 25 lbs. (5% of time).

Equipment and Machines

Standard office equipment (PC, telephone, printer, etc.).

Attendance

Regular attendance in accordance with established work schedule is critical. Ability to work outside normal schedule and adjust schedule to meet peak periods and surge requirements.

Other Essential Functions

Professional behavior that enhances productivity and promotes teamwork and cooperation. Grooming and dress must be appropriate for the position and must not impose a safety risk/hazard to the employee or others.

Jacobs is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, religion, creed, color, national origin, ancestry, sex (including pregnancy, childbirth, breastfeeding, or medical conditions related to pregnancy, childbirth, or breastfeeding), age, medical condition, marital or domestic partner status, sexual orientation, gender, gender identity, gender expression and transgender status, mental disability or physical disability, genetic information, military or veteran status, citizenship, low-income status or any other status or characteristic protected by applicable law. Learn more about your rights under Federal EEO laws and supplemental language.