Job description

We are looking to grow our team and currently have entry to manager level opportunities for Data Analysts in our McLean, VA location. The Data Analyst specializes in collecting, organizing, and analyzing data from various systems. Specific Duties • Develop an in-depth understanding of the interrelationships of data and multiple data domains • Create thorough documentation artifacts and maintain same for duration of project • Identify and document data migration paths and processes • Maintain industry/technical knowledge base and facilitate/maintain industry relationships • Demonstrate commitment to providing customer-focused quality service • Support assigned systems through transition period • Perform other duties as deemed relevant based upon experience to fulfill customer needs • Develop and perform standard queries to ensure data quality, identify data inconsistencies, missing data and resolve as needed • Standardize data naming, data definitions and modeling • Perform data extraction, storage, manipulation, processing, and analysis • Collect, profile, collate, and map appropriate data for usage in new or existing solutions as well as for ongoing data analysis activities • Interpret Customers functional and information needs and turn them into functional or data requirements, process models, etc. • Must be willing to travel (35-50%) • Must be authorized to work for any U.S. employer • 1-5 years of demonstrated experience in data analysis, data manipulation, and decision support • Knowledge and application of relational database concepts • Experience or exposure to Extract/Transform/Load (ETL) and/or Business Intelligence • Strong SQL skills • Skilled at completing technical design via iterative mockups • High proficiency in MS Office Suite (esp. Word and Excel) • Openness to learning new skills and software as necessary • Demonstrated ability to manage simultaneous work flows while maintaining quality output and meeting deadlines • Demonstrated ability to learn new and exciting technologies with little assistance • Experience with ETL tools and procedures (any tool) • Prior experience working in the Cloud • Strong verbal and written communication skills with demonstrated ability to communicate at different levels of the organization • Ability to perform ad-hoc analysis and maintain clear and comprehensive documentation of decision-making, data preparation, and processes • High aptitude in analytical and logical thinking • Demonstrated experience with data models and data mapping • Experience with Unified Modeling Language (UML), including Entity-Relationship Diagrams (ERD), Sequence Diagrams, and Data Flow Diagrams (DFD) • Understanding of XML, SQL, Data Modeling Language (DML), and Data Definition Language (DDL) • Strong communication skills, both written and spoken • Demonstrated ability to produce highly detailed, comprehensive documentation artifacts • Client-focused attitude • High-level knowledge of enterprise IT organizational, business, and technical environments • Ability to analyze processes and recommend improvements as needed Education and Certification • Bachelor’s degree or equivalent in Computer Science, Information Systems, Engineering, Business, Mathematics, or other related scientific or technical discipline with two (2) or more years of experience related to this position • Exposure to one or more of the following: Informatica, Pentaho, DataStage, Jitterbit, Mulesoft, etc. • Relevant IT certifications preferred Benefits Acumen Solutions offers the opportunity for growth and advancement, as well as a competitive base salary, annual performance based incentives, medical benefits & 401k. EOE M/F/V/D VEVRAA Federal Contractor

Requirements

Must-haves

Specific Duties
Develop an in-depth understanding of the interrelationships of data and multiple data domains
Create thorough documentation artifacts and maintain same for duration of project
Identify and document data migration paths and processes
Maintain industry/technical knowledge base and facilitate/maintain industry relationships
Demonstrate commitment to providing customer-focused quality service
Support assigned systems through transition period
Perform other duties as deemed relevant based upon experience to fulfill customer needs
Develop and perform standard queries to ensure data quality, identify data inconsistencies, missing data and resolve as needed
Standardize data naming, data definitions and modeling
Perform data extraction, storage, manipulation, processing, and analysis
Collect, profile, collate, and map appropriate data for usage in new or existing solutions as well as for ongoing data analysis activities
Interpret Customers functional and information needs and turn them into functional or data requirements, process models, etc.
Must be willing to travel (35-50%)
Must be authorized to work for any U.S. employer
1-5 years of demonstrated experience in data analysis, data manipulation, and decision support
Knowledge and application of relational database concepts
Experience or exposure to Extract/Transform/Load (ETL) and/or Business Intelligence
Strong SQL skills
Skilled at completing technical design via iterative mockups
High proficiency in MS Office Suite (esp. Word and Excel)
Openness to learning new skills and software as necessary
Demonstrated ability to manage simultaneous work flows while maintaining quality output and meeting deadlines

Nice-to-haves

Relevant IT certifications preferred

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: smartrecruiters
Effort: medium

Benefits

Benefits detected in the listing.

401k