drjobs Data Engineering Analyst

Data Engineering Analyst

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Mexico City - Mexico

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Company:

Marsh

Description:

Data Engineering Analyst

This position is responsible for development and operational support on business databases. Creation of SSIS packages as well as SSRS reports for various clients both internal and external. This may include data transfers data integrity application support and reporting. Lead cross-training efforts within team to assure proper coverage. MMC offers a very strong benefits package including Employee Stock purchase plans and a large selection of employer sponsored health plans.

What can you expect

  • This roles primary responsibility is developing enhancing and supporting Icat Online Icats customer facing quoting and policy management system.
  • Icat Online is the backbone of Icats business generating over 200000 instant quotes a year for Earthquake and Hurricane Exposed Residential and Commercial Customers across the entire United States.

Whats in it for you

  • Culture of internal mobility collaboration and valued partnership with stakeholders.
  • Employee Resource Groups which provide access to leaders relevant volunteer and mentoring opportunities and interactions with counterparts in industry groups and client organizations.
  • Full benefits package starting day one.
  • Generous Parental Leave and Tuition Reimbursement plan per year and participation in our Employee Stock Purchase Plan (regional specificity required).
  • Generous paid time off additional floating holidays time off to give back to your community.
  • Multiple medical dental and vision plans with choices to fit all needs and budgets.

We will expect you to:

  • Review analyze and modify SQL programs applications and extract transform load processes including encoding testing debugging and documenting.
  • Write SQL programs or scripts as required for small to large scale data updates.
  • Implement data models and database designs data access and table maintenance codes. Assist in the resolution of database capacity issues replication and other distributed data issues.
  • Consult with ICAT personnel to determine business and functional requirements and identify solutions to resolve those needs.
  • Write and maintain functional and technical specifications.
  • Provide technical support to database applications including data conversion and data integration supporting back-end insurance processes such as claims billing policy printing inspections and reporting.
  • Gather requirements and convert to SSRS reports both adhoc and scheduled.
  • Create scripts and ETL processes for data integration data maintenance or bug fixes. - Create new prototype applications to refine requirements.
  • Analyze define and document system requirements for data workflow logical processes interfaces with other systems auditing reporting requirements and production configuration.
  • Analyze code for problem resolution and performance optimization.
  • Provide technical consulting and respond to error reports problems or questions.
  • Lead and promote a team environment identify best practices and collaborate to implement across various systems.
  • Participate in QA and Production release teams.
  • Cross-train team. Work with manager to designate primary/backup for each function.
  • Write SQL code as required to support business operations reporting and database management.
  • Assist Business Information Systems team as needed with functions including- General Administration Document Issuance Application Support Reporting Support other departments with their database server environment and architecture.
  • Assist with ad-hoc requests.
  • Maintain knowledge of and support ICATs company values and strategic plan
  • Additional duties as assigned
  • Escalate problems as appropriate
  • Exhibit good troubleshooting and technical skills

What you need to have Experience in:

  • A Bachelors degree in Computer Science Engineering a related field and 2-5 Years in industry experience OR 5-7 Years Industry experience without a 4 year degree.
  • At least eight years of experience with relational databases and writing/maintaining SQL code preferably Microsoft SQL Server. Primary focus on complex SQL in PL-SQL or Transact-SQL. SSIS/SSRS experience required.
  • At least six years of experience in a production environment with responsibility for the timely production of business processes and output.
  • At least six years of experience using a change management system such as VSS StarTeam or Perforce.
  • At least three-year experience with structured programming techniques and formal application development processes.
  • P&C Insurance knowledge ISO Statutory and/or State DOI reporting experience preferred.
  • Demonstrated ability to proactively address issues streamlining processes where possible.
  • Demonstrated ability to develop formal application specifications and project plans using common documentation tools such as Visio Microsoft Word and Microsoft Project.
  • Demonstrated ability to troubleshoot stored procedures by reviewing code isolating any issues suggest corrections and/ or enhancements using proper change control methodologies.

What makes you stand out

  • Experience in insurance or finance.
  • Demonstrated ability to work in a large global company and or complex IT environment preferred

  • Excellent verbal and written communication skills comfortable interfacing with business users
  • Adaptability to change

Marsh McLennan (NYSE: MMC) is a global leader in risk strategy and people advising clients in 130 countries across four businesses: Marsh Guy Carpenter Mercer and Oliver Wyman. With annual revenue of $24 billion and more than 90000 colleagues Marsh McLennan helps build the confidence to thrive through the power of perspective. For more information visit or follow on LinkedIn and X.

Marsh McLennan is committed to creating a diverse inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age background disability ethnic origin family duties gender orientation or expression marital status nationality parental status personal or social status political affiliation race religion and beliefs sex/gender sexual orientation or expression skin color or any other characteristic protected by applicable law.

Marsh McLennan is committed to hybrid work which includes the flexibility of working remotely and the collaboration connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one anchor day per week on which their full team will be together in person.


Required Experience:

IC

Employment Type

Full-Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.