Job description
We are looking for a Senior Data Analyst - Team Lead to join our successful organization. Our company culture fosters and encourages innovation and growth by promoting openness, flexibility and an entrepreneurial spirit.
Are you ready to join one of the fastest growing broker-dealer networks in financial services? (Cerulli Associates, 2020) At Atria, we support independent financial professionals and financial institution investment programs so they, in turn, can provide exceptional service to their clients and develop meaningful relationships with them.
The Sr Data Analyst, Team Lead will be responsible for performing data analysis and support for requirements and testing on efforts to grow and optimize our advisor workstation. This includes maintenance of tables with processing systems used by internal and external sources, development and maintenance of reporting functionality, creation of regulatory and management reporting and analyzing data discrepancies. This position research and provide support for the data received from various sources (including support for transformation of data inputs to conform to our enterprise data model) along with testing and documenting production changes made within the systems.
The anticipated annual base salary range for this position is $90,000 to $160,000. Exact compensation may vary based on skills, experience, and location. May hire at lower or senior level for the right candidate.
Ideal Candidate
- Ability and experience in managing people and projects
- 5 years’ experience with SQL and PostgreSQL ETL, SDLC, Agile methodology
- 2+ years’ experience in the financial service industry, securities preferred
What you will do:
- Manage and maintain data tables to support various business functions.
- Work with developers to update our application database data model.
- Identify opportunities to make data available and find and correct discrepancies, deficiencies, and blind spots.
- Perform root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
- Manage and lead assigned projects and effectively communicate with the requestor and leadership team any project roadblocks that may jeopardize deadlines in advance of due dates.
- Work with Agile project teams of people with technical and non-technical backgrounds. Able to communicate requirements questions and technical issues to a non-technical audience.
- Manage, develop, and maintain reports for use by various departments.
- Ad-hoc SQL queries to support data analysis.
- Collaborates and maintains effective working relationships with management, internal departments, and external vendors.
- Provide testing support for all in-bound and out-bound files.
- Test and document system changes thoroughly. Support for QA and UAT of system changes
Must Haves:
- 2 or more years of prior experience in wealth management/securities industry
- In lieu of a bachelor's degree, 5+ years of experience with reporting and analytics with data analysis, extraction, and manipulation in a financial setting utilizing SQL.
- A very high level of proficiency in SQL, PostgreSQL and relational and multi-dimensional databases.
- Ability to analyze a company’s big-picture data needs.
- Solid experience in data sourcing, transformation and clean up, incl. use of data ETL (Extract, Transform, Lead) tools.
- Solid experience in Agile methodology
- Practical understanding and experience in Software Development Life Cycle (SDLC)
- Solid grasp of software engineering fundamentals and their practical application.
- Strong interpersonal skills, with a demonstrated ability to make effective decisions while working through complex issues.
- "Self-starter"" attitude and ability to make decisions independently.
- Comfortable working in a fast-paced and highly collaborative environment.
- Excellent verbal and written communication skills.
- Helpful, can-do attitude and a willingness to take ownership of problems.
- Strong desire to learn and grow.
- Flexible and adaptable in response to changing demands.
Preferred:
- Bachelor’s or master’s degree in Computer Science, Information Systems or related field or equivalent Experience
- Strong project leadership experience, including being a technical lead for multiple complex software development projects using agile methodologies.
- Scrum Master
- Comfortable using the Atlassian suite: Jira, Confluence.
Why work at Atria?
In addition to a competitive salary, we provide a full benefits package that includes:
- Medical insurance
- Dental insurance
- Prescription drug benefits
- Vision insurance
- Retirement savings 401(k) plan with matching
- Paid time off
- Paid holidays
- Critical illness insurance
- Veterinary pet insurance
- Employee assistance program
- Life insurance
- Short & long-term disability insurance
- Legal plan
At Atria, we consider Diversity, Inclusion, and Belonging to be essential to our success, and we are working to integrate it into the fabric of our organization. Our commitment to Diversity, Inclusion, and Belonging is key to our culture and values, and critical for great products, and satisfied customers.
Atria Wealth Solutions, Inc. (Atria) is a wealth management solutions holding company focused on delivering a clear path to the future of financial advice for financial professionals, financial institutions and their clients. Headquartered in New York City, Atria’s broker-dealer subsidiaries empower financial institutions and independent financial professionals with a sophisticated set of tools, services, and capabilities that deepen client relationships and maximize efficiencies in their practices.
Atria’s broker-dealer subsidiaries include CUSO Financial Services, L.P., Sorrento Pacific Financial, LLC, Cadaret Grant & Co., Inc., NEXT Financial Group, Inc., Western International Securities, Inc., and SCF Securities, Inc. Atria’s subsidiaries together support nearly 2,500 financial professionals and over 200 financial institutions with over $100 billion of assets under administration. For more information, please visit www.atriawealth.com.
Atria Wealth Solutions and its affiliated entities are equal opportunity employers that are committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.
This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. Atria Wealth Solutions and its affiliated entities make hiring decisions based solely on qualifications, merit, and business needs at the time.
It’s time for the next step in your career. Apply now.
LpFOZEdGBv
caravetterealestate.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, caravetterealestate.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, caravetterealestate.com is the ideal place to find your next job.