Job Information
Deloitte Consulting LLP Consulting, Solution Specialist in Mechanicsburg, Pennsylvania
Deloitte Consulting LLP seeks a Consulting, Solution Specialist in Mechanicsburg, Pennsylvania and various unanticipated Deloitte office locations and client sites nationally.
Work You'll Do Perform database administration activities and coordinate with technical and functional teams; understand the criticality of activities and schedule the same accordingly. Work across all phases of the Agile and Waterfall lifecycle for the design, development, testing and implementation of Extract Transform Load (ETL), Analytical and Business reports, and Data Warehouse solutions for enterprise-level clients. Maintain system security by implementing security standards. Implement data integration solutions using dimensional modeling, granularity and source-to-target mapping to integrate new BI/DW requirements. Perform analysis, design, programming and testing for presentation, reporting and data ETL layers of enterprise data warehouse. Design and develop data validation processes, perform data analysis and profiling to identify data gaps using data quality and data profiling tools to rectify data redundancies and anomalies. Work in multidimensional data modeling, including star schemas, snowflakes, normalized and de-normalized models, handling "slow-changing" dimensions/attributes. Tune performance of complex solutions (both ETL processes and reporting queries) using database administration tools and tuning techniques. Perform analysis, design, programming and testing for presentation, reporting and data ETL layers of enterprise data warehouse, ensuring data design follows the prescribed reference architecture and framework.
- 15% 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 1 year of related work experience in the job offered or in a related occupation. Position requires 1 year of related work experience in each of the following:
- Utilizing Continuous Integration/Continuous Deployment (CI/CD), Jenkins CloudBees, Bitbucket, Visual Studio Code (VS Code), and Salesforce Change Set Development Model to perform deployments of coding, cloning, refreshing, patching, backups, and restoration of multiple middleware components;
- Maintaining technical and data security in systems by implementing security standards, including Identity and Access Management (IAM), encryption, and multi-factor authentication;
- Writing complex queries, functions, and procedures utilizing Salesforce Object Query Language (SOQL) and Salesforce Apex to control and design application data;
- Tuning performance of complex solutions using Salesforce Snowfakery and CumulsCI;
- Supporting production activities through performance tuning of Extract, Transform, and Load (ETL) jobs, resolution of production failures, and completion of service desk tickets utilizing ServiceNow;
- Utilizing YAML Ain't Markup Language (YAML), Docker, and Apache Groovy for the design and development of solutions; and
Designing interactive dashboards and data visualization reports using Salesforce Einstein Analytics, Tableau, and Power BI.
To apply visit apply.deloitte.com. Enter XB24C88961 in "Search jobs" field. EOE, including disability/veterans. If offered employment, must have legal right to work in U.S.