Prepare for and practice interview questions from Shulman Fleming & Partners.

Shulman Fleming & Partners Interview Questions

Shulman Fleming & Partners Interview Guides

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Shulman Fleming & Partners Salaries by Position

<h3>Job Description</h3><div>Job Description<div>Senior Data ArchitectMUST be local to New York. Hybrid Schedule. At least 3 days onsite.Salary: up to $240k baseNo SponsorshipKey Responsibilities:<ul><li>Build and document reference architecture, including conceptual, logical, and physical models.</li><li>Communicate and mentor teams on architectural standards and best practices.</li><li>Support engineering teams in implementing architectural designs.</li></ul>Requirements:<ul><li>10+ years as a data architect.</li><li>Proficiency in data modeling and establishing data contracts between producers and consumers.</li><li>Experience designing modern, cloud-based data pipelines with strong data governance.</li><li>Knowledge of medallion and Lambda architectures (streaming/batch).</li><li>Strong discipline in documenting architecture (conceptual, logical, physical).</li><li>Expertise in microservices architecture.</li><li>Familiarity with data governance tools (Data Quality, Lineage, Cataloging, Profiling, and Observability).</li><li>Ability to design analytical layers for diverse business use cases, including AI.</li><li>Financial sector experience, preferably with derivatives, cash, finance, or banking products.</li><li>Familiar with Databricks, Snowflake, Kafka, MDM tools, and governance solutions.</li><li>Strong skills in data observability and Site Reliability Engineering (SRE).</li><li>Excellent written, verbal, and presentation skills.</li></ul>Bachelor's degree required</div></div>

Senior Data Architect MUST be local to New York. Hybrid Schedule. At least 3 days onsite. Salary: up to $240k base No Sponsorship Key Responsibilities: <ul><li>Build and document reference architecture, including conceptual, logical, and physical models.</li><li>Communicate and mentor teams on architectural standards and best practices.</li><li>Support engineering teams in implementing architectural designs.</li></ul> Requirements: <ul><li>10+ years as a data architect.</li><li>Proficiency in data modeling and establishing data contracts between producers and consumers.</li><li>Experience designing modern, cloud-based data pipelines with strong data governance.</li><li>Knowledge of medallion and Lambda architectures (streaming/batch).</li><li>Strong discipline in documenting architecture (conceptual, logical, physical).</li><li>Expertise in microservices architecture.</li><li>Familiarity with data governance tools (Data Quality, Lineage, Cataloging, Profiling, and Observability).</li><li>Ability to design analytical layers for diverse business use cases, including AI.</li><li>Financial sector experience, preferably with derivatives, cash, finance, or banking products.</li><li>Familiar with Databricks, Snowflake, Kafka, MDM tools, and governance solutions.</li><li>Strong skills in data observability and Site Reliability Engineering (SRE).</li><li>Excellent written, verbal, and presentation skills.</li></ul> Bachelor's degree required

Lead Business/Data Analyst with Banking or Financial Industry ExperienceMUST be local to New York City, Hybrid Schedule at least 3days onsiteSalary Range: $165k to $185kNo SponsorshipTo qualify you must have worked on a Data Warehouse built in Snowflake with data coming from multiple sources. You must have exceptional SQL and Snowflake skills, combined with excellent verbal communication skills. Experience with Loan IQ is a huge plus.You will be working on data requirements analysis, mapping, documentation, testing validation and support and must understand patterns of data as they apply to Banking products. Additionally, you will collaborate in Agile methodology, participate in daily scrum meetings, and assist in compiling necessary documentation for testing results.Business/Data Analyst Job Responsibilities<ul><li>Actively engage as SME on source system data attribution for alignment to data warehouse sourcing and analytic efforts</li><li>Develop, review, and validate requirements and specifications.</li><li>Conduct business/data analysis and research to validate new requirements and identify patterns and inconsistencies of data across sources and targets.</li><li>Use automated tools to extract data from primary and secondary sources</li><li>Filter Data by comparing results in sources and targets to identify and correct code problems</li><li>Use statistical tools to identify, analyze, and interpret patterns and trends in complex data sets that could be helpful for the diagnosis of exception requirements</li><li>Document meeting minutes</li><li>Take an active role in Agile scrum sessions for project execution, including task allocations, blocker remediation and general progress tracking</li><li>Report on common sources of technical issues or questions and make recommendations to development team</li><li>Mapping of source system data attributes to target destination, including transformation specifications as required to be used by developers for implementation</li></ul>Job Qualifications<ul><li>3– 5+ in Business or Data Analyst role in Banking or Finance industry</li><li>SME level familiarity with Investment Banking products or subject areas from a data level: Derivatives, Finance, Cash, Loans, Commitments; Regulatory Reporting</li><li>Excellent communication, collaboration, analytical, problem-solving, and organizational skills</li><li>Strong documentation and specification writing</li><li>Understanding of Database Design concepts – Dimensional modelling</li><li>Hands on technical skills supporting data analysis</li><li>Programming languages such as SQL,</li><li>Technical proficiency regarding database design development, and data models – especially Dimensional Data Models (e.g., Snowflake)</li><li>Proficiency in statistics and statistical packages like Excel, SPSS, SAS to be used for data set analysis.</li><li>Experience with Snowflake data warehouse environments (Snow SQL)</li><li>Data visualization and data analysis experience is a plus (Power Bi, Alteryx)</li><li>Experience with project management tools such as Jira, and Confluence</li><li>Experience in analyzing data to draw business-relevant conclusions.</li></ul>

<h3>Job Description</h3><div>Job Description<div>Lead Business/Data Analyst with Banking or Financial Industry ExperienceMUST be local to New York City, Hybrid Schedule at least 3days onsiteSalary Range: $165k to $185kNo SponsorshipTo qualify you must have worked on a Data Warehouse built in Snowflake with data coming from multiple sources. You must have exceptional SQL and Snowflake skills, combined with excellent verbal communication skills. Experience with Loan IQ is a huge plus.You will be working on data requirements analysis, mapping, documentation, testing validation and support and must understand patterns of data as they apply to Banking products. Additionally, you will collaborate in Agile methodology, participate in daily scrum meetings, and assist in compiling necessary documentation for testing results.Business/Data Analyst Job Responsibilities<ul><li>Actively engage as SME on source system data attribution for alignment to data warehouse sourcing and analytic efforts</li><li>Develop, review, and validate requirements and specifications.</li><li>Conduct business/data analysis and research to validate new requirements and identify patterns and inconsistencies of data across sources and targets.</li><li>Use automated tools to extract data from primary and secondary sources</li><li>Filter Data by comparing results in sources and targets to identify and correct code problems</li><li>Use statistical tools to identify, analyze, and interpret patterns and trends in complex data sets that could be helpful for the diagnosis of exception requirements</li><li>Document meeting minutes</li><li>Take an active role in Agile scrum sessions for project execution, including task allocations, blocker remediation and general progress tracking</li><li>Report on common sources of technical issues or questions and make recommendations to development team</li><li>Mapping of source system data attributes to target destination, including transformation specifications as required to be used by developers for implementation</li></ul>Job Qualifications<ul><li>3– 5+ in Business or Data Analyst role in Banking or Finance industry</li><li>SME level familiarity with Investment Banking products or subject areas from a data level: Derivatives, Finance, Cash, Loans, Commitments; Regulatory Reporting</li><li>Excellent communication, collaboration, analytical, problem-solving, and organizational skills</li><li>Strong documentation and specification writing</li><li>Understanding of Database Design concepts – Dimensional modelling</li><li>Hands on technical skills supporting data analysis</li><li>Programming languages such as SQL,</li><li>Technical proficiency regarding database design development, and data models – especially Dimensional Data Models (e.g., Snowflake)</li><li>Proficiency in statistics and statistical packages like Excel, SPSS, SAS to be used for data set analysis.</li><li>Experience with Snowflake data warehouse environments (Snow SQL) </li><li>Data visualization and data analysis experience is a plus (Power Bi, Alteryx)</li><li>Experience with project management tools such as Jira, and Confluence</li><li>Experience in analyzing data to draw business-relevant conclusions.</li></ul></div></div>

Contract Data Engineer MUST be local to Iselin, NJ, Hybrid Schedule, at least 3 days in office Responsibilities: <ul> <li>Hands on experience designing, modeling and developing Enterprise Data Warehouse solutions. </li><li>Hands on experience coordinating and executing SIT and UAT testing for Enterprise Data Warehouse solutions. </li><li>Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process </li><li>Leverage SQL, programming language (Python or similar) and/or ETL Tools (Azure Data Factory, Data Bricks, Talend, SSIS etc) to develop data pipeline solutions to ingest and exploit new and existing data sources. </li><li>Proficient on data analysis and complex problems resolution </li><li>A significant contribution to an enterprise-wide Cloud Data Platform migration. </li><li>Participate in the improvement of our DevOps initiatives </li></ul>Nice to Have: <ul> <li>Azure Cloud platform experience. </li><li>Azure Data Factory or similar ETL tool. </li><li>Azure Data Bricks experience. </li><li>Columnar Data Warehouse solution like Snowflake, RedShift, Vertica, Greenplum. </li><li>Any capital markets industry knowledge or experience. </li><li>Snowflake development experience </li><li>SQL Server development experience </li></ul>Qualifications: <ul> <li>The right candidate will be able to work independently in a fast-paced environment with minimal direction </li><li>As a key contributor, you will be expected to perform detailed analysis, develop and foster key operational relationships with stakeholders, and understand all facets of our technology planning, delivery and operational sustainment capability </li> <li>Understands and/or performs physical modeling and metadata analysis efforts </li><li>Provides database design guidance and work with DBAs in Enterprise Database Management group to troubleshoot problems and optimize performance </li><li>Provides support for ongoing data management efforts in Development, QA and Production environments </li><li>Experience designing, modeling and developing Enterprise Data Warehouse solutions. </li><li>Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process </li><li>Provides guidance and direction to less experienced staff in resolution of escalated issues and/or complex production, application or system problems </li><li>Develops new documentation </li><li>Assures quality, security and compliance requirements are met for supported area and oversees updating and testing of the business continuation plan </li><li>6+ years of experience in development of high-availability, high volume transactional processing systems </li><li>Proficiency in working with systems required to effectively process large volumes of both real-time and batch transactions </li><li>Perform activities in order to sustain enhancements and release activities for Snowflake platform </li><li>Complex data analysis across all Software inventories with emphasis on understanding the financial and operational risks in order to drive recommendations and change </li> </ul>Education: <ul><li>Minimally a BA degree within an engineering and/or computer science discipline </li> </ul>

Senior Data ArchitectMUST be local to New York. Hybrid Schedule. At least 3 days onsite.Salary: up to $240k baseNo SponsorshipKey Responsibilities:<ul><li>Build and document reference architecture, including conceptual, logical, and physical models.</li><li>Communicate and mentor teams on architectural standards and best practices.</li><li>Support engineering teams in implementing architectural designs.</li></ul>Requirements:<ul><li>10+ years as a data architect.</li><li>Proficiency in data modeling and establishing data contracts between producers and consumers.</li><li>Experience designing modern, cloud-based data pipelines with strong data governance.</li><li>Knowledge of medallion and Lambda architectures (streaming/batch).</li><li>Strong discipline in documenting architecture (conceptual, logical, physical).</li><li>Expertise in microservices architecture.</li><li>Familiarity with data governance tools (Data Quality, Lineage, Cataloging, Profiling, and Observability).</li><li>Ability to design analytical layers for diverse business use cases, including AI.</li><li>Financial sector experience, preferably with derivatives, cash, finance, or banking products.</li><li>Familiar with Databricks, Snowflake, Kafka, MDM tools, and governance solutions.</li><li>Strong skills in data observability and Site Reliability Engineering (SRE).</li><li>Excellent written, verbal, and presentation skills.</li></ul>Bachelor’s degree required

Shulman Fleming & Partners Interview Questions

Shulman Fleming & Partners Interview Guides

Shulman Fleming & Partners Interview Questions

Shulman Fleming & Partners Salaries by Position

Shulman Fleming & Partners Opening Jobs