Full Job Description
Job Summary The Data Analyst / Application and Data Platform Specialist will provide technical support for enterprise applications and data and reporting platforms, including Enterprise Invoice Management/Enterprise Service Management (EIM/ESM), Snowflake, and Tableau. The role will support application solution design, technical analysis, development, implementation, and ongoing application support while providing hands-on administration of Snowflake and Tableau environments. The position will collaborate across application, infrastructure, database, reporting, security, and business teams to maintain reliable, secure, and efficient technology environments.
Key Responsibilities
• 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.
• Develop and maintain a strong understanding of application components, databases, interfaces, middleware, operating systems, and supporting infrastructure.
• Work with 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.
• Administer and support enterprise Snowflake and Tableau environments to ensure 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 support 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 Snowflake and Tableau.
• 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.
• Collaborate with application, infrastructure, security, database, data, and business teams to resolve technical issues.
• 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 Qualifications
• Bachelor's degree in Information Technology, Computer Science, Business, or a related field, or equivalent education and experience.
• 5+ years of professional information technology experience in application development, systems analysis, database administration, platform administration, or production support.
• Experience with Snowflake administration and performance optimization.
• Experience with Tableau Server and/or Tableau Cloud administration.
• Experience with Oracle, SQL Server, SQL, and PL/SQL.
• Experience with Java and enterprise application development.
• Experience with UNIX/Linux and shell scripting.
• Experience with AWS or other cloud environments.
• Experience with application interfaces and system integrations.
• Experience with database administration and query tuning.
• Experience with enterprise reporting and analytics.
• Experience with production application and batch-processing 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.
Preferred Qualifications
• Experience with XML/XSLT and service-oriented architecture.
• Experience working in HIPAA/HL7 environments.