Appian Dev-Reporting & Analytics
NYC Department of Finance · Manhattan, NY · 2 days ago
Analyst$125k–$140k/yrFull-time
Responsibilities
- Build and maintain high-impact Appian dashboards and user interfaces using SAIL (Self-Assembling Interface Layer), Record Views, and Process HQ, ensuring data is accurate and visually intuitive.
- Agregate, format, and structure data within Appian’s Data Fabric to ensure reports update dynamically as new cases and data are processed.
- Develop and configure reporting features, Appian reports, and analytics.
- Build, and maintain report objects, data visualizations, process mining, and reporting solutions within the low-code Appian platform.
- Write and optimize complex SQL queries to extract and integrate data from relational databases, APIs, and enterprise systems into the front-end UI.
- Monitor and perform troubleshooting related to Appian performance. Report response times and suggest logic, data structure, or indexing tweaks to prevent bottlenecks and maintain data integrity.
- Design, develop, and deploy enterprise-grade, highly integrated, complex web and mobile environment applications, harnessing your knowledge of data structures, algorithms, and design patterns to develop full stack and low-code platform solutions, utilizing frameworks such as process models, record actions, Rules, Expressions, custom web interfaces SAIL (Self-Assembling Interface Layer), custom plug-ins and other out of the box tools.
- Utilize APIs and SQL queries to seamlessly pull and map data from external enterprise systems into Appian for unified reporting.
- Work alongside Business Analysts and stakeholders to translate business goals into analytical frameworks. Translate business requirements into functional, real-time dashboards to optimize operational workflows.
- Contribute to the architectural design and development of complex low-code applications, ensuring they are scalable, reliable, secure, and aligned with DOF’s business objectives.
- Foster a culture of learning and growth. Perform application reviews, providing constructive feedback on quality, design and implementation that help ensure applications meet high standards of performance and reliability.
- Test and debug applications to ensure cross-browser compatibility, responsiveness, and performance optimization.
Qualifications
- A baccalaureate degree from an accredited college and four years of satisfactory full-time experience related to the area(s) required by the particular position; or, Education and/or experience which is equivalent to "1" above.
- 5+ years of hands-on experience in business intelligence, dashboard design, or process automation, with specific expertise developing applications on low code platforms such as Appian.
- Experience building and delivering enterprise-grade software applications in a high-volume or critical production service environment, with familiarity of production environments (application servers, web servers, databases).
- Write complex Appian Custom Data Types (CDTs), create optimized database views, stored procedures, and queries.
- Map data using Appian Records and localized synchronization features. Integrate external data sources via Web APIs and integrations.
- Proficiency in using data visualization tools such as Tableau, Power BI, or similar platforms (i.e. Appian).
- Knowledge of business Objects and ETL tools would be nice to have.
- Hands-on experience building solutions using Appian's proprietary features (Process Modeler, SAIL, Records, Reports).
- Strong understanding of development fundamentals like HTML, CSS, and JavaScript, JSON is crucial, even with low-code platforms. Custom development using Java, Python, JavaScript, SQL, HTML, XML, XSL, etc.
- Understanding of design principles and best practices for creating clear, effective, and visually appealing data visualizations. Familiarity with Appian Process HQ or similar process mining/analytics tools.
- Experience working collaboratively with data engineers, data scientists, and other team members. Experience analyzing and interpreting data to identify trends, patterns, and insights.
- Optimize slow-running reports and heavy database queries. Establish data aggregation models for high-volume process metrics. Maintain security models for data visibility.
- Strong proficiency in MySQL, MariaDB, Oracle, SQL or PostgreSQL.
- Strong analytical mindset. Clear communication skills, problem-solving abilities, and Agile methodology experience.
- Understanding of responsive design principles that ensure applications function seamlessly across various devices and screen sizes. Experience with web accessibility standards is also crucial to ensure web content is usable by individuals with disabilities.
- Strong verbal and written communication skills experience with customer interaction, requirements analysis, and presentations.
- Industry certifications such as Appian Certified Developer and/or certified Java Developer etc. is preferred.
Pay
$125,000.00 – $140,000.00