Snowflake Data Engineer

I run a software company that develops software for an open-source project called OpenEMR, an application that runs medical clinics, hospitals, and other medical organizations. I am looking for a part-time 20 hours per month junior developer to assist me and my company with completing tasks for OpenEMR. As time progresses this has the ability to turn into more hours. You would be a 1099 contractor for my company. More info about the project (this is the project you will be working on): https://www.open-emr.org/ Before the interview I need you to read the following document. In your cover letter please be able to demonstrate as much as possible what is contained in this document. You probably won't get 100% but please give it a solid try. Requirements for OpenEMR Development This document defines the minimum skills and tasks you must demonstrate to be considered ready for OpenEMR development. Review carefully and be prepared to show working examples for the interview. Core Competencies Using Git and standard source control workflows Understanding the OpenEMR database schema at a basic level Setting up multiple virtual hosts using LAMP (preferred), WAMP, or MAMP Configuring and troubleshooting Apache Virtual Host Setup Task Demonstrate your ability to set up a local sandbox by: Creating a new Apache virtual host Installing the latest community version of OpenEMR (use the most recent patch release) Cloning the OpenEMR GitHub repository outside of any vhost folder. (basically, not storing the git repo in the /var/www/ directory, but using an rsync script to update the vhost ) Setting up local instances for both: Master branch and most current stable patch release At minimum: Run OpenEMR v703v4 on a dedicated vhost Git and Source Control Best practices for managing a project with Git Why repositories must not be stored directly on Staging or Production vhosts What cherry-picking is and why it is useful How git reflog can help find a file’s history Xdebug Task Place a breakpoint in login.php at the line that includes globals.inc.php Step over into the next line and explain why globals.inc.php is critical Identify a variable or function from globals.inc.php that is used in login.php OpenEMR Schema Explain the purpose and stored data of these tables: patient_data form_encounter forms users users_secure list_options layout_options Write a query to return: patient first name, last name, PID, encounter number, and forms used in encounters within a specific date or date range Write a query to return: PID and encounter ids for a date range Identify which table/column records when a form has been deleted Identify the view in the OpenEMR interface that updates the list_options table Identify the view in the OpenEMR interface that updates the layout_options table Make a change using the OpenEMR interface and demonstrate the change in the raw data (phpMyAdmin view) Explain how layout_options and list_options are related to creating or updating layout based forms

**About Us** We’re a specialized SaaS company serving the construction industry. Our platform helps employers and unions streamline reporting and benefits management by transforming payroll data into accurate, secure reports—eliminating manual paperwork and reducing compliance risks. **The Role** We’re looking for a **Senior Full-Stack Web Application Developer / Technical Lead** who thrives on building data-intensive applications and embraces AI-assisted development. You’ll work directly with our CTO to design scalable systems, guide product releases, and explore the frontiers of AI-driven software engineering. **Important Requirements** * Experience: Minimum 10+ years in application architecture and system design. (Please do not apply if you do not meet this criterion.) * Language: Fluency in English is mandatory. You must be able to communicate ideas clearly. * Applicants: Individuals only — we will not consider working with agencies, recruiters or any businesses. * Contact: Please use email exclusively to apply for this position. * Location: This position is 50% remote. Candidate must be located in Portland area and must be able to come into the office 2-3 days a week. **What You’ll Do** * Leverage AI tools/agents for planning, development, testing, and documentation * Architect and build full-stack features across React/TypeScript, GraphQL, ASP.NET Core, and MS SQL Server **What We’re Looking For** * 10+ years of senior or lead-level hands-on development * Strong expertise in React/TypeScript, .NET Core, SQL Server * Comfortable with GraphQL, Linux, and scripting (bash or similar) * Demonstrated experience using LLMs in real workflows, with the ability to evaluate and improve their outputs * A systems thinker who thrives on solving complex, large-scale problems * Experience with and understanding of analytical database products is a big plus **Why Join Us** * Your work will directly impact thousands of users and company growth * Collaborate with a passionate, forward-looking team * Performance-based bonus opportunities **Next Steps** Applicants who advance will be asked to complete a short, unpaid technical assessment project prior to moving to the next phase.

We train and promote from within Excellent low-cost health benefits Retirement plan with employer-paid contributions Paid vacation and 10 holidays At Sierra Pacific Industries, we understand our greatest strength is the people who choose to build a career with us. We are a fourth-generation family-owned company that has grown to be one of the largest lumber and millwork producers in the United States. Our more than 6,000 employees are proud to work at our state-of-the-art sawmills and other facilities, including: manufacturing, custom wood-framed windows, fabrication, millwork, veneer, cogeneration, trucking, forestry, and other operations. We are seeking an experienced Web Developer to work collaboratively with our IT team based in Anderson, California, with a hybrid schedule possibility. The successful applicant requires current authorization to work in the United States as Sierra Pacific does not provide a Visa sponsorship. Sierra Pacific is a family-oriented company where employees are respected, integrity is valued and a strong work ethic is recognized and rewarded. We seek qualified IT professionals to become a valued members of our IT team that takes pride in effectively responding to business needs and directly contributing to the success of the company. About the Position Take ownership of the full lifecycle of customer-facing and internal website applications Collaborate with users to understand and create project requirements and specifications Work independently and in a team environment to design, develop, and maintain browser-based applications and user experiences Proactively troubleshoot and test production issues Use critical thinking and effective communication to solve problems and provide solutions with varying degrees of complexity Be resourceful and proactive in gathering information and sharing ideas Provide direct technical support to users and staff Promote a positive, team-oriented, collaborative, and problem-solving focused work environment Qualifications 5 years’ minimum combined college-level education in Software Engineering, Application Development, or related Computer Science program, and/or professional experience in Web and Application Development Professional experience in full-stack web development with front-end technologies like HTTP, JavaScript/jQuery, AJAX, and CSS Professional experience in back-end coding languages such as C# or VB in a .Net environment Preference given for professional experience in database development, particularly with Microsoft SQL Server or other relational databases Preference given for experience with Visual Studio, Razor/Blazor, Bootstrap, DevExpress, or Azure Cloud Proven problem-solving and time management skills Demonstrated effective verbal and written communication skills Why Join Our Team? Because this is more than an invitation, it's a commitment to offer opportunities for personal and professional growth to everyone! We ask people to grow with us and make the company even better. We provide an excellent benefit package including a full Health Benefits Plan (including medical, dental, and vision) with low-cost premiums, a 401(k) with Company Match, additional Retirement Contributions, and company-paid Life Insurance. How to Apply If you are qualified and would like to join our team, please send a cover letter referencing this position and a resume to: Sierra Pacific Industries Human Resources PO Box 496011 Redding, CA 96049 (866) 378-8001 or apply online and view all our career opportunities at: spi.careers Sierra Pacific is an (EOE) Equal Opportunity Employer, including those with a disability and veterans. The general wage range for this position at Sierra Pacific Industries is from $70,000 to $125,000 per year, and is dependent upon a number of factors, including, but not limited to: relevant work experience, skill, knowledge, and/or education. About Our Company Sierra Pacific Industries is a fourth-generation family-owned company based in Northern California that started in 1949 and has grown to be one of the largest lumber and millwork producers in the U.S., employing around 6,500 crew members. Sierra Pacific continues to be a company where its employees are proud to work at state-of-the-art facilities and others strive to become part of the team. We own and sustainably manage more than 2.4 million acres of timberland in California, Oregon, and Washington. Our forests are sustainably managed under a 100-year plan by Registered Professional Foresters, Wildlife Biologists, Botanists, and other professionals. We are growing forests for our future, planting over 6 million new trees every year. In Spring 2024, we planted our 300 millionth seedling on our timberlands. This milestone was decades in the making, reflecting our commitment to sustainable forest management and ensuring we have forests not just for today, but for generations to come. Sierra Pacific effectively uses nearly 100% of every piece of wood we bring to our facilities. In fact, any small amount that isn't turned into hand-crafted doors and windows, millwork, lumber, or landscaping material is actually converted into electricity in our eight biomass-fueled power plants. We are proud that all Sierra Pacific facilities follow our drug-free and tobacco-free policies. As part of our safety in the workplace policy, an offer of employment is subject to a negative drug screen result. We use E-verify to verify the social security number and work authorization of all newly hired employees. Sierra Pacific is an (EOE) Equal Opportunity Employer, including those with a disability and veterans.

Company Profile      At Sand Cherry Associates, we excel in the design and delivery of strategic customer-centric initiatives through digitally native, data-empowered solutions.  Our client’s confidence in us is centered on exceptionally skilled, high-energy talent working with the support of the full Sand Cherry team.  Finding the right match for this role is a critical aspect of continuing that success.       Overview   We are looking for an experienced Product Manager. This role is responsible for leading project lifecycle and product development and deployment initiatives for an IP Video product for an enterprise organization. This involves product planning, drafting and refining product requirements, competitive research and analysis, and all product operations through deployment. This position is hybrid and qualified candidate will work on-site in either Philadelphia PA, or Denver, CO a few days a week and other days remote. Candidates must live in either the Philadelphia metro area or the Denver metro area and be willing to go on-site each week some days.     Duties & Responsibilities  Manage products and services utilizing product and/or project management principles, strategy and execution  Understand the current GTM approach and how to engage with stakeholders as necessary for product release solutions  Proven ability to work in large, enterprise organization and communicate effectively with stakeholders  Manage key documentation deliverables such as inputs, outputs, GTM materials   Enhance product management tools, documentation, and reporting  Create and maintain product related information and communication  Create and maintain process workflow documentation to support business needs  Consistently exercise informed judgment and discretion in matters of significance  Direct cross functional teams, such as engineering or development, regarding product requirements  Act instrumentally in connecting Agile and non Agile teams to support product efforts   Requirements Desired Skills and Experience  Minimum 7 years direct product planning, product operations and product management experience  Experience in telecommunications/broadband, data service networks, or contact center environments preferred  Experience working with IP video is required Experience in an Agile or Scaled Agile environment is necessary  Experience with project or program management is necessary Knowledge and understanding of products in a technical capacity, understanding their requirements and related business needs  Experience aligning multiple business groups in a cross-functional, matrixed environment  Ability to drive and lead stakeholder meetings and manage deliverables from development and engineering  Excellent communication skills, utilizing a formal system for communications, reporting intake status, and collaborating with other internal groups  Ability to ramp up on new projects quickly and work autonomously, while actively keeping project team and client informed of milestones and potential issues    Qualifications/Technical Skill Requirements  Excellent knowledge of MS Office Suite products, especially Excel and PowerPoint for tracking, reporting, and executing slide presentations  Experience with MS Project and JIRA are helpful  Experience with broadband technology product solutions/offerings is preferred  Familiarity working with cross functional teams- IT, product development, engineering, and marketing is necessary  Experience managing numerous product lines and providing updates and insights to stakeholders at a variety of levels in a large enterprise organization    Education/Certifications  Bachelor’s degree in Business or other quantitative field  PMP certification is helpful or project management methodology courses  Consulting background is helpful but not required  Compensation For individuals assigned and/or hired to work in Colorado, Sand Cherry Associates is required by law to include a reasonable estimate of the compensation range for this role. This compensation range considers a wide range of factors considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and delivery model. This is a 6 - 12 month engagement with an annualized salary of $120,000 - $150,000. Years of experience, level of education, geographic location, unique skills/qualifications for the specific role and potential certifications can be key factors in the final compensation for this role. Benefits Our team is unique — we are passionate about what we do. At Sand Cherry, our consultants know they are impacting and shaping our clients’ industries. We recognize our employees for their contributions. Our culture is one of the most friendly and communicative in the consulting industry. Sand Cherry is not a top-heavy organization. We offer the opportunity to be part of a digital workforce. Discover the experience that only comes with self-responsibility in the workplace. Our team members manage their own workloads and are expected to deliver exceptional work for our clients. Professional career growth is one of our main priorities, as we affirm that investing in our consultants and empowering our people will also deliver the best results and value for our clients.

If you’re driven to innovate and passionate about software, we invite you to build your career with us in a fast-moving and rewarding tech environment. We are a dedicated tech company looking for new learners ready to build real developer skills. Interested in mastering software and web development from home? This structured, remote program can be completed part- or full-time and includes nearly 900 hours of guided work with industry-standard tools and technologies. Key training areas: 🖥️ Programming & Tech Literacy • Explore system architecture, browsers, networking, and computing basics • Study algorithms, Python, command-line logic, and technical vocabulary 💻 Front-End Technologies • Use HTML, CSS, JavaScript, Bootstrap, and React.js • Build interactive, responsive, mobile-friendly web interfaces 🗄️ Back-End Systems & Databases • Design and use databases with SQL • Integrate backend services using Django and C#/.NET • Apply CRUD operations and relational logic 🧑‍💻 Languages & Tooling • Train in seven core programming languages • Work with Git, GitHub, Visual Studio, and team workflows • Apply version control and collaborative development principles 🧪 Capstone Projects • Complete two substantial projects (Python and C#) • Simulate professional development with Agile and DevOps practices • Showcase your skills in real-world coding scenarios 🧰 Professional Readiness • Practice technical interviews and coding challenges • Build a résumé that highlights your technical experience • Gain confidence transitioning into a development track Remote access provided. No prior experience required. Apply here: https://techschooldev.online/

MS2 is a national leader in transportation data management and analysis and has the largest traffic count database in North America. More than 270 agencies in 31 US States, and 3 Canadian Provinces, including 28 state Departments of Transportation, are using MS2 software to manage their transportation data. MS2 is located in the beautiful city of Ann Arbor, Michigan, the home of high-tech industries and the University of Michigan. Residents of the city enjoy beautiful parks, mature neighborhoods, amenities of the Huron River (a state-designated Natural River) and easy access to downtown Detroit or to colorful “Pure Michigan” woods and waterways. MS2 is a friendly, open, team working to support our clients' software needs. Employees work on a variety of tasks and are given a high degree of responsibility. We offer an excellent environment for transportation professionals. MS2 offers a competitive compensation and benefit package. We're building the next generation of Transportation Data Management Systems and we need your help! We're a small team and you'll have an opportunity to make a big impact. Position Description MS2 is looking for a Software Project Manager to manage the development of innovative software and data analytics for transportation planning and traffic engineering. An MS2 Software Project Manager will be responsible for concurrent projects and is expected to actively work with our clients. The position is open to professionals with software project management experience. Candidate must possess excellent verbal and written communication skills and be able to relate to clients and staff in a professional, thoughtful, and pleasant manner. Candidate must be able to effectively and professionally represent MS2 at meetings or other public forums. Being an active member of a professional organization is a plus. Candidate must be flexible to do assignments as necessary. This is a full-time position. Occasional, overnight travel is required (estimated at 1-2 times per year). Responsibilities: Project Management (approximately 60%) Manages assigned IT projects to ensure adherence to budget, schedule and scope of project. Be the main interface to MS2’s software engineers, the clients and internal leadership and be responsible for software project deliverables Build project schedules, and provide ongoing project plan/status reporting for weekly staff meetings Make decisions and communicate trade‐offs and risks; drive key decisions across projects Prepare documentation such as requirements and user manuals Drive collaboration across teams and advance project goals Carefully track project deadlines and work closely with MS2 development to meet timelines Contribute to improvement and ongoing refinement of software development lifecycle processes Contribute to technical and cost proposals Coordinate tasks, milestones and availability of project resources Facilitate discussions with both client and internal users and document specifications. Effectively communicate to MS2 development client requests, ideas for new software modules or ideas for user interface improvement Perform quality assurance for system enhancements. Frequent communication with clients Subject Matter Expert (approximately 30%) Conduct methodology research to help guide new software features or solutions Develop solution technical concepts based on an understanding of the data management needs of our clients Business Development (approximately 10%) Work with Business Development Manager to grow MS2 in new market areas. Attend professional conferences as directed to represent MS2. Cross‐sell other MS2 products and services to existing clients Requirements Associate’s or Bachelor’s degree in Engineering, Information Systems, or related field 3 or more years experience as a Project Manager, or similar role Highly proficient in Microsoft Word, Excel, PowerPoint & Project Excellent writing skills, as well as outstanding proofreading skills Excellent attention to detail – gets it right the first time Experience with the full software development life cycle (SDLC) Well organized self-starter with strong project management skills who can independently move projects forward, prioritize tasks, and meet deadlines Preferred: Project Management Professional (PMP) certification Membership in related professional organizaion(s) Previous experience with Software-as-a-Service (SaaS) model Previous experience in transportation planning or traffic engineering Benefits We offer a competitive salary and benefits package. We promote a strong work/life balance at MS2. We encourage our employees to pursue their professional interests and take ownership of projects from start to finish. You’ll be working with big data and cloud-based solutions using the latest technologies as part of a fun and energetic team. We get along so well, we even have regular nights out and company sponsored dinners to celebrate our successes! It’s a great place to work. Salary: $70,000-$115,000, to be determined based on the candidate’s individual skills and experience. Benefits: Participation in the MS2 annual bonus program 401(k) w matching Dental insurance Employee assistance program Flexible schedule Flexible spending account Health insurance Life insurance Paid time off Professional development assistance Referral program Disability insurance Vision insurance We Want You to Be You at MS2: At MS2 a diverse, inclusive, and equitable workplace is one where all employees, whatever their race, gender, color, ethnicity, national origin, age, sexual orientation or identity, education, disability, religion, or veteran status, feel valued and respected. We are committed to a nondiscriminatory approach and provide equal opportunity for employment and advancement in all of our departments and programs. We respect and value diverse life experiences and heritages and ensure that all voices are valued and heard. MS2 is committed to maintaining a welcoming environment with equitable treatment for all, and we strive to: Provide a working environment where all employees feel safe, comfortable, and valued. See diversity, inclusion, and equity as connected to our mission and critical to ensure the well-being of our staff and the agencies we serve. Examine and dismantle any inequities within our policies, systems, programs, and services, and continually update and report our progress to our employees. Explore potential underlying, unquestioned assumptions that interfere with inclusiveness. Encourage company-wide thinking about how systemic inequities impact our organization’s work, and how best to address that in a way that is consistent with our mission. Help to challenge assumptions about what it takes to be a strong leader at our organization, and who is well-positioned to provide leadership. Practice and encourage respectful and transparent communication in all interactions. Commit time and resources to expand more diverse leadership at all levels of our organization. Lead with respect and tolerance. We expect all employees to embrace this notion and to express it in workplace interactions and through everyday practices. MS2 wants every employee to feel our commitment to showing respect for everyone, and we encourage open communication that enables each person to be their best self. MS2 is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status. Hybrid Work We require you to work in the office generally at least one day per week. This is not a fully remote position, but we may provide relocation assistance to successful candidates.