Data Integration Analyst Job in Acoustics

Description As part of the Professional Services team, the Integration Services Analyst is responsible for working closely with the customer and internal teams to ensure data integrity within a Saas environment. This position utilizes skills in data mining, data analysis, and data manipulation against large-scale datasets. You must be able to understand business scenarios, analyze, interpret and communicate findings to all levels of the organization. Additional tasks would include performing data analysis and source-to-target mapping; performing ad-hoc analysis; and validating, structuring and deriving insights from large amounts of data. A drive to learn and master new technologies and techniques. Have a strong track record of applying problem-solving skills, particularly in relation to large data volumes and technical systems. Must have a curious and innovative mind-set, with a determination to understand challenging concepts and find new solutions. Intellectually curious and enjoys problem-solving, requirement gathering, and adaptive to lead with example. Ability to sense check and identify trends or patterns in data. Comfortable taking ownership of tasks and working with limited supervision or instruction in a remote work environment. Thoughtful and comfortable communicator (in person or on paper) with both technical and business stakeholders, with the ability to facilitate discussions. Ability to thrive in a flexible and collaborative environment. A willingness to adapt and learn. RESPONSIBILITIES Work closely with customer and internal teams to ensure timely completion of project milestones related to data requirements while handling multiple project priorities. Manipulate data sets Understanding of business scenarios related to the data Work diligently to help ensure overall data quality for customer accounts Assist in resolution of data issues Ensure accuracy and integrity of data through analysis, coding, writing clear documentation and problem resolution. Experience and understanding of data life cycle: data acquisition, data quality and data management Strong Analytics knowledge and insight generation Able to rationally and systematically analyze the raw data, check for anomalies, cleanse and transform into information useful for decision making Hands-on experience with data aggregation techniques, data ingest/transformation, data analytics, machine learning Ability to apply, modify, and formulate algorithms and processes to solve challenging problems Ability to present results in an intuitive, actionable manner that can be understood by sponsor audiences, regardless of technical expertise Identify data quality issues, root causes, and apply remediation Strong problem-solving skills Communicate with stakeholders to understand current needs, near-term plans, and opportunities for improved data-driven decision support. Write custom SQL queries to extract data from internal databases. Write python or perl scripts to structure data into the desired format or to clean/parse data. Strong knowledge and experience in querying, manipulating and summarizing large amount of data through SQL, in addition to experience in scripting languages such as R or Python Understanding and related experience in the integration of data from multiple data sources and automation of data processes Requirements MINIMUM REQUIREMENTS 3-5 years experience and proficiency in SQL(Oracle, DB2, SQL Server) 3-5 years experience with scripting/programming languages (Perl, Python, PHP, Java etc.) 1-2 years with ETL tools, EDI, DataStage or MapReduce Analyzing, organizing, cleansing and manipulating large amounts of data Troubleshooting, problem-solving and decision-making skills Demonstrated partnering and communication skills 1+ years Linux/Unix experience with shell scripting Experience with managing multiple projects simultaneously 1+ years experience with APIs Language: English and Spanish Location: US or UK or Poland DESIRED EXPERIENCE 6+ years experience and proficiency in SQL(Oracle, DB2, SQL Server) 6+ years experience with scripting/programming languages (Perl, Python, Java, PHP, etc.) Data mapping experience with ETL tools, EDI, DataStage or MapReduce Data cleansing experience Retail systems experience (supply chain, POS, trade funds, etc.) 1-2 years experience with data warehouse environments or BigData