IS Snowflake Administrator
CareOregon
- Snowflake, AZ
- $120,000-145,200 per year
- Permanent
- Full-time
- Assess the current performance and efficiency of the Snowflake data platform (running system diagnostics).
- Participate in establishing, monitoring, and reporting on target goals for data management and system performance improvements.
- Identify optimal approaches for resolving Snowflake platform issues to achieve targets.
- Work within and beyond data management areas to implement system improvement approaches.
- Monitor and track ongoing system performance levels.
- Ensure that optimal system performance is maintained so that the data can effectively support business processes.
- Proactively and timely resolve or escalate Snowflake platform issues.
- Work in a collaborative fashion with other Snowflake Administrators, data analysts, and overall IT management team.
- Escalate issues exceeding the scope of this position to IT leadership or other business leaders.
- Influence changes to business processes and restrict access to applications and data to resolve behaviors impacting negatively on system performance.
- Identify system performance metrics and execute system audits to benchmark the state of Snowflake platform.
- Participate in development of monitoring and alerting solutions for identifying potential system performance issues.
- Regularly monitor alerts and take appropriate actions to resolve issues before they impact business activities.
- Regularly expose system performance metrics via standard reporting mechanisms (for example, system performance scorecard or dashboard).
- Engage with business leadership to quantify and articulate the business impact of system performance issues.
- Follow prescribed methodologies to execute system improvement projects.
- Actively participate in the design and deployment of data integration processes to ensure standards and controls to ensure high-quality of data are implemented.
- Publicize successes to further engage individuals at all levels of the organization.
- Perform work in alignment with the organization's mission, vision and values.
- Support the organization's commitment to equity, diversity and inclusion by fostering a culture of open mindedness, cultural awareness, compassion and respect for all individuals.
- Strive to meet annual business goals in support of the organization's strategic goals.
- Adhere to the organization's policies, procedures and other relevant compliance needs.
- Perform other duties as needed.
- Minimum 3 years' experience with Tableau, SQL, Snowflake and MS Azure cloud
- Minimum 3 years' experience monitoring and maintaining ETL pipelines with Azure data factory
- Minimum 3 years' experience with statistical software packages, such as Python, R or SAS
- Minimum 3 years' experience that includes some or all of the following:
- Analyzing data quality and recommending process improvements
- Continuously monitoring data quality and associated reports
- Engaging both technical and non-technical stakeholders
- Implementing data quality initiatives
- Experience with Agile frameworks
- Experience working in health care payer/managed care organizations
- Experience in planning or leading data quality initiatives
- Familiarity with and basic knowledge of statistics, control charts and process controls
- Experience in the healthcare or health insurance industry
- Experience with Health Plan business processes
- Experience with Medicaid and Medicare programs
- Experience with SQL Server tools like SSIS, SSAS, and SSRS
- Deep understanding of Snowflake architecture, features, and capabilities
- Strong knowledge of system development methodologies
- Comprehensive knowledge of SQL Server databases including administration, query optimization, and troubleshooting
- Strong knowledge of data warehousing concepts including ETL processes, data modeling, and data architecture
- Understanding of the healthcare insurance sector, including industry-specific data structures, terminologies, and privacy laws
- Proficiency in SQL and other scripting languages like Python
- Ability to perform database administration, performance tuning, and data modeling
- Ability to troubleshoot complex database issues and come up with effective solutions
- Ability to manage multiple projects concurrently, prioritizing tasks based on business needs, and meeting project deadlines
- Ability to clearly and effectively communicate complex technical information to non-technical team members and stakeholders
- Ability to work effectively in a team and collaborate with diverse groups of professionals including data analysts, IT staff, and business stakeholders
- Ability to adapt to changing business needs, new technologies, and evolving industry standards
- High degree of attention to detail when designing, testing, and maintaining data management systems
- Ability to learn new skills and staying up to date with industry trends and best practices
- Ability to learn, focus, understand, and evaluate information and determine appropriate actions
- Ability to accept direction and feedback, as well as tolerate and manage stress
- Ability to see, read, and perform repetitive finger and wrist movement for at least 6 hours/day
- Ability to hear and speak clearly for at least 3-6 hours/day