AMVETS Jobs

We are a leading financial services provider committed to making decisions easier and lives better for our customers and colleagues around the world. From our environmental initiatives to our community investments, we lead with values throughout our business. To help us stand out, we help you step up, because when colleagues are healthy, respected and meaningfully challenged, we all thrive. Discover how you can grow your career, make impact and drive real change with our Winning Team today.

Working Arrangement

Hybrid

Job Description

Job Duties:

Responsible for expanding and optimizing company’s data and data pipeline architecture, integrating data with multiple systems, and monitoring, analyzing and optimizing infrastructure, network and hardware environment to best support testing and deployment in continuous integration/continuous delivery environment. Duties include:

• Collaborate with subject matter experts, product owners, business users, technical leads, business analysts and reporting teams to determine business needs and requirements to facilitate loading of data into data warehouse including creating ETL designs, mappings/sessions and workflows, performing gap analysis and recommending process improvements;

• Use knowledge of database architecture to study needs of business teams and propose database design solutions;

• Translate project architecture into efficient, scalable, maintainable and re-usable designs that are aligned with business and technical strategies;

• Analyze and patch data in datahub/datamart to resolve data issues reported by business teams;

• Translate requirements into business requirements documents, functional specs, ETL design docs and source to target documents;

• Handle end to end development of ETL/ELT process during discovery, design, coding, and production deployment;

• Create and maintain referential integrity, domain integrity and column integrity using database constraints;

• Maintain inventory of environment details and coordinate with development and release teams to migrate code across environments;

• Use input from business stakeholders to create and maintain data dictionaries for specifying data input and output formats;

• Use Master Data Management (MDM) and feedback from business owners, stewards and/or custodians to ensure master data and policies are up-to-date;

• Gather data metrics for business partners and research and suggest new technologies to improve business intelligence and data management across business functions;

• Perform unit testing, system testing and functional testing of ETL jobs using data feeds received from source vendors;Collaborate with QA and Development Teams to write test cases and perform data validation to test functionality of features or programs before deployment; and

• Collaborate with database administrators to optimize SQL queries, tune Informatica jobs and identify bottlenecks to enhance performance of slow running ETL jobs.

May telecommute from any U.S. location.

Minimum Requirements:

Bachelor’s degree or foreign equivalent in Computer Science, Computer Engineering, Information Technology, Electrical Engineering, Electronic Engineering or related field and 5 years of experience providing technical and business consulting services.

Experience must include:

• 5 years of experience designing, implementing and maintaining large-scale distributed systems using knowledge of software development lifecycle;

• 5 years of experience developing technical standards and strategic systems architecture to ensure business solutions adhere to strategic IT direction;

• 5 years of experience designing database solutions focusing on reusability of components within IT organization;

• 5 years of experience developing and reviewing technical design documents to ensure adherence to business and functional requirements for business initiatives, features and user stories;

• 5 years of experience providing guidance for development, unit/integration testing and implementation of simple and complex business solutions;

• 3 years of experience developing effective business/systems solutions including balancing complex business and technical issues;

• 3 years of experience developing and presenting cost/benefit analysis of business solutions including evaluating alternative vendor solutions;

• 5 years of experience providing systems support;

• 5 years of experience using structured analysis and design techniques including design and development tools, methodologies and techniques;

• 5 years of experience conducting technical assessments and estimation efforts for database initiatives;

• 5 years of experience evaluating industry trends and emerging technologies to provide competitive advantage to business.

Experience may be gained concurrently.

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services group that helps people make their decisions easier and lives better. With our global headquarters in Toronto, Canada, we operate as Manulife across our offices in Asia, Canada, and Europe, and primarily as John Hancock in the United States. We provide financial advice, insurance, and wealth and asset management solutions for individuals, groups and institutions. At the end of 2022, we had more than 40,000 employees, over 116,000 agents, and thousands of distribution partners, serving over 34 million customers. At the end of 2022, we had $1.3 trillion (US$1.0 trillion) in assets under management and administration, including total invested assets of $0.4 trillion (US $0.3 trillion), and segregated funds net assets of $0.3 trillion (US$0.3 trillion). We trade as ‘MFC’ on the Toronto, New York, and the Philippine stock exchanges, and under ‘945’ in Hong Kong.

Manulife is an Equal Opportunity Employer

At Manulife /John Hancock , we embrace our diversity. We strive to attract, develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment, retention, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour , ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy-related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process . All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies . To request a reasonable accommodation in the application process, contact .

Salary & Benefits

The annual base salary for this role is listed below.

Primary Location

Boston, Massachusetts

Salary range is expected to be between

$102,200.00 USD - $189,800.00 USD

If you are applying for this role outside of the primary location, please contact for the salary range for your location. The actual salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance.

Manulife/John Hancock offers eligible employees a wide array of customizable benefits, including health, dental, mental health, vision, short- and long-term disability, life and AD&D insurance coverage, adoption/surrogacy and wellness benefits, and employee/family assistance plans. We also offer eligible employees various retirement savings plans (including pension/401(k) savings plans and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in the U.S. includes up to 11 paid holidays, 3 personal days, 150 hours of vacation, and 40 hours of sick time (or more where required by law) each year, and we offer the full range of statutory leaves of absence.

Company: John Hancock Life Insurance Company (U.S.A.)