Senior Data Analyst
3-month contract with strong potential of extension
$___/hr w2
Top Skills' Details
1. Senior Data Analyst with 8-10+ years of experience- preferably financial services industry experience.
2. Experience as a Senior Data Analyst on a Data Ingestion project. This group will be in a Salesforce and Snowflake Data Ingestion environment.
3. Advanced SQL skills and ability to analyze complex datasets to identify trends, patterns, and anomalies using tools like Excel, Alteryx, SQL.
4. Excellent communication skills and client facing skills- able to work with business teams and lead requirement gathering independently.
Job Description
T. Rowe Price is a wealth and asset management company headquartered in Baltimore, MD and with a large technology campus in the surrounding suburban area. They offer a variety of financial products and services to individuals, institutions, and third-party investors.
The Investment Technology group at T. Rowe Price is looking for a Data Analyst to join their team! This group supports the US Intermediaries Business at T. Rowe Price and have several large projects going on that support their investment products for their customers. One of the key projects is the Distribution Intelligence Platform-This is a Data Lake that consumes Salesforce, adobe, and 3rd party data then ingests into Snowflake then reports are created in tableau for users. This a huge engagement with cross matrixed support both onsite and offshore. T. Rowe is looking for a senior Business Data Analyst who can work with the product owners- understand their pain points around data related reports and applications. Also will then need to work with mdm and salesforce team and help them understand and solve the data issues and create user stories around them.
Well versed with SQL knowledge.
Analyze complex datasets to identify trends, patterns, and anomalies using tools like Excel, Alteryx SQL.
Knowledge of data warehousing concepts, architecture and best practices.
Experienced in eliciting, documenting, and managing business requirements.
Ability to work closely with stakeholders to understand their needs and translate them into technical specifications.
Ability to lead meetings ensuring they are productive, efficient and achieve desired outcomes.
Experience with Agile methodologies, write stories for the development team, lead refinement sessions.
Ability to build data models using tools like Erwin/Hackolade
Nice to have:
- Prior experience working with Salesforce tool.
- experience using Snowflake database
- Knowledge of ETL tools like Power Center, IICS
Requirements:
1. Bachelor's degree or the equivalent combination of education
2. 5+ years of experience writing queries on databases like Oracle, postgres, snowflake is required
3. Experience and ability to create user-friendly Excel spreadsheets from a large set of raw data
4. 2+ years of experience in the field of data governance, data quality, meta data management, is preferred
5. Experience understanding formulas and algorithms and capability of dissecting a problem into manageable parts
6. Experience with ETL tools like power center, IICS, Snaplogic is a preferred
7. Experience processing various file types (CSV, Fixed Width, JSON, XML)
8. Experience in Programming languages like Python is preferred
9. Experience with MDM, salesforce is preferred
10. Experience with AWS is preferred
11. Familiarity with iterative development methodologies (agile)
12. Strong interpersonal oral and written communication skills
13. Ability to set priorities and objectives, then plan and organize the team in order to meet them
14. Able to work independently, plan workloads and deliver on commitments
15. Superior analytical, evaluative, and problem-solving abilities
Additional Skills & Qualifications
College Degree Required
Employee Value Proposition (EVP)
T. Rowe Price is a trusted client of TEKsystems. We have over 10 years of history with T. Rowe Price and the feedback from our candidates placed there has been mostly favorable. This is an excellent opportunity to join a stable company with an exciting project. Long term work and the chance to work on a project with new technology.
Work Environment
Agile environment. Team of about 25 people. Mix of contractors and full time employees that are apart of a much larger program of around 50 people.
Business Drivers/Customer Impact
Create reports on T. Rowe Price's Investment Products that can be used by the business to make decisions.
Why is the position open(provide details)
External Communities Job Description
1. Senior Data Analyst with 8+ years of experience- preferably financial services industry experience.
2. 5+ years of experience writing queries on databases like Oracle, postgres, snowflake is required
3. Experience and ability to create user-friendly Excel spreadsheets from a large set of raw data
4. 2+ years of experience in the field of data governance, data quality, meta data management, is preferred
...more than a half century ago as a full-service consulting firm providing mechanical, electrical, structural, civil, transportation, water and wastewater, land development, planning services; a broad range of field work including survey, geotechnical, construction inspection...
...compelling content daily to captivate a B2B audience. Actively engage with followers, respond promptly to queries, and monitor customer reviews. Create ways to gather more reviews Conceptualizes, writes, edits and creates digital and video content for Community...
...deliver mail, take care of data entry into various software, assist our sales agents, and assist us with other operations as needed... ...provide the most skilled service with a courteous attitude to our real estate customers and agents. Our company has a strong market share...
...for healthcare excellence? We are seeking a multi-site Hospital Director who embodies a unique blend of operational expertise, business... ...Leadership Directly oversee all operations and business activities, leading team members across all departments with enthusiasm and...
...Provides front-office customer service to include receiving/ directing incoming calls and e-mails. Monitors and responds to Hubspot requests; refers technical requests to sales and/or engineering as appropriate, maintain accurate and complete information in Hubspot...