Consulting, Senior Consultant

Position Summary

Deloitte Consulting LLP seeks a Consulting, Senior Consultant in Seattle, Washington and various unanticipated Deloitte office locations and client sites nationally.

Work You'll Do
Drive software advisory and implementation services to help companies unlock the value of technology investments as discrete services or comprehensive solutions. Perform assessments of existing information systems and identify gaps between business requirements and current system capabilities; provide application analysis to meet software architecture and infrastructure goals. Define systems strategy, develop system requirements, design, prototype, and test custom technology solutions and support system implementation. Participate in setting engagement objectives and scope, develop work plans for components of engagements, and coordinate activities between workstreams and identify changes in scope. Provide industry insight and analytical support using data mining, pattern matching, data visualization, and predictive modeling tools to produce analyses and algorithms that help businesses make better decisions. Transform detailed requirements into a complete, detailed systems design document; support creation of interface specifications and call flows for the various components in the design.

• 50% Travel required nationally.
• Telecommuting permitted.
• Work location includes various unanticipated Deloitte office locations and client sites nationally.

Requirements
Bachelor's degree or foreign equivalent in Business Administration, any STEM field, or a related field. Must have 2 years of related work experience in the job offered or in a related occupation. Position requires 2 years of related work experience in each of the following:
• Utilizing Extract, Transform, and Load (ETL) and Apache Hadoop Framework to provide software advisory and implementation services for clients in the Life Sciences and Health Care industries;
• Designing sub-components of larger systems, integrating applications with each other, and continuously optimizing system structure, utilizing Microsoft (MS) SQL Server Integration Services (SSIS) and Informatica PowerCenter;
• Researching user reported issues with software systems, identifying root causes and resolutions, and implementing fixes, by leveraging Teradata SQL Assistant, MS SQL Server Agent Job Monitoring, Zena, and Control-M Scheduler;
• Tracking implementation defects, coordinating defect resolution efforts, and documenting resolution details, by employing Azure DevOps, Kanban, and Scrum Boards, Atlassian Jira, and ServiceNow;
• Utilizing Teradata BTEQ, Apache HiveQL, and TransactSQL (T-SQL) scripts to build, maintain, and deploy Relational Database and Data Warehouse based applications;
• Monitoring application server performance of MS SQL Server, Teradata in Data Lake, and Oracle;
• Working across all phases of the software development lifecycle to design, develop, test, and implement End-to-End (E2E) ETL solutions for enterprise-level clients; and
• Interfacing directly with client stakeholders to gather, analyze, and translate functional and technical requirements into project designs to deliver solutions that fully meet client needs, utilizing MS Visio, PowerPoint, Excel, Word, SQL Server Management Studio (SSMS), and Mural.

Other
Hours: M-F, 40 hours/week;
Annual Salary: $138,174.00-$208,250.00

If offered employment, must have legal right to work in U.S. EOE, including disability/veterans.

Recruiting tips

From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters.

Benefits

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.

Our people and culture

Our diverse, equitable, and inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our client most complex challenges. This makes Deloitte one of the most rewarding places to work. Learn more about our inclusive culture.

Our purpose

Deloitte's purpose is to make an impact that matters for our clients, our people, and in our communities. We are creating trust and confidence in a more equitable society. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. We are focusing our collective efforts to advance sustainability, equity, and trust that come to life through our core commitments. Learn more about Deloitte's purpose, commitments, and impact.

Professional development

From entry-level employees to senior leaders, we believe there's always room to learn. We offer opportunities to build new skills, take on leadership opportunities and connect and grow through mentorship. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their career.

As used in this posting, "Deloitte" means Deloitte Consulting LLP, a subsidiary of Deloitte LLP. 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.

Requisition code: 206034