Collect, profile, map, extract, store, manipulate, process, and analyze data from multiple systems and domains.
Create and maintain project documentation, data models, data definitions, and data migration paths and processes.
Write standard queries to check data quality, identify inconsistencies or missing data, and resolve issues.
Translate customer functional and information needs into data or functional requirements and process models.
Summarised from the posting by AI and can be wrong. The full description is the source.
Requirements
Licenses and certifications
Relevant IT certifications (preferred)
Experience
1–5 years of experience in data analysis, data manipulation, and decision support
Experience or exposure to ETL and/or Business Intelligence
Experience with ETL tools and procedures
Prior experience working in the Cloud
Demonstrated experience with data models and data mapping
Education
Bachelor’s degree or equivalent in Computer Science, Information Systems, Engineering, Business, Mathematics, or a related scientific or technical discipline, with at least 2 years of related work
Skills
Knowledge and application of relational database concepts
Strong SQL skills
Proficiency in MS Office Suite, especially Word and Excel
Ability to perform ad-hoc analysis and document decision-making, data preparation, and processes
Experience with UML, including Entity-Relationship Diagrams, Sequence Diagrams, and Data Flow Diagrams
Understanding of XML, SQL, DML, and DDL
Exposure to one or more of Informatica, Pentaho, DataStage, Jitterbit, or MuleSoft
Other requirements
Willingness to travel 35–50%
Authorized to work for any U.S. employer
Your match
Sign in and add your resume to see which of this job's requirements it shows.
Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.
Benefits
Health insurance
Medical benefits
Retirement plan
401(k)
Bonus
Annual performance-based incentives
Full job description
From Acumen Solutions’ careers site
Company Description
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.
Show full descriptionShow less
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.
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.
Qualifications
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
Additional Information
Benefits
Acumen Solutions offers the opportunity for growth and advancement, as well as a competitive base salary, annual performance based incentives, medical benefits & 401k.