This is the second in a series of four revenue cycle analyst roles in a multi-site, multi-specialty academic medical center. Works in a team environment providing support to revenue analysts and revenue cycle leadership under minimal supervision. Actively communicates and presents pertinent information to various audiences, particularly practice and finance leadership. Proactively identifies opportunities and recommends options for enhancing revenue, while preserving Mayo standards and minimizing the financial and legal risks to Mayo. Interprets, implements, and maintains billing and compliance rules across the revenue cycle. Is recognized and relied upon as a subject matter expert of a revenue or compliance technical area. Uses reporting tools to understand revenue and compliance risks and opportunities with significant impact to Mayo Clinic and conveys these risks and opportunities to leadership. Interprets and applies Mayo and governmental coding and billing rules and guidelines to ensure compliance. Conducts research and analysis, benchmarking, and audits to ensure reasonableness and accuracy of information along with identifying and implementing best practices and improvements. Provides revenue and billing analytics to support department and institutional leadership. Proactively identifies and communicates revenue and billing problems and opportunities; seeks input and participates in implementing solutions or process improvements. Mentors, coaches, and trains staff. Why Mayo Clinic Mayo Clinic is top-ranked in more specialties than any other care provider according to U.S. News & World Report. As we work together to put the needs of the patient first, we are also dedicated to our employees, investing in competitive compensation and comprehensive benefit plans – to take care of you and your family, now and in the future. And with continuing education and advancement opportunities at every turn, you can build a long, successful career with Mayo Clinic. Benefits Highlights - Medical: Multiple plan options. - Dental: Delta Dental or reimbursement account for flexible coverage. - Vision: Affordable plan with national network. - Pre-Tax Savings: HSA and FSAs for eligible expenses. - Retirement: Competitive retirement package to secure your future. Just as our reputation has spread beyond our Minnesota roots, so have our locations. Today, our employees are located at our three major campuses in Phoenix/Scottsdale, Arizona, Jacksonville, Florida, Rochester, Minnesota, and at Mayo Clinic Health System campuses throughout Midwestern communities, and at our international locations. Each Mayo Clinic location is a special place where our employees thrive in both their work and personal lives. Learn more about what each unique Mayo Clinic campus has to offer, and where your best fit is. Equal Opportunity All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, protected veteran status or disability status. Learn more about the "EOE is the Law". Mayo Clinic participates in E-Verify and may provide the Social Security Administration and, if necessary, the Department of Homeland Security with information from each new employee's Form I-9 to confirm work authorization.

Position Summary: Provide support to develop and implement data repository and analytics tools in support of pharmaceutical regulated GMP (Good Manufacturing Practices) data and with the focus on manufacturing and quality domains. Essential Duties & Responsibilities: - Analyze business needs and requirements for data and analytics to support regulatory filings. - Identify, classify, and map data sources. - Build data lineage diagram from data source to analytics ready datasets - Determine data curation requirements to help organize, clean, manage, and maintain data so it can be used reliably for analytical use cases. - Provide support for technical activities such as building data integration, design data architecture, and data transformation and processing. - Develop data governance standards to comply with company and industry best practices. - Lead development of key project documents such as user requirements, design specifications, and configuration specifications. - Lead development of test scenarios and scripts in partnership with business, technical, and validation team members. - Lead test execution according to test protocols. - Provide support for development of standard operating procedures and other documentation required to go-Live. - Monitor execution of testing and relay results to technical team to address issues. - Provide support for training business teams for Go-Live - Development of training materials as needed - Provide regular updates to project team Qualifications: - Education/Training: Bachelor’s Degree. - Experience: - Minimum of 5-10 years of experience in IT experience working in the role of business and technical analyst with the focus on data, business intelligence, and analytics projects - Experience working in Biotech/Pharma (Regulated Industry) - Experience with developing requirements, design, and testing documents. - Hands-on experience with data analysis and reporting in support of Pharmaceutical GMP environment. - Understanding of GMP data sources across pharmaceutical manufacturing process and quality control testing environment sources such as Laboratory Management Information Systems, Quality Systems, Manufacturing Execution Systems, Data Historian, and other tools. - Experience with design and development and usage of data repository and analytics platforms - Demonstrated experience managing lifecycle documentation and validation in FDA-regulated environments. - Versed in FDA/Industry regulations and policies (Part 11, Computer System Validation) - Experience with system administration responsibilities - Experience with helping lead data analysis and engineering projects - Ability to work under tight timelines - Ability to communicate and work across teams in collaborative manner - Ability to work independently with minimal supervision - Knowledge: - GxP, Pharmaceutical Manufacturing and Quality Data (GMP data), Data analysis and reporting - Understanding of data modeling tools - Experience working with analytics (Python, R, Excel, Tableau, Spotfire, other reporting and analytics for manufacturing process industries) - Experience with database (SQL) and ETL development - Experience with cloud environments (AWS, Azure) - Experience with usage of process analytic software is a plus (Aveva, Seeq). - Skills: - System Support/System Administration, Communications, Project Management, Training, Computer System Validation, Business Requirements Documentation. - Certifications/Licenses: None ProKidney is an equal employment opportunity employer and does not discriminate against any applicant because of race, creed, color, age, national origin, ancestry, religion, gender, sexual orientation, disability, genetic information, veteran status, military status, application for military service or any other class protected by state or federal law. Applicants must be eligible to work in the United States without the need for work visa or residency sponsorship.

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description We are seeking a Data Analyst with strong SQL and Python skills to build, optimize, and support Streamlit dashboards and the data systems behind them. This role focuses on delivering reliable, performant analytics products by developing dashboards, improving underlying tables and pipelines, and ensuring data freshness and accuracy. - Build and maintain Streamlit dashboards for business reporting and operational insights. - Optimize dashboard performance (query tuning, caching strategies, efficient data loading, and rendering). - Design, develop, and maintain SQL tables, views, and models that feed dashboards. - Implement and maintain Python-based data workflows to transform, validate, and deliver data for analytics use cases. - Monitor and improve data quality, freshness, and completeness (including automated checks and alerting). - Partner with stakeholders to define metrics, ensure consistent definitions, and translate requirements into data products. - Maintain documentation for dashboards, datasets, KPI definitions, and data lineage. - Troubleshoot data and dashboard issues, providing timely support and root-cause analysis. Qualifications - Strong experience with SQL (complex joins, window functions, performance optimization, and data modeling). - Strong experience with Python for data work (e.g., pandas, data validation patterns, and APIs as needed). - Experience building dashboards using tools such as Streamlit (ideal), Looker, Tableau, etc. - Solid understanding of analytics engineering fundamentals: dimensional modeling, metric definitions, and reproducible transformations. - Knowledge of basic software engineering practices (Git workflows, code reviews, testing, CI/CD). Requirements - Professional experience building dashboards in Streamlit, including performance tuning and maintainability. - Familiarity with modern data stack concepts (ELT patterns, semantic layers, governance). - Experience implementing automated data quality tests and observability. - Experience working with large datasets and improving query and pipeline efficiency. What Success Looks Like - Dashboards are fast, stable, and trusted by stakeholders. - Underlying tables and transformations are efficient, well-documented, and easy to maintain. - Data quality issues are detected early, with clear ownership and resolution paths. - Metrics are consistent across dashboards and align with agreed business definitions. Skills & Attributes - Strong analytical thinking and attention to detail. - Ability to balance delivery speed with data correctness and maintainability. - Clear written and verbal communication with technical and non-technical partners. - Comfortable owning end-to-end analytics products from requirements to production support. Assignment - 4-month contract with possibilities to extend.

At CDW, we make it happen, together. Trust, connection, and commitment are at the heart of how we work together to deliver for our customers. It’s why we’re coworkers, not just employees. Coworkers who genuinely believe in supporting our customers and one another. We collectively forge our path forward with a level of commitment that speaks to who we are and where we’re headed. We’re proud to share our story and Make Amazing Happen at CDW. Job Summary The Reporting & Data Analyst designs and develops reporting & analyses to support Managed Services customers and coworkers. This role focuses on providing the best solutions through useful and accurate reporting and dashboards based on a thorough understanding of CDW data, systems, and reporting tools.   What you will do: - Report Generation: Create weekly, monthly, bi-monthly, quarterly, and annual reports based on management requirements for content, frequency, and formatting. - Design standardized reporting formats for utilization within department, incorporating CDW system data and other practice specific requirements. - Perform ad-hoc reporting utilizing CDW reporting systems, based on manager and team needs. - Interact with business stakeholders to help identify and develop new reports or updates to existing reports which will enable the business to take a deeper look at data and increase productivity. - Troubleshoot and improve existing reporting and data solutions. - Implement and maintain testing processes to ensure data quality in reporting. - Perform analysis of data being shared and design solutions using best practices. - Lend expertise to others in the department as necessary to help resolve process or reporting issues. - Design and develop reporting and analytics to support the key internal clients. - Document and maintain Standard Operating Procedures as required. What we expect of you: - Bachelor’s degree in business, plus 3 years of experience with Microsoft Excel advanced functions to include: formulas, V-lookups, pivot tables, and data manipulation, OR 7 years of experience with Microsoft Excel advanced functions to include: formulas, V-lookups, pivot tables, and data manipulation. - Experience with VBA, and/or Excel to develop analytical customer solutions. - Experience with MS Office applications (Word, Outlook, PowerPoint). - Applicants should demonstrate solid attention to detail with a penchant for accuracy. - Demonstrated commitment to quality, accuracy, and completeness in reporting. - Exceptional oral and written communication skills and the ability to deal effectively with a variety of internal customers. - Strong customer focus – committed to building and maintaining strong working relationships with management and staff. - Ability to balance multiple priorities simultaneously and adapt to the changing needs of the business while meeting deadlines, especially in a fast-paced environment. - Adaptable, dependable, and proactive in determining managers’ needs. - Excellent analytical skills. Demonstrated ability to understand data findings, draw conclusions, and develop actionable recommendations. - Demonstrated time management skills with the ability to meet deadlines while maintaining strong attention to detail. - Ability to compute, analyze and interpret complex statistical data and/or to develop forecasts and other statistical reports as needed. - Proven ability to shift priorities quickly. - Preferred qualifications, all a plus: - SAS, Crystal Reports, IBMi experience, Mainframe. - Experience with SQL, views, functions, indexes, and query tuning. - Working knowledge of ITS business data and processes. - 2 years of SQL experience to include: query writing, data extraction and manipulation. - Understanding a relational database. - Pay range: $77,725 - $108,265 depending on experience and skill set Annual bonus target of 10% subject to terms and conditions of plan Benefits overview: https://cdw.benefit-info.com/ Salary ranges may be subject to geographic differentials  - CDW is committed to being an AI-fluent organization We’re looking for people who bring curiosity, a learner’s mindset, and a willingness to engage with ever-evolving technology and tools. We value adopting AI as a partner, openness to experimentation, and a shared interest in learning together on AI. Our goal is to create a culture where AI enhances—not replaces—human creativity and decision-making. You don’t need to be an expert today; what matters is your readiness to explore, adapt, and grow with us as we integrate AI responsibly and effectively into our work. We make technology work so people can do great things.     CDW is a leading multi-brand provider of information technology solutions to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. A Fortune 500 company and member of the S&P 500 Index, CDW helps its customers to navigate an increasingly complex IT market and maximize return on their technology investments. Together, we unite. Together, we win. Together, we thrive. CDW is an equal opportunity employer. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status or any other basis prohibited by state and local law.      CDW is committed to fostering an equitable, transparent, and respectful hiring process for all applicants. During our application process, CDW’s goal is to get to know you as an applicant and understand your experience, strengths, skills, and qualifications. While AI can help you present yourself more clearly and effectively, the essence of your application should be authentically yours. To learn more, please review CDW's AI Applicant Notice.