Data Analyst Ii-F33365d

Syapps Reston , VA 20190

Posted 6 months ago

SyApps is a Technology and Management Consulting Services firm based in Greater Washington area, with focus on solutions in the area of Strategy, Process, Technology and Management support. As a diverse end-to end IT and Management solution Provider, SyApps offers a range of expertise aimed at helping customers re-engineer and re-invent their business to compete successfully in an ever-changing marketplace.

Please visit us at www.syapps.com.

Description

Job Responsibilities:

Work with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies

Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions

Design, implement, automate and maintain large scale enterprise data ETL processes

Modify existing databases and database management systems and/or direct programmers and analysts to make changes

Test programs or databases, correct errors and make necessary modifications

Create Source to Target mapping document.

Education/Experience:

Bachelor's degree in a technical field such as computer science, computer engineering or related field required

Experience with database technologies

Knowledge of the ETL process

Knowledge of at least one scripting language

Strong written and oral communication skills

Strong troubleshooting and problem solving skills

Desire to be working with data and helping businesses make better data driven decisions.

  • Strong SQL Knowledge

  • Strong Knowledge of Data warehousing Concepts

  • Understand how to read and use XML, JSON

  • Understand AWS(S3, HIVE, REDSHIFT) Concepts

Type: Contract

Travel: No

Location: Washington DC

SyApps LLC is a Winner of the SmartCEO/Grant Thornton Future 50 Award for being recognized as one of 50 fastest growing companies in the Greater Washington Area.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Financial Data Analyst
New!

Decisionpoint Corporation

Posted Today

VIEW JOBS 10/19/2019 12:00:00 AM 2020-01-17T00:00 <strong>Job purpose:</strong><br /> <br /> DecisionPoint is actively seeking a qualified, experienced Financial/Data Analyst to support a large contract with the Department of State. This position will report directly to the Deputy Program Manager. The full-time position is based in Reston, VA. Candidate must have the ability to pass a federal background investigation and achieve a Secret Clearance<br />  <br /> <strong>Duties and responsibilities</strong><br />   <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Responsible for devising analysis, reporting, and system capability solutions to support the development of global cost of living indexes and cost of living allowances (COLAs)</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Consult with appropriate offices within the Department of State including appropriate personnel within ALS, all Regional Executive Bureaus (to discuss applicability of the off the shelf products and to identify appropriate posts to create, test and verify new methodology), and other DOS offices as appropriate</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Revise/update DOS procedures for integrating independently-provided data into COLA calculations process; finalize delivery templates that align to all policy requirements and other standards mandated in the PWS for each location Index/COLA report; deliver defined quality assurance methodology and review standards</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Run test/demo of independent data collection and integration; Verify successful integration; Modify methodology and standards as required</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Determine which of the 275 locations will not be supported by currently available vendor data (non-standard locations); develop non-standard methodology and strategy to ensure accurate and verifiable COLA calculation process for these locations;  </li> </ul>  <br /> <strong>Qualifications</strong><br />   <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">2-5 years’ hands-on Federal Government analytics experience with proven quantitative orientation.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">At least 1 years’ experience in data management, data quality, or business applications functions.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">BS/BA in Statistics, Economics or Mathematics is preferred.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Experience and understanding of Information Architecture concepts.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Experience working in healthcare or medical industry preferred.</li> </ul> <strong>Business Tools:</strong> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Advanced Modeling, Excel skills and proficiency in SQL.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Tableau or similar Business Intelligence tools.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Knowledge of data visualization tools (e.g., Tableau or Microsoft Power BI).</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Advanced MS Project skills.</li> </ul> <strong>Competencies:</strong> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Creative problem-solving, analytical, and quantitative skills.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Effective communication skills with an ability to synthesize and disseminate knowledge, and communicate complex quantitative analysis in a clear, precise, and actionable manner.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Demonstrated ability to work independently, take initiative and be self-motivated.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Ability to effectively manage competing priorities with a sense of urgency.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Ability to query, mine, and manipulate and analyze large volumes of data, create new and improved techniques, and/or solutions for data collection, management, and usage.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Skilled in understanding and correcting data discrepancies; reading and translating data models; data querying; identifying data anomalies and root cause analysis; understanding and capability to explain Master Data Management.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Physical requirements may include lifting or reaching; extended periods in stationary position (sitting or standing), repetitive motion (computer usage). Ability to perceive verbal communications and possess visual acuity necessary to review documents and electronic records.</li> </ul> Decisionpoint Corporation Reston VA

Data Analyst Ii-F33365d

Syapps