Senior Programmer Analyst –FINRA and CFTC regulations / Compliance Technology

Senior Programmer Analyst –FINRA and CFTC regulations / Compliance Technology (SG Americas Operational Services, LLC, Chicago, IL)

Perform Data architecture for public and private cloud compliance databases. Design solutions for new builds and identify potential issues and areas for improvement. Provide reporting and systematic solutions for FINRA and CFTC regulations. Use strong communication skills (written and verbal) to confer with other programmers to create the best solutions to complex technical problems. Automate reports with complex logic from internal and external data repositories. Create unix scripts for automated jobs and commands. Database queries and generate Compliance reports in public cloud technologies, using Azure. Develop monitoring capabilities for regulatory and surveillance reporting. Create data quality controls for critical Compliance Reports. Refactor complex Oracle, PostgreSQL, and MS SQL stored procedures. Create data feeds from data repositories to user interface. Perform Level 3 support for database incidents. Create front end user interface to maintain static data. Perform complex data analysis in the datalake. Document technical architecture flow. Telecommuting permitted up to two days per week. When not telecommuting must report to SG Americas Operational Services, LLC, 425 S. Financial Place, Chicago, IL. Salary: $147,472 - $250,000 per year.

MINIMUM REQUIREMENTS: Bachelors’ Degree or U.S. equivalent in Computer Engineering, Computer Science, or related field, plus 5 years of professional experience as a Programmer Analyst, Software Developer, or any occupation/position/job title involving database development in the financial services industry.

Must also have experience in the following: 5 years of professional experience developing database components in conjunction with object-oriented programming; 5 years of professional experience providing level 3 technical support in the event of a production issue with applications; 5 years of professional experience performing PySpark or UNIX Shell Scripting; 4 years of professional experience performing database development in Oracle, MS SQL, PostgreSQL, Azure, and AWS, automated processing using shell scripting, complex data analysis, and public cloud development; and 4 years of professional experience working with technical infrastructure for financial markets and Compliance related activities (including Capital Market Surveillance, Regulatory Reporting, and Regulatory Registration for FINRA and CFTC).

LINK TO EMPLOYEE REFERRAL PROGRAM:

Incentives offered through the firm's Employee Referral Program are applicable to this position.  For more information please visit our "Employee Referral Program" link in the Human Resources section of our intranet under the Talent Management tab at: http://entrenet.us.world.socgen/support_groups/human_resources/talent_management/employee_referral_program.html.

Societe Generale is committed to offering an inclusive recruitment experience to all candidates. If you require any reasonable accommodations during the recruitment process, please do not hesitate to let our Recruiters know.

OUR CULTURE: 
At Societe Generale, we live by our 4 core values of commitment, responsibility, team spirit and innovation. We are engaged and demonstrate consideration for others. We act ethically and with courage. We focus our talent and energy on collective success. We experiment and propose new ideas. This way, we maximize our ability to serve client needs and anticipate market changes. Societe Generale is committed to strengthening bonds with colleagues, communities, and the world in which we live, because relationships are at the heart of how we operate. For more information about our Culture and Conduct initiatives, please visit this link (https://americas.societegenerale.com/en/careers/get-know-culture/)

D&I: 
Our Diversity & Inclusion Mission: Recruit, develop, advance, and retain a diverse workforce that is united in our efforts to enhance our competitive position and deliver innovative solutions to our clients.
Our Diversity & Inclusion Vision:

• Engaged workforce that is demographically diverse in a way that reflects the communities in which we operate
• Inclusive culture and workplace that recognizes employees' unique needs and utilizes their diverse talents
• Engage our community and marketplace, and position the organization to meet the needs of all its clients

For more information about our D&I initiatives, please visit this link (https://americas.societegenerale.com/en/societe-generale-about/diversity-and-inclusion/)

HYBRID WORK ENVIRONMENT:
Societe Generale offers a hybrid work arrangement that offers employees the flexibility to work remotely, as well as on-site, in order to promote interaction and collaboration with colleagues while adhering to all SG standard protocols.  Hybrid work arrangements vary based on business area.  The applicable business lines will determine and communicate the work arrangements that best meet their business needs.

COMPENSATION:
Base salary range does not include overtime pay, bonus and/or other benefits, where applicable. Actual base salary offer will vary based on skills and experience. The role is eligible for an annual discretionary bonus and includes a competitive benefits package including 401(k) plan with company match, medical/dental/vision, and other benefits for fertility, wellness, student loans and commuters.