Data Analyst/ Application and Data Platform Specialist

Lancesoft; Quincy (MA); On-site; USD 110,000 - 140,000; Full time

Job summary

State of MA is seeking an Application and Data Platform Specialist in Quincy, MA to support enterprise data apps and platforms, including Snowflake and Tableau. The role works with architects and technical teams on design, development, and ongoing support to ensure secure, reliable environments.

The candidate will administer Snowflake and Tableau, optimize performance, and contribute to data reporting solutions across multiple agencies. A strong IT background and teamwork are essential.

Qualifications

• Bachelor’s degree or equivalent education and 5+ years in IT.
• Experience with enterprise data platforms and reporting.
• Strong analytical, troubleshooting, and communication skills.

Responsibilities

• Support architecture evaluation, design, and implementation of applications and data platforms.
• Provide technical analysis for databases, interfaces, middleware, and infrastructure.
• Administer Snowflake and Tableau environments, manage security and performance.
• Develop technical designs, docs, and implementation artifacts.
• Collaborate with cross-functional teams and provide production support.

Skills

Snowflake administration

Tableau administration

SQL & PL/SQL

Unix/Linux scripting

AWS/cloud environments

Enterprise reporting

Data analysis

Problem solving

Education

Bachelor's degree in IT/CS or related field

Tools

Oracle

SQL Server

SQL

Job description

Client: State of MA Title: Application and Data Platform Specialist Location: Quincy, MA Duration: 12 Months Summary (Job Overview): 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

QUALIFICATIONS (Education, Years’Experience, Certificates)

Bachelor’s degree in Information Technology, Computer Science, Business, or a related field, or equivalent education and experience. Five or more years of professional information technology experience in application development, systems analysis, database administration, platform administration, or production support. Strong analytical, troubleshooting, and problem‑solving skills. Ability to manage multiple technical assignments and work independently while collaborating effectively with senior technical resources. Strong written and verbal communication and customer‑service skills.