Senior Business Analyst 67

Ariel Partners; New York (NY); On-site; USD 120,000 - 170,000; Full time

Job summary

Ariel Partners is seeking qualified candidates for IT solutions in database design, architecture, and development. The role focuses on data integrity, security, and governance across DSS programs.

You will design data models, implement ETL with IBM InfoSphere DataStage, develop reports in Cognos, and support inter-agency data exchanges. Responsibilities include requirements analysis, system design, data replication, and 24/7 ETL support.

Qualifications

• Minimum of 6 years of experience in relevant roles.
• Curam V7 Certified Developer with Enterprise Framework knowledge.
• Experience with Curam IE Gatherer (IEG2) and CERT for Triage.
• Proficiency in SQL, PL/SQL, UNIX Shell Scripting.
• Experience with data modeling (Star/Snowflake schemas) and ETL tooling (InfoSphere DataStage).
• Strong knowledge of WebSphere/ESB and Oracle environments.
• Experience with Cognos/BI reporting and data exchanges.
• Experience with Linux/UNIX environments and batch/job control.

Responsibilities

• Develop business and technical requirements and translate into technical tasks.
• Create system and process design documentation and data feeds.
• Develop and maintain ETL processes using IBM InfoSphere DataStage.
• Develop and maintain Oracle PL/SQL objects and complex queries.
• Support data replication and 24/7 ETL process availability.
• Collaborate with stakeholders and vendors for tool evaluation and upgrades.
• Prepare test protocols, UAT, and QA testing coordination.
• Provide environment support and system migration assistance.

Skills

Curam V7 Certified Developer

SQL/PLSQL

Unix Shell Scripting

Data Modeling

Data Warehousing

WebSphere/ESB

Oracle & BI tools

ETL Development

QA Testing

Education

Curam V7 Certification

Tools

HTML/JavaScript

Struts/Springs

Ajax/JQuery/Dojo

SQL*Loader/TOAD

Informatica/ Cognos/ BO

Job description

PROJECT DESCRIPTION: ITS serves all DSS program areas to fulfill their IT needs. To meet the business needs and ITS' workload, ITS is seeking qualified candidates in the areas of Database design, architecture, and development, including base definition, structure, documentation, long-range requirements, operational guidelines, and protection. Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries. Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of various systems that ITS supports across DSS program areas.

Tasks & Duties

• Develop Business and Technical Requirements
• Identify user stories and translate them into technical requirements
• Break down requirements into deliverable components
• Review requirements with stakeholders for approval
• Create system and process design documentation
• Develop and present business process mockups and data feeds
• Produce Source-to-Target mapping and transformation rules documentation
• Design and Development of Software Applications
• Develop conceptual, logical, and physical data models using Erwin; generate DDL scripts
• Perform data profiling and metadata management
• Design, develop, and implement ETL processes using IBM InfoSphere DataStage
• Support CARES DataMart updates and inter-agency data exchanges
• Develop reports using IBM Cognos Report Studio
• Participate in upgrades (Cognos, Attunity), proof of concepts, and solution evaluations
• Evaluate tools, coordinate with vendors, and support installation/configuration
• Implement data replication to the Operational Data Store using Qlik (Attunity)
• Provide Environment Support
• Develop and maintain Oracle PL/SQL objects (packages, procedures, functions, views, tables)
• Create complex queries for data validation and analysis
• Develop programs for data fixes and manual invoice generation
Maintain data exchange integrations with systems such as HOME Tracker, BCS, CPS, and OPPM
• Coordinate with networking teams and external agencies for data exchange
• Provide 24/7 support for ETL processes and data replication
• Enhance and maintain ETL programs following best practices
• Execute data fixes and manage batch jobs, including user access updates
• Support system migration, maintenance, and production issue resolution
• Management Reporting and Information Dissemination
• Analyze and document current systems and processes
• Recommend improvements based on stakeholder feedback
• Collaborate with business users, developers, and technical teams
• Perform system, integration, and user acceptance testing (UAT)
• Prepare test protocols and reports to meet audit requirements
• Coordinate Application Testing
• Prepare test environments for system integration testing and UAT
• Develop test cases and acceptance criteria
• Coordinate QA testing among QA teams, developers, and stakeholders
• Ensure adherence to IT quality assurance standards

MANDATORY SKILLS/EXPERIENCE

Note: Candidates who do not have the mandatory skills will not be considered

• A minimum of 6 years of experience with the following skill sets:
• Curam V7 Certified Developer Experience working in the technical architecture field.
• Cúram V7, Cúram Enterprise Framework Components, Cúram Intelligent Evidence Gathering (IEG2), Cúram Express Rules for Triage (CERT)
• HTML, DHTML, JavaScript, open source Java framework, (Struts/Springs), Ajax (JQuery, Dojo), SOA, and WebServices (Attunity/Qlik)
• Websphere, ESB or Message Broker, Eclipse, JIRA, Webservice, and Oracle
• Real world delivery experience
• SQL, PL/SQL, UNIX Shell Scripting.
• MS Visio, Star Schema Modeling, Snow Flake Modeling.
• SQL*LOADER, SQL Developer, TOAD, SQL*PLUS. DBArtisan, Perforce, PVCS, SSMA, RGS, SSMA, SSIS, SSRS
• Informatica 8, Business Objects X, XI, Oracle Reports, BM Cognos Version 10.2.2
• Linux, UNIX, Windows 2003/2000/NT.

At Ariel Partners, we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions, so when they have their biggest challenges, we are on their short list. We are looking for team members who share our values of: Integrity to do the right thing even when it hurts; Commitment to the long-term success and happiness of our customers, our people, and our partners; Courage to take on difficult challenges, accept new ideas, and accept incremental failure; and the constant pursuit of Excellence. Ariel Partners is an Equal Opportunity Employer in accordance with federal, state, and local laws.