Advisory Data Analyst

Ricoh Americas Corporation Exton , PA

Posted 3 weeks ago

POSITION PROFILE

As an Advisory Data Analyst, you will scope and lead large projects around Ricoh's data and reporting platform, working closely with the architecture and development teams to deliver analytics and reporting solutions that enable our business teams to continue growing and evolving Ricoh's business. You will work under the general direction of a Director or Senior Technology Manager, providing expertise and technical guidance that is backed up by an in-depth reporting, data domain expertise around cross functional areas of the applications and/or architecture.

JOB DUTIES AND RESPONSIBILITIES

  • Work with business stakeholders to identify business data content and analytics needs, define Ricoh's data strategy around it with innovative and effective solutions

  • Work with databases, ETL and other tools to centralize data from multiple sources, optimize data efficiency and quality.

  • Understand, interpret, and analyze data using current tools and techniques to provide ongoing reports. Provide data visualization using tools and techniques in easy to understand formats.

  • Leads and executes projects and initiatives in full compliance with defined processes and controls.

  • Develops and generates complex ad hoc reports and databases to address specific business needs.

  • Recommends / suggests alternatives on analytics solutions to business challenges, train business teams on self service analytics capabilities.

  • Gather and compile data, eliminate or reduce redundancy, maintain data integrity, improve data quality and availability. Monitor data quality and suggestion to improve data quality

  • Provide technical guidance on new products and technology. Provide guidance for technical architecture, data modeling and ETL standards

  • Communicates and coordinates with other team leads, business leadership, and development teams to ensure on time and budget deliveries.

  • Advice and train new and Jr. Level data analysts with data analysis and developing reports

  • Performs other duties as assigned.

QUALIFICATIONS (Education, Experience and Certifications)

Typically Required:

  • Bachelors or Masters Degree in Information technology or related field.

  • Minimum of 8 years of experience in Information Technology with 2+ years experience leading complex IT projects around data integration, analytics and data warehouse platforms,

  • Minimum of 2 years of experience on MPP databases, preferably Snowflake

  • 3+ years of data analysis experience writing, understanding and performance tuning complex SQL queries on relational databasess(Oracle, SQL Server, MySQL or similar databases), preferably on Snowflake

  • Minimum 2 years of data engineering experience working on ETL tools, preferably using Informatica ETL tools

  • Minimum 2 years of experience working with data visualization tools (Qlik, OBIEE, Power BI or similar reporting software)

  • Hands on experience gathering requirements, driving design, and owning solutions from end to end.

  • Coding proficiency in at least one programming language (Python, Java, etc)

  • Experience in data architecture and data design solutions, preferably AWS or other cloud solutions

  • Excellent critical thinking and problem problem-solving skills

  • Experience managing multiple large projects simultaneously.

  • Experience establishing and maintaining relationships with various senior level stakeholders.

KNOWLEDGE, SKILLS AND ABILITIES

  • Possesses ability to interpret business needs and translate them to create complex solutions.

  • Conducts research around best practices and has ability to adequately document created solutions.

  • Possesses ability to effectively communicate with people at multiple levels. Requires excellent negotiation skills.

  • Possesses facilitation skills including ability to organize, conduct and document effective meetings.

  • Possesses ability to clearly communicate technical and procedural information verbally and in written documentation form.

  • Possesses ability to recognize conflict situations and resolve many; escalates those that cannot be resolved.

  • Possesses ability to determine resolution for routine and non-routine issues; recognizes issues for escalation.

  • Possesses very good customer service and interpersonal skills; is motivated and team oriented.

  • Possesses ability to prioritize multiple tasks and projects, is organized and dependable.

  • Possesses ability to work in a fast paced and changing environment.

  • Possesses ability to create, modify and execute complex project plans and participate in plan implementation with little direction.

  • Strategic thinker with courage to challenge requests and inspire collaboration for more innovative solutions.

  • Strong delegation skills, and quick decision making.

WORKING CONDITIONS, MENTAL AND PHYSICAL DEMANDS

  • Typically, an office environment with adequate lighting and ventilation, and a normal range of temperature and noise level.

  • Work assignments are diversified. Interpret, comprehend and apply complex material, data and instruction - prepare, provide and convey diversified information.

  • Minimal physical effort required. Work is mostly sedentary but does require walking, standing, bending, reaching, lifting or carrying objects that typically with less than 10 lbs. (e.g., papers, books, files and small parts, etc.). Moderate dexterity - regular application of basic skills (calculator, keyboard, hand tools, eye/hand coordination.

Visa Sponsorship is not offered for this position.

Ricoh is an EEO/Affirmative Action Employer -- Minorities/Women/Protected Veterans/Disabled.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Fraud And Chargeback Analyst

Learfield

Posted 1 week ago

VIEW JOBS 1/15/2022 12:00:00 AM 2022-04-15T00:00 Paciolan is the #1 primary ticketing company in college athletics, and the #2 largest primary ticketing provider in the US including performing arts, arenas, and professional sports. As a leader in ticketing, fundraising, marketing, analytics, and technology solutions, we power more than 500 live entertainment organizations, selling over 120 million tickets a year. Qualifications: * Customer Service experience with demonstrated ability to develop effective working relationships * Analytical mindset and ability to make effective decisions under time and information constraints * Strong research, critical thinking, and problem-solving skills * Prior experience in chargebacks, fraud review or analysis a plus * Advanced written and verbal communication skills with the ability to lead and work collaboratively * Proficient in Windows environment with strong Excel, Word, Outlook and Internet skills * Must be accurate and efficient with ability to meet deadlines, work with limited direction and manage multiple priorities Job Functions: * Monitor ticket transactions for fraud, utilizing historical and current data * Research credit card inquiries and disputes to identify trends and process improvements * Compile and analyze internal and external data to identify at-risk transactions, accounts, and devices. * Maintain accurate work flow of all unresolved order reviews * Track attempted fraud by year, month etc. and provide detailed reports to management * Continuously improve the methods used to proactively identify suspicious accounts and transactions * Collaborate with internal departments to communicate the results of research and the impact of fraud prevention, assist as needed in development of corrective measures to reduce fraud losses * Maintain and continuously improve knowledge of current risk factors and fraud trends via ongoing training, industry collaboration, and professional development * Other duties and responsibilities as assigned Nonessential Job Functions: * Other duties and responsibilities as assigned Intellectual/Social, Physical Demands and Work Environment: The intellectual/social, physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Intellectual/Social demands: * While performing the essential functions of this job, the employee is continuously asked to multi-task under time limits. Position requires constant attention to precise details and accuracy of specified standards including: following simple to complex (more than 3 steps) instructions, and concentration which frequently extends beyond 30 minutes at a time. This position also requires constant use of interpersonal skills including: ability to direct/motivate/inform staff and foster collaboration, being able to recognize and resolve conflicts, being able to openly communicate in writing and verbally with clients. Physical demands: * While performing the essential functions of the job, the employee constantly operates a computer and other office devices such telephones, copy machines, fax machines, etc; occasionally moves about inside the office to access storage areas, cabinets and office machinery; constantly communicates via telephone, email and in-person with others to exchange accurate information. Travel to annual fraud conference and local client offices. Work environment: * The duties of this position are usually performed indoors. The noise level in the work environment is usually moderate to loud during events and minimal during non-event times. Learfield Exton PA

Advisory Data Analyst

Ricoh Americas Corporation