Previous Job
SQL Developer
Ref No.: 18-65709
Location: McLean, Virginia
Position Type:Full Time/Contract
Experience Level: 6 Years
Start Date: 09/07/2018

What you'll do

In this role, you will report to the Director, Reporting Applications. You will be responsible for writing complex SQL queries per HSM business requirements and ensuring the validity of data being provided.  You will create ad-hoc reports in MS Excel or Tableau for delivering the data to business analysts and/or business owners.
What you have

·        Great attention to detail
·        Excellent communication
·        Problem Solving
·        Well-organized and reliable
To fulfill this role successfully, you should demonstrate the following minimum qualifications:
·        Demonstrate a strong understanding of relational database and the SQL server platform like SSIS
·        Advance Microsoft Excel skills (vlookup, functions etc.)
·        Have a passion for high quality data
·        Ability to manage a workload based on priorities
·        Have interpersonal skills to deal effectively with all business contacts
·        Professional appearance and demeanor
·        Positive attitude
·        Good knowledge of SQL
·        Good knowledge in Excel
6-8 Years
·        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
·        Project Management knowledge
·        Experience with a Business Intelligence tool (e.g. Tableau, MicroStrategy, PowerBI, CognosBI, Spotfire)
·        Supply chain management knowledge
BS Bachelor's Degree in Computer Science or a related field and a minimum of three (3) years of experience of developing complex SQL queries