Senior Analyst, Data Solutions – Comcast Global Audit
Senior Analysts provide support to CGA engagements by identifying risks and generating insights for audit scope areas through data analytics and/or identifying efficiencies through automation. With our standard engagement cadence and focus on diversifying our talent, Senior Analysts will be responsible for providing ad hoc reporting, proactive monitoring metrics (dashboards) and analyses, and identifying/executing automation opportunities. In this role you will gain broad exposure to the Comcast Corporation through the audit process.
What You Deliver
-Delivers on project tasks and assists with the development of project plans and timelines.
-Identifies audit scope areas that can be automated or repeated through data analytics and works with leadership to schedule/implement.
-Ensures all data is secure and follows company policies regarding data classification.
-Identifies opportunities for improvement to team activities, tools, and training.
-Supports department objectives and performs other duties and responsibilities, as assigned.
-Extracts, manipulates, visualizes, and analyzes accurate, relevant, timely, and cohesive analytics that support the audit lifecycle.
-Discusses engagement objectives with other CGA team members and provides recommendations on potential data analytics to support the audit.
-Analyzes data to determine if businesses are conducting operations in accordance with established policies/procedures, best practices, US GAAP, and governmental and legal requirements.
-Applies analytical models (e.g., regression, simulation, statistical, etc.) to audit scope areas to identify outliers, trends and/or projections, where appropriate.
-Uses data concepts, tools, and programming techniques including SQL programming, MS SQL Server development, Oracle Business Intelligence, Teradata, Tableau, and/or comparable platforms (e.g., Alteryx, Python) to perform extract, transform, load (ETL) and data analysis activities.
-Prepares clear and well-organized analysis workpapers, documenting root-cause (as applicable), work performed, findings, and recommendations.
-Creates graphical reports and executive presentations to effectively summarize analysis and findings.
-Partners with the Automation sub-team to develop technical design for, build and test (unit/SIT) bots.
-Provides support for the Automation sub-team during bot user acceptance testing (UAT) and launch.
-Assists with managing, scheduling, monitoring, and maintaining automated processes in production.
-Bachelor’s Degree or Equivalent in Business or related field
-Data analyst background with excellent data manipulation and analysis skills
-Strong experience of manipulating large datasets
-Experience using advanced data extraction techniques
-Able to perform ETL (extract, transform, load) of data from complex database/data lake
-Open to various database experience including SQL Server and Oracle BI tools
-Preference for experience with SQL Scripting and/or Alteryx
-Any knowledge or experience with RPA tools (UI Path, Automation Anywhere, Blue Prism) would be beneficial