Vacancy expired!
My Direct Client needs a
Tableau Analyst with Strong SQL in Alpharetta ,GA If interested, please contact Amita @OR email your to . Remote due to COVID Alpharetta ,GA Responsibilities include:Turn business requirements into solutions that drive meaningful reporting and analysis for stakeholders across Firmwide Sourcing and the firm.Develop, modify, and maintain visualizations and dashboards that are hosted on an in-house Tableau server (MSViz).Execute daily ETL processes. This includes extracting, transforming and loading of datasets from multiple source systems, specifically; sourcing, contracts, accounts payable (BOXI), and other expense management and risk related tools.Become a subject matter expert on the data model/structure in order to perform meaningful analysis and apply it to business needs.Write complex queries for large volumes of data (joins, functions, sub queries, etc.).Ensure all daily/weekly/monthly/quarterly reporting deliverables are completed on time.Edit and create SQL stored procedures/views in order to generate the KPIs and metrics required by leadership.Troubleshoot and perform root cause analysis; investigate discrepancies and gaps for issues arising from any errors, failing data connections or source system data quality.Work independently with stakeholders for any ad hoc requests or modifications to existing reporting solutions and dashboards.Find efficiencies with respect to database indexing, process automation and report execution.Monitor and manage ad-hoc and day to day tasks and document procedures that are easily replicable by other resources. QUALIFICATIONSRequired Skillset:5+ years' experience in a professional setting with a strong focus on reporting and data analytics.Education: Minimum of a Bachelor's Degree in a relevant field (Finance, Information Systems, Data Science, Technology preferred).Analytical skills: The candidate must be highly analytical with experience in using objective data to drive strategic recommendations. Experience of collecting, analyzing and synthesizing large and complex datasets.Industry experience with report development, data warehousing, business analytics and using data science/business intelligence tools.Advanced Microsoft Office Skills; PowerPoint, Word, Access, and Excel (complex formulas, pivot tables, slicers, data connections, macros).A willingness to understand underlying data, sources, data elements and end to end data flow in order to provide clarity to stakeholders.Client management and teamwork skills: The candidate must have demonstrated ability in being flexible and working with stakeholders and colleagues at all experience levels, as well as external counterparts.Prior experience using an RDBMS (Relational Database Management Systems), Particularly SQL Server. Must also possess SQL Code development skills in order to create custom queries, stored procedures, execute code, views, etc. ThanksAmita Tatiparti Sr. Technology Recruiter Lenmar Consulting, Inc. [a Kellton Tech Company] Harborside 5, Jersey City, NJ 07311 DM: 347.517.0317 O: 201.946.1777 ext. 4011 E:Vacancy expired!