SQL Developer/Data Analyst

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

Qualifications:

• 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
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.
Required Skills/Certifications:
like
3