Junior Sql Data Analyst Jobs in Reston, VA (NOW HIRING)

Acumen Solutions is the trusted leader in Enterprise Cloud Transformation, helping organizations realize dramatic improvements in productivity and profitability through innovations in business and technology. Industry and government leaders including American Express, Comcast, McKesson, the US Army, and the US Securities and Exchange Commission rely on our global consultants to deliver cloud solutions that yield exceptional results. We apply this same focus on results to our unparalleled social responsibility program, generating sustainable impact across our local communities.

As a leading management and technology consulting firm, Acumen Solutions offers a range of challenging and rewarding opportunities whether you're just starting out in your career, looking to advance your career, or seeking a senior leadership position. Acumen Solutions employees are ambitious, committed, passionate problem solvers.

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