If you're fascinated with predicting consumer behavior, and you enjoy delivering insights from your analysis to influence important decisions, you should learn more about Corios LLC. We're a Portland, Oregon-based management analytics consultancy, and we want to hire bright, inquisitive analysts who enjoy solving challenging predictive analytics problems. At Corios, we tell the stories the numbers can't; we believe business decisions are influenced not only by the measurement of behavior, but by synthesizing data-driven insights along with our past experience in order to deliver the most relevant interpretation and client recommendations possible. About the Junior Analytics Consultant role The Junior Analytics Consultant is an entry-level analytics consulting role with promotion potential in a growing organization. The qualified candidate will prepare and analyze data, interpret results, document findings and recommendations, and participate in client meetings and workshops. Additionally, they will be expected to coordinate, prepare, and manage project documents and deliverables for the project manager; analyze the current state of the client's business; identify gaps and deficiencies, and develop recommendations for improvement. Outside of project work, the qualified candidate will develop and evaluate company procedures, controls and guidelines, to maximize efficiency and ensure that the business operates at full functionality. Required skills, knowledge, experience Qualified candidates should possess most of the following skills, knowledge and experience: Data Analysis and Management Development of ETL code Programming: relevant platforms include SAS, SQL, Python Excellent Verbal Communication Self-motivated and efficient time management Operating systems: Windows, Linux Skills Desired Proficiency in Microsoft Office (Excel, Access) UNIX shell/Python scripting SAS programming skills, including SAS PROC SQL, SAS Data Step, and SAS Macro programming skills Understanding and usage of SAS Enterprise Guide and SAS Stored Processes Working knowledge of SAS BI Web Services Experience with data in financial services, insurance, retail, and energy business Experience with Hadoop/No-SQL data stores Database clients Jupyter Notebooks Qualifications Geography: This position is based at company headquarters in Portland, Oregon. Management’s strong preference is for candidates already located in our metropolitan area. 1+ years of experience in financial services, energy, and/or insurance fields. Bachelors Degree in mathematics, finance, economics, statistics, data science, or computer science Commitment: Full time, 40-50 hours/week.   Travel: the basic expectation for travel within North America is 10 to 40%. Candidates are required to pass a background screen including a criminal history, reference check and drug screen. Corios LLC is a drug-free employer. About Corios Our clients are leading financial services, energy and retailing companies in North America and around the world. Corios helps our clients make important decisions about customer acquisition, lifecycle marketing, utilization, retention, pricing, delinquency, debt recovery, capacity planning, and financial crime detection and prevention. To meet those objectives, we leverage deep expertise in predictive analytics, statistics, econometrics, forecasting, experimental design and mathematical optimization, and the business processes that leverage those analytical disciplines. Corios values its employees! Located in downtown Portland near fantastic restaurants and breweries, our team members enjoy convenient access to public transportation, ergonomic sit-stand desks, an open office with loads of ambient light, and a work environment where we enjoy supporting each other along with sharing good laughs and great food. Medical, Dental, and Vision insurance 100% employer paid for employees, with the option to extend benefit participation to employee dependents/spouse/partner Short-and Long-Term Disability and Life Insurance paid 100% by employer Simple IRA with company match Generous paid time off program Flexible work schedules Professional Development Opportunities Parking/Public transit and gym reimbursement

About the Company Avalon Healthcare Solutions, headquartered in Tampa, Florida, is a clinical services and information technology company using evidence-based medicine to develop and deploy medical policies and protocols in the high-volume, dynamic and complex diagnostic lab environment. The company manages the appropriate use of thousands of existing lab tests and researches new tests to determine efficacy and impact on patient care. Studies show that 30% of clinical laboratory testing is unnecessary or overused. Inappropriate testing or missing a key screening can lead to complications and expense arising from unwarranted care, or not obtaining proper care when needed, leading to increased health risks and costs. Avalon helps ensure delivery of the right test, at the right time, and in the right setting. We seek to ensure the most effective patient treatment, improve clinical outcomes, and optimize cost and affordability. Avalon is a portfolio company of Francisco Partners, a global private equity firm that specializes in investments in technology and technology-enabled service companies. Since its launch 15 years ago, FP has raised approximately $10 billion and invested in more than 150 companies. Avalon is a high growth company where every associate has an opportunity to make a difference. You will be part of a team that shapes a new market and business. You'll enjoy seeing the results of your work as we rapidly implement our plan. Most importantly, you will help Avalon to achieve its mission and improve clinical outcomes and health care affordability for the people we serve. For more about Avalon, please visit our web site. About the Position The Data Analyst is a technical role that is responsible for the development and management of data and database requirements and design, analysis and reporting capabilities, and monitoring performance and quality control plans. Our health analytics function is responsible for analyzing large data sets containing health care expenditures and developing opportunities for improving quality and affordability. No sponsorship is available at this time. No third party recruiter calls please. No relocation assistance offered. Responsibilities include, but are not limited to: Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality. Assist in managing the company's health analytics database including structure, maintenance, data extract, transform, and load (ETL) efforts. Acquire data from primary or secondary data sources and maintain databases/data systems. Ensure data integrity working with the clients to receive and validate data and perform ongoing quality assurance. Filter and “clean” data, and review reports and performance indicators to locate and correct code problems. Complete ad-hoc data management requests, e.g., queries, reporting. Qualifications At least one year of employment experience as a data analyst. Bachelor's degree in mathematics, computer science, information management, or statistics, or equivalent work experience. Technical knowledge regarding data models, database design development, data mining, schema definition, and segmentation techniques. Knowledge of and experience with reporting packages, databases (e.g., SQL), and programming (e.g., XML, ETL frameworks). Knowledge of statistics and experience using statistical packages for analyzing large datasets (e.g., Excel, Tableau, SAS). Analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. Adept at queries and report writing.