Launch Your Job Search

Browse openings and submit your resume.

Apply Now

SQL Reporting Analyst 4486

Mclean, VA 22102

Posted: 08/15/2024 Employment Type: Contract Industry: IT/Computing Job Number: 3087 Remote Friendly: Fully Remote

Job Description

SQL Reporting Analyst
1+ Year Contract
Mclean, Virginia (hybrid)
(4486)

IMMEDIAE NEW JOB OPENING for a SQL Reporting Analyst to join our team and work in a hybrid setting for our global client on their supply management team.  With 6 billion dollars of spend influence and over 2000 suppliers, this function has transformed how supply chain and procurement add value to our client. 

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 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.


Responsibilities:
  • 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.

Required Skills:
  • 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 (VLOOKUP, functions, etc.) and PowerPoint
  • Bachelor Degree in Computer Science or a related field
  • Experience with a Business Intelligence tool (e.g. Tableau, MicroStrategy, PowerBI, CognosBI, Spotfire) and report development – plus
  • Supply chain management knowledge – plus
  • Project Management Certification – plus


**To view all of our open positions, please visit: https://jobs.alleareconsulting.com/.
 

 

Meet Your Recruiter

Lana Arnold
President, CEO

Lana Arnold has a diverse background in technical recruiting, business development, project management, and management. She has worked with numerous Fortune 50, 100, 500 companies as well as small start-ups across multiple vertical markets. She has experience managing large enterprise accounts as well as managing a team of recruiters to ensure quality and talent are placed on the job. To add to her industry experience Lana also has extensive experience partnering with numerous VMS systems and applicant tracking devises.
 
Mrs. Arnold holds a Bachelor's degree from Texas A&M University as well as a Minor in Professional Writing. Along with her professional career, she is always involved in a variety of networking groups and charitable organizations.

Apply Online
Apply with LinkedIn Apply with Facebook Apply with X

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Mclean, VA

Ready to take your career to the next level in Mclean, Virginia? Explore our job opportunities in this vibrant area surrounded by innovation and growth. As a hub for tech companies and Fortune 500 corporations, Mclean offers a unique blend of professional opportunities and a charming community atmosphere. With world-class dining options, stunning art galleries like Colvin Run Mill, and access to outdoor activities at Great Falls Park, Mclean provides an ideal backdrop for both work and play. Join us in discovering the career potential and the enchanting culture that Mclean has to offer - your next adventure awaits!