Full-Stack Developer

Madison, WI (United States)

Category: Programming

Posted on: 19 Nov 2020

sql github powerbi tableau-api oracle

Making a Difference
SWIB is a trusted and skilled global investment organization managing the assets of the Wisconsin Retirement System (WRS) and other separately managed funds. With almost $129 billion in total assets under management, SWIB has been recognized by the investment industry for its teamwork and innovation that helps make it a premier asset manager. Sophisticated investment management strategies, forward-looking technologies, and strong internal asset management make SWIB a leading investment organization.
For public employees in Wisconsin, SWIB is a unique and valuable partner. Investing for the financial security of more than 642,000 individuals – and for the 1,500 Wisconsin employers who contribute on behalf of their employees – SWIB’s strong management of the WRS has helped fuel one of only a few fully funded public pension funds in the country. SWIB’s long-term investment returns meet the challenges of a constantly evolving investment landscape while helping grow and protect the assets of the WRS, the 9th largest public pension fund in the U.S. and 25th largest public or private pension fund in the world. 
We are a mission-driven organization and the participants we serve are our mission. By bringing a disciplined, prudent and innovative approach to market opportunities, SWIB has been successful in generating respectable returns and maintaining the trust of the beneficiaries and stakeholders of the funds we oversee.

Home to Top Talent
SWIB has long been recognized as an investment leader because of its success in maintaining the WRS and because of the highly qualified staff overseeing the retirement trust funds. SWIB’s internal team invests a majority of its assets under management. This means SWIB is committed to investing in professionals that will keep the organization at the forefront of the investment industry. As an innovative organization, SWIB offers professional development opportunities that enable staff to grow and develop. Approximately 61 percent of SWIB’s investment professionals are Chartered Financial Analyst (CFA) charterholders. 

About the Team
Partner and collaborate across department, function, and/or asset class to drive architecture, design, and development. Own various aspects of governance, development life cycle standards, versioning/controls, and enterprise architecture. As part of the technology, the department finds new solutions to existing problems, or for new challenges. The group will be responsible for code reviews, reviewing architecture solutions and recommending them. Partner with other technology teams.
This role offers a unique opportunity to learn and contribute to the technology and the business through technology.

Position Overview
Essential activities:

    Deliver on requirements gathering, analysis, and full development cycle
    Deliver on taking manual processes and fully automating
    Troubleshoot, and diagnose application, data issues
    Support tactical and strategic development projects
    Implement designs, give feedback on designs from various implementations
    Work on projects related to automation, reducing risk for the business and technology partners through governance implementations
    Support various development efforts

Technical skills:

    Architecture, design
    Developing applications
    SQL/Query writing
    Snowflake (or some equivalent datastore tool)
    SQL Server, Oracle, or equivalent experience
    Development SLDC/programming experience
    JIRA and Confluence
    PowerBI, Tableau

Data skills:

    Datastore design and SQL development
    Data modeling
    Data Analysis
    ETL (Extract Transform load) exposure
    Python experience

Financial knowledge recommended but candidates in other industries highly recommended to apply:

    Understanding of multi-asset products is desirable
    Comprehensions of risk, return, and cost metrics in the industry is desirable
    Exposure to the investment management life cycle is desirable

The ideal candidate:

    5-10 years’ experience in architecture, development, analytics, or related fields
    Bachelor's degree or advanced degree in computer science, finance, quantitative finance, or another related field
    Ability to take various questions gathered from the business leveraging existing data as well as improving upon that data to deliver complete, consistent, and precise answers
    Experience in working with/understanding the various life cycles of data management, extraction, loading, transformation to its applications in analysis, research, and solving problems
    Extensive knowledge in composing Oracle SQL, SQL Server queries, data modeling, and having a SQL and analytics background
    Experience in identifying use cases for the business, contributing to analysis and understanding of existing data models with iterative recommendations on improvement resulting in some improvement in risk, return or cost for the organization
    Extensive knowledge of data extraction, transformation, and loading
    Experience refactoring SQL queries, use of Python
    Experience designing architecture and implementation
    Experience working with large structured and financial data sets
    Ability to follow rigor in creating/updating documentation, maintain a process (i.e. JIRA tickets), and following technology and business best practices
    Ability to present and communicate well and connect business and technology
    Ability to tactically understand results in context (i.e. when does something look wrong), and strategically how to resolve those issues via data quality and rule-based instrumentation
    Interest in newer data technologies, Snowflake programming, i.e. Python
    Interest or experience in investment management, quantitative finance, and technology
    Background in Agile methodologies and their applications

SWIB Offers:

    Competitive McLagan-base salary
    Meaningful performance-based incentive compensation
    A comprehensive benefit package
    Educational and training opportunities
    Tuition reimbursement
    Challenging work in a professional environment

The position requires U.S. work authorization and residency in, or willingness to relocate to the Madison, Wisconsin area. SWIB is prepared to offer relocation assistance as needed. 

Want more jobs like this?

Apply Now

By clicking "Apply Now" or "Subscribe and Apply" you will be redirected to an external website. By clicking "Subscribe & Apply" you give TechieJobs consent to process and store your data, and send you job alerts to provided email.

Job Source: Stackoverflow (Will expire by: 2021-01-03 00:00:00)

Apply Now

Quick poll
Does your employer allow you to work from home?
  • Yes
  • Yes, but not every day
  • No

* This poll is anonymous.