Data Analyst/ Application and Data Platform Specialist
LanceSoft
1 day ago
Full-time
On-site
Quincy, Massachusetts, United States
$58 - $60.71 USD hourly
Client: State of MA
Title: Application and Data Platform Specialist
Location: Quincy, MA
Duration: 12 Months
Summary (Job Overview):
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:
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.