דרושים Sql Data Analyst ב-United States, Pennsylvania, Pittsburgh

Ernst & Young U.S. LLP, Charlotte, NC.

Full time employment, Monday– Friday,hours per week, 8:30 am – 5:30 pm.

Bachelor's degree in Finance, Accounting, Economics, Mathematics, Statistics, Information Systems, Computer Science, Engineering, Business or a related field; and at least 5 years of post-bachelor’s progressive related work experience. Alternatively, will accept a Master’s degree in Finance, Accounting, Economics, Mathematics, Statistics, Information Systems, Computer Science, Engineering, Business or a related field; and at least 4 years of related work experience.Must have 4 years of experience in at least one or a combination of the following analytics tools:
- ACL,
- Tableau,
- Spotfire,
- Microsoft SQL Server,
- SPSS,
- SAS,
- Business Objects,
- Cognos,
- Informatica,
- Trillium, and/or
- Data Stage.Must have 3 years of experience in at least one or a combination of the following modernized information management tool landscapes:
- Talend,
- Collibra,
- Oracle DRM,
- SAP MDM,
- Informatica,
- Hyperion,
- Essbase, and/or
- SQL.Must have 4 years of experience with ETL processes.Must have 3 years of experience advising clients on the full data supply chain from data wrangling to data consumption via analytics.Must have 3 years of experience in providing complex consultative services in at least one or a combination of the following areas:
- information strategy,
- data architecture,
- information/data governance,
- master data management,
- data quality, and/or
- data integration.Must have 2 years of experience in supervising a team of professionals.Employer will accept any suitable combination of education, training or experience.

What we offer

We offer a comprehensive compensation and benefits package where you’ll be rewarded based on yourperformance and recognized for the value you bring to the business. The base salary for this job is $153,962.00per year. In addition, our Total Rewards package includes medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options. Join us in our team-led and leader-enabled hybrid model. Our expectation is for most people in external, client serving roles to work together in person 40-60% of the time over the course of an engagement, project or year. Under our flexible vacation policy, you’ll decide how much vacation time you need based on your own personal circumstances. You’ll also be granted time off for designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.

• Continuous learning: You’ll develop the mindset and skills to navigate whatever comes next.
• Success as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
• Transformative leadership: We’ll give you the insights, coaching and confidence to be the leader the world needs.
• Diverse and inclusive culture: You’ll be embraced for who you are and empowered to use your voice to help others find theirs.

If you can demonstrate that you meet the criteria above, please contact us as soon as possible.

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.

For those living in California, please

This particular position at Ernst & Young in the United States requires the qualified candidate to be a "United States worker" as defined by the U.S. Department of Labor regulations at 20 CFR 656.3. You can review this definition at at the bottom of page 750. Please feel free to apply to other positions that do not require you to be a "U.S. worker".

Your key responsibilities

You’re likely to spend your time on a diverse array of projects, responsibilities and tasks, supporting client engagements by participating in day-to-day interactions with team members, providing a quality work product and driving delivery of services to meet deadlines. You will serve as a trusted advisor and role model for our people across multiple teams, research tax law issues, provide advice and assistance to help clients understand risks and potential needs for additional tax advisory or compliance services.

• Performing tax research and preparing written tax advice
• Preparing tax information statements and tax returns including complex Forms 1041 and state income tax returns for trusts and estates
• Reviewing and interpreting wills and trust documents to determine fiduciary tax reporting requirements confirm beneficiary allocations and identify matters that may require additional research and review by a subject matter professional such as determination of state tax nexus.
• Analyzing proper tax treatment of various transactions, learning to identify, review and confirm accuracy in tax reporting
• Translating complex data from a range of sources into client-ready insights and deliverables to support informed decision-making concerning required tax reporting

You will support the Fiduciary/Trust Tax Services practice with the preparation and delivery of tax information statements, tax returns and related reporting for agency, custody and fiduciary accounts for tax compliance engagements with banks, wealth management firms, trust companies and law firms. You’ll be working in a highly collaborative culture, where listening to and sharing information with colleagues is an essential part of the role.

Skills and attributes for success

• Collaborate with clients and colleagues to analyze tax issues, determine alternative methods of problem-solving and arrive at recommendations
• Support managers, senior managers and PPEDs with reconciling returns, e-filing returns, and validating data in the tax system
• Communicate with client tax liaisons, client trust administration teams and client trust officers to gather required information, to share information to support informed decision-making, and obtain instruction or authorization necessary for timely, accurate production of tax information statements, tax returns and related reporting
• Support billing and collections for tax compliance and related services and participating in the process of contract renewals and new business pursuits
• Communicate complex tax issues to colleagues, clients and non-tax professionals to enable evaluation and review of tax compliance requirements central to fulfilling fiduciary tax reporting obligations
• Responsible for training less experienced team members on administrative tasks and tasks supporting the tax compliance process

To qualify for the role you must have

• Bachelor degree or equivalent experience (Accounting, Business, Finance or equivalent degree preferred)
• Minimum 2 years of experience in a professional services or tax services organization and preparing federal and state fiduciary income tax returns
• Proficient in computer software applications, including Microsoft Word, Excel and PowerPoint, knowledge of trust accounting systems and tax software applications, including ONESOURCE™ Trust Tax
• Experience preparing income tax returns with complex pass-through investments, read and interpret trust agreements
• Ability to work effectively both independently and with a team, assist with a variety of projects of varying degrees of complexity
• Knowledge of taxation, trusts and estates, wealth planning and fiduciary income taxation
• Demonstrated technical expertise in fiduciary accounting matters
• Build effective relationships with our clients, understand their unique needs to provide tailored services. Manage workflow effectively to comply with clients’ needs and expectations and complete special projects
• Excellent organizational and verbal/written communication skills
• Commit to periodic travel (10-15%)

Ideally, you’ll also have

• CPA or EA certification or membership in The Bar desired, but not required
• Thorough knowledge tax compliance, information reporting rules, fiduciary and/or income tax law and concepts required to prepare US federal and state tax information statements and tax returns
• Strong analytical skills and attention to detail
• The ability to adapt your work style to work with both internal and client team members

What we look for

We’re interested in tax professionals with a genuine interest in providing outstanding services to some of the world’s most influential people. Working with people from all backgrounds, from executives and entrepreneurs to investors and families, you’ll use your experience and status as a trusted advisor to maintain and further our reputation for excellence.