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.