Data Analyst

Software Guidance & Assistance, Inc., (SGA), is searching for a Data Analyst for a CONTRACT ssignment with one of our premier Regulatory clients. This is a hybrid position at ny of the client's office sites.


We are looking for a professional with strong problem solving and data analytics talent and experience. As a Data Analyst, you will leverage analytic and technical skills to design, build, and maintain well-managed data solutions and capabilities which address business problems and help regulatory staff make better informed decisions. This role will also develop scalable analytics solutions and web applications using Dataiku, build business intelligence solutions using tools including Amazon QuickSight and Microsoft Power BI, and enable team adoption through clear documentation, knowledge sharing, and hands-on training.


Our mission is to provide operational insights and metrics that inform leadership decisions, identify program trends, and surface emerging risks - all in service of amplifying the firm's ability to protect investors, uphold market integrity and manage risk.



Responsibilities :

• Designing and developing interactive dashboards, reporting solutions, and decision-support tools that transform complex business and membership data into actionable insights, utilizing technologies including Microsoft Power BI, Amazon QuickSight, and VBA.
• Executing analytics projects including non-analytical tasks, such as data sourcing, documentation etc.
• Creating user documentation and delivering hands-on training, demonstrations, and knowledge-transfer sessions so team members can effectively use and support the developed solutions
• Designing, developing, testing, and maintaining Dataiku workflows, reusable analytics components, and web applications that support business and regulatory needs
• ccessing and compiling large volumes of custom and syndicated data from disparate sources into concise and precise information
• Developing process maps for complex business functions and documenting business requirements to support project needs
• Developing end-to-end workflow automation solutions using Microsoft Power Automate, integrating data sources, applications, and business processes to increase efficiency, improve data quality, and reduce operational risk
• Leveraging existing data using analytical tools and languages (SQL, R, Python, SAS, or SPSS) to perform data manipulation and analysis
• Designing and developing data-driven analysis using statistical & advanced analytics methodologies to solve business problems
• Collaborating closely with colleagues to develop proofs of concept that can be converted into production-level applications
• Presenting prototypes and learnings to stakeholders at all levels across the organization
• Leveraging experience to ensure consistent data quality
• Performing research to gain context and meaning of uncultivated data sets
• Supporting the importance of repeatable data processes, data integrity and cleanliness, and strategic use of dat

Required Skills :

• Bachelor's degree in Finance, Mathematics, Operations Research, Computer Science, or equivalent/related degree required. Master's degree is preferred.
• Basic business process mapping and requirements gathering/documentation skills
• Banking or Broker-Dealer product knowledge i.e., capital markets/ core banking offerings is a plus
• 3+ years' experience writing complex SQL queries working with relational databases
• Visualization and business analytic tools such as PowerBI, Tableau, Cognos Analytics, VBA, etc.
• Hands-on experience with the Dataiku data science platform, including development of data workflows, reusable analytical solutions, and Dataiku web applications
• Hands-on experience with Amazon QuickSight to design and develop dashboards, visual analytics, and business intelligence solutions
• Demonstrated ability to document technical solutions and train team members with varying levels of technical expertise on Dataiku, Amazon QuickSight, and related analytics tools
• Experience developing and supporting user-friendly web applications or analytical interfaces that translate business requirements into scalable solutions
• bility to work as an individual contributor and collaborator in a fast-paced proof of concept development environment
• Excellent communication skills; ability to explain technical concepts to a variety of audiences
• Experience working with analysts in a research/modeling environment that leverages tools such as R and/or Python

By applying for a job with SGA, you agree to allow SGA to process your application for this and future opportunities in accordance with our Privacy Policy. Also, to ensure timely processing, you agree to be contacted by our AI recruiter via email, text, or phone. Message frequency varies and data rates may apply, but you can reply STOP to any SMS message to opt-out of texts and may contact SGA at View email address on click.appcast.io to opt-out of AI communications. The choice not to engage with AI will not adversely impact your consideration for placement. AI is not used to make any hiring determinations.


SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .


SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.