The Att Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Att Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Att? The Att Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Att Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Att.</li>
<li>Practice real Att Business Intelligence 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 Att Business Intelligence interview.


Getting ready for an Business Intelligence interview at Att? The Att Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Att Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Att.
- Practice real Att Business Intelligence 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 Att Business Intelligence interview.
        

Overview

Att Business Intelligence Salary

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.

Att Business Intelligence Interview Process

We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

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

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

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Rolling Bank Transactions

Write a query to identify the manager with the biggest team size.

You may assume there is only one manager with the largest team size.

Example:

Input:

<code>employees</code> table

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>managers</code> table

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td><code>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Manager Team Sizes

What are the logistic and softmax functions? What is the difference between the two?

What makes them useful for use in logistic regression?

In logistic regression, how is the predicted class determined based on the logistic function?

In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Att Business Intelligence Interview Questions

Senior SOX Business Analyst Location: Dallas, Texas (NOTE: This is "hybrid" 3 days a week onsite in our Dallas HQ offices.) Job requisition id: R-33899 Job Description:Join AT&T and reimagine the communications and technologies that connect the world. Our Consumer Technology experience team is delivering innovative and reliable technology solutions to power differentiated, simplified customer experiences. Bring your bold ideas and fearless risk-taking to redefine connectivity and transform how the world shares stories and experiences that matter. When you step into a career with AT&T, you won’t just imagine the future-you’ll create it. Position Overview: The Senior Technology Business Analysis role will play a crucial role in ensuring the effective management and execution of technology projects within the HR Technology & Analytics (HRTA) organization. This role encompasses a variety of responsibilities, including overseeing SOX audits and control creation, analyzing and optimizing technology work requests, communicating project updates to leadership and clients, and fostering organizational engagement and collaboration. Key Responsibilities:SOX Audit Management & Control Creation:<ul><li>Lead the management of SOX (Sarbanes-Oxley Act) audits within the HRTA organization.</li><li>Develop and implement SOX controls to ensure compliance and mitigate risks.</li><li>Collaborate with internal and external auditors to facilitate smooth audit processes.</li><li>Document and maintain audit findings and resolutions.</li></ul>Technology Work Request Analysis:<ul><li>Analyze the lifecycle of HRTA work requests (tickets) to determine completion times.</li><li>Identify bottlenecks and inefficiencies in the ticket resolution process.</li><li>Develop and recommend actionable solutions to enhance the efficiency and effectiveness of ticket completion.</li><li>Monitor and report on ticket metrics and performance trends.</li></ul>Project Portfolio Updates:<ul><li>Facilitate regular updates to leadership and clients regarding the status of the HRTA project portfolio.</li><li>Prepare comprehensive reports and presentations that highlight project progress, risks, and milestones.</li><li>Ensure transparent and timely communication of project updates and potential issues.</li></ul>Organizational Engagement & Collaboration:<ul><li>Lead initiatives to engage HRTA team members and foster a collaborative work environment.</li><li>Organize and facilitate team-building activities and events.</li><li>Promote knowledge sharing and best practices within the organization.</li><li>Encourage a culture of continuous improvement and open communication.</li></ul> Education: Bachelors of Science in Information Systems Technology, Computer Science or Engineering preferred; or Business Analyst nanodegree. Experience: Typically requires 3-5 years experience as a business analyst managing Sarbanes-Oxley Audits (SOX). Experience with managing SOX controls to ensure compliance and mitigate risks. Experience collaborating with internal and external auditors Our Senior Technology Business Analysis position earns between $105,600 - $158,400 annually. Not to mention all the other amazing rewards that working at AT&T offers. Individual starting salary within this range may depend on geography, experience, expertise, and education/training. Joining our team comes with amazing perks and benefits:<ul><li>Medical/Dental/Vision coverage</li><li>401(k) plan</li><li>Tuition reimbursement program</li><li>Paid Time Off and Holidays (based on date of hire, at least 23 days of vacation each year and 9 company-designated holidays)</li><li>Paid Parental Leave</li><li>Paid Caregiver Leave</li><li>Additional sick leave beyond what state and local law require may be available but is unprotected.</li><li>Adoption Reimbursement</li><li>Disability Benefits (short term and long term)</li><li>Life and Accidental Death Insurance</li><li>Supplemental benefit programs: critical illness/accident hospital indemnity/group legal</li><li>Employee Assistance Programs (EAP)</li><li>Extensive employee wellness programs</li><li>Employee discounts up to 50% off on eligible AT&T mobility plans and accessories, AT&T internet (and fiber where available) and AT&T phone.</li></ul> AT&T is leading the way to the future – for customers, businesses and the industry. We're developing new technologies to make it easier for our customers to stay connected to their world. Together, we’ve built a premier integrated communications and entertainment company and an amazing place to work and grow. Team up with industry innovators every time you walk into work, creating the world you always imagined. Ready to #transformdigital with us? Apply now! Location:Dallas, Texas (Hybrid 3 days a week)Salary Range: $105,600.00 - $158,400.00

NOTE: We have 2 openings for this team, just slightly different level and role. One is for a Sr. Software Engineer, the second is for a Principal Software Engineer as posted below. LOCATION: You must be currently living in the Dallas/Fort Worth area. This role is located in Plano Texas and is "Hybrid" 3 days a week onsite. This is NOT remote. Expert level technical professional. Advisor on technical knowledge and ATT technologies along with Artificial Intelligence. Collaborate with engineers/architects, clients, etc. to validate test environments, test data and test results, design and implement code fixes, validate outcomes against expected results and produce associated reporting. Qualifications:<ul><li>Preferred Bachelors of Science degree in Computer Engineering, Computer Science, Applied Science, Electrical Engineering, or Math; Developer nanodegree; or equivalent experience.</li><li>8-10 years experience in Software Engineering</li><li>5+ years of experience in Java, RESTful APIs, Spring, Spring MVC, Spring Kafka, Microservices, Struts 2, database technologies, and related testing tools/methodologies.</li><li>5+ years of experience in advanced Git skills and respective branching strategies.</li><li>Cloud, Cosmos (non SQL), Data manipulation/migration/scrubs, Flat file staging and uploading.</li><li>3+ year experience building APIs</li><li>3+ years of experience in API documentation tool, Swagger preferred</li><li>2+ years of experience in API monitoring and dashboards using ELK and Dynatrace,</li><li>2+ years experience with JSON, XML, SoapUI,</li><li>2+ years of experience in Unit and Function testing using Junit, Spock, Mockito/JMock, Selenium, Cucumber.</li></ul> Desirable experience: experience building APIs in Mulesoft Our Principal Software Engineering, earns between $158,200.00-$237,400.00 USD Annual, Not to mention all the other amazing rewards that working at AT&T offers. Individual starting salary within this range may depend on geography, experience, expertise, and education/training. Joining our team comes with amazing perks and benefits:· Medical/Dental/Vision coverage· 401(k) plan· Tuition reimbursement program· Paid Time Off and Holidays (based on date of hire, at least 23 days of vacation each year and 9 company-designated holidays)· Paid Parental Leave· Paid Caregiver Leave· Additional sick leave beyond what state and local law require may be available but is unprotected· Adoption Reimbursement· Disability Benefits (short term and long term)· Life and Accidental Death Insurance· Supplemental benefit programs: critical illness/accident hospital indemnity/group legal· Employee Assistance Programs (EAP)· Extensive employee wellness programs· Employee discounts up to 50% off on eligible AT&T mobility plans and accessories, AT&T internet (and fiber where available) and AT&T phone. AT&T is leading the way to the future – for customers, businesses and the industry. We're developing new technologies to make it easier for our customers to stay connected to their world. Together, we’ve built a premier integrated communications and entertainment company and an amazing place to work and grow. Team up with industry innovators every time you walk into work, creating the world you always imagined. Ready to #transformdigital with us?Apply now! #ConsumerTechnologyeXperience Location:Plano, Texas Salary Range: $158,200.00 - $237,400.00 NOTE: This is NOT a remote role. You must be currently living in the Dallas/Fort Worth area and able to work onsite at least 3 days a week.

Att Business Intelligence Interview Guide

Overview

Att Business Intelligence Salary

Att Business Intelligence Interview Process

Att Business Intelligence Interview Questions

Att Business Intelligence Jobs