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 impactsResponsible for analyzing data in response to new business requests, performing maintenance and changes on interfaces, and identifying and resolving data discrepancies across multiple business applicationsWorks directly with the client user community and business analysts to define and document data requirements for data integration and business intelligence applicationsDetermines and documents data mapping rules for movement of medium to high complexity data between applicationsExtracts and analyzes data from specific applications, systems and/or databases to create reports and provide recommendations based on the analysis of the dataInvestigates and resolves data issues across platforms and applications, including discrepancies of definition, format and functionWorks closely with DBAs to transition logical models to physical implementationDeep technical knowledge and subject matter expert on ATT technologies.Key Technical Requirements:Proficient in SQL Server:SQL Server Stored ProceduresSQL Server (SSIS)SQL Server (SSAS)SQL Server Administration experienceProficient in other Database Environments:OracleSnowflakeTrino / MongoDBData AnalyticsPowerBITabular SSAS (DAX)Other Tech RequirementsStrong 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, etcTCP 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 coverage401(k) planTuition reimbursement programPaid Time Off and Holidays (based on date of hire, at least 23 days of vacation each year and 9 company-designated holidays)Paid Parental LeavePaid Caregiver LeaveAdditional sick leave beyond what state and local law require may be available but is unprotectedAdoption ReimbursementDisability Benefits (short term and long term)Life and Accidental Death InsuranceSupplemental benefit programs: critical illness/accident hospital indemnity/group legalEmployee Assistance Programs (EAP)Extensive employee wellness programsEmployee discounts up to 50% off on eligible AT&T mobility plans and accessories, AT&T internet (and fiber where available) and AT&T phoneWeekly Hours:40Time Type:RegularLocation:Alpharetta, Georgia, Dallas, TexasSalary Range: $128,400.00 - $215,800.00AT&T and its subsidiaries are committed to equal employment opportunity. All hiring, promotion, and other employment decisions remain merit-based and free from discrimination on the basis of race, color, religion, religious creed, national origin, ancestry, age, sex, sexual orientation, gender, gender identity, gender expression, physical disability, mental disability, pregnancy, medical condition, genetic information, marital status, citizenship status, military status, veteran status, or any other characteristic protected by federal, state, or local laws. In addition, AT&T will provide reasonable accommodations to qualified individuals with disabilities. AT&T is a fair chance employer and does not initiate a background check until an offer is made. Click here to learn more or request an application accommodation here.