Advisory Senior Consultant

  • Competitive
  • Chicago, IL, USA
  • Permanent, Full time
  • Deloitte Services LP - Global
  • 16 Oct 17 2017-10-16

Advisory Senior Consultant

Deloitte & Touche LLP seeks a Advisory Senior Consultant in Chicago, IL.
Work You'll Do
Evaluate clients' critical business processes (revenue, payables, fixed assets, financial close and reporting, inventory) and General Computer Control (GCC) environment by performing design implementation and operating effectiveness audits. Perform risk assessment, risk ranking, automated control design, control GAP analysis, manual control design, and RCM documentation. Conduct Sarbanes Oxley (IT SOX) and SAS-70 audits and remediation. Gather business requirements, data mapping, and document report specifications for trading, compliance, and portfolio management reports. Participate in implementation and reconciliation of financial reporting system. Assist in daily aspects of client engagements, including scheduling and conducting client interviews and documenting, coordinating, and presenting client deliverables. Understand clients' business environment and basic risk management approaches. Utilize knowledge of market trends, competitor activities, products, and service lines. Participate in decision making with engagement management and seek to understand broader impact of decisions. Build and nurture client relationships. Facilitate use of technology-based tools or methodologies to review, design, or implement products and services.

  • Bachelor's (or higher) degree in Mathematics, Economics, Computer Science, Information Systems, Engineering, Finance, Accounting, Business Administration, or related field (willing to accept foreign education equivalent).
  • Two years of experience preparing complex mathematical models for risk assessment.
  • Experience must include two years of:
    • Performing analytics and validating data by developing scripts in SAS, SPSS and SQL Server;
    • Performing daily extract, transform, and load practices in the SQL Server Integration Service tool, conducing data integrity and completeness consolidation, and creating an automation process for ETL on multi-tenant data sources and structures;
    • Performing model designs, analysis, and metrics to calculate brand risk and key performance attributes distribution;
    • Performing data model assessments and model consolidations on technology vendors including TPM, Sassie, and Steton;
    • Data modeling to perform quality standards and measurements for the hospitality industry;
    • Programming in R, SAS, Matlab, Stata, Python, SQL Server, and Qlik Stack;
    • Creating predictive and prescriptive analytic models for workforce optimization;
    • Designing and implementing automation and orchestration of large corporate systems;
    • Developing backend scripts on QlikView and QlikSense for data loading and transformation; and
    • Developing client facing dash boarding utilizing QlikSense and Tableau.
  • Position requires approximately 80% travel.

At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you.
Deloitte's culture
Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture where our people excel and lead healthy, happy lives.  Learn more about Life at Deloitte.
Corporate citizenship
Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities.  We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities.  Learn more about Deloitte's impact on the world.
Recruiter tips
We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the organization and the business area you're applying to. We also suggest that you brush up on your behavioral and case interviewing skills and practice discussing your experience and job history with a family member, friend, or mentor. Check out recruiting tips from Deloitte professionals.

Requisition code: XSFH18FA1017CHI2