Data AnalystPerforms data collection, analysis, validation and reporting. Designs, tests, and documents processes, SQL queries, and stored procedures. Extracts and analyzes data from various sources, including databases, manual files, and external websites.
Responds to data inquiries from various groups within an organization. Creates and publishes regularly scheduled and ad hoc reports. Documents reporting requirements and processes and validates data components as required.
Requires experience with relational databases and knowledge of query tools and/or statistical software. Strong analytical and organizational skills also essential. 10+ years of experience.NO -H1B VISA PROFILESMAJOR DUTIES AND RESPONSIBILITIESConduct complex data analysis in support of a variety of analytic solutionsCapture, develop, and document data definitions, business rules, and data quality requirementsIntegrate data from multiple sources to produce requested or required data elementsCreate and produce technical reports, ad hoc requests, dashboards, etc.Interpret data, analyze results, and provide insights to determine operational impact, trends, and opportunitiesDevelop reports and deliverables for management and communicate with all levels of stakeholdersIdentify and define data quality improvementsCreate and maintain report forms and formats, information dashboards, data generators, canned reports and other end-user information portals or resourcesEnsure compliance with deliverable reporting requirements by performing quality data audits and analysisCreate specifications for reports based on business requestsIdentify opportunities to use data to develop new strategies and improve business performance and utilize knowledge of mathematical modeling and other optimization methods to perform quantitative and qualitative data analysisPerform other duties as requestedREQUIRED QUALIFICATIONSSkills/Abilities and KnowledgeAbility to read, write, speak and understand EnglishAbility to prioritize and organize effectivelyAbility to work independently, as well as in a collaborative and dynamic team environmentAbility to handle multiple projects and prioritiesAbility to analyze and interpret dataAbility to quickly identify business problems/opportunitiesAbility to communicate orally and in writing in a clear and straightforward mannerAbility to communicate with all levels of management and company personnelAbility to manage multiple projects at one timeAbility to document, prepare and present data-driven presentationsPREFERRED QUALIFICATIONS: Skills/Abilities and KnowledgeWillingness to learn networking and WiFi and Wireless technologies and automation frameworks.Experience with software applications such as Word, Excel, etc.Experience with Python: numpy, pandas, pyplot, seaborn (xlsxwriter, pyodbc, pymongo, and pptx)Experience with databases: SQL and NoSQL (MongoDB)Experience with data visualization/reporting tools: Tableau or anything Microsoft Power BIExperience with Gitlab; JIRA; ConfluenceExperience with Alteryx softwareFamiliarity with JavaScript API, Rest API or Data Extract APIsExperience with cloud-based data technologies preferredExperience with creating dashboards, reportingExperience with descriptive and multivariate modelingExperience with data and statistical analysisPossesses understanding of Machine LearningExperience receiving, converting and cleansing big data with complex queries and diverse formats (dbs; csv; json; PDF)Self-starter and ability to work without direct supervisionEDUCATIONBachelor’s degree in business or related fieldRelated Work Experience Number of YearsData analysis and reporting or related experience 10 PLUSWORKING CONDITIONS