Developer-ETL - (Python Scripting, ETL Tools (Alteryx), SQL , Tableau preferred) (Open to H1B-C2C)
Location: McLean, VA
Experience with designing, development of DataStage ETL components and performance tuning for multi-dimensional models on the data warehouse
Position Overview Section
The Data Analytics Senior is responsible for development and operations of Business intelligence (BI), Reporting, Data management and data warehouse repository for Enterprise Supply Chain.
o Improve customer experience, mitigate third-party risk and leverage buying power in-order to capture, enable and sustain value for business partners and suppliers.
o Unlock value in the supply network to enable growth, innovation, and exceptional customer experience.
ESC Data Analytics goals
o Deliver data insights to support ESC mission and vision
o Focus on delivering business value and innovate iteratively
o Build and enhance team capabilities to deliver consistent and sustainable data solutions and value and to business
o In this role, Data Analytics Senior will report to Data Analytics and Business Intelligence Manager within Enterprise Supply Chain organization.
o Collaborate with team members to provide robust data analytics solutions and operational monthly dashboards.
o Partner with business stake holders to create solutions and play active role in supporting overall procurement cycle.
o Lead data and reporting initiatives by implementing design and development solutions.
o Execute tasks timely per requirements in a professional manner.
o Identify and assess data gaps and potential by providing troubleshooting in a timely manner.
o Implement solutions with attention to detail per requirements with end to end validation before the delivery to customers.
o Demonstrated on-the-job experience getting data or proposing ways in which to measure or collect the data in the future
o Experience working with and manipulating the data to answer the question at hand or develop metrics that are relevant
o Demonstrated on-the-job experience with Data Analytics
o Demonstrated on-the-job experience solving data problems, successfully and skillfully conveying process and outcomes to senior stakeholders in both written and oral formats
o Intellectually curious and motivated to research and learn new techniques to support Enterprise Supply Chain initiatives
List the Skills and Experience Required
o Bachelors in a quantitative discipline such as Statistics, Economics, Mathematics, Computer Science, Information Systems
• Technical Skills/Proficiency
o Experience extracting New and Innovative Insights from Complex, Non-Traditional, and/or Large Data Sets
o Demonstrated on-the-job experience with Data Analytics tools including SQL Developer, Python, MS Access, Advanced Excel
o Demonstrated on-the-job experience briefing results and associated methodologies in a manner that is easy for non-technical audience to understand
o Demonstrated on-the-job experience with the enterprise data systems (Financial, CRM and others)
o Demonstrated experience with Unix/Linux/Shell Scripting
o Experience working in an Agile environment
o Experience with Data visualization Tools including Tableau, Microsoft Power BI
o Experience in Data Warehousing and data integration with ETL Tools such as Informatica
o Predictive modeling, statistics, trend analysis, and other data analysis techniques to collect, explore, and identify the right data to be analyzed from internal and external sources
o Proficient in working with large-scale business data sets, fluent in scripting and rapid prototyping skills
• Years of experience
o 5-7 years related experience
• Leadership / Management experience
o Not Applicable. Should possess self-management of tasks and on time delivery.
o Proven experience setting up data quality and data storage
o Proven experience in working with data warehouse environment
o Experience with supporting data analytics solution within an organization
o Preferred but not required