
data analyst Remote
Job description
- Work closely with stakeholders, DBAs, testers, and developers to identify and solve data issues, design solutions, develop conceptual models, map functional requirements into technical requirements, and support the design and implementation of conversions and interfaces throughout the lifecycle of system development and sustainment
- Develop logical and physical model design, source-to-target mapping, use cases, and other development processes and artifacts
- Identify data subject areas, entities, attributes, relationships, information types, and domains
- Perform code reviews, data model reviews, and testing
- Establish standards and best practices
- Update and maintain metadata repositories and dictionaries
- Work within a daily Agile/Scrum process for sprints across projects and operations
- Responsible for promoting an understanding of data integrity and methodology
- Identify, document, and recommend solutions for poor-quality data
- Define, maintain, and enforce data architecture definitions and standards
- Recommend optimum approach and advise on alternatives and the implications of new or revised data processing systems
- Work with Functional Leads, Team Leads, and ETL Developers to communicate business and technical requirements clearly and effectively
- Utilize the Alteryx, Toad Data Point, Access, SQL Developer software, and/or other tools needed to manipulate data
- Write and optimize in-application, simple to complex, SQL, and SQL statements as required
- Other duties as assigned
- Alteryx Advanced Designer certification is highly desired or working experience with Alteryx software.
- 5+ years of military experience in the Navy Safety and Occupational Health field preferred but not required.
- Advanced knowledge and understanding of the Alteryx software are required.
- Experience with data mapping for integration of legacy and interface data.
- Experience with data analysis, data mining, data cleansing, modeling, metrics analysis, performance measures, and research.
- Experience with aggregating and analyzing performance measure data collected from various sources.
- Experience with identification, research, and resolving discrepancies in analytical procedures or cross-functional methods.
- Experience with Software Development Life Cycle (SDLC) and Agile methodologies, in particular the test process associated with Agile development programs.
- Ability to work independently, collaboratively, creatively, and analytically.
- Experience with Enterprise Data Warehouse (EDW) data analysis/library products to support automated test tool development.
- Ability to design, re-design, document, administer, and fine-tune database environments.
- Ability to create and maintain data standards, lineage, and attribute mapping from various data sources, as well as various formats.
- Skilled in the integration of Commercial Off-the-Shelf (COTS) products and legacy DoD systems as part of an integrated information system, including the organization and execution of large-scale test and evaluation events.
- Experience with ETL development software, cloud architectures, Amazon Web Services (AWS), Oracle, Java, Toad Data Point, Microsoft Access, SQL Developer, and SQL.
- Must be very proficient in Microsoft Excel.
- Ability to determine database structural requirements by analyzing functional requirements, client business operations information, and evaluating existing systems or applications.
- Must be well organized.
- Must be an effective communicator at multiple levels with the ability to grasp system concepts and communicate their applications.
- Must be capable of quickly learning new systems and associated software applications for proficient execution of tasks.
- Must be capable of managing multiple projects with time-related constraints in a fast-paced contract manufacturing environment.
- Must be able to speak effectively before groups of internal and/or external customers or employees.
- Travel < 10% of the time (CONUS).
Clearance Requirements: A background investigation at the T3 level is required, as this is not currently a classified position. Must be a U.S. citizen.
Work Location: 100% Remote with <10% travel (CONUS)
The pay range for this position is $130,000/yr - $145,000/yr. The exact pay will depend on skills and experience.
