No more applications are being accepted for this job
Data Analyst - Frisco, United States - RIT Solutions, Inc.
Description
J ob Description - Role:: Data AnalystClient :
: Fidelity Investments
Location:
: Durham, NC /Westlake, TX must be local
Duration:
: 6 month
Must Have Skills:
AWS, Azure, PowerBI, SQL Quieres
Preferred Skills:
data warehousing and database performance tuning
Domain Knowledge:
Retirement, 401K, Defined Contribution
Location:
onsite 2 weeks per month in Durham, NC or Westlake, TX
Employment Allowed:
w2, c2c, RITS
SUMMARY:
The client, Fidelity, is initiating a migration project to enhance and update their current reporting
infrastructure, aiming to move away from the existing ecosystem of Oracle Business Intelligence
Enterprise Edition (OBIEE) and Oracle Exadata towards a new setup involving Snowflake and
Power BI hosted on AWS and Azure platforms, respectively. The migration is driven by the need
to address various challenges including data quality issues, lack of self-service capabilities, and
alignment with Enterprise Information (EI) and Workplace Investing (WI) cloud strategies. The
transition aims to provide a better reporting experience, faster time to market, and support the
decommissioning of legacy hardware and data warehouses.
Responsibilities:
Collaborate with business stakeholders to understand reporting requirements
and data analysis needs. Assist in the design of the database by providing insights into data
usage and reporting patterns. Validate data quality and integrity in the new AWS RDS database.
Support the development of data governance and data quality frameworks.
Qualifications:
Strong analytical skills with experience in data analysis methodologies.
Knowledge of database design principles and experience with SQL queries. Familiarity with
AWS, Azure and data visualization tools (e.g. Power BI). Understanding of financial data and
reporting standards