Analyst, Reporting Applications

1 month ago


McLean, United States INSPYR Solutions Full time

Job Title: Analyst, Reporting Applications - SQL
Location: 2-3 days on site in McLean, VA or Memphis,TN
Position Type: 6-12 month contract with potential to extend
Work Requirements: US Citizen, GC Holders or Authorized to Work in the U.S.

Job Description:
Analyst, Reporting Applications - SQL

Do you have a passion for high-quality data? If so, this could be the role for you. The Analyst of Digital Solutions team will be responsible for writing complex SQL queries per the set business requirements and ensuring the validity of data being provided. In this role, you will create ad-hoc reports in MS Excel or Tableau/PowerBI for delivering the data to business analysts and/or business owners.

More specifically, you will:

• Assist Senior Manager in Project Management related tasks such as prioritizing of efforts, leading status update calls, providing meeting recaps, and escalation of issues and resolutions.
• Design, develop, and test complex SQL queries and store procedures that are outside of canned reports, based on specific parameters to allow for ongoing flexibility
• Develop data modeling concepts to put into meaningful views for smoother reporting capabilities
• Perform analysis and validation of the data being queried for internal and external clients to ensure accuracy and consistency
• Interact with business analysts and/or business owners to clarify requirements and ensure that finalized data/reports meet end-user needs
• Assist internal and external users with data mapping for ad hoc reporting, and help them understand the relationships of data warehouse tables
• Troubleshoot reporting issues and resolve end-user reporting problems through collaboration between multiple functional teams promptly
• Review existing queries and store procedures and identify areas for performance improvements, and rewrite if needed
• Identify opportunities that ad-hoc reports should be converted canned reports, work with Sr. Analyst and Manager to convert ad-hoc report requirements to canned report design, and pass to Business Intelligence (BI) developer to implement and push to production for BI dashboard release
• Maintain and run regularly scheduled canned reports and distribution for end-user consumption.
• Perform other reporting duties as assigned

To fulfill this role successfully, you should demonstrate the following minimum qualifications:
• Bachelor Degree in Computer Science or a related field
• Project Management Certification (Not Required)
• Two (2) years of experience in developing complex SQL queries
• Demonstrate a strong understanding of relational databases and the SQL server platform like SSIS
• Advanced Microsoft Excel skills (vlookup, functions, etc.)
It would be helpful in this position for you to demonstrate the following capabilities and distinctions:
• Experience with a Business Intelligence tool (e.g. Tableau, MicroStrategy, PowerBI, CognosBI, Spotfire) and report development
• Supply chain management knowledge

Our benefits package includes: Comprehensive medical benefits
Competitive pay
401(k) retirement plan
…and much more


About INSPYR Solutions
Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.

INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities


  • Data Analyst

    3 weeks ago


    McLean, United States Collabera Full time

    Description Home Search Jobs Job Description Data Analyst Contract: McLean, Virginia, US Salary: $55.00 Per Hour Job Code: 354879 End Date: 2024-11-14 Days Left: 9 days, 2 hours left Apply Position Details:Industry: Financial IndustryJob title: Senior Data AnalystLocation: McLean, VA 22102 Duration: 12 months of Contract Start date: ASAPMust Have...

  • Data Analyst

    1 week ago


    McLean, United States Collabera Full time

    Description Home Search Jobs Job Description Data Analyst Contract: McLean, Virginia, US Salary: $55.00 Per Hour Job Code: 354879 End Date: 2024-11-14 Days Left: 2 hours left Apply Position Details:Industry: Financial IndustryJob title: Senior Data AnalystLocation: McLean, VA 22102 Duration: 12 months of Contract Start date: ASAPMust Have...

  • Data Analyst

    1 week ago


    McLean, United States Collabera Full time

    Description Home Search Jobs Job Description Data Analyst Contract: Mclean, Virginia, US Salary: $55.00 Per Hour Job Code: 355694 End Date: 2024-12-07 Days Left: 22 days, 2 hours left Apply Client: Financial ServicesJob Title: Data AnalystDuration: 12 months Location: Mclean, VA Qualifications • Typically, 5-7 years of related data analytics...


  • McLean, United States Larson Maddox Full time

    A leading financial services firm is looking to add you to it's team as it's next Senior Regulatory Analyst! This is an exciting opportunity to join a firm that offers continued growth. You will be part of a team that values research, analysis, and reporting to ensure it stays compliant. This role will also operate on a hybrid basis in McLean, VA working...


  • McLean, United States Larson Maddox Full time

    A leading financial services firm is looking to add you to it's team as it's next Senior Regulatory Analyst! This is an exciting opportunity to join a firm that offers continued growth. You will be part of a team that values research, analysis, and reporting to ensure it stays compliant. This role will also operate on a hybrid basis in McLean, VA working...


  • McLean, United States Larson Maddox Full time

    Job DescriptionJob DescriptionA leading financial services firm is looking to add you to it's team as it's next Senior Regulatory Analyst! This is an exciting opportunity to join a firm that offers continued growth. You will be part of a team that values research, analysis, and reporting to ensure it stays compliant. This role will also operate on a...

  • Data Analyst

    4 months ago


    McLean, United States Abode Techzone LLC Full time

    Position: Data Analyst (Sybase,MongoDB) Job Location - McLean, VA. (Day-1 Onsite| 3 days Onsite & 2 Days remote) Data Analyst Analyze the current source of data, for key data elements, understand the current usage and identify the new/alternative source for these data elements Experience in Sybase and DB2 is needed and knowledge of ECDA is...

  • Motion GEOINT Analyst

    3 weeks ago


    McLean, United States Global Dimensions Full time

    Description Global Dimensions is a HUBZone, service disabled, veteran-owned small business based in Fredericksburg, VA. We are a dynamic, expanding company with exciting opportunities in language/culture, training/education/instruction, IT, cyber security, and intelligence. Global Dimensions is currently seeking Senior Motion GEOINT Analysts for positions...


  • McLean, United States Softworld Inc Full time

    Job Title: 80474 - Junior Cybersecurity Operations Analyst Job Location: McLean VA 22102 Onsite Requirements: intrusion detection intrusion prevention incident response Job Description: PROJECT DESCRIPTION: The Cybersecurity Operations Unit is seeking a Cybersecurity Operations professional who will support daily technical operations for the...

  • Payroll Analyst

    3 weeks ago


    McLean, United States Cherokee Nation Businesses LLC Full time

    Overview: Job DescriptionPayroll Analyst Compile, analyze, reviews and update data for accurate and timely execution of payroll. Support day-to-day payroll operations, including reconciliation, generation of reports and audits. Compensation & Benefits: Estimated Starting Salary Range for Payroll Analyst: Pay commensurate with experience.Full time...

  • Sr. data Analyst

    4 months ago


    McLean, United States Diverse Lynx Full time

    Role; Sr. Data Analyst Location: McLean VA ( 3 Days Onsite & 2 Days Remote )(Local candidate only) JD, Python is nice to have - Data flux, ETL, SQL, Unix are main skills • 8-10+ years of experience as Business/Data Analyst and overall progressive experience supporting a divisional/enterprise data driven initiatives • Production Support of systems •...

  • Data Analyst

    2 weeks ago


    McLean, United States Soho Square Solutions Full time

    Job Title: Data Analyst SeniorLocation: McLean, VA (Hybrid)Duration: 12 Months (Contract to hire)NOTE: Looking for W2 candidates onlyJob Description:Must Have Qualifications:Must be proficient with relational databases and have hands on experience using reporting tools including Tableau, MS Query, Rapid SQL, and/or MS Access.Must be proficient with MS Office...

  • Motion GEOINT Analyst

    3 weeks ago


    Mclean, United States Global Dimensions Full time

    Description Global Dimensions is a HUBZone, service disabled, veteran-owned small business based in Fredericksburg, VA. We are a dynamic, expanding company with exciting opportunities in language/culture, training/education/instruction, IT, cyber security, and intelligence. Global Dimensions is currently seeking Junior Motion GEOINT Analysts for positions...


  • McLean, United States Cherokee Nation Businesses LLC Full time

    Overview: Business Intelligence AnalystUnited States (Remote) Job DescriptionCompetitive Business Intelligence Analyst We are seeking a highly skilled Competitive Intelligence Analyst to join our dynamic team in the federal procurement space. The ideal candidate will be responsible for gathering, analyzing, and interpreting competitive intelligence to...

  • Motion GEOINT Analyst

    5 months ago


    McLean, United States Global Dimensions Full time

    Global Dimensions is a HUBZone, service disabled, veteran-owned small business based in Fredericksburg, VA. We are a dynamic, expanding company with exciting opportunities in language/culture, training/education/instruction, IT, cyber security, and intelligence. Global Dimensions is currently seeking Senior Motion GEOINT Analysts for positions in McLean,...

  • Motion GEOINT Analyst

    3 weeks ago


    McLean, United States Global Dimensions Full time

    Global Dimensions is a HUBZone, service disabled, veteran-owned small business based in Fredericksburg, VA. We are a dynamic, expanding company with exciting opportunities in language/culture, training/education/instruction, IT, cyber security, and intelligence. Global Dimensions is currently seeking Mid level Motion GEOINT Analysts for positions in McLean,...

  • Data Analyst

    2 weeks ago


    McLean, United States Genesis10 Full time

    Genesis10 is seeking a Senior Data Analyst for a 12 month contract position (possible CTH) with a mortgage loan corporation located in McLean, VA. This is a hybrid position and requires being onsite Tuesday through Thursday. Responsibilities This role will support the Single-Family line of business in the counterparty and access management space. Known...


  • McLean, United States Softworld, a Kelly Company Full time

    Job Title: 80474 - Junior Cybersecurity Operations AnalystJob Location: McLean VA 22102 Onsite Requirements:intrusion detectionintrusion preventionincident responseJob Description: PROJECT DESCRIPTION: The Cybersecurity Operations Unit is seeking a Cybersecurity Operations professional who will support daily technical operations for the unit.BACKGROUND:The...


  • McLean, United States Softworld, a Kelly Company Full time

    Job Title: 80474 - Junior Cybersecurity Operations AnalystJob Location: McLean VA 22102 Onsite Requirements:intrusion detectionintrusion preventionincident responseJob Description: PROJECT DESCRIPTION: The Cybersecurity Operations Unit is seeking a Cybersecurity Operations professional who will support daily technical operations for the unit.BACKGROUND:The...


  • McLean, United States Booz Allen Full time

    Data Visualization AnalystThe Opportunity:As a data analyst, you love diving into data and turning it into meaningful insights. With the abundance of structured and unstructured data, you understand the importance of transforming complex data sets into useful information to solve challenges. As a data analyst at Booz Allen, you can use your skills and...