Data Specialist, Mid-Sr.

Posted on Indeed on Jun 08, 2021

Data Specialist, Mid-Senior

Atlas Research is seeking qualified candidates for a Data Analyst position to join an emerging technology and innovation practice. Primary objectives involve participating with a team responsible for data analysis and analytics utilizing database management software/tools against various database platforms. In this role you will assist in the development of automated queries and data extraction across multiple computing environments. You will develop technical expertise in data mining techniques and tools to ensure deliverables meet the needs of both internal and external business customers. This position serves as an excellent starting point for becoming a Data Scientist.

Essential Duties and Responsibilities

  • Joins and combines various data sources, systems, databases, reports, to come up with a single data output.
  • Convert business requirements into specifications, jobs, process, scripts, programs, and queries; Writes basic to intermediate queries (like CRUD statements, joins, stored procedure, functions) and views to extract required data
  • Enhances and optimizes advanced query, views and procedures to improve efficiency and reliability of data manipulation (i.e. SSIS, VBA, Excel Macro, VB, .Net, SQL).
  • Design and develop, build and modify, and maintain complex reports using data visualization tools (i.e. MSSQL, SSRS, Power BI, Tableu, Excel)
  • Provide management with status reports of current ETL (extract, transform, load) processes
  • Create visually rich presentations using various forms, charts, and other graphical elements into dashboards
  • Produce clear, concise, relevant, and accurate documentation as needed
  • Import and export data in different formats and various sources for data manipulation, wrangling, modeling, migration, and reporting

Key Requirements:

  • Bachelor's degree in Information Technology, Computer Science, or related Field
  • Must have 2-5 years of relevant data analysis experience
  • Must be proficient MSSQL stored procedure creation, job creation, and general report automation
  • Familiarity with advanced MSSQL features (linked servers, dB mail, bulk copy program (bcp) utility) to use in automating data delivery, file creation, notifications
  • Familiarity with Open Database Connectivity (ODBC) creation/usage
  • Familiarity with Microsoft Access table creation, queries, macros, forms and reports, Visual Basic for Applications (VBA)
  • Familiarity with MSSQL (2000/2005/2008) and Oracle (10G/11G) databases
  • Must possess strong organizational skills with Must be able to work under tight deadlines efficiently demonstrated attention to detail
  • Must flexible and able to adapt in a changing business environment
  • Must possess strong written and verbal communication
  • Must be resourceful, industrious, and willing to take on new tasks and proactively learn new technologies to keep up with business needs for example developing a proficiency in R or Python
  • Knowledge or familiarity to VA data management systems to include but not limited to Corporate Data Warehouse (CDW), Veterans Health Administration Support Services (VSSC), Computerized Patient Record System (CPRS) is a plus

Special skills/must be proficient in the following or willing to improve proficiency in these areas:

  • Structured Query Language (SQL)
  • Cursory knowledge of programming and scripting languages (.Net C#, C++, VBS, etc.)
  • Microsoft Office 2007/2010 (Excel, Access, Word, PowerPoint)
  • Database structure and design
  • Excellent written and oral communication skills


0bJ9WDwmVB

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Sunrun
Featured
5 d ago