This role will be responsible for business-led development for the GCO, specifically leveraging our data lake and SQL environments for reporting and analytics. Additionally, this role will maintain and transition several access databases to longer term, more sustainable solutions. This role will develop and support business configuration of technology systems.
Key Responsibilities
> Develop, maintain and support ongoing reporting or queries where GCO data lake is the source.
> Actively explore and investigate data to build/enhance reporting and analytics
> Support ongoing maintenance and troubleshooting for existing Board Reporting tool using VB queries in Excel and work towards transition to Columbia Threadneedle data source.
> Support ADV filing process using SQL and SSIS/SSMS processing.
> Support Field Office Inspections Scheduling Tool
> Creation and ongoing development of MS Power BI reporting and data enablement for Investment Compliance team.
> Support GCO data lake enablement through development and use of data lake tools, such as AWS Athena, MS PBI, QuickSight, Dataiku.
> Troubleshoot/problem solve on data source/reporting issues; support data lake users on data
Required Qualifications
> Bachelor's degree from a reputed university with 5 - 8 years of relevant experience
> Strong experience and skills developing/working with data lakes and connecting tools (e.g., AWS Athena (queries and views), QuickSight, MS PBI
> Expert knowledge of MS Power Tools (SharePoint, SharePoint Designer, Power Automate/Apps/BI, SQL (SSIS, SSMS, SSRS)
> Strong experience with MS Excel and Access, programming languages: SQL (SQL Server), VBA, PowerShell, DAX, SAS (preferred)
> Robust understanding of data structure and relational databases; understanding of software development lifecycle
> Strong systems analysis skills, including data mapping, deconstructing code
> Strong Analytical skills, inter-personal and communication skills and ability to work on multiple priorities
Preferred Qualifications
> Knowledge of technology standards and controls
> Knowledge of developing Power BI reporting utilizing data sources other than SharePoint
> Knowledge of Data Lake environments
> Knowledge of at least one programming language - Python preferred
About Our Company
Ameriprise India LLP has been providing client based financial solutions to help clients plan and achieve their financial objectives for 125 years. We are a U.S. based financial planning company headquartered in Minneapolis with a global presence. The firm’s focus areas include Asset Management and Advice, Retirement Planning and Insurance Protection. Be part of an inclusive, collaborative culture that rewards you for your contributions and work with other talented individuals who share your passion for doing great work. You’ll also have plenty of opportunities to make your mark at the office and a difference in your community. So if you're talented, driven and want to work for a strong ethical company that cares, take the next step and create a career at Ameriprise India LLP.
Ameriprise India LLP is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, genetic information, age, sexual orientation, gender identity, disability, veteran status, marital status, family status or any other basis prohibited by law.
Full-Time/Part-Time
Full time
Timings
(4:45p-1:15a)
India Business Unit
AWMPO AWMP&S President's Office
Job Family Group
Technology
Top Skills
What We Do
For over 30 years, Freedom Mortgage has helped millions of Americans achieve their dreams of homeownership and financial betterment. The wellbeing and improvement of our customers' lives and the communities in which they live fuels our ambition. We’re driven by boundless stamina and an unwavering focus on continuous collaboration, relentlessly seeking the right solutions for every customer and loan every day.
Today, we service nearly 1.5 million customers with over $300 billion in mortgage loan assets, and we consistently rank as one of the nation's top 10 lenders. We are over 13,500 team members strong, recognized as a Top Workplace in the U.S., and are continuing on our unprecedented growth trajectory.
Freedom Mortgage is an Equal Opportunity Employer committed to workforce diversity. Qualified applicants will receive consideration without regard to age, race, color, religion, gender, sexual orientation, disability, or national origin. Local applicants are encouraged to apply. Employment contingent upon successful completion of a background investigation. Smoke-free workplace. Drug-free work environment. Excellent benefits package including medical, dental, vision, and 401(k). All resumes are held in confidence. Only candidates whose profiles closely match requirements will be contacted during this search.
Come #SoarWithUs and be a part of the Freedom family!
Freedom Mortgage Corporation
951 Yamato Road, Suite 175
Boca Raton, FL 33431
Lender NMLS ID: 2767
www.nmlsconsumeraccess.org
