ETL UI Developer
New York, NY

Job Description

Position Summary

The Developer will be responsible for assisting in the implementation of a data management solution. This includes the analysis, design, development, testing, installation, and initial maintenance of the solution and acting as interface with customers and other developers to determine the most efficient and cost-effective approach to meeting business requirements. The position will utilize a variety of hardware and software technologies and would include system integration, new code construction, modifications to existing modules, and package implementations. This position will apply disciplined software development methodology and utilize leading edge technologies to engineer and implement solutions for business problems. He/she will display technical and functional competence in data management standards and uphold Guardian's commitment to Guardian values.

Candidate Responsibilities

* Collaborate with team members, IT, and software consultants to ensure functional and business specifications are converted into flexible, scalable, and maintainable solution designs
* Develop and implement software to support data warehouse and system integration strategies that utilize data marts and/or data warehouse systems to enhance business processes and manage business intelligence
* Design and manage data models for applications, metadata tables, and views, ensuring system, data and reporting standards, security, performance, robustness and reliability
* Establish analytic environments required for structured, semi-structured and unstructured data
* Develop data quality metrics that identify gaps and ensure compliance with Investment and Enterprise wide standards
* Active role in quality assurance (QA) and user acceptance testing (UAT) for data and solution initiatives by providing test plans and testing support, attending team meetings, and documentation.

Functional Skills

Required

* 4 to 7 years of overall experience in Investments and Insurance data and systems management, data science, programming, and information systems
* Experience with an Enterprise Data Management Tool (Markit EDM, GoldenSource, etc.) or Data Warehouse /ETL (IBM Datastage, Informatica, etc.
* Experience building various in-bound and out-bound feeds (Markit, Bloomberg, PAM, etc.)
* Understand and support business data needs; understand data layout and resulting business impact
* Track record of collaborating with IT, Business and vendor teams to provide technical solutions and improvements, delivering end-to-end products/processes on schedule and budget, as per business requirements and SDLC standards, including addressing performance and ad-hoc requests
* Working knowledge of financial investments
* Works effectively with associates across business and IT functional teams
* Adapt to changing business priorities and environments
* Strong Agile experience and the ability to work on a cross functional, self-organizing development team. SAFe experience is a plus

Plus

* Experience with BI Systems

Position Qualifications

* Bachelor degree in management information systems, computer science, or a related field
* UNIX scripting experience
* Strong development experience: Java, .Net, SQL, VBA, R, Python, or similar programming languages, EMS/JMS, ETL
* Amazon Web Services experience
* Tableau experience (or any other visualization tool)
* Strong knowledge of Excel
* Strong mathematical, analytical, and communication skills

Travel

* This position will be primarily located in our New York City, NY (Headquarters) office.

Guardian2019

Every day, Guardian gives 26 million Americans the security they deserve through our insurance and wealth management products and services. Since our founding in 1860, our long-term view has helped our customers prepare for whatever life brings whether starting a family, planning for the future or taking care of employees. Today, we're a Fortune 250 mutual company and a leading provider of life, disability and other benefits for individuals, at the workplace and through government sponsored programs. The Guardian community of ~9000 employees and our network of over 2750 financial representatives is committed to serving with expertise when, where and how our clients need us. Our commitments rest on a strong financial foundation, which at year-end 2017 included $8.0 billion in capital and $1.6 billion in operating income. For more information, please visit guardianlife.com or follow us on Facebook, LinkedIn, Twitter and YouTube.

Guardian® is a registered trademark of the Guardian Life Insurance Company of America.

Guardian is an equal opportunity employer. All qualified applicants will be considered for employment without regard to age, race, color, creed, religion, sex, affectional or sexual orientation, national origin, ancestry, marital status, disability, military or veteran status, or any other classification protected by applicable law.