Data Wrangler Jobs (NOW HIRING)

Position: Data Wrangler
Duration: 12 Months
Location: 123 Main Street, White Plains NY (Westchester County), NY
Work Schedule: Monday through Friday
7.5 hour work day with .5 hour unpaid lunch
Paid for time worked only
Overtime is not permitted unless authorized in advanced.
Project Overview
New York Energy Manager is partnering with a Cloud vendor to implement Energy Management system for our customers (NYEM 2.0 Program). Client will be responsible for data discovery, cleansing and transformation of various data steams to the vendor's canonical format to support data analytics and reporting.
Functions and Responsibilities
• Wrangle data (a.k.a. data engineering) from a wide variety of complex data sets large volumes of data into normalized and enriched data sets.
• Assemble and evaluate data such that new insights, solutions, and visualizations can be derived. This individual will develop a deep understanding of analytical needs in order to enable the Client data assets, big data technologies, keying and linking concepts to analyze Internal and External utility industry data to create insights.
• Perform data discoveries to understand data formats, source systems, file sizes, etc. This will include engaging with internal and external business partners in the discovery process.
• Deliver data acquisition, transformations, normalization, mapping, and loading of data into a
variety of data models.
• Clear understanding of, and the ability to navigate file structures such as CSV files, Excel spreadsheets, relational data bases, SAP business warehouse cubes to locate and extract data.
• Ability to design and architect method of extracting data from its original source to another location (i.e. a data lake) to make that data consumable for a variety of downstream purposes such as applications, visualizations, analytics and other related data science activities.
• Basic understanding of data science and the ability to support a data science team.
• Ability to transforming and map one "raw" data form into another format with the intent of making it more appropriate and valuable for a variety of downstream purposes such as analytics.
• Interact with all levels of people including Data Stewards, Analytics professionals, IT, Sales and Customers, engineers and power plant personnel.
• Interact with Customer Business Technologists in order to satisfy customer needs.
• Assist in the development of ETL migration plans for all Client Internal and External data assets not currently integrated into a Client data lake, including developing a level of subject matter expertise with each new data asset being loaded.
• Lead and execute activities to support all aspects bringing new data sources into Client's data lake environment, Collaborate extensively with Technology to design data ingestion, data models, and automated operational metrics for consistent high quality data loading into Client Data platform.
• Develop strategies, standards, and best practices in the areas of data wrangling, data visualization, and data integration and lead adoption throughout the Client and the New York Canals Corporation.
• Ensure quality, coverage and accuracy of data. Validate data quality content in conjunction with respective data stewards by developing reports and tools to monitor and visualize data.
• Develop and Collaborate extensively with Data, Analytics, and Technology leads to ensure the seamless consumption of insights generated from Client and the New York Canals Corporation emerging big data analytical platform.
Skills:
• Expert level proficiency in SQL.
• Expert level proficiency in Microsoft Excel
• Experience working independently with minimal guidance
• Strong problem solving and troubleshooting skills with experience exercising mature judgment
• Proficiency in multiple programming languages
• Comfortable working with open-source technologies
• Agile Methodologies, Scrum, XP, particularly with more than one team within an organization
• Iterative project delivery, Scrum experience
• Experience in multiple roles of an Agile team
• Experience of coaching teams
• Experience in workshop facilitation
• Experience in software process improvements
• Knowledge of other Agile methodologies, such as Crystal, DSDM Atern, RUP, is a plus
• Experience in evangelizing Agile, is a plus
• Ability to work directly with highly experienced user community.
• Must have effective collaboration skills
• Exceptional ability to clearly and effectively communicate with IT peers and users at all levels of technical and business acumen.
• Strong time management skills and multi-tasking capabilities
• Ability to understand business rules governing financial and budgeting process
• An understanding of technical concepts, principles and terminology
• Exceptional oral and written communication skills
• Self-motivated, ability to set priorities and meet deadlines
• Ability to handle multiple tasks/assignments/projects simultaneously.
• Strong attention to detail
• Ability to clearly and correctly state and summarize technical information
• Ability to present finds to both technical and non- technical audiences.
• Experience with ETL and/or other Big Data processes.
Education and Certifications:
BA in Computer Science.