Previous Job
Previous
Senior SQL Developer
Ref No.: 18-65398
Location: Edison, Virginia
Position Type:Full Time/Contract
Start Date: 09/06/2018
 Senior SQL Developer
McLean, VA


·        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 in a timely manner
·        Review existing queries and store procedures and identify areas for performance improvements, and rewrite if needed
·        In opportunities that ad-hoc reports should be converted canned reports, work with Sr. Analyst 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 professional and technical knowledge by identifying and participating in training programs
·        Perform other reporting duties as assigned