Our Deloitte Customer team empowers organizations to build deeper relationships with customers through innovative strategies, advanced analytics, Generative AI, transformative technologies, and creative design. We can enhance customer experiences and drive sustained growth and customer value creation and capture, through customer and commercial strategies, digital products and innovation, marketing, commerce, sales, and service. We are a team of strategists, data scientists, operators, creatives, designers, engineers, and architects. Our team balances business strategy, technology, creativity, and ongoing managed services to solve the biggest problems that affect customers, partners, constituents, and the workforce. Work You'll Do As a Project Delivery Senior Analyst on the project, you will be responsible for: + Data Modelling and ETL Developer for Data Conversion Design, Develop, and Test Talend ETLs. + Responsible for building and validating ETL (Extract, Transform, Load) processes using Talend for data conversion projects. + Lead Design Discussions: Facilitate design conversations with both client stakeholders and internal Deloitte teams to ensure alignment on requirements and solutions. + Legacy Data Model Analysis: Analyze and review existing (legacy) data models to understand current structures and identify areas for improvement or transformation. + Create Mapping Documents: Develop comprehensive mapping documents that detail how legacy data will be transformed and loaded into the new system. + ETL Testing: Conduct thorough testing of ETL jobs to ensure data accuracy, integrity, and performance. Functional Coordination: Collaborate with the functional application team to assess and address any functional impacts resulting from data conversion activities. The Team Deloitte's Government & Public Services (GPS) practice - our people, ideas, technology and outcomes - is designed for impact. Serving federal, state, & local government clients as well as public higher education institutions, our team of professionals brings fresh perspective to help clients anticipate disruption, reimagine the possible, and fulfill their mission promise. Our Human Services Transformation offering delivers large, complex systems development and transformation projects to Human Service agencies across federal, state, and local government agencies. The Project Delivery Talent Model is designed for professionals with specialized skills that align to a current client need. Team members focus on delivering services to clients, without additional expectations related to business development or promotion. Their employment is tied to their role on a project, and they are eligible for a benefits package that is competitive for project delivery-focused professionals. Qualifications Required: + Bachelor's degree + Be on-site with the team 3 days/week in the Sacramento office. + Extraction Transform Load (ETL): Mastery + IBM DB2 Connect: Intermediate + Salesforce: Intermediate + SQL Query: Mastery + Talend ETL: Mastery + Limited immigration sponsorship may be available Preferred: + Design Analysis: Advanced + Requirements Management: Advanced + Practice Area The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Deloitte, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $80,000 to $110,000. You may also be eligible to participate in a discretionary annual incentive program, subject to the rules governing the program, whereby an award, if any, depends on various factors, including, without limitation, individual and organizational performance. Information for applicants with a need for accommodation: https://www2.deloitte.com/us/en/pages/careers/articles/join-deloitte-assistance-for-disabled-applicants.html 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. 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.