Prepare for and practice interview questions from Ascendum Solutions.

Ascendum Solutions Interview Questions

Ascendum Solutions Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

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

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

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

Write a query to randomly sample a row from a big table.

Random SQL Sample

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

Ascendum Solutions Salaries by Position

Job DescriptionThe IT risk analyst supports the IT risk management practice, which ensures risk is proactively identified, decisioned, communicated and monitored. The primary responsibilities of the IT risk analyst are to perform assessments of potential risk exposures and prepare actionable risk reporting. In this role, it is critical to foster strong working relationships with leaders in other areas of the enterprise to perform evaluations of the enterprise risk posture and to offer independent advice regarding ways to reduce risk in line with established risk appetites. The successful candidate thinks strategically, is intellectually curious and is comfortable working in undefined problem spaces. As a member of a growing enterprise, the IT risk analyst will be expected to shape and further refine the risk program and will have the opportunity to operate with both autonomy and empowerment from senior leadership. Top Must Haves:<ul><li>Risk management experience: previous experience working and reviewing cyber risk assessments</li><li>Familiarity with cyber security frameworks, such as, NIST-CSF</li><li>Experience with risk tools (administrative, power user, user)</li><li>Facilitate cyber risk communications, cyber risk lifecycle task completion and cyber risk aware decision making with technical and non-technical audiences</li></ul> Key ResponsibilitiesCRA Responsibilities:<ul><li>Managing cyber risk assessments</li><li>Evaluating internal Company’s operational controls for alignment to cyber risk treatment needs.</li><li>Analyzing, framing, and updating threat and risk scenarios for use in cyber risk management</li><li>Communicating cyber risk to Management and designated stakeholders.</li><li>Assess and update cyber risk appetites for LOB.</li><li>Evaluate cyber risk treatment options and facilitate communication with stakeholders.</li><li>Training employees in cyber risk awareness and risk first culture.</li><li>Adjust cyber risk scores based on available controls and treatment options.</li><li>Create cyber risk dashboards/reports based on complex risk, process and control relationships.</li><li>Facilitate risk management oversight in supporting internal/external audits and regulatory exams.</li></ul> CRA Requirements:<ul><li>Prefer 5-10 years’ experience in governance, risk, and compliance</li><li>Job field related certification(s), CISSP/CISA/CRISC (preferred but not required)</li><li>Previous experience as a compliance analyst in a related field.</li><li>In-depth knowledge of industry compliance requirements and standards.</li><li>Proficiency in compliance management software, Archer, ServiceNow, MetricStream, etc.</li><li>Ability to accurately complete applications for compliance certification.</li><li>Ability to effectively train employees.</li><li>Exceptional communication and interpersonal skills.</li><li>Understanding of regulatory frameworks</li><li>Requirements analysis</li><li>Ability to develop standards to maintain legal compliance</li><li>Quality management</li><li>Critical thinking and problem-solving skills</li><li>Organization, project management, and strategic planning skills</li><li>Familiarity with process improvement methodology</li><li>Attention to detail</li><li>Ability to embrace complexity</li></ul>

The IT risk analyst supports the IT risk management practice, which ensures risk is proactively identified, decisioned, communicated and monitored. The primary responsibilities of the IT risk analyst are to perform assessments of potential risk exposures and prepare actionable risk reporting. In this role, it is critical to foster strong working relationships with leaders in other areas of the enterprise to perform evaluations of the enterprise risk posture and to offer independent advice regarding ways to reduce risk in line with established risk appetites.The successful candidate thinks strategically, is intellectually curious and is comfortable working in undefined problem spaces. As a member of a growing enterprise, the IT risk analyst will be expected to shape and further refine the risk program and will have the opportunity to operate with both autonomy and empowerment from senior leadership. Top Must Haves:<ul><li>Risk management experience: previous experience working and reviewing cyber risk assessments</li><li>Familiarity with cyber security frameworks, such as, NIST-CSF</li><li>Experience with risk tools (administrative, power user, user)</li><li>Facilitate cyber risk communications, cyber risk lifecycle task completion and cyber risk aware decision making with technical and non-technical audiences</li></ul> Key Responsibilities:<ul><li>Managing cyber risk assessments</li><li>Evaluating internal company's operational controls for alignment to cyber risk treatment needs.</li><li>Analyzing, framing, and updating threat and risk scenarios for use in cyber risk management</li><li>Communicating cyber risk to Management and designated stakeholders.</li><li>Assess and update cyber risk appetites for LOB.</li><li>Evaluate cyber risk treatment options and facilitate communication to stakeholders.</li><li>Training employees on cyber risk aware and risk first culture.</li><li>Adjust cyber risk scores based on available controls and treatment options.</li><li>Create cyber risk dashboards/reports based on complex risk, process and control relationships.</li><li>Facilitate risk management oversight in supporting internal/external audits and regulatory exams.</li></ul> CRA Requirements:<ul><li>Prefer 5-10 years' experience in governance, risk, and compliance</li><li>Job field related certification(s), CISSP/CISA/CRISC (preferred but not required)</li><li>Previous experience as a compliance analyst in a related field.</li><li>In-depth knowledge of industry compliance requirements and standards.</li><li>Proficiency in compliance management software, Archer, ServiceNow, MetricStream, etc.</li><li>Ability to accurately complete applications for compliance certification.</li><li>Ability to effectively train employees.</li><li>Exceptional communication and interpersonal skills.</li><li>Understanding of regulatory frameworks</li><li>Requirements analysis</li><li>Ability to develop standards to maintain legal compliance</li><li>Quality management</li><li>Critical thinking and problem-solving skills</li><li>Organization, project management, and strategic planning skills</li><li>Familiarity with process improvement methodology</li><li>Attention to detail</li><li>Ability to embrace complexity</li></ul>

12 month contract to hire, full benefits/PTO provided prior to conversion. Candidates should be eligible to work for any employer in the United States without needing Visa sponsorship. Job Description<ul><li>Assist with the maintenance of daily, weekly, monthly, and quarterly business reporting functions.</li><li>Gather Retail Operations data from multiple databases, platforms, stakeholders, and 3rd party vendors to complete analyze.</li><li>Transform large data sets through data wrangling, exploratory data analysis, and predictive modeling.</li><li>Leverage Power BI (and other data visualization tools) to build and maintain custom reports and dashboards to reveal trends and correlations in large data sets.</li><li>Implement row level security in the Power BI (and other data visualization tools) to enable secured viewing of the reports for designated job levels and locations.</li><li>Identify opportunities to enhance reporting capabilities and improve processes.</li><li>Collaborate with cross-functional teams to understand the data needs to execute department and enterprise-wide strategic objectives and initiatives.</li><li>Identify and communicate any data-related issues and recommendations to the business owner, manager, and the team.</li><li>Provide data insights and solutions to leaders to drive decision-making.</li></ul> Key Responsibilities<ul><li>Standardize and solidify data processes and quality</li><li>Assist in developing business reporting</li><li>Increase data availability, standardization and automation processes</li><li>Problem solve and investigate issues</li><li>Participate in all phases of system testing Work successfully in an Agile Project across multiple feature and component teams</li><li>Complete estimates and work plans in Program Increments (PI) Meetings as appropriate for design, development, implementation and rollout tasks</li></ul> Skills:<ul><li>R (data cleaning, performing calculations on large datasets, performing exploratory data analysis).</li><li>Python</li><li>PowerBI (especially with DAX). Working with Power Query, Dataflows, Row Level Security (RLS) and writing measures with DAX</li><li>Experience with visualization and a focus on the user experience. This role will have importance with making reports visually appealing and user friendly.</li></ul>

Candidates MUST be local to Cincinnati. Interviews will be onsite, and they will be working a hybrid schedule in the office 2-3 day/week. Contract TO HIRE- Candidates should be eligible to work for any employer in the United States WITHOUT needing Visa sponsorship MINIMUM QUALIFICATION/EDUCATION• 5+ years’ experience as a Data Scientist/ML Engineer.• High level of independence to develop and own toolkits, pipelines, models and dashboards. REQUIREMENTS• Experience designing, building, and deploying scalable cloud-based solution architectures• Experience working with public cloud platforms such as AWS, Azure. GCP• Experience in MLOps, CI/CD, TDD/BDD• Extensive knowledge of ML frameworks, libraries, data structures, data modeling, and software architecture.• In-depth knowledge of mathematics, statistics, and algorithms.• Knowledge of containerization and container orchestration technologies.• Good understanding and/or experience writing software in one or more languages, such as Python, Java, Go, JavaScript, C++, or similar• Familiarity and good understanding of infrastructure – storage, networking etc.• Strong analytical problem-solving skills• Excellent written and verbal communication skills• Self-starter takes the initiative and works well under pressure• Business-minded approach to time, costs, and milestones• Can work well within a matrixed team environment BONUS POINTS· Microsoft Certified: Azure Data Scientist Associate (DP-100)· Experience with Azure Service Fabric, Azure Databricks, Power BI, Azure ML, Azure Synapse· Experience with combinatorial optimization· Experience with GitHub Functions· Experience with SQL Server, SSIS, ETL/ELT, NoSQL, redis, ODS· Experience working with Industry Standard Data Models such as ADRM, Common Data Model· Experience in Domain Driven Design, microservices, Event Driven and Mesh App· Experience in Retail industry

Candidates MUST be local to Cincinnati. Interviews will be onsite, and they will be working a hybrid schedule in the office 2-3 day/week. Candidates should be eligible to work for any employer in the United States without needing Visa sponsorship. Job Description<ul><li>Accountable for developing and delivering technological responses to targeted business outcomes.</li><li>Analyze, design and develop enterprise data and information architecture deliverables, focusing on data as an asset for the enterprise. Understand and follow reusable standards, design patterns, guidelines, and configurations to deliver valuable data and information across the enterprise, including direct collaboration with the Sister Company, where needed.</li><li>2+ years’ experience with automation production systems (Ansible Tower, Jenkins, Puppet, or Selenium)</li><li>Working knowledge of databases and SQL Experience with software development methodologies and SDLC Candidate possess a problem-solving attitude and can work independently</li><li>Must be very organized, able to balance multiple priorities, and self-motivated</li></ul> Key Responsibilities<ul><li>Experience in administration and configuration of API Gateways (e.g. Apigee/Kong) Apply cloud computing skill to deploy upgrades and fixes</li><li>Design, develop, and implement integrations based on use feedback.</li><li>Troubleshoot production issues and coordinate with the development team to streamline code deployment.</li><li>Implement automation tools and frameworks (Ci/CD pipelines).</li><li>Analyze code and communicate detailed reviews to development teams to ensure a marked improvement in applications and the timely completion of products.</li><li>Collaborate with team members to improve the company’s engineering tools, systems and procedures, and data security.</li><li>Deliver quality customer service and resolve end-user issues in a timely manner</li><li>Draft architectural diagrams, interface specifications and other design documents</li><li>Participate in the development and communication of data strategy and roadmaps across the technology organization to support project portfolio and business strategy</li><li>Innovate, develop, and drive the development and communication of data strategy and roadmaps across the technology organization to support project portfolio</li><li>Drive the development and communication of enterprise standards for data domains and data solutions, focusing on simplified integration and streamlined operational and analytical uses</li><li>Drive digital innovation by leveraging innovative new technologies and approaches to renovate, extend, and transform the existing core data assets, including SQL-based, NoSQL-based, and Cloud-based data platforms</li><li>Define high-level migration plans to address the gaps between the current and future state, typically in sync with the budgeting or other capital planning processes</li><li>Lead the analysis of the technology environment to detect critical deficiencies and recommend solutions for improvement</li><li>Mentor team members in data principles, patterns, processes and practices</li><li>Promote the reuse of data assets, including the management of the data catalog for reference</li><li>Draft and review architectural diagrams, interface specifications and other design documents</li></ul>

Ascendum Solutions Interview Questions

Ascendum Solutions Interview Guides

Ascendum Solutions Interview Questions

Ascendum Solutions Salaries by Position

Ascendum Solutions Opening Jobs