Senior Consultant, Strategy & Analytics, Analytics & Cognitive
Dallas, TX

Job Description

Deloitte Consulting LLP seeks a Senior Consultant, Strategy & Analytics, Analytics & Cognitive in Dallas, TX and various unanticipated Deloitte office locations and client sites nationally.

Work You'll Do

Functioning as an integrator between business needs and technology solutions, helping to create technology solutions to meet clients' business needs. 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. Synthesizing overall operations strategy by analyzing a wide variety of business solutions. 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. Defining systems strategy, developing system requirements, designing, prototyping, and testing custom technology solutions, and supporting system implementation. Creating test cases and performing functional, non-functional, system integration, black-box, white-box, and end-to-end testing of software applications. Performing assessments of existing information systems, and identifying gaps between business requirements and current system capabilities. Eliciting, documenting and refining business requirements and serving as a liaison between the business community and the Information Technology (IT) team to provide quality technical solutions to meet user needs. Creating a System Interface Agreement (SIA) between the source systems and targeting systems, with the escalation procedures in the case of issues, and the Service Level Agreement (SLA). Designing Extract Transform Load (ETL) specifications with transformation rules for good performance, maintainability of the code and efficient restart ability. Coordinating with data modeler for designing the dimensional model using Erwin. Performing data modelling by organizing data into efficient and effective categories by using Excel, Visio, and Erwin. Performing ETL implementation by extracting data, cleansing raw data, homogenizing the data, applying business rules per the client needs, and loading the data into DataMart or data warehouse. Loading data into data warehouses, creating reports and dashboards for matrices and performing calculations for analysis on top of the data in the dashboards, and presenting in Excel. Performing cross-platform integration, including databases, flat files, systems, and applications for seamless transportation of data prior to and after ETL implementation. Testing and tuning the Structured Query Language (SQL) queries.

#LI-DNI

Requirements

* Bachelor's degree or foreign equivalent degree in Computer Science, Information Technology, Engineering (any), CIS, MIS or a related field.


* Two years of experience as Senior Consultant, as a Technology Analyst or a position in a related occupation.


* Must have two years of experience with:
* Eliciting, documenting and refining business requirements and serving as a liaison between the business community and the Information Technology (IT) team to provide quality technical solutions to meet user needs;


* Creating a System Interface Agreement (SIA) between the source systems and targeting systems, with the escalation procedures in the case of issues, and the Service Level Agreement (SLA);


* Designing Extract Transform Load (ETL) specifications with transformation rules for good performance, maintainability of the code and efficient restart ability;


* Coordinating with data modeler for designing the dimensional model using Erwin;


* Performing data modelling by organizing data into efficient and effective categories by using Excel, Visio, and Erwin;


* Performing ETL implementation by extracting data, cleansing raw data, homogenizing the data, applying business rules per the client needs, and loading the data into DataMart or data warehouse;


* Loading data into data warehouses, creating reports and dashboards for matrices and performing calculations for analysis on top of the data in the dashboards, and presenting in Excel;


* Performing cross-platform integration, including databases, flat files, systems, and applications for seamless transportation of data prior to and after ETL implementation;


* Testing and tuning the Structured Query Language (SQL) queries.




* 80% travel required.



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.

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.

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. Certain services may not be available to attest clients under the rules and regulations of public accounting.

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: XGGS19FC0519DAL1

*
*
*
*
*
*