Child care . (Scottsdale)

Data Analyst (15.31-DHA)   OCT Consulting is a business management and technology consulting firm that provides support to Federal Government clients. We provide consulting services in the areas of Strategy, Process Improvement, Change Management, Program and Project Management, Acquisition/Procurement, and Information Technology. Responsibilities and Duties OCT currently has an opening for a Data Analyst (1099 hire, Part-time, approximately 500 hours per year) to work with our federal client.The position is primarily on-site in Falls Church, VA, although telework arrangements may be considered.  This position is contingent upon contract award. Day to day responsibilities include: Collect and organize data to support the client in becoming a more data-driven organization. Assist in creating dashboards, charts, and reports to provide visibility into small business program performance. Conduct basic analysis to identify trends, patterns, and areas for improvement. Support the evaluation of strategic planning initiatives by providing data summaries and insights. Help track and monitor annual small business goals through data reporting. Use data analysis tools to prepare clear visuals and summaries for program staff and leadership. Ensure accuracy and consistency of data used in reports and presentations. Collaborate with team members to integrate data findings into program management activities. Requirements Must be a U.S. Citizen, as it is required for the clearance associated with this position Bachelor’s degree in Data Analytics, Business, Economics, Statistics, Computer Science, or a related field. 1–2 years of experience in data analysis, reporting, or related work (internships or academic projects may count). Basic experience with data tools such as Excel, Tableau, Power BI, R, or Python. Ability to interpret data, identify trends, and communicate findings in a clear, simple way. Familiarity with creating visuals (charts, tables, dashboards) to present data. Strong attention to detail and ability to maintain accuracy in data handling. Good written and verbal communication skills, with the ability to explain data to non-technical audiences. Ability to work independently on assigned tasks and contribute to team projects. Benefits Salary Range:  $50.00-$60.00/hour (1099 Part-time hire, with an estimated 500 hours per year),  commensurate with experience, education, etc.  About OCT Consulting OCT Consulting LLC is a minority-owned, Small ​Disadvantaged Business (SDB) providing professional services and information technology solutions to the Federal government and commercial clients. Founded in 2013, we bring the advantage of agility in operations along with a management team with a track record of leading successful engagements at major Federal government agencies. At OCT, we are committed to ensuring equal opportunity for all individuals, recognizing that merit and qualifications are the foundation of our hiring, promotion, and development practices. We believe in creating a work environment where employees can thrive based on their abilities, skills, and achievements. Our practices ensure fair treatment and equal access to opportunities for all, regardless of race, ethnicity, gender, sexual orientation, age, abilities, or other personal characteristics. We are dedicated to providing career growth and professional development based on individual merit and fostering a workplace where everyone’s contributions are valued and recognized.

With 150+ locations in 17 states, QualDerm Partners is the largest multi-state female-founded and owned dermatology network in the U.S. At QualDerm we are united in our purpose: to educate, protect, and care for your skin. We are committed to bringing you the very best in comprehensive skin care so that you can achieve a confident, healthier, and more beautiful you!  Our mission is to educate communities and healthcare professionals about the importance of skin health; including skin cancer prevention, risk factors and how to achieve healthy skin through annual skin exams and dermatologic care. We strive to provide the latest proven, proactive and comprehensive dermatologic care to populations in the expanding geographies we serve by making high-quality skin care timelier and more accessible all while creating a rewarding work environment for our providers and employees. Not only do we offer aggressive compensation and benefit packages, but we offer a culture that is unsurpassed!   Job Summary: The Front Office Receptionist will be responsible for accurate and timely patient registration utilizing medical systems. This individual will utilize facility medical necessity tool to verify appropriate patient insurance coverage. This work will need to be performed according to established policies and procedures. The associate will provide exceptional customer service to physicians, patients, family members and all other medical professionals.   Essential Duties and Responsibilities: Welcomes patients and visitors by greeting them in person or on the telephone, answering or referring inquiries. Notes patient arrival in Practice Management System (EMR). Identifies patients by date of birth and name in computer system and creates new account if patient is not in the system. Prepares necessary patient paperwork prior to patient’s appointment. Calls “No Show” appointments to reschedule, makes appropriate notations in Practice Management System and sends letters to patients when necessary. Optimizes patient satisfaction, provider time, and treatment room utilization by scheduling appointments in person or by telephone and comforts patients by anticipating their anxieties and answering their questions. Helps in emergency situations by quickly responding to patients in distress by using good reasoning and judgment. Reviews Practice Management System (EMR) for information that needs to be updated. Works with patients to obtain updated information and accurately enters information in Practice Management System (EMR). Identifies payer sources, verifies insurance eligibility, financial status and assigns correct payor type. Verifies if prior authorization from insurance is required; notifies Billing Department, if required. Responsible for keeping the reception area clean and organized. Obtains revenue by recording and updating financial information, recording and collecting patient copays and/or balances at check in/out. Protects patients’ rights by maintaining confidentiality of personal and financial information. Maintains operations by following policies and procedures, and reports changes as needed. Contributes to team effort by accomplishing related results, as needed. Routinely demonstrates superior customer service skills. Answers the telephone in a timely and polite manner. Communicates with patients, visitors, providers, and team members in a courteous, professional, cooperative and mature manner. Other duties as assigned by Practice Manager or Area Practice Manager. Requirements High School Diploma required; Associates Degree preferred 1 year customer service experience in health care Benefits Benefits of joining Qualderm Partners: Competitive Pay – Attractive compensation to reward your hard work Comprehensive Health Coverage – Includes Medical, Dental, and Vision plans to keep you covered Generous 401(k) Plan – Company matches 100% of the first 3%, plus 50% of the next 2%, with immediate vesting Paid Time Off (PTO) – Accrue PTO from day one, plus enjoy 6 paid holidays and 2 floating holidays each year Company-Paid Life Insurance – Peace of mind with basic life coverage, with the option for additional plans Disability Protection – Short-term and long-term disability coverage to protect you in unexpected circumstances Additional Wellness Plans – Accident, critical illness, and identity theft protection plans for extra security Employee Assistance Program (EAP) – Access confidential support for personal or work-related challenges Exclusive Employee Discounts – Save on products and services with special discounts just for you Referral Bonus Program – Earn bonuses by referring qualified candidates to join the team QualDerm Partners is proud to be an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Applicants must be currently authorized to work in the United States in a full-time basis.

Job Summary: We are looking for a skilled SQL Developer with strong Snowflake experience to design, develop, and optimize database solutions for large-scale data platforms. The ideal candidate will have expertise in SQL programming, data modeling, ETL development, and Snowflake cloud data warehouse, along with strong problem-solving and performance-tuning skills. Key Responsibilities: ·      Develop, optimize, and maintain SQL queries, stored procedures, and views in Snowflake. ·      Design and implement data models, schemas, and warehouse structures for scalable reporting and analytics. ·      Build and maintain ETL/ELT pipelines to integrate data from various sources into Snowflake. ·      Work with business stakeholders to understand requirements and deliver data solutions. ·      Implement performance tuning, query optimization, and cost management in Snowflake. ·      Manage Snowflake security, role-based access, and data governance. ·      Collaborate with data engineers, BI developers, and analysts to ensure data quality and consistency. ·      Monitor database performance and troubleshoot issues proactively. Required Skills & Qualifications: ·      Proven experience as a SQL Developer with expertise in Snowflake. ·      Strong SQL programming skills, including advanced functions, optimization, and debugging. ·      Hands-on experience with ETL/ELT development using tools like Informatica, Talend, dbt, or Python. ·      Experience with cloud platforms (AWS, Azure, or GCP) and integration with Snowflake. ·      Solid understanding of data warehousing, dimensional modeling, and star/snowflake schemas. ·      Familiarity with version control (Git) and CI/CD pipelines for data workflows. ·      Strong problem-solving, communication, and collaboration skills. Preferred Qualifications: ·      Experience with Snowpipe, Streams, and Tasks in Snowflake. ·      Exposure to Snowflake performance monitoring tools. ·      Knowledge of data visualization tools (Power BI, Tableau, Looker) for reporting integration. ·      Familiarity with Python or Scala for data transformation and automation. Education: Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a related field.

Qualifications: ·      Proven experience as a Power BI Developer or a similar Business Intelligence role. ·      Strong proficiency in Microsoft Power BI Desktop, Power BI Service, Power Query (M), and DAX. ·      Solid understanding of data modeling concepts (e.g., star schema, snowflake schema) and data warehousing principles. ·      Experience in connecting to and extracting data from various data sources (e.g., SQL Server, Azure SQL Database, облачные хранилища данных, Excel, CSV). ·      Excellent SQL skills for data querying and manipulation. ·      Strong data visualization skills and the ability to design clear, concise, and impactful dashboards and reports. ·      Understanding of data security and governance principles. ·      Excellent analytical and problem-solving skills with a keen attention to detail. ·      Strong communication and interpersonal skills, with the ability to effectively communicate technical concepts to non-technical stakeholders.  

Hello Sunshine is on a mission to change the narrative for women. Founded by Reese Witherspoon, Hello Sunshine is a media company that puts women at the center of every story we create, celebrate and discover. We tell stories we love–from big to small, funny to complex–all shining a light on where women are now and helping them chart a new path forward. This role is part of Solar, a story-led agency built on Hello Sunshine’s expertise in premium storytelling, experiences, community, and an unparalleled understanding of women. Solar creates audience-first brand partnerships across platforms and mediums. Our stories uniquely empower brands to tell stories that drive impact, create culture, and deeply connect with women across our brands - Hello Sunshine, Reese’s Book Club, and Sunnie. The Sr. Director, Integrated Marketing will serve as both an independent contributor and the team lead, with three direct reports on the IM team. This role is responsible for the pre-sale process: from briefing and strategy development to concepting and pricing to deck building and presentations. You’ll collaborate across internal teams including Sales, Creative, Production, Experiential, Talent, Editorial/Social, and Sales Planning in order to develop and deliver cross-platform ideas and campaigns that deliver for our brand partners and our audience. The ideal candidate is a strong storyteller and collaborative while also being autonomous and solutions-oriented. Direct experience building creative and innovative brand partnerships, visual-forward pitch decks, and an understanding of the digital and experiential media landscape is a must. Along with proactive and reactive partnerships this role is also responsible for Solar’s go-to-market materials, creating and maintaining sales materials that tell our story and clearly communicate how brands can partner with us. This role reports directly to the VP, Integrated Marketing & Activation.   RESPONSIBILITIES: Partner with Sales and collaborate across internal teams to concept and deliver proactive and inbound proposals with unique and ownable ideas that deliver impact for our clients and audience. Manage the workload of the team and individual projects, assign new projects and establish timelines to meet external deadlines and account for internal processes and approvals. Develop and build go-to-market strategies and branded content packages across each brand (including Hello Sunshine, Shine Away, Reese’s Book Club, Sunnie and our podcast slate), establishing quarterly opportunities and yearly tentpoles that maximize revenue and brand growth. Price and package opportunities in pre-sale for inbound briefs, proactive pitches, and maintain the branded content/package rate card, updating quarterly to align with sales and brand priorities.  Work with the Creative/Design team to establish deck templates and design tools that simply and beautifully convey our ideas. Maintain a database of templates and audit quarterly. Establish, implement, and maintain processes that simplify day-to-day team operations and cross-team collaboration. Understanding of project management & AI tools is important. Attend client meetings both in-person and virtually. Maintain the voice of Hello Sunshine and our brands in all written materials and presentations. Requirements 10+ years experience working in branded content/integrated marketing for a digital publisher, media company, agency, or similar company. Must have experience creating packages and process for client partnerships across different mediums and content formats. 5+ years experience managing a team Strong storytelling, social, experiential, talent, and creative strategy experience a must. Excellent writing and presentation skills – both in structure and content, you must be able to clearly articulate ideas in concise and impactful ways. Ability to turn Sales and Client asks, direct KPIs, and creative briefs into actionable strategies that deliver on creative and revenue goals. A passion for storytelling that centers women, a familiarity with the Hello Sunshine brand ecosystem, and a deep understanding of the people and trends that drive culture. Stellar interpersonal communication and collaboration skills with the ability to thrive in a startup environment - effectively navigating ambiguity and complexities. Serve as the CEO of your own team - bringing solutions to leadership, managing up and across while being able to foster independence in your direct reports. Ability to work well with different personalities and within a team setting. Benefits The salary range for this role is $150,000-$160,000 Health Care Plan (Medical, Dental & Vision) Retirement Plan (401k, IRA) Life Insurance (Basic, Voluntary & AD&D) Paid Time Off (Vacation, Sick & Public Holidays) Family Leave (Maternity, Paternity) Short Term & Long Term Disability

The Exhibits Support and Services Coordinator will provide administrative and operational support for the Exhibits department. They will ensure accurate data management, order processing, and vendor coordination. The Exhibits Support and Services Coordinator will support both internal teams and external customers by maintaining efficient workflows, up-to-date records, and delivering high-quality customer service. Key Contributions of the Role Manage the general phone line, general email mailbox, Services Cloud, and Helpscout for the Exhibits team. Assist with all Exhibits support processes and manage daily Salesforce data entry. Complete reporting as needed from sources to include, but not limited to, Salesforce, Shepard Custom Platforms, and Cornerstone. Assist with creating event opportunities and show codes in Salesforce for Exhibits projects. Maintain accuracy and updates with the exhibits tracking spreadsheet and vendor resources, as needed. Process, track, and report orders from outside vendors, including support purchase orders and invoice processing. Complete COI/EAC submissions, as needed.    Review and audit expenses and expense reporting on a regular basis. Requirements Minimum 2 years of experience in field operations of trade events, with preferred experience in custom exhibit booth design and production. Proficient in ancillary ordering, booth work orders, processing standard orders, and project management. Excellent verbal and written communication skills. Detail-oriented with the ability to organize tasks and meet deadlines. Proficient in working within a team and independently. Proficient in Microsoft Office Suite, including Word and Excel; experience with Salesforce is a plus. Ability to work a flexible schedule with occasional extended hours and weekend work. Bachelor’s degree in related field; or relevant experience may be substituted for formal education. Aligning With Our Values for Success Demonstrate Core Values of Caring, Commitment, Integrity, Spirit, Responsiveness, Inclusivity, and Teamwork. Ability to perform as a responsible ESOP owner by making daily decisions to benefit the client and the company. Treat all internal and external customers with courtesy and respect, as outlined in our Blue Diamond Customer Service Program.   Please note that the roles and responsibilities outlined in this job description are not exhaustive and may be subject to change. Additional tasks may be assigned as needed to meet the evolving needs of the company.