Technical Task Lead - Data Engineering (FAA/DoT Experience Required) Strategic Innovation Group (SIG) seeks an experienced Technical Task Lead to join our team. The ideal candidate will have a strong background in data engineering, with hands-on experience administering data platforms, building data workflows, and ensuring data security and access controls. FAA/DoT experience is required for this position.
Salary: $150,000 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 OK to meet with coworkers and clients.
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 Build workflows in Alteryx to load data from xls, csv to load to Postgres database and workflows to load from Postgres DB views to Tableau server as hyper files. Build workflows in Alteryx to export data from Oracle DB to Tableau site as hyper files on Tableau Server Utilize Presto to connect Postgres DB to Tableau Online for reporting data Utilize Postgres SQL to build schemas, roles, tables and views Assigning Postgres roles to tables, views and schemas for access, modify and creation Move files to Amazon S3 bucket for data import into EIM Build Alteryx workflows to alter, clean and consolidate data to be loaded from SplashBI, Oracle DB, Denodo, csv, xslx and txt files into Postgres database Build and assist building 100's of Alteryx workflows to 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 Existing FAA badge Expertise in 'hard joins' and combining PRISM and Delphi data 10+ years of experience with SQL queries (Oracle SQL, PL/SQL, Postgres, MYSQL, etc) Advanced Excel skills PREFERRED EXPERIENCE/QUALIFICATIONS 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.
#J-18808-Ljbffr