ShiftCode Analytics
Senor Data Apps Engineer - Finserv
ShiftCode Analytics, Berkeley Heights, New Jersey, us, 07922
Interview: F2F
Visa: USC and GC
Onsite: Berkeley Heights, NJ (Need local)
JD: What does a great Senior Data AppOps Engineer do? In this role, you will help build and support Data Analytic and Operational reporting applications with a focus on supporting Data Warehouse and Business Intelligence solutions. Your work will influence the success of companies across the world. Members of our Technology team are experts in the field, working to evaluate and improve today's systems while building tomorrow's.
Additionally, you will focus using analytical and troubleshooting skills to provide project participation, support continuity, and rotating on-call escalation. You will also lead detection and troubleshooting of issues that affect delivery of services for industry leading Data products. Teamwork and creativity are essential to this role. As a go-to point of escalation you will be challenged with resolving card holder impacting issues in a fast-paced environment.
Essential Role Responsibilities:
Provide hands-on support for existing environments to include performance of the following related tasks: software installation, upgrades, query writing, configuration, security, system monitoring and tuning, disaster recovery planning, and release deployments. Automate and evolve deployment strategies and testing to support a quick turnaround of deployments. Work closely with Engineering to ensure all relevant KPI's are implemented within the monitoring framework. Participate in all Production Support activities during incidents and outages. Hands-on technical resource capable of resolving technical issues and making recommendations for application performance and capacity improvements. Participate in capacity planning, tuning systems stability, provisioning, performance, and scaling of the application infrastructure. The desire to resolve issues for a 24x7 environment in a non-impacting yet fast-paced resolve time. Create and maintain technical support documentation. Basic Qualifications for Consideration:
Bachelor's degree required; relevant, equivalent work experience may be substituted for degree requirement IT experience in a technical application production support role or equivalent Ability to design and support DW/BI solutions, technically lead a team on various ETL and BI tools A good experience in ETL development for 4-6 years and with hands-on experience in a migration or data warehousing project Expert knowledge in writing SQL commands, queries and stored procedures Good knowledge of ETL tools like SSIS, SSRS, etc. and data warehousing concepts Analytical problem solving skills to solve complex problems and independent judgement to identify problems and recommend solutions Able to work effectively, both independently and as a member of a cross-functional team Demonstrate a desire to automate as much as possible Able to participate in on-call rotation Skills in ETL, Cognos, Informatica/IDMC, AWS EKS, QLIK, Business Objects, Netezza, Snowflake, Kafka, SQL, UNIX, Qlik, Oracle PREFERRED QUALIFICATIONS:
Good to have .NET programming experience Understanding of ETL best practices, Informatica, Netezza, Alteryx, and Tableau. Experience with AWS services and Snowflake Linux and Windows system administration - ability to manage and troubleshoot Linux systems and services, bash scripting Networking: solid understanding of routing and networking concepts Experience working in an Agile development environment Collaboration platforms such as JIRA, Confluence, Wiki, ServiceNow Familiarity with infrastructure as code (IaC) tools like Terraform or Ansible
JD: What does a great Senior Data AppOps Engineer do? In this role, you will help build and support Data Analytic and Operational reporting applications with a focus on supporting Data Warehouse and Business Intelligence solutions. Your work will influence the success of companies across the world. Members of our Technology team are experts in the field, working to evaluate and improve today's systems while building tomorrow's.
Additionally, you will focus using analytical and troubleshooting skills to provide project participation, support continuity, and rotating on-call escalation. You will also lead detection and troubleshooting of issues that affect delivery of services for industry leading Data products. Teamwork and creativity are essential to this role. As a go-to point of escalation you will be challenged with resolving card holder impacting issues in a fast-paced environment.
Essential Role Responsibilities:
Provide hands-on support for existing environments to include performance of the following related tasks: software installation, upgrades, query writing, configuration, security, system monitoring and tuning, disaster recovery planning, and release deployments. Automate and evolve deployment strategies and testing to support a quick turnaround of deployments. Work closely with Engineering to ensure all relevant KPI's are implemented within the monitoring framework. Participate in all Production Support activities during incidents and outages. Hands-on technical resource capable of resolving technical issues and making recommendations for application performance and capacity improvements. Participate in capacity planning, tuning systems stability, provisioning, performance, and scaling of the application infrastructure. The desire to resolve issues for a 24x7 environment in a non-impacting yet fast-paced resolve time. Create and maintain technical support documentation. Basic Qualifications for Consideration:
Bachelor's degree required; relevant, equivalent work experience may be substituted for degree requirement IT experience in a technical application production support role or equivalent Ability to design and support DW/BI solutions, technically lead a team on various ETL and BI tools A good experience in ETL development for 4-6 years and with hands-on experience in a migration or data warehousing project Expert knowledge in writing SQL commands, queries and stored procedures Good knowledge of ETL tools like SSIS, SSRS, etc. and data warehousing concepts Analytical problem solving skills to solve complex problems and independent judgement to identify problems and recommend solutions Able to work effectively, both independently and as a member of a cross-functional team Demonstrate a desire to automate as much as possible Able to participate in on-call rotation Skills in ETL, Cognos, Informatica/IDMC, AWS EKS, QLIK, Business Objects, Netezza, Snowflake, Kafka, SQL, UNIX, Qlik, Oracle PREFERRED QUALIFICATIONS:
Good to have .NET programming experience Understanding of ETL best practices, Informatica, Netezza, Alteryx, and Tableau. Experience with AWS services and Snowflake Linux and Windows system administration - ability to manage and troubleshoot Linux systems and services, bash scripting Networking: solid understanding of routing and networking concepts Experience working in an Agile development environment Collaboration platforms such as JIRA, Confluence, Wiki, ServiceNow Familiarity with infrastructure as code (IaC) tools like Terraform or Ansible