Job Seekers, Please send resumes to resumes@hireitpeople.com our client is currently hiring a Senior-level Alteryx Developer with experience in data acquisition/extraction and data blending geared towards but not limited to the Entertainment Industry. The developer will be responsible for researching and extracting pertinent data points within multiple source systems while developing analytical reporting solutions.
PRINCIPAL DUTIES AND JOB RESPONSIBILITIES:Design and develop ETL workflows and datasets in Alteryx to be used by the BI reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI)Will write complex SQL queries with multiple joins to automate/manipulate these extracts in AlteryxWorks in partnership with the other IT teams and stakeholders concerning the accuracy of data and efficiency of processesPrepare technical specifications and documentation for Alteryx workflows supporting BI reports.Perform end to end Data validation to maintain accuracy of data setsLead discussions with business partners to identify functional requirements resulting in data acquisition for BI applicationsTranslate business logic from one system (Excel, SQL, etc) into Alteryx in a quick and accurate mannerDevelop re-useable processes that can be leveraged and standardized for multiple instancesUnderstand the existing source system data models.Ensure application stability and performance by monitoring existing workflows to ensure they are working correctly and that they reconcile with the source.Provide ad-hoc data analysis and support to business functions.Qualifications:
KNOWLEDGE AND SKILLS REQUIRED:Advanced knowledge of SQL, database technologies and data warehouse design philosophiesAdvanced skills with Microsoft Office Suite with emphasis on ExcelAbility to effectively prioritize and execute tasksStrong analytical, problem solving, and troubleshooting abilitiesAdvanced knowledge of self-service analytic/ETL tools, specifically Alteryx DesignerAbility to follow detailed procedures and ensure accuracy in documentation and dataKNOWLEDGE AND SKILLS PREFERRED:Competency of BI tools (Tableau)Highly proficient in Microsoft Excel to analyze data and report results using pivot tables, charts and graphsEDUCATION AND EXPERIENCE REQUIRED:Bachelor's degree in Computer Science, Management Information Systems, Informatics or similar analytical fieldMinimum 5 years of related experience with Alteryx.Minimum 3 - 5 years writing SQL queries against any RDBMS with query optimization.Ability to gather and document business requirements.Minimum 3 - 5 years of experience in working with relational database systems OR Master's degree in a field mentioned above with -2-3 years of experienceEDUCATION AND EXPERIENCE PREFERRED:Master's degree in any of the fields mentioned above5+ Years of experience in working with Entertainment relational database systemsExperience in building, publishing and managing reports/dashboards leveraging Tableau.