The business problem is to leverage expertise in SQL, Tableau, and Microsoft Excel to drive data-driven decision-making, design and maintain database structures, perform complex data analyses, and develop client-driven metrics. The role aims to solve systemic problems, enhance data management processes, identify root causes of issues, and prevent recurring problems.
Requirements
- Strong SQL language, Tableau, and Microsoft Excel skills
- Ability to extract and manipulate large sets of data.
- 3+ years of SQL language experience required
- Strong analysis and reporting skills
- Data Modeling experience
- Microsoft - Power BI experience
- 3+ years experience of working with large data sets
Responsibilities
- Primary job duties include writing SQL queries in SyBase and/or Tableau to interface with various databases, as well as writing and testing code.
- Development often consists of designing tables, storing procedures, views, and functions.
- Data extraction from various database sources and data manipulation.
- Work with project managers, analyst teams and clients, building database queries, both for one-time and recurring use.
- Document, code, create table mappings, provide progress reports, and perform code review, and peer feedback.
- Perform data analyses by comparing information located in separate, but related, databases or tables.
- Utilize SQL, MS Excel, MS Access, Tableau, Python, and other applications to complete analysis of logistics data and to create client driven metrics.
Other
- Active DoD Secret Security Clearance
- Desire to learn and expand knowledge base in data analysis and logistics.
- Ability to gather and accurately translate requirements from stakeholders
- Ability to provide solutions to complex problems
- Attention to detail; maintains a high level of accuracy
