Become a Surrogate, Earn up to $115,000, Stay At Home Mom

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.

Ironwear is an established and growing safety solution provider. For over 30 years we have manufactured, developed, and reengineered Personal Protective Equipment (PPE) for all industrial markets around the globe. The Customer Experience Coordinator will assist as a direct link between the Customer, Sales Team, and internal personnel. The position includes a limited sales capacity, maintaining customer relationships, providing ongoing support, addressing various customer needs, addressing inquiries regarding products, and helping them make informed decisions about products to purchase. Responsibilities: Answer incoming phone calls, customer support emails and customer chats while providing a first-class customer experience. Evaluate and write up incoming orders and present them to the Processing Department. Assist customers with product inquiries regarding inventory, pricing, incoming orders, back orders, and returned goods. Have a basic understanding of company product knowledge to properly address customer questions and concerns. Offer customers alternative products or additional products to boost sales and provide first-class customer service. Provide customer outreach when necessary to relay and evaluate any pending issues. Communicate cross-functionally with processing team/Account Managers to ensure orders are processed accurately inclusive of; price validation, shipping methods/costs, backorders etc. Communicate with account managers to address any customer concerns. Process all paperwork for customer orders/RMAs/backorders etc. Compile pertinent customer data in provided documentation and flag any concerns/patterns to management. Maintain and collect accurate customer data in our ticketing, ERP and CRM platforms Requirements Required Skills/Abilities: Superior verbal and written communication skills. Proficient in Microsoft Office Suite. Ability to multi-task in a demanding environment Organized and meticulous. Strong interpersonal skills. CX ticketing platform experience is a plus (Zendesk/Gorgias/Kustomer/similar). Education and Experience: High school degree or GED required. A minimum of two year’s related experience Benefits Health Care (Medical, Dental & Vision) 401(k) Plan with Company Match Paid Time Off (Vacation, Sick & Public Holidays) Convenient Location with Free Parking Company Provided Beverages and Snacks Dog Friendly Work Atmosphere Company Gatherings and Events

Ironwear is an established and growing safety solution provider. For over 30 years we have manufactured, developed, and reengineered Personal Protective Equipment (PPE) for all industrial markets around the globe. The Account Coordinator will assist as a direct link between our customers, Sales Team, and internal personnel. The position includes a limited sales capacity, maintaining customer relationships, providing first-class customer service, addressing all customer needs, and helping customers make informed decisions about products to purchase. Responsibilities: Answer incoming phone calls, customer support emails and customer chats while providing a first-class customer experience. Evaluate and write up incoming orders and present them to the Processing Department. Assist customers with product inquiries regarding inventory, pricing, incoming orders, back orders, and returned goods. Have a basic understanding of company product knowledge to properly address customer questions and concerns. Offer customers alternative products or additional products to boost sales and provide first-class customer service. Provide customer outreach when necessary to relay and evaluate any pending issues. Communicate cross-functionally with processing team/Account Managers to ensure orders are processed accurately inclusive of; price validation, shipping methods/costs, backorders etc. Communicate with account managers to address any customer concerns. Process all paperwork for customer orders/RMAs/backorders etc. Compile pertinent customer data in provided documentation and flag any concerns/patterns to management. Maintain and collect accurate customer data in our ticketing, ERP and CRM platforms Requirements Required Skills/Abilities: Superior verbal and written communication skills. Proficient in Microsoft Office Suite. Ability to multi-task in a demanding environment Organized and meticulous. Strong interpersonal skills. CX ticketing platform experience is a plus (Zendesk/Gorgias/Kustomer/similar). Education and Experience: High school degree or GED required. A minimum of two year’s related experience Benefits Career growth & development Competitive Compensation Plan Group benefits including medical, dental, and vision benefits with 100% premiums paid by Ironwear Paid Time Off Paid Holidays 401k with company match