Deloitte Senior Consultant, Strategy & Analytics, Analytics & Cognitive in Philadelphia, Pennsylvania
Deloitte Consulting LLP seeks a Senior Consultant, Strategy & Analytics, Analytics & Cognitive in Philadelphia, PA and various unanticipated Deloitte office locations and client sites nationally.
Work You ll Do
Leveraging analytics, robotics, and cognitive technologies to uncover hidden relationships from vast troves of data, creating and managing large-scale organizational intelligence, and generating insights that catalyze growth and efficiencies. Synthesizing overall operations strategy by analyzing a wide variety of business solutions. Selecting the most relevant tools/techniques to meet specific client requirements such as business case, pricing, or complex financial analysis and interpreting and reporting on outputs. Participating in setting engagement objectives and scope, developing work plans for components of engagements, coordinating activities between workstreams and identifying changes in scope. Participating in various aspects of the full software development lifecycle for software applications, which may including requirements gathering, application configuration design, business process analysis, scripting, code deployments, enhancement validation, triage of defects and change requests, escalations and urgent issues. Evaluating clients technology needs, developing customized applications and draft technical and functional design documentation. Identifying and mitigating risks in process and technology for client engagements. Functioning as integrators between business needs and technology solutions, helping to create technology solutions to meet clients business needs. Defining systems strategy, developing system requirements, designing, prototyping, and testing custom technology solutions, and supporting system implementation. Developing dashboard wireframes and designing requirements based on discussion with an understanding of technical and visual design considerations. Developing and maintaining project deliverables for clients for all phases of the software development lifecycle to substantially build the system functionalities. Creating test cases and performing functional, non-functional, system integration, black-box, white-box, and end-to-end testing of software applications. Researching user reported issues with software applications, identifying root causes and resolutions, implementing fixes, and liaising between business functions, end users, and technical delivery teams. Creating technical and functional specifications, including screen layouts, navigation flows, logic diagrams, data models, process models, and pseudo code, to be used for application development. Tracking application defects using defect tracking tools; coordinating defect resolution efforts, and documenting resolution details. Performing assessments of existing information systems, and identifying gaps between business requirements and current system capabilities. Estimating time and resources needed for the development work. Designing sub-components of larger application systems; integrating the applications with each other and continuously optimizing the system structure to improve stability and performance. Developing, testing and implementing custom ETL solutions using Informatica PowerCenter and Talend Data Integration. Designing database queries, triggers, procedures, functions and packages for reporting and data analytics using Oracle Database, Microsoft SQL Server and Vectorwise DBeaver. Performing gap and impact analysis in Greenplum, Oracle Database, Vectorwise, Teradata and Microsoft Excel databases. Performing data merging and blending in Oracle Database, Microsoft SQL Server, and Informatica using Informatica PowerCenter and Talend Data Integration. Modeling, designing and developing Tableau and Qlik Sense reports and dashboards to measure client s performance metrics using customized SQLs. Participating in meetings with clients and technical teams to transform business requirements into technical design documents using Microsoft Visio, Microsoft Excel and Microsoft Word.
Bachelor s degree or foreign equivalent degree in Engineering (any), Computer Science, CIS, MIS or a related field.
Two years of experience in the offered position or a position in a related occupation.
Must have two years of experience with:
Developing, testing and implementing custom ETL solutions using Informatica PowerCenter and Talend Data Integration;
Designing database queries, triggers, procedures, functions and packages for reporting and data analytics using Oracle Database, Microsoft SQL Server and Vectorwise DBeaver;
Performing gap and impact analysis in Greenplum, Oracle Database, Vectorwise, Teradata and Microsoft Excel databases;
Performing data merging and blending in Oracle Database, Microsoft SQL Server, and Informatica using Informatica PowerCenter and Talend Data Integration;
Modeling, designing and developing Tableau and Qlik Sense reports and dashboards to measure client s performance metrics using customized SQLs;
Participating in meetings with clients and technical teams to transform business requirements into technical design documents using Microsoft Visio, Microsoft Excel and Microsoft Word.
80% travel required.
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. at http://www2.deloitte.com/us/en/pages/careers/articles/life-at-deloitte-benefits-and-rewards.html
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.
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. at http://www2.deloitte.com/us/en/pages/careers/topics/recruiting-tips.html
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. at http://www2.deloitte.com/us/en/pages/careers/topics/recruiting-tips.html
Category: Management Consulting
As used in this document, Deloitte means Deloitte LLP and its subsidiaries. Please see www.deloitte.com/us/about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.