Power Bi jobs in United States

You will be working on a 100% remote schedule as part of Fidelity’s dynamic working arrangement.

Fidelity Clearing Canada (FCC) is the leading independent clearing broker and custodian in the Canadian market. We provide trade execution, clearing, custody and back-office support services to Canadian-based brokerage firms and the Canadian brokerage arms of U.S.-based firms.

What You’ll Be Doing

The Senior Data Architect - FCC provides data architecture expertise on key FCC business and IS (Information Services) initiatives and participates in the development of application systems and technical solutions, focusing on new/enhanced data structures. This includes database logical and physical design, BI design, design and overview of data.

Key Responsibilities:

1. Lead research, impact analysis, technology evaluations/selections, initial proof of concept, and the roll out of new tools and documented standards to IS development teams and functional areas. This includes enterprise data architecture, operational and database design, BI technology and processes;
2. Govern definition, design, storage, maintenance, movement, and access of data;
3. Act as a liaison between the technical and business user communities for data requirements;
4. Participate in Fidelity Enterprise architecture efforts, and ensure that FCC standards align with Enterprise Architecture blueprints and guidelines;
5. Perform the primary data architect/designer role on client applications in partnership with development teams;
6. Develop and maintain FCC data architecture, including development of FCC data models and other data structures definitions, defining standards, promoting conformity and compatibility, and reducing redundancies in data.

What We Are Looking For:

1. Completed University degree, preferably in Computer Science, Engineering, or equivalent working experience
2. 10+ years’ experience as data architect or similar role, preferably within the financial services industry
3. Minimum 8 years’ experience with databases - Snowflake, Oracle and MariaDB.
4. Minimum 5 years’ experience with OLTP and OLAP/Data Warehouses. Expert knowledge of relational and multi-dimensional data models, SQL, performance tuning.
5. 2+ years’ experience in Data Integration Tools - Talend (preferred), CDC.
6. 2+ years’ experience in BI and data visualization tools (e.g.: PowerBI, Tableau, HighCharts).
7. Good knowledge of cloud (AWS) and on-premise infrastructure.

The Expertise You Bring:

1. Practical experience with Data Governance with the ability to influence on initiatives.
2. Strong data analysis, logical and physical database design skills, with thorough understanding on data architecture principles.
3. Comprehensive understanding of data architecture, current and emerging technologies.
4. Excellent Analytical and Problem-solving skills.
5. Excellent verbal and written communication skills.
6. Proven strength in collaboration and teamwork.
7. Strong relationship management skills

Current work authorization for Canada is required for all openings.

Some of the ways we’ll help you feel valued and supported as part of our team:

1. Flexible working arrangements - 100% remote, hybrid, and in office options
2. Competitive total compensation, including company contributions to your group RRSP without a matching requirement from you
3. Comprehensive health benefits that start on your first day, with 100% employer-paid premiums, that include up to $5000 annually for mental health services and therapy
4. Parental leave top-up to 100% of your salary for a period of 25 weeks
5. Up to $650 for home office equipment
6. Generous time off policy, including 2 paid days annually to volunteer at a charity of your choice
7. Diversity and inclusion programs, including an active network of Employee Resource Groups
8. Extensive professional development opportunities, including access to over 11,000 training and development courses, tuition reimbursement, and monetary rewards for completing a required designation

Fidelity Canada is an equal opportunity employer

Fidelity Canada is committed to fostering a diverse and inclusive workplace. We will consider all qualified applicants for employment regardless of race, color, religion, sex, sexual orientation, gender identity or expression, national or ethnic origin, age, disability, family status, protected veterans’ status, Aboriginal/Native American status or any other legally-protected ground.

Accommodation during the application process

Fidelity Canada welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in the selection process. If you require an accommodation, please email us at FidelityCanadaStaffing@fidelity.ca.

No telephone inquiries or agencies please. We thank all applicants for their interest, please be advised that only those selected for an interview will be contacted.