Search jobs > Columbus, OH > Etl developer

Operations & Technology Transformation, Guidewire Developer - ETL/Data Migration - Senior Consultant

Deloitte
Columbus, OH
$128K-$208.3K a year
Full-time

Senior Consultant, Operations & Technology Transformation, Insurance, Guidewire Developer - ETL / Data Migration

What we do

Operations and Technology Transformation delivers market leading expertise and industry depth by harnessing deep sector knowledge, scaling the power of hybrid services and products, and unlocking the power of Process Bionics to deliver sustainable and impactful solutions to our clients.

We advise, design, implement, and deploy innovative and technology enabled solutions focused on "heart of the business" issues in specific sectors including Health Care & Life Sciences, Digital Banking & Payments, Investment & Wealth Management, Insurance, Telecom, Media and Energy & Resources.

Our OTT team brings clients the knowledge of industry leaders who understand the relevant processes and technologies for their industry-and apply them with a process and mindset that tailors transformational change to their specific organization.

Who we serve

Deloitte's Financial Services Industry consulting practice is the largest in the world, serving over 90% of Fortune 500 banking, insurance, securities, investment management, and real estate companies.

Candidate profile

The ideal candidate will be curious, analytical, and confident with a natural drive to exceed immediate project requirements and overcome obstacles.

A genuine passion for the insurance industry, combined with relationship-building, leadership, and communication skills will be critical to success.

Candidates should be energized by continuous personal improvement, proactively seeking out new skills and perspectives, exhibiting openness to coaching from senior colleagues, and contributing to the development of junior staff.

Your role

As a Senior Consultant you will bring considerable technical expertise to deliver effective solutions to clients. You will be the lead person to interface between the clients and our Deloitte teams.

You will serve as an integrator between business needs and technology solutions, helping to create technology solutions to meet clients' business needs.

Senior Consultants will define systems strategy, develop system requirements, design and prototype, test, train, define support procedures and implementation.

You will develop and review system requirements, design the solution, redefine the business, present the prototype, and lead the testing of our custom technology solutions.

Required qualifications

  • Bachelor's degree
  • 4 years consulting or relevant industry experience (Insurance - P&C, L&A / group, Commercial lines, Specialty)
  • Minimum 4 years consulting or relevant Insurance experience within Property & Casualty - Personal Lines, Commercial lines, Specialty Insurance
  • 4 years of experience in Property & Casualty Insurance Solutions with Guidewire, Duck Creek, Majesco, Origami or similar package
  • 4 years of experience working in one of the following sub service areas : Insurance Products, Underwriting, Claims, Billing & Payments, Policy Administration or Distribution
  • Minimum 4 full life cycle implementations of Large-Scale System Delivery Experience preferably for Policy Administration, Billing Systems and / or Claims Systems
  • 1 year experience estimating and planning Large Scale System Implementations
  • 2 years of experience managing at least one large Business Integration effort and project team through all phases of the project lifecycle from scoping and planning, requirements gathering, design, development, and testing
  • 4 years of hands on ETL experience with Informatica and / or Microsoft SSIS
  • 4 years experience with Data Mapping or Data Migration experience
  • 4 years experience with SQL
  • Ability to travel 50%, on average, based on the work you d o and the clients and industries / sectors you serve
  • Limited Sponsorship may be available.
  • Information for applicants with a need for accommodation :

https : / / www2.deloitte.com / us / en / pages / careers / articles / join-deloitte-assistance-for-disabled-applicants.html

Preferred skills

  • Advanced degree in area of technical specialization
  • CPCU, AIC, ARM Certification
  • Guidewire Integration or Configuration certification
  • 4 years experience with Guidewire Cloud Claims migration
  • Experience delivering via an Agile / Scrum methodology
  • A strong Java, Gosu (Guidewire), EJB, BPEL, UNIX background
  • Experience with Business Process Modeling (BPM) tools, Business rules integration
  • Experience with technologies like BEA, Sonic, IBM, Oracle, Apache ServiceMix, FuseESB, Camel, Mule etc.
  • Strong knowledge and comprehension of standards, specifications, standards bodies (e.g., XML, UDDI, JMS, Web services, etc.)
  • Experience with Cloud platforms such as AWS, Azure or GCP
  • 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 $127950 - $208250

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.

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.

23 hours ago
Related jobs
Promoted
Deloitte
Columbus, Ohio

Manager/Specialist Master, Operations & Technology Transformation, Insurance, Guidewire Integration & Configuration. Operations and Technology Transformation delivers market leading expertise and industry depth by harnessing deep sector knowledge, scaling the power of hybrid services and pro...

Mediabistro
Columbus, Ohio

This involves understanding data and data flow across products, extracting the data from the source, re-designing the data into more applicable data models, and designing queries and reports to represent key metrics for clients to understand and make decisions about their business. ETL & Data wareho...

Promoted
Deloitte
Columbus, Ohio

Knowledge of SAP Landscape Transformation (SLT), Smart Data Integration (SDI) or Smart Data Access (SDA). As an SAP Senior Consultant, you will. Data quality reporting and data cleansing implementation experience. Each SAP implementation focuses on achieving results that support businesses strategie...

Deloitte
Columbus, Ohio

Operations & Technology Transformation Manager, Guidewire PolicyCenter Configuration Technical Lead. Operations and Technology Transformation delivers market leading expertise and industry depth by harnessing deep sector knowledge, scaling the power of hybrid services and products, and unlocking...

Highmark Health
OH, Working at Home, Ohio

In this role you will have hands on experience in the full development lifecycle, working with diverse data formats on industry leading technology, like Informatica. As a member of the Medicaid Data Integration team, you will provide value to customers by delivering outstanding integration solutions...

Montrose Environmental Group, Inc.
Columbus, Ohio

Principal/Senior Consultant - EHSS IT Data/Systems Management. Our experts take a strategic approach to address broader environmental goals from sustainability program development, data-driven decision-making using economics and ecology expertise, data management and validation, software strategy an...

JPMorgan Chase & Co.
OH, United States

As a Tech Risk & Controls Senior Associate in Infrastructure Platforms Risk, you will contribute to the successful management of technology-aligned aspects of Governance, Risk, and Compliance in line with the firm's standards. Harvests data from existing (APIs, dashboards, and other data extracts). ...

Elevance Health
Columbus, Ohio

Tableau Developer / Data Analytics Senior (Business Information Consultant Sr). Tableau Developer / Data Analytics Senior. Developing requirements for data visualization from business problem statements. May make recommendations and present based upon data analysis. ...

MSR Technology Group
Columbus, Ohio
Remote

Job Title: Guidewire Developer. Guidewire Digital Certified Associate). ...

JPMorgan Chase & Co.
Westerville, Ohio

In addition, the team develops new data identifiers, builds and maintains tools and capabilities for data loss triage prioritization, analyzes trends and patterns of DLP activity and works with stakeholders to reduce the risk of data loss across all lines of business. Contribute to development of ne...