The Williston Financial Group, Llc Data Analyst interview guide, interview questions, salary data, and interview experiences.

Williston Financial Group, Llc Data Analyst Interview Guide

Getting ready for an Data Analyst interview at Williston Financial Group, Llc? The Williston Financial Group, Llc Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Williston Financial Group, Llc Data Analyst roles.</li>
<li>Gain insights into the Data Analyst interview process at Williston Financial Group, Llc.</li>
<li>Practice real Williston Financial Group, Llc Data Analyst interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Williston Financial Group, Llc Data Analyst interview.


Getting ready for an Data Analyst interview at Williston Financial Group, Llc? The Williston Financial Group, Llc Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Williston Financial Group, Llc Data Analyst roles.
- Gain insights into the Data Analyst interview process at Williston Financial Group, Llc.
- Practice real Williston Financial Group, Llc Data Analyst interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Williston Financial Group, Llc Data Analyst interview.
        

Overview

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Williston Financial Group, Llc Data Analyst Interview Process

Let’s say your team at Spotify wants to determine if a recently launched feature, curated playlists, has increased user engagement. However Spotify launched the feature without an A/B test.

How would you measure the effect of curated playlists on user engagement?

How would you establish causal inference to measure the effect of curated playlists on engagement without A/B?

Causal Inference Without A/B

As part of the financial management in a large corporation, the CFO wants to review the expenses in all departments for the previous financial year (2022).

Write a SQL query to calculate the total expenditure for each department in 2022. Additionally, for comparison purposes, return the average expense across all departments in 2022.

Note: The output should include the department name, the total expense, and the average expense (rounded to 2 decimal places). The data should be sorted in descending order by total expenditure.

<h3>Example:</h3>

Input:

<code>departments</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<code>expenses</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>department_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>amount</td>
<td>FLOAT</td>
</tr>

<tr>
<td>date</td>
<td>DATE</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>department_name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>total_expense</td>
<td>FLOAT</td>
</tr>

<tr>
<td>average_expense</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Calculate total and average expenses for each department.

Department Expenses

The probability that it will rain tomorrow is dependent on whether or not it is raining today and whether or not it rained yesterday.

If it rained yesterday and today, there is a 20% chance it will rain tomorrow. If it rained one of the days, there is a 60% chance it will rain tomorrow. If it rained neither today nor yesterday, there is a 20% chance it will rain tomorrow.

Given that it is raining today and that it rained yesterday, write a function <code>rain_days</code> to calculate the probability that it will rain on the nth day after today.

Example:

Input:

<pre tabindex="0" class="chroma"><code>n=5
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def rain_days(n) -&gt; 0.39968
</code></pre>

Given that it is raining today and that it rained yesterday, write a function to calculate the probability that it will rain on the nth day after today.

Rain in N Days

Williston Financial Group, Llc Data Analyst Interview Questions

About the JobAs a Senior Data Analyst, you will elevate your career by leveraging your skillsets in conjunction with learning the intricacies of the talent solutions Industry. With our Immersion course and your existing skillsets, you will be exposed to each aspect of our business and begin to understand how we collect, utilize, and display data. You will begin to develop insight and create tools based on the assed business needs. Daily ResponsibilitiesYour primary responsibilities as a Senior Data Analyst will be to develop, deliver, and lead projects necessary to address critical and immediate business issues. As a Senior Data Analyst, you will be expected to partner with our group’s Lead Analysts and Insight Global’s Executive team to understand immediate business issues, gather the necessary requirements, and develop adoptable solutions. In addition, you will more frequently leverage your technical background to implement new processes and educate other members of the team. These experiences will help grow your working knowledge of the talent solutions Industry. Project work will consist of executive-backed initiatives, reporting on company performance, and developing tools for field use. QualificationsHard-Skills:<ul><li>Bachelor’s Degree in Data Analytics, Data Science, other business-related fields</li><li>3+ Year(s) Of experience with dashboard development and integration</li><li>3+ Year(s) Experience working with disparate data sources</li><li>3+ Year(s) Tableau, SQL, Excel experience</li></ul> Soft-Skills:<ul><li>Willingness to learn and get outside of your comfort zone</li><li>Ability to talk in front of large groups and executive management</li><li>Solution driven thought processes and analytical mindset</li></ul> External Preference:<ul><li>Has experience with Tableau, SQL, PowerBI, and ETL</li><li>Has experience working with disparate data sources</li><li>Ability to adapt previous practices to work with antiquated data</li></ul>

Role: Digital Data Analyst-Sr. Work Location: Atlanta, GA (Hybrid) Top 5 Must Haves: <ul><li>Exp with Tealium</li><li>Extensive experience with Adobe Analytics</li><li>Deep understanding of purchase funnels and buy flows</li><li>Exp with Tableau or other data visualization tools</li><li>Understanding of tagging, segmentations, modals, and event management</li></ul> Overview: Seeking an experienced Digital Analyst to join our Digital team,focusing on optimizing and measuring our online and digital channels. This role requires a deep understanding of Adobe Analytics and Tealium Tag Management, with experience using Tableau to communicate actionable insights to business stakeholders. The ideal candidate has a strong analytical background, a passion for data-driven decision-making, and the technical skills to deploy, configure, and monitor digital tags and analytics tools. Responsibilities: <ol><li>Data Collection & Tag Management:</li></ol><ul><li>Oversee implementation, configuration, and management of tags and tracking through Tealium.</li><li>Ensure all digital properties are accurately tracked, monitored, and measured.</li><li>Collaborate with development, UX, and marketing teams to design and implement tracking solutions that support business objectives.</li></ul> Digital Analytics:<ul><li>Utilize Adobe Analytics to monitor website traffic, user behaviors, conversion rates, and other key performance metrics.</li><li>Create reports, dashboards, and ad-hoc analyses to track performance, identify trends, and inform strategies.</li><li>Support A/B testing and personalization initiatives by providing detailed analysis and insights.</li></ul> Data Visualization & Reporting:<ul><li>Design and maintain Tableau dashboards to deliver insights and track KPIs for digital properties.</li><li>Present complex data in a visually engaging way to help non-technical stakeholders understand key findings.</li><li>Work closely with cross-functional teams to translate insights into recommendations for optimization.</li></ul> Optimization & Insights:<ul><li>Perform deep-dive analyses on customer journeys, funnel performance, and engagement patterns to uncover opportunities for conversion optimization.</li><li>Provide actionable insights to improve user experience, increase conversion rates, and drive strategic initiatives.</li><li>Stay up-to-date with the latest industry trends and tools in digital analytics, tag management, and visualization.</li></ul> Qualifications: <ul><li>Bachelor’s degree in Business, Marketing, Analytics, Information Systems, or a related field.</li><li>5+ years of experience in digital analytics, preferably with extensive Adobe Analytics expertise.</li><li>Hands-on experience with Tealium or similar tag management systems.</li><li>Proficiency in Tableau or a similar data visualization tool; ability to design dashboards that tell a story and drive action.</li><li>Strong analytical and problem-solving skills with attention to detail.</li><li>Ability to translate business objectives into actionable data and analytical strategies.</li><li>Excellent communication skills with the ability to convey insights to technical and non-technical audiences.</li></ul> Preferred Qualifications: <ul><li>Knowledge of JavaScript, HTML, CSS, or other web development technologies.</li><li>Familiarity with A/B testing tools and methodologies.</li><li>Certification in Adobe Analytics, Tealium, or Tableau is a plus.</li></ul> Thank You

Job Title: Data Analyst/Medeler - W2 only - We can provide sponsorship Duration: Long Term Location: Westlake, TX - Hybrid - Local Must Have:Solid SQL for data gathering and analysis is a must,SnowflakeOracleAWSModeling tool, either (PowerDesigner or Erwin) Key Responsibilities:1. Strategic Discovery & Alignment<ul><li>Collaborate with stakeholders to understand business objectives and data needs.</li><li>Identify data-related pain points and map data requirements to business goals.</li><li>Assist in documenting key data domains and creating high-level entity relationship diagrams (ERDs).</li></ul>2. Governance & Quality Foundation<ul><li>Support the definition of data ownership, stewardship roles, and governance policies.</li><li>Contribute to the development and monitoring of data quality KPIs.</li><li>Assist in evaluating and improving metadata tools and documentation standards.</li></ul>3. Security, Tools & Usage<ul><li>Help classify and secure sensitive data in compliance with regulations (e.g., GDPR, SEC).</li><li>Analyze current data tools and support the standardization of modeling and reporting toolkits.</li><li>Track data usage patterns and support analytics initiatives through dashboards and reports.</li></ul>4. Scalability & Execution<ul><li>Support change management processes for data model updates.</li><li>Contribute to the development of a scalable and actionable data strategy roadmap.</li><li>Assist in prioritizing initiatives and tracking progress toward short- and long-term goals.</li></ul>Additional Responsibilities:<ul><li>Maintain a centralized inventory of data models and ensure integration of KPIs and analytics.</li><li>Support technical governance processes, including version control and CI/CD for data models.</li><li>Collaborate with consultants and internal teams to implement tools and build capabilities.</li></ul>Qualifications:<ul><li>Bachelor’s degree in Data Science, Information Systems, Business Analytics, or related field.</li><li>2+ years of experience in data analysis, data governance, or data modeling.</li><li>Proficiency in tools such as Power BI, Snowflake, Alation, or similar.</li><li>Strong understanding of data quality metrics, metadata management, and regulatory compliance.</li><li>Excellent communication and collaboration skills.</li></ul>

<div><h3>Overview</h3><div>Position Summary: Are you excited to analyze large datasets and help business owners make data driven decisions? Are you excited to design and develop automated reports using industry leading tools like Power BI? At New American Funding we know the importance of utilizing quantitate insights and actionable reports to drive our business; and we are looking for a highly talented Business Data Analyst to join our BI and Analytics team and help us become a more data driven company.Location: Remote/ Hybrid two days a week if you reside within 30 miles of Tustin, CA or Austin, TXStarting Salary $90k and can go up d.o.e.</div><h3>Responsibilities</h3><div>Duties and Responsibilities:<ul><li>Own the design, development, and maintenance of ongoing metrics, reports, dashboards and analysis to drive business growth through product improvements.</li><li>Work with Product Managers and Product Owners to establish KPIs specific to the digital products that measure against the opportunity for further improvement.</li><li>Extensive experience in building Power BI Dashboards using Complex DAX Functions / merging multiple data sets/data sources.</li><li>Strong SQL skills in analyzing, implementing/writing complex SQL scripts for designing critical data sets, trace data quality issues and should be proficient in data cleansing.</li><li>Strong analytical and problem-solving skills, and attention to details</li><li>Possess the ability to identify, analyze and resolve problems logically and systematically.</li><li>Strong verbal and written communication skills; ability to present complex information in an easy-to-understand manner with clear recommendations based on data insight.</li><li>Can function collaboratively as part of a fast-paced, customer-oriented team, perform effectively and demonstrate willingness to support the team on all levels to get the job done.</li><li>Ability to deal with ambiguity and competing objectives in a fast-paced environment.</li><li>Other duties may be assigned.</li></ul></div><h3>Qualifications</h3><div> Digital Product Analysis experience highly desired Bachelors degree in business, Statistics, Computer Science, Mathematics or a related field preferred. Experience with Marketing tools such as Google Analytics highly desired. Experience with understanding user session information, bounce rates, funnel conversion desired. Experience working with Power BI. 3+ years of experience as a Business Data Analyst, Data Engineer or equivalent. Relevant experience as a business analyst, data analyst or related role is a plus. Working knowledge of SQL and creating complex queries. Experience with Snowflake. Distributed Retail Mortgage experience highly desired. Other Duties: This job may require frequent sitting or standing for long periods of time. This job profile is not intended to be an all-inclusive list of job duties and responsibilities, as one may perform additional related duties as assigned in order to meet the needs of the organization. Work Authorization: Must be able to verify identity and employment eligibility to work in the U.S. [EOE/M/F/D/V. Drug-free workplace.] Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Must be able to lift up to ten pounds. Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull light to moderate amounts of weight; to operate office equipment requiring repetitive hand movement and fine coordination including use of a keyboard; and to verbally communicate to exchange information. VISION: See in the normal visual range with or without correction. HEARING: Hear in the normal audio range with or without correction. #LI-REMOTE#LI-KH1</div></div> #J-18808-Ljbffr

About GoodLeap: GoodLeap is a technology company delivering best-in-class financing and software products for sustainable solutions, from solar panels and batteries to energy-efficient HVAC, heat pumps, roofing, windows, and more. Over 1 million homeowners have benefited from our simple, fast, and frictionless technology that makes the adoption of these products more affordable, accessible, and easier to understand. Thousands of professionals deploying home efficiency and solar solutions rely on GoodLeap's proprietary, AI-powered applications and developer tools to drive more transparent customer communication, deeper business intelligence, and streamlined payment and operations. Our platform has led to more than $27 billion in financing for sustainable solutions since 2018. GoodLeap is also proud to support our award-winning nonprofit, GivePower, which is building and deploying life-saving water and clean electricity systems, changing the lives of more than 1.6 million people across Africa, Asia, and South America. The Senior Business Data Analyst role will play a key part in shaping the company's growth by supporting the B2B side of the business dealing with home efficiency, solar loans and third-party ownership consumer finance products. Essential Job Duties and Responsibilities: <ul><ul><li>Performance and Risk Tracking: Identify and track strategic org KPIs that will showcase organization health data such as program and risk metrics, consolidated into a single, automated source of truth to measure organizational success and drive alignment between the product, technology, and business functions. </li><li>Data Reporting and Management: Increase data maturity capability across the organization by building durable and scalable dashboard solutions to ensure data driven, quick decisions can happen at all levels of the organization. Support building clean data pipelines and one source of truth solutions. Become a subject matter expert in all things data, operations intelligence, and financial insights. </li><li>Complex Problem Solving: Structure and solve problems with analytic skills (e.g., investigation, modeling, mapping, and gap analysis) and techniques (e.g., trend analysis, forecasting, and experimental design). </li><li>Presentations, Reporting & Recommendations: Prepare high quality presentations and reports for senior executives and board members, providing actionable recommendations on pricing, profitability and new potential product lines. </li></ul></ul> Required Skills, Knowledge and Abilities: <ul><ul><li>Bachelor's degree in finance, economics, business, mathematics or a related field (MBA, CFA or CPA is a plus). </li><li>4-6 years of experience in data analysis, finance, consulting or a similar role. SaaS experience a plus but not required. Experience in the solar or home improvement industry a plus. </li><li>High proficiency in SQL, proficient in Python, capable with BI tools (i.e. PowerBI, Tableau). Some experience in building ETL solutions a plus. </li><li>Strong analytical skills with the ability to work with large datasets and draw meaningful insights. </li><li>Advanced proficiency in Microsoft Excel (financial modeling) and PowerPoint. </li><li>Ability to synthesize complex information into clear, concise recommendations. </li><li>Excellent written and verbal communication skills. </li><li>Strong problem-solving skills with a proactive approach to challenges. </li></ul></ul> Compensation: $120k-$140k Additional Information Regarding Job Duties and Job Descriptions: Job duties include additional responsibilities as assigned by one's supervisor or other managers related to the position/department. This job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and other skills required for the position. The Company reserves the right at any time with or without notice to alter or change job responsibilities, reassign or transfer job position or assign additional job responsibilities, subject to applicable law. The Company shall provide reasonable accommodations of known disabilities to enable a qualified applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law. If you are an extraordinary professional who thrives in a collaborative work culture and values a rewarding career, then we want to work with you! Apply today!

GENERAL SUMMARY The Senior Business Data Analyst reports directly to the Director of Planning & Analysis. In addition to the activities of the Business Data Analyst, this role provides supervisory and training support to Business Data Analysts and direct support to business development efforts, budgeting, reporting, and analysis. The Senior Business Data Analyst is responsible for performing advanced analytics using strong math, statistics, programming, data mining, and problem-solving skills to optimize and develop business opportunities and assist with executive business recommendations. FOUR DIAMOND SERVICE AGREEMENT All Team Members will display a Four Diamond commitment to Guest Service through the delivery and maintenance of the Quality Standards established by Pechanga Resort Casino (PRC). KEY RESPONSIBILITIES<ol><li>Supervise and support Business Data Analysts in the completion of reports, budgeting, and analytics projects.</li><li>Perform independent analytical research to identify and resolve complex data and validate results.</li><li>Assist in the creation and review of company budgets, providing information and assisting management in budget preparation, implementation, and control.</li><li>Apply critical thinking skills and perform advanced analytics to solve complex and multi-faceted business problems.</li><li>Perform advanced quantitative and statistical analysis of large datasets to identify trends, patterns, and correlations that can improve business performance.</li><li>Collect and organize data using complex database queries, software systems, and business intelligence tools.</li><li>Develop presentations to summarize and communicate key messages to senior management.</li><li>Collaborate with others in the organization to develop new ideas and brainstorm potential solutions.</li><li>Perform special projects and ad hoc analysis in support of business development opportunities.</li><li>Provide strategic analysis and support to the company budget.</li><li>Prepare complex concept models for events, promotions, and property changes.</li><li>Analyze financial information to determine profitability and provide recommendations as appropriate.</li><li>Support the business in various projects, cost reduction initiatives, and analytics.</li><li>Other duties as assigned.</li></ol> ACCOUNTABILITY: This position has supervisory responsibilities that include support and mentoring. The Team Member is responsible for protecting the assets of PRC. QUALIFICATIONS AND GUIDELINES EXPERIENCE/TRAINING/EDUCATION: Bachelors degree with an emphasis in Mathematics, Economics, Statistics, Finance, Engineering, Computer Science, Business Analytics, or related analytical field of study preferred. Accounting acceptable with statistics experience/knowledge. At least 5 to 8 years of experience in analysis and business analytics is preferred. Proven ability to develop predictive data models using statistical and mathematical methods. Ability to understand financial statements. Knowledge of the current and relevant gaming industry is preferred. COMMUNICATION SKILLS: Solid communication skills both verbal and written. Ability to communicate and present complex mathematical information/analytics in business language for management. Ability to work both independently and collaboratively. Capable of communicating complex technical information to a non-technical audience. Ability to train, provide direction, support, and direct Business Data Analysts. MATHEMATICAL SKILLS: Solid foundation and/or education in mathematics, statistics, probability, or engineering preferred. Ability to work with advanced mathematical concepts and apply them to practical situations. REASONING ABILITY: Outstanding critical thinking and problem-solving skills. Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables. CERTIFICATES, LICENSES, & REGISTRATIONS: Must qualify to obtain and maintain a class A gaming license. SKILLS/ABILITIES: Advanced knowledge of Excel including pivot tables, lookups, charts, graphs, and advanced formula writing. Advanced knowledge of MS Access and/or MS SQL preferred. Experience with Infor/FSM, XLCubed, Bally CMS (CMP, SDS, Table View, Bally BI), and Business Intelligence software preferred. Strong cognitive skills including analysis, problem solving, and attention to detail. Ability to merge data from separate sources and systems for analysis and recommendations. Ability to work with mathematical concepts such as probability and statistics. Ability to define problems, collect relevant data, establish facts, and draw valid conclusions. Ability to work cooperatively and collaboratively with all departments and management levels. Ability to investigate and learn new technologies and products. Passion for continuous learning and professional development. Ability to effectively supervise and train. Must be outgoing, energetic, and capable of interacting with the general public in a highly professional manner. Must possess great integrity, be a team player, and a supportive and effective listener who seeks to motivate, coach, and mentor the team. Ability to work in a stressful environment. Must be flexible and willing to work nights, weekends, and holidays. Must be a self-starter who is highly motivated and resourceful. Must be able to work with a positive attitude in a fast-paced and culturally diverse casino environment. Must have a pleasant personality and present a professional image when assisting players. Must be able to take direction and follow through with assigned tasks. Must possess excellent phone guest service skills. DISCLAIMER: The above information on this description has been designed to indicate the general nature and level of work performed by Team Members within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of Team Members assigned to this job. #J-18808-Ljbffr

Come join the Fintech Technical Strategy and Planning team as a Senior Staff Business Data Analyst. This role involves working with and supporting management and leadership teams across partner organizations, requiring strategic thinking, exceptional technical acumen, and data analytics skills. The successful candidate will demonstrate excellent leadership and business acumen, attention to detail, the ability to drive process improvements, strong collaboration skills, and comfort operating in a fast-paced environment.<h3>Responsibilities</h3><ol><li>Identify and Track Strategic KPIs: Monitor organization health data such as engineering excellence, people, and program metrics. Consolidate these into a single, automated source of truth to measure success and align product, technology, and business functions.</li><li>Continuous Improvement: Regularly assess and enhance workflows and processes to improve efficiency, speed, and adaptability in delivering key programs and initiatives.</li><li>Increase Data Maturity: Build scalable dashboards and support data pipelines to enable quick, data-driven decisions across the organization.</li><li>Scale and Operationalize Strategic Initiatives: Translate strategic objectives into tools that visualize data and extract key insights for stakeholders.</li><li>Operational Efficiency: Lead the rollout of processes and tools to improve operational efficiency by understanding customer problems and providing effective solutions.</li><li>Communication: Share insights and recommendations based on data and organizational strategy.</li><li>Standardization: Identify and lead the implementation of engineering best practices to improve ways of working.</li></ol><h3>Minimum Qualifications</h3><ul><li>Experience in driving operational efficiency in engineering organizations with strong analytics and visualization skills.</li><li>Expertise in building technical solutions for data visualization and KPI tracking.</li><li>Background in computer science or related degree is a plus.</li><li>Proven ability to build trust with stakeholders, motivate teams, set direction, resolve conflicts, and adapt to ambiguity.</li><li>Thrives in a culture of ownership, delivery, and innovation.</li><li>Ability to navigate both vertically and horizontally within a large organization.</li><li>Strong people, organizational, and technical skills to deliver outcomes.</li><li>Excellent communication skills, both written and verbal.</li><li>Effective at presenting, negotiating, and collaborating across organizational levels.</li><li>Comfortable handling a rapidly changing environment.</li><li>Professional team player with leadership and interpersonal skills.</li><li>Business analytics and data visualization experience is a plus.</li></ul> #J-18808-Ljbffr

Important Notes:<ul><li>Due to the nature of this opportunity, visa sponsorship or application through a 3rd party/employer will not be considered.</li></ul> Data Analyst (SQL/Data Warehousing)Optomi, in partnership with a leading telecommunications client, is seeking a detail-oriented and technically skilled Data Analyst to support its growing data analytics initiatives. This role is ideal for a data-savvy professional who enjoys turning complex datasets into actionable insights, supporting strategic decision-making across business units. What the right candidate will enjoy!<ul><li>The opportunity to support high-impact analytics in a large enterprise environment</li><li>Hybrid work arrangement with a collaborative and cross-functional data team</li><li>Engaging with varied data sources and advanced reporting tools</li></ul> Experience of the right candidate:<ul><li>Bachelor’s degree in Data Analytics, Information Systems, Statistics, Computer Science, or a related field</li><li>2–5 years of experience in a data analyst or similar data-focused role</li><li>Strong SQL skills and experience with relational databases (e.g., SQL Server, Oracle, MySQL, PostgreSQL)</li><li>Proficiency in tools such as Power BI, Tableau, or Excel for dashboards and reporting</li><li>Analytical mindset with the ability to interpret and present complex data sets</li><li>Excellent attention to detail, documentation, and communication abilities</li></ul> Preferred Experience:<ul><li>Background in ETL processes and scripting with Python or R</li><li>Experience working in large enterprise or telecommunications environments</li><li>Familiarity with data governance and compliance best practices</li></ul> Responsibilities of the right candidate:<ul><li>Collect, extract, and analyze structured and unstructured data from various sources, including databases, spreadsheets, and web data</li><li>Develop and maintain SQL queries, stored procedures, and automation scripts to support streamlined workflows</li><li>Create scheduled and ad hoc dashboards and reports to drive business operations</li><li>Validate and troubleshoot data accuracy, completeness, and quality across systems</li><li>Collaborate with business units to understand data needs and translate them into meaningful insights</li><li>Document data requirements, processes, and logic to ensure repeatability and transparency</li><li>Provide timely, data-driven responses to internal inquiries and ad hoc stakeholder requests</li><li>Support the ongoing evolution of data governance, security, and compliance initiatives</li></ul>

Software Guidance & Assistance, Inc., (SGA), is searching for a Sr. Business/Data Analyst for a direct placement assignment with one of our premier financial services clients in Tampa, FL or Irving, TX. Responsibilities : <ul> <li>Responsible for providing authoritative sources of securities indicative data to our clients across the organization, through implementing state of the art technologies and operational processes which promote the collection, storage, analysis, and distribution of product, pricing, account and corporate action data. </li> <li>Team is tasked with the enhancement to the system including integration of vendor feeds, data model enhancement and updates to existing data from vendors. This may involve analyzing multiple data sets manually or engineering automated solutions. </li> <li>The overall objective of this role is to understand business needs & conduct data analysis </li> <li>Financial Data Modeling Capabilities </li> <li>Data Analysis for complex system </li> <li>Reverse engineering functional specifications from data </li> <li>Work closely with End Users/Clients to understand Business Process/Industry Standards/Regulatory Mandate requirements. </li> <li>Work closely with IT and Operations partners </li> <li>Work with external data vendors (i.e., Bloomberg, Reuters, IDC, Markit, etc) and standards organizations </li> <li>Able to execute projects Independently </li> <li>Conduct Systems Integrated Testing (SIT) and User Acceptance Testing (UAT) </li> <li>Create Function Specification Documents (FSD), System Requirement Specification (SRS), and test plans </li> <li>Mentor and coaching lower level analysts </li></ul> Required Skills: <ul> <li>Working experience of [8] years min. as Business Analyst </li> <li>Strong background in financial reference data and capital markets </li> <li>Strong SQL knowledge required (able to query data, analyze and troubleshooting) </li> <li>Strong Data analysis and Mapping skill </li> <li>College degree, specialized training or equivalent work experience </li> <li>Data Oriented with an excellent attention to detail </li> <li>Experience/understanding of business process reengineering and business modeling concepts, systems development lifecycle </li> <li>Strong analytical skills and writing skills, to include solid experience in writing functional and technical specifications </li> <li>Must possess good communication skills with the ability to be assertive </li> <li>Ability to focus on high quality work while under pressure </li> <li>Experience utilizing various SDLC methodologies like Waterfall, Agile (JIRA etc.) </li> <li>Comprehensive knowledge of the Testing Lifecycle with SIT, UAT, and Production. </li></ul> Preferred Skills: <ul> <li>Experience working with major vendor data providers (i.e., Bloomberg, Reuters, IDC, Markit) </li> <li>Project lead experience </li> <li>Experience working closely with IT Project managers and development teams </li> <li>Knowledge of MS Excel, Visio </li> <li>Experience with vendor product implementation </li></ul> 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 https://sgainc.com/ . 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 #LI-JS1

**Business/Data Analyst****Category:** Business Analysis (functional and technical)**Main location:** United States, Virginia, Reston**Position ID:** J0625-0550**Employment Type:** Full Time**Position Description:**CGI has an immediate need for a ?Business/Data Analyst to join our team. This is an exciting opportunity to work in a fast-paced team environment supporting one of the largest leaders in the secondary mortgage industry. We take an innovative approach to supporting our client, working side-by-side in an agile environment using emerging technologies. This position is located at a client site in Reston, VA. A hybrid working model is acceptable. We partner with 15 of the top 20 banks globally, and our top 10 banking clients have worked with us for an average of 26 years! We have over 92,000+ CGI Members in 40 countries and over 5k+ loyal Clients who are leveraging our end-to-end services across the globe.**Your future duties and responsibilities:** Manage to strict deadlines as well as prioritize and perform tasks in a high-pressure environment. Multitasking, completing sprint goals and managing changing priorities. Diagnose and solve problems efficiently and effectively. Reporting for the purposes of system analysis, testing, and decision-making with the use of relevant software such as MSOffice and SQL.**Required qualifications to be successful in this role:** 5+ years' experience Excellent oral and written communication, including presentation skills. Skilled in documentation writing of business requirements, release notes, user guides. Skilled in the system analysis and software testing by leveraging SQL, JIRA, or other tools. Proficiency in the use of presentation tools and methods; skilled in presenting information and/or ideas to an audience in a way that is engaging and easy to understand. Proficiency in the use of analytic tools (Excel, Tableau) and strong analytical thinking. Working knowledge of Scrum and Agile Software Development Methodology. Ability to prioritize effectively and see the big picture". Knowledge of user-centered design principles. Ability to work with large teams and a variety of people, including users, product development team members and management team membersDesired Skillet:? System analysis and development skills in SalesforceEducation: Bachelors degree or equivalent on Computer Science, IT, Engineering with related experiences.CGI anticipates accepting applications for this position through JUNE 30, 2025.CGI is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. To support the ability to reward for merit-based performance, CGI typically does not hire individuals at or near the top of the range for their role. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $59,000.00 - $130,600.00.CGIs benefits are offered to eligible professionals on their first day of employment to include: Competitive compensation Comprehensive insurance options Matching contributions through the 401(k) plan and the share purchase plan Paid time off for vacation, holidays, and sick time Paid parental leave Learning opportunities and tuition assistance Wellness and Well-being programs#LI-JN2**Skills:**+ Analytical Thinking+ Business Analysis+ Data Analysis+ SQL**What you can expect from us:****Together, as owners, lets turn meaningful insights into action.**Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, youll reach your full potential becauseYou are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.Come join our teamone of the largest IT and business consulting services firms in the world.Qualified applicants will receive consideration for employment without regard to their race, ethnicity, ancestry, color, sex, religion, creed, age, national origin, citizenship status, disability, pregnancy, medical condition, military and veteran status, marital status, sexual orientation or perceived sexual orientation, gender, gender identity, and gender expression, familial status or responsibilities, reproductive health decisions, political affiliation, genetic information, height, weight, or any other legally protected status or characteristics to the extent required by applicable federal, state, and/or local laws where we do business.CGI provides reasonable accommodations to qualified individuals with disabilities. If you need an accommodation to apply for a job in the U.S., please email the CGI U.S. Employment Compliance mailbox at US_Employment_Compliance@cgi.com . You will need to reference the Position ID of the position in which you are interested. Your message will be routed to the appropriate recruiter who will assist you. **Please note, this email address is only to be used for those individuals who need an accommodation to apply for a job. Emails for any other reason or those that do not include a Position ID will not be returned.**We make it easy to translate military experience and skills! Clickhere (obs/) to be directed to our site that is dedicated to veterans and transitioning service members.All CGI offers of employment in the U.S. are contingent upon the ability to successfully complete a background investigation. Background investigation components can vary dependent upon specific assignment and/or level of US government security clearance held. Dependent upon role and/or federal government security clearance requirements, and in accordance with applicable laws, some background investigations may include a credit check. CGI will consider for employment qualified applicants with arrests and conviction records in accordance with all local regulations and ordinances.CGI will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with CGIs legal duty to furnish information.

Williston Financial Group, Llc Data Analyst Interview Guide

Overview

Williston Financial Group, Llc Data Analyst Interview Process

Williston Financial Group, Llc Data Analyst Interview Questions

Williston Financial Group, Llc Data Analyst Jobs