Sarga Job Listings:
Position: Research Analyst / ETL/BI Developer / Data Analyst
Duties: Design, develop, implement, test, installation, deployment, migration, integration and support web-based Business Intelligence (BI) and ETL-SQL Database systems and applications; Gather, analyze and interpret functional specifications and user/business requirements; Define business objectives, project scope and solutions using Object Oriented design / development approach for various knowledge research applications; Participate and contribute in the design and development of appropriate database and BI database solutions, including database architectural designs, flow charts and work flow; Design and creation of data warehouse schema and technical design plan for data warehouse and reporting systems; Design, development, implementation, administration and support of ETL processes for large-scale Data Warehouses; Design and creation of database pre-processors and report templates; Data review and analysis; Uploading, analyzing, and validating data; Develop and implement physical and logical database structures, workflows and data models designs and test and deploy them into various existing database warehousing; Develop and utilize business process automation tools to create data structures and models and to automate the business processes for daily maintenance and process reporting; Design and develop the Database system/applications work flows and architectural designs; Design, develop and implement Data Models, Tables and Stored Procedures for the application/system to capture and analysis data using SQL Server 2005; Create data packages and deployment scripts for deploying the application into the Client Server Architecture system; Analyze and troubleshoot system/application, and technical issues confronted by business users and resolve any data usage and functionality issues; Develop, and implement information delivery solutions for the purpose of providing business intelligence; Develop functionality that graphically represents data in a manner that is user friendly, fully automatable, and supportable; Perform data analysis, reporting analysis, development, documentation, and testing in different environments; Analyze the validation procedure of documentation and modify the procedures as required; Research data inaccuracies and inconsistencies and determined causes through researching the multiple source systems; Research data validity issues with application environment and implement changes to improve application stability/data validity to ensure data quality and performance; Monitor and document the data movement to the target sources through different automation tools for testing and production environments; Built and deployed various SQL Server Reporting Services reports for data analysis; Develop system and mechanism to record the data process and reporting using a data visualization tool such as Tableau; Data conversion and migration; Database management and administration, including testing, disaster recovery, performance enhancement; Provide 24x7 production, technical support and maintenance; Perform application and system testing and implementation and ensure quality/performance per specifications; Participate in daily/weekly stand-up meetings, which involves planning the development tasks and fixing the errors during production process utilizing technical skills, technologies and tools such as - SQL Scripts, PL/SQL, T-SQL, SQL Server, SSRS, MOSS, DTS/ETL/SSIS, Excel, MS Access, Oracle, OLTP, OLAP, SAS, Team Foundation Server (TFS), and Visual Source Safe (VSS), Visual Studio, ERWIN, C, C#, SQL Profiler, Java, Windows, and other analytical / data analysis tools, etc.
Minimum Requirement: Bachelor of Science Degree in Computer Science, Engineering, Mathematics or related computer or analytics fields of studies and 3 years of experience or a Master of Science degree in relevant fields above.
Location: Herndon, VA and other Clients Projects locations nationwide
Send detailed Resume with references to; Attn: HR, Sarga Solutions Inc., 459 Herndon Parkway, Suite 18, Herndon, VA 20170