- The Data Analyst provides technical support for enterprise applications and data/reporting platforms, including Enterprise Invoice Management/Enterprise Service Management (EIMESM), Snowflake, and Tableau.
- EIMESM system is a highly customized application which currently processes approximately $3.5 billion in invoicing, service delivery management and reporting across eight constituent agencies. The EIM/ESM system involves approximately 8,000 agency and provider users and 1,100 provider organizations.
- This position works closely with and serves as a technical resource to the Application/Solutions Architect, assisting with solution design, technical analysis, development, implementation, and ongoing application support.
- The role also provides hands-on administration of Snowflake and Tableau and works across application, infrastructure, database, reporting, and business teams to maintain reliable and secure technology environments.
|
Application Architecture & Technical Support
- Support the Application/Solutions Architect in evaluating, designing, documenting, and implementing application solutions and enhancements.
- Assist with translating business requirements into technical specifications, designs, and implementation plans.
- Provide technical analysis and recommendations related to application architecture, databases, interfaces, middleware, infrastructure, and integrations.
- Develop and maintain technical designs, application documentation, diagrams, and implementation artifacts.
- Support technical reviews of application changes, database scripts, interfaces, and production releases.
- Participate in application modernization and enhancement initiatives under the technical direction of the Application/Solutions Architect.
- Serve as a technical resource to development, QA, infrastructure, operations, and business teams.
Application & Production Support
- Develop and maintain a strong understanding of EIMESM application components, databases, interfaces, middleware, operating systems, and supporting infrastructure.
- Work with the client, and other technical teams to support production and non-production environments.
- Coordinate and support application installations, configurations, deployments, upgrades, and production releases.
- Troubleshoot complex application, database, interface, infrastructure, and batch-processing issues.
- Perform or support application database administration and UNIX application administration activities.
- Maintain technical documentation, operating procedures, and application knowledge-base information.
- Support production operations and participate in on-call activities as required.
Snowflake & Tableau Administration
- Administer and support enterprise Snowflake and Tableau environments, ensuring availability, security, performance, and reliability.
- Manage Snowflake databases, schemas, warehouses, users, roles, permissions, and platform configurations.
- Monitor Snowflake workloads, queries, storage, and compute utilization and assist with performance and cost optimization.
- Administer Tableau Server and/or Tableau Cloud, including users, groups, permissions, projects, data sources, queries, dashboards, workbooks, extracts, schedules, and subscriptions.
- Monitor Tableau platform performance, extract refreshes, scheduled processes, and system utilization and troubleshoot operational issues.
- Manage Snowflake and Tableau access controls in accordance with enterprise security and data-governance standards.
- Support Tableau connectivity to Snowflake and other enterprise data sources.
- Support platform upgrades, integrations, configuration changes, capacity planning, and lifecycle management.
- Maintain administration standards, operating procedures, and technical documentation for both platforms.
Data, Reporting & Development Support
- Develop and support enterprise reports, queries, scripts, and data solutions.
- Support data reconciliation, database corrections, data archiving, query tuning, and performance optimization.
- Work with analysts and business stakeholders to translate reporting and data requirements into technical solutions.
- Support development and testing of application enhancements and technical fixes.
- Review database and production scripts for technical accuracy and operational readiness.
- Ensure batch processes and scheduled jobs are appropriately documented, monitored, and designed to operate efficiently with minimal manual intervention.
Collaboration & Customer Support
- Collaborate with the Application/Solutions Architect and application, infrastructure, security, database, data, and business teams.
- Proactively investigate and resolve application and customer issues and coordinate resolution across technical teams.
- Communicate task, project, and issue status clearly to management and stakeholders.
- Maintain current technical knowledge and share information and best practices with team members.
REQUIRED SKILLS (Special Skill Set, Abilities, Knowledge):
Experience with several of the following is preferred:
- Snowflake administration and performance optimization
- Tableau Server and/or Tableau Cloud administration
- Oracle, SQL Server, SQL, and PL/SQL
- Java and enterprise application development
- UNIX/Linux and shell scripting
- AWS/cloud environments
- Application interfaces and system integrations
- Database administration and query tuning
- Enterprise reporting and analytics
- XML/XSLT and service-oriented architecture
- HIPAA/HL7 environments
- Production application and batch-processing support
|