FAA Data Analyst/Visualizer (FAA/DoT Experience Required)
Strategic Innovation Group (SIG) seeks an experienced Data Analyst/Visualizer to join our team. The ideal candidate will have a strong background in data analysis, with hands-on experience in working with BI reporting and visualization.
Salary: $120 - $150K
SIG is a fast-growing 8(a) government contractor based in Arlington, Virginia. We offer a broad range of technical expertise and experience in Professional Services, Digital Transformation, Data Management/Data Science, and Systems Modernization. At SIG, our people are our mission. Come join our team! A successful candidate will be offered the following:
- Great work/life balance
- Eligibility for performance-based participation in cash bonuses
- Excellent benefits, including health, dental, vision, generous PTO, a 401(k) with match, life insurance, short- and long-term disability, and a health savings account (HSA)
- Remote work, preferred location in Oklahoma City to meet with coworkers and clients 4 times a year for 4 days (M-Th).
ESSENTIAL DUTIES AND RESPONSIBILITIES
The essential functions include, but are not limited to, the following:
- Administer roles, access and permissions to Tableau Sites in Tableau Online
- Build worksheets, dashboards and data sources in Tableau Desktop
- Daily data validation and reconciliation
- Utilize Presto to connect Postgres DB to Tableau Online for reporting data
- Run Alteryx workflows to alter, clean and consolidate data to be loaded from SplashBI, Oracle DB, Denodo, csv, xslx and txt files into Postgres database
- Validation of 100's of Alteryx workflows that facilitate loading DELPHI data into EIM
- Configure Alteryx server to schedule workflows, allow for coordination within team in Collections so all team members can share, allow others to run and view workflows loaded to the Collections
- Work with FAA Alteryx and Tableau Admin teams to look for ways to make Alteryx and Tableau more efficient and better use of resources
REQUIRED EXPERIENCE/QUALIFICATIONS
- Bachelor's or master's degree
- 10+ years of experience with SQL queries (Oracle SQL, PL/SQL, Postgres, MYSQL, etc)
- Advanced Excel skills
PREFERRED EXPERIENCE/QUALIFICATIONS
- Current Public Trust clearance or higher.
- Experience with Denodo, Starburst EIM SQL, and Oracle EBS is desirable
- Knowledge of maintaining CMMI ML3 for development is a plus
SPECIAL REQUIREMENTS/SECURITY CLEARANCE
- Must be able to obtain and maintain a Public Trust clearance.
- Must work a minimum expected 1,920 hours per year.
The company is an Equal Opportunity Employer, drug-free workplace, and complies with ADA regulations as applicable.