ETL Production Support

Data Analyst Professional Location: Must be able to be on-site in McLean Tuesdays, Wednesdays, and Thursdays, role is not open to relo Con Work Authorization: All candidates must be eligible to work in the United States without sponsorship and be direct W-2 employees to our vendors. Reason for Opening: Backfill of FTE Schedule: 40 hrs Affected by Holiday Furlough TBD Required Skills: Unix, Python, SQL, Data ETL, Production support Supplier Vetting Questions: Years of experience: 2+ Soft Skills Required: Shortlisting cutoff: 03/24 Interview Debrief: 03/31 Interview Information - Rounds: 2 rounds Duration: 60 mins Additional Notes: MS Teams, Video Mandatory Scheduling: 03/View email address on click.appcast.io&1, 03/View email address on click.appcast.io:30 &3 Our Impact We support one of the largest business data and application repositories of the company, which facilitate business decisions for modeling and reporting. We collaborate with business teams and IT teams to advance our technical capabilities and go from not yet to possible. We pioneer various new technologies that advance our businesses customers needs. Your Impact Understand business context and needs, and accordingly understand data flow from various structure/unstructured formats. Ensure completion of data analysis/lineage, operational support requirements such as SLAs and control reports, and other technical/business support as appropriate for the effort. Able to grasp system process flows and identify data points, calculations and business rules and help enhance operational processes. Understand and analyze current production process and help identify/analyze/document gaps and clearly communicate the same to the team. Act as liaison between business users and upstream operations teams to ensure all parties have complete understanding of issues/requests, requirements and process steps to ensure alignment and successful outcome. Follows established processes, procedures, and directions. Responsible for maintaining process documentation and other relevant records as needed. Be a creative thinker and can adapt to a quickly changing environment. Manage concurrent and multiple priorities within fast changing environment and meet tight deadlines Support weekend and late nights deployments and production issues. Monitor daily production jobs and communicate to CAR users in a timely basis. Qualifications Master's degree in statistics, data science, computer or information science or a related quantitative field. 2+ year data engineer experience in writing computer programs to implement data ETL, process integration and automation. Programming languages may include--but are not limited to--Python, PySpark, Unix Shell scripts, Autosys, SAS and AWS Cloud technologies. Strong hands-on experience under Unix/Linux environment. 2+ year work experience in quantitative analysis and production support activities. Strong SQL, Python, PySpark programming skill and experience Qualifying coursework may include--but is not limited to-programming languages, data science, machine learning, application optimization, numerical analysis and image analysis. 2+ years of data analysis experience, with a combination of business and technical skills with experience working with data marts/database from structured/unstructured data. Experience with database, data model and data warehouse concepts Familiar with Autosys scripts or similar job scheduling tools Work experience using technologies for manipulating structured and unstructured big data, data formats include--but are not limited to-CSV, XML, JSON, Parquet, etc. Familiar with Big data technologies may include--but are not limited to--Hadoop, Hive, Pig, Spark, relational databases, and NoSQL. SAS, Tableau, MicroStrategy are plus. Proficiency with Microsoft Office (Word, Excel, etc. Samprasoft