SQL Developer/Data Analyst
Location: Linthicum/Baltimore, MD (Hybrid)
Duration:12+Months
Database Management Specialist (Senior)
Duties:
Review and evaluate the existing data sources and analyze the conversion steps required.
Profile the source data by domain and prepare data quality profile and mitigation plan
Design, develop, revise, and maintain SQL scripts, code, and queries for data translation, conversion, and reporting.
Convert existing data, using ETL processes, creating queries and scripts to manipulate the data into the format needed.
Conduct system testing and provide trouble-shooting to quickly and accurately find solutions to resolve issues.
Provide post conversion issue resolution, inefficiencies and/or recommendations for existing process changes.
Education Qualification:
A Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related technical discipline is required. A Master's Degree is preferred.
Knowledge in developing shell scripting.
Knowledge in database servers such as PostgreSQL, SQL Server
General Experience:
At least Eight (8) years of experience in writing data conversion logic in Java, scripting languages such as SQL, Python, Linux Shell Script, Perl, Windows PowerShell.
Must be proficient in SQL Scripting (SQL Query, Store Procedure, SQL Functions)
Experience in extracting useful information and knowledge from large volumes of data in order to improve government decision-making or provide the insights to make data-driven decisions
Experience using statistical computer languages (R, Python, SLQ, etc.) to manipulate data and draw insights from large data sets.
Experience visualizing/presenting data for stakeholders using tools such as SAS, Tableau, QlikSense etc.