Role Overview:

• The person will be part of the Global Technology team for a major Insurance client. He/ She will work as a Senior Cloud Engineer within the CDO EDP team and will have the opportunity to work one-on-one with application and infrastructure developers to build and enhance the data infrastructure and application patterns that power mission-critical applications, ensuring that they are engineered for high availability, durability, and resiliency
• They will be part of an agile team that combines various backgrounds, experiences, and perspectives to solve complex problems within AWS and beyond.
• The person will also be required to participate actively in brainstorming sessions for improvement opportunities and take it to completion
• A suitable candidate should have 8+ years of IT experience with at least 5+ years of experience working as an AWS Data Engineer. He/ She should be able to deal with ambiguity.
• Experience in life insurance preferred but not mandatory.

Key Responsibilities & Skillsets:

• Common Skillsets:
  • Superior analytical and problem solving skills
  • Should be able to work on a problem independently and prepare client ready deliverable with minimal or no supervision
  • Good communication skill for client interaction

Application development Skillsets:

• Ability to debug, optimize code, and automate routine tasks
• A systematic problem-solving approach coupled with a strong sense of ownership and drive
• Ability to quickly pickup and understand where newly released cloud services would be appropriate for business applications
• Experience with infrastructure automation tools such as Puppet, Ansible, CloudFormation, or Terraform
• Working knowledge of pipeline-automation tools such as Jenkins, CodePipeline, Azure DevOps, or other comparable tools
• Experience using Git for source control management
• Ability to proficiently write code in Python, Node.js, Bash (shell), PowerShell, or other similar languages
• Experience using Docker within container orchestration platforms such as AWS ECS, EKS, Google Anthos, or others
• Comfortable in a Linux environment
• Understanding of foundational AWS services such as VPCs, EC2, S3, RDS, Auto Scaling Groups, CloudWatch Logs, etc.
• In-depth knowledge of security and IAM within AWS, including the management and operation of Security Groups, KMS Keys, VPC NACLs, and SCPs
• Familiar with ETL and big data tool-chains such as those provided by Hadoop/EMR, Glue, Spark, Impala, or similar
• Understanding of relational database systems and how applications interact with them
• Familiarity with one or more log and event aggregation and monitoring systems such as Splunk, Elasticsearch (ELK), Prometheus, Grafana, or similar

Candidate Profile:

• Bachelors/Master's degree in computer science/engineering, operations research or related analytics areas welcome to apply
• 7+ years experience in AWS Data Engineering, preferably in Life Insurance but not mandatory
• Application development experience
• Team Management
• Superior analytical and problem solving skills
• Outstanding written and verbal communication skills
• Able to work in fast pace continuously evolving environment and ready to take up uphill challenges
• Is able to understand cross cultural differences and can work with clients across the globe
• Preferably based out of the New Jersey area with at least two days of work from office at the clients location

Role and Responsibilities Overview:

• Oversee all aspects of quality assurance including establishing and reporting on metrics, applying industry best practices and developing new tools and processes to ensure quality goals are met.
• Adhere to formal QA processes, ensuring that the Systems Implementation (SI) team is using Industry accepted best Practices.
• Ensure data accuracy in both SQL and SSIS. Detailed and effective written communication skills documenting the features tested and bugs found.

• Database testing
  • Database design Normalization, Administration, Security
  • ETL testing
  • Master Data Management
  • Reference Data management
  • Knowledge of different type of Keys in Database Management
  • Working knowledge of any of these databases DB2, Oracle, SQL Server etc.

• Extensive experience in writing test cases, test Scenarios, defect reporting
• Proficient in test planning, Quality Assurance, defect tracking
• Proficient in Analyzing bugs and interacting with development teams
• Document necessity of performance optimization, identify the stale & error calculations.
• Act as key point of contact for all QA aspects of releases, providing test services and coordinating QA resources internally and externally in SQL.
• Create and Provide Feedback on test cases, scripts, plans and Procedures (manual and automated) responsible for executing them.
• The entire software development life cycle and test cycles (unit, Regression, Functional, Systems, stress& scale, smoke and sanity)
• Strong experience in functional testing and test automation.
• Process breakdown & testing the different scenarios at every step.
• Diagnose defects and track them from discovery to resolution.
• Ensure the the SI maintains High quality and accuracy up to software release.
• Ensure all testing work is carried out in accordance with the testing plan, Including schedule and quality requirement.
• Collaborates with data warehouse architect, the ETL lead and BI developers in the construction and execution of test scenarios including those applicable to the development, test and production data warehouse environment.
• Able to lead & mentor offshore team members (4 - 5)

Candidate Profile

• Bachelors/Master's degree in computer science/engineering, operations research or related analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to apply
• Insurance Industry knowledge preferred.
• Proficient in SQL queries, sub queries, and complex joins for generating stored procedures.
• Experience working in ETL projects and ETL technologies like SQL Server Integration Services (SSIS).
• Good Understanding of Data Warehouse concepts such as Dimensions and Facts tables, SCD, OLAP, OLTP etc.
• Experience extracting and manipulating data from relational databases with advanced SQL.
• 5-8 years of QA experience.
• Able to test the data ingestion/curation pipelines.
• Experience with the test artifacts (test strategy, test cases, defect logs, status report)
• Able to write nonfunctional and negative test cases.
• Outstanding written and verbal communication skills
• Able to work in fast pace continuously evolving environment and ready to take up uphill challenges.
• Able to understand cross cultural differences and can work with clients across the globe.
• Self-Motivated, works well independently and with others.
• Using metrics-driven approach and closed loop feedback to improve software deliverables and improve predictability and reliability of releases.

In this role associate will be responsible for designing reports and dashboards as per the business requirements and coordinate across different teams for data integration. As a Tableau Developer you will also be part of a team that has the responsibility for the definition, design and implementation of the Business Intelligence solutions for all functional operations areas within the organization. You will process documentation to produce the required reporting and analytics deliverables using Tableau Software.

The ideal candidate for this position will come from a healthcare background (preferred) and is a proactive thinker, self-starter, who enjoys working in a fast-paced and challenging environment with the ability to work independently.

Role and Responsibilities:

• Develop Dashboards/Metrics reports using Tableau platform
• Gather, interpret, and analyze business requirements and use cases, develop concepts/mock-ups via iterative practices, and design reporting solutions (dashboards, scorecards etc.) that meet use cases/requirements, as well as achieve ease of usability and self-service capabilities
• Perform data integration, write efficient SQL Queries, and develop/deploy reporting solutions that apply data visualization standards and best practices, and meets quality standards by performing unit testing
• Work in a fast-paced Agile environment especially as it pertains to new idea generation

Other Essential Duties:

• Create documentation and technical specifications for reporting solutions, develop procedures/standard work, support readiness/training activities to end users
• Perform routine maintenance support, and troubleshoot reported issues as well as determine root causes, and implement counter measures
• Execute performance-tuning to achieve optimal performance
• Oversee and validates integration of source data into the target environment
• Identify process improvement opportunities
• Interface with key business and project team members to facilitate seamless execution of requirements
• Analyze and resolve cross-functional data issues
• Collect data, analyze, and report for early detection and correction, continual improvement.
• Develop reports in a consistent best practices format
• Coordinate new reporting requests/changes to ensure accuracy and consistency of reports
• Monitor and troubleshoot escalated support tickets
• Additional duties as assigned

Candidate Profile:

• BS degree in Computer Science, Computer Engineering, or other technical degree.
• 6+ years of experience in Software Design, Development, Implementation and Maintenance of Business Intelligence
• Must have US Healthcare domain experience (min 4 years)
• Must have 4+ hands-on experience with Tableau (and share examples of development work)
• Must leverage advanced Tableau functionality (parameters, actions, tooltip modifications, LODS, API, etc.) to create analytical and complex interactive dashboards
• Experience with tableau Desktop version 8.x or newer, SQL, Database management, data visualization and discovery
• Very strong experience with SQL and writing complex queries
• Disciplined with effective execution Demonstrate a disciplined approach; deployment, and follow-through to ensure achievement of results. Capable of working with a high degree of discretion, employing effective customer service and communication methods
• Ability to understand and communicate technical concepts at business and also entry user level

• Effectively resolves problems and roadblocks as they occur.
• Demonstrates good written and verbal communication skills.
• Worked in a team environment and also coordinated with business/functional team

Product Management (2 positions)

• Understanding of end to end product roadmap
• Great communication and Negotiation skills
• Agile way of working
• Requirements gathering to post implementation
• Product lifecycle
• Hands on (SQL)

Business Analyst

Key Responsibilities

• Coordinate across functional groups to review and interpret business issues and needs to develop accurate Business Requirements
• Perform requirements analysis
• Evaluate business processes, develop and implement robust solutions and identify areas of improvement
• Lead multi-functional group reviews of issues and process to successfully drive initiatives to completion
• Complete documentation of initiatives and communicate status and results
• Ensure initiative documentation is complete, accurate, and sored for validation and auditing
• Gather critical information from meetings and assist in developing and communicating reporting to business groups and management
• Work closely across internal business groups and Technology and external vendors
• Ensure solutions meet the business needs and requirements
• Effectively manage projects including developing plans and monitoring performance
• Prioritize initiatives based on regulatory, financial, and customer impact; escalate as necessary
• Serve as a point of contact and liaison between stakeholders
• Ensure timely and accurate completion of initiatives
• Research data required to properly execute queries
• Work in a controlled environment to mitigate risk and provide accurate and timely results by following controlled processes

Additional Responsibilities

• · Ensure query business requirements, structure, output, and approvals are captured and stored for audit and review
• · Partner with other teams to develop and maintain relationships by engaging stakeholders to establish credibility, solve problems, build consensus and achieve objectives as required
• · Assist to coordinate efforts to investigate exceptions and errors with regard to business processes to identify root cause and solutions
• · Assist in identifying and/or resolving risk and controls issues impacting the business, including assisting in the conducting of control reviews or gap analyses for existing processes as needed
• · Review, analyze, and prioritize initiatives, transactions, and processes that have compliance and regulatory impacts
• · Coordinate and collaborate with various functions / departments and project teams across multiple locations
• · Partner with other teams to develop and maintain relationships by engaging stakeholders to establish credibility, solve problems, build consensus and achieve objectives
• · Design/re-design for continuous improvement using Agile, Lean & Six Sigma principles and methods

Skills and qualifications

• · Bachelors degree and/ or equivalent work experience
• · Financial Industry experience preferred
• · 3+ years of relevant Business Analyst experience
• · Exceptional analytical and conceptual thinking skills
• · Sense of ownership and pride in performance
• · The ability to influence stakeholders of all levels and work closely with them to develop solutions
• · Excellent documentation skills
• · Experience in creating Business Requirements, reports, and presentations
• · Highly motivated, energetic, personable, thorough, detail oriented, and ability to multitask
• · Good problem-solving skills.
• · Team player with the ability to work independently
• · Excellent time-management, planning, and prioritization skills
• · Extremely detail-oriented and ability to prioritize and see initiatives through to completion
• · Able to work in a fast-paced organization and meet deadlines
• · Proficiency with Microsoft products, MS Word, MS Excel SQL and MS Power Point

SQL Developer

Key Responsibilities

• Review and interpret Business Requirements to develop high-quality SQL queries and code that meet business needs
• Execute Test Scripts and stored procedures for newly developed functionality
• Research data required to properly execute queries
• Analyze existing SQL queries for performance efficiency and accuracy
• Audit query output and results and effectively communicate to business groups
• Support business units with SQL and development support as needed; Escalate issues or concerns as necessary
• Ability to solve advanced problems and deal with a variety of options in complex situations requiring advanced analytical and quantitative skills
• Make recommendations to drive company business decisions and outcomes
• Assist in the development of reporting solutions leveraging SQL queries and data knowledge
• Work in a controlled environment to mitigate risk and provide accurate and timely results by following controlled development and validation processes

Additional Responsibilities

• · Ensure query business requirements, structure, output, and approvals are captured and stored for audit and review
• · Partner with other teams to develop and maintain relationships by engaging stakeholders to establish credibility, solve problems, build consensus and achieve objectives as required
• · Investigate exceptions and errors with regard to business processes to identify root cause and solutions
• · Assist in identify and/or resolve risk and controls issues impacting the business, including conducting control reviews or gap analyses for existing processes, as needed
• · Review and analyze transactions and processes for compliance with regulatory requirements
• · Coordinate and collaborate with various functions / departments and project teams across multiple locations
• · Partner with other teams to develop and maintain relationships by engaging stakeholders to establish credibility, solve problems, build consensus and achieve objectives
• · Design/re-design for continuous improvement using Agile, Lean & Six Sigma principles and methods

Skills and qualifications

• · Bachelors degree and/ or equivalent work experience
• · Relevant Financial Industry experience
• · 3+ years of relevant SQL development experience
• · Sense of ownership and pride in performance
• · Strong analytical skills
• · Outstanding verbal and written communication skills
• · Highly motivated, energetic, personable, thorough, detail oriented, and ability to multitask
• · Good problem-solving skills.
• · Team player with the ability to work independently
• · Excellent time-management and prioritization skills
• · Proficiency with Microsoft products, MS Word, MS Excel SQL and MS Power Point
• · Extremely detail-oriented and ability to prioritize and see initiatives through to completion
• · Able to work in a fast-paced organization and meet deadlines