Lead Advanced Data Analyst

**Overall Purpose:** Strategically analyze data from diverse sources using advanced predictive modeling, statistics, and trend analysis, thereby driving informed decision-making and optimizing business performance.   The **Lead Advanced Analytics** role is responsible for designing, developing, and maintaining advanced analytics and reporting and data solutions that support Compensation. This individual will play a critical role in building scalable data and automation solutions, ensuring data accuracy, and delivering actionable insights to business stakeholders.   This role supports the end-to-end Quota Tool process on the Consumer Technology Team for Sales Compensation, Automation & Analytics. Having a strong background in Agile development is a must in continuing to create a culture of being fast, accountable and results oriented.  Having vast knowledge in our applications that serve as our Commission, Hierarchy, Billers, and Point of sale systems will be a value add for our processes and tools.  **Key Roles and Responsibilities:** Typical tasks may include, but are not limited to, the following: * Champions end-to-end Quota process from capturing the business need, coding, testing, and pushing to production, as well as coordinating WebTool and Goal Loading impacts * Responsible for analyzing data in response to new business requests, performing maintenance and changes on interfaces, and identifying and resolving data discrepancies across multiple business applications * Works directly with the client user community and business analysts to define and document data requirements for data integration and business intelligence applications * Determines and documents data mapping rules for movement of medium to high complexity data between applications * Extracts and analyzes data from specific applications, systems and/or databases to create reports and provide recommendations based on the analysis of the data * Investigates and resolves data issues across platforms and applications, including discrepancies of definition, format and function * Works closely with DBAs to transition logical models to physical implementation * Deep technical knowledge and subject matter expert on ATT technologies. **Key Technical Requirements:** Proficient in SQL Server: * SQL Server Stored Procedures * SQL Server (SSIS) * SQL Server (SSAS) * SQL Server Administration experience   **Proficient in other Database Environments:** * Oracle * Snowflake * Trino / MongoDB   **Data Analytics** * PowerBI * Tabular SSAS (DAX)   **Other Tech Requirements** * Strong ETL Skillset with large volumes of data using SSIS. * Experience using relational databases (Ex- SQL Server, Oracle) and/or Data Warehouse data storage (Ex- Snowflake or Databricks Delta Lake). * Experience utilizing big data analytics tools (Ex- Tableau, Power BI AI Insights, Databricks) for modeling and process integration, and to make recommendations for improvements to processes, financials, business models, etc **TCP Career Step Differentiator:** Performs very complex advanced analytics work, builds complex business models, and makes recommendations that impact multiple organizations, lines of the business, etc. **Education/Experience:** Bachelor’s degree (BS/BA) desired from an accredited University in a Quantitative field of study such as Data Science, Math, Statistics, Engineering or Physics. 5+ years of related experience. Certification is required in some areas. **This position requires office presence of a minimum of 5 days per week and is only located in the location(s) posted. No relocation is offered.** Our Lead Advanced Analytics jobs earn between $128,400.00 - $215,800.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 **Weekly Hours:** 40 **Time Type:** Regular **Location:** Alpharetta, Georgia, Dallas, Texas **Salary Range:** $128,400.00 - $215,800.00 It is the policy of AT&T to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, AT&T will provide reasonable accommodations for qualified individuals with disabilities. AT&T is a fair chance employer and does not initiate a background check until an offer is made.