You will be responsible for managing, monitoring, and ensuring the optimal performance of the Snowflake data platform. Collaborating with the Data Management and Business Intelligence Teams, you will design, implement, and refine Snowflake environments and structures, addressing any issues identified promptly. This position will partner with the Data Development Teams to ensure that efficient data management procedures are embedded in the development and deployment processes. You will also escalate critical issues to the IT leadership team as necessary and ensure that the platform aligns with the company's data strategy and goals.
Remote (must reside in Oregon, Washington, Utah, Idaho, Arizona, Nevada, Texas, Montana, or Wisconsin) Responsibilities: 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 other duties as needed. Requirements: 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 Preferred :
Experience with Snowflake administration 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 Equal Employment Opportunity Policy Talent Advisory Group provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
