Application Data Analyst

JOB TITLE: Application Data Analyst
JOB LOCATION: Quincy MA
WAGE RANGE*: $60-$62
JOB NUMBER: ITS77-EHS-FY27-DATA ANAL- 004-
JOB DESCRIPTION:
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 EOHHS constituent agencies, as well as the Executive Office of Veteran Services (EOVS). 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. JOB DUTIES (Detailed Statement of Duties and Responsibilities):
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 EOHHS, EOTSS/AWS, 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
Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities

• While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.