Build a Career in Software Development 🧑‍💻

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

Rea is a growing Top 100 business advisory & accounting firm providing our clients services in tax, accounting, and business consulting. We have a ‘People First’ culture and we focus on our employees’ well-being and professional development. With over 400 professionals and locations throughout Ohio, our firm has a culture that respects a work-life balance for our team. We also provide competitive compensation and a robust benefits plan. The BI Data Analyst will play a critical role in leveraging Power BI and Azure SQL to analyze data, build data sets, develop insightful reports, and create efficient workflows. The role’s use of these tools will contribute to data-driven decision-making and process optimization across our organization.  Responsibilities Utilize Power BI to gather and transform data from various sources (IE Excel, APIs, SQL), creating visually appealing and interactive dashboards to present key insights to stakeholders   Collaborate with cross-functional teams to understand data requirements and design meaningful visualizations that drive informed decisions   Design robust generalized SQL datasets through combining raw data for reports.  Work closely with end-users to gather requirements and ensure that dashboards meet their needs effectively   Identify opportunities for reporting and process automation across internal clients and implement solutions that deliver tangible benefits   Apply data cleansing and transformation techniques using Power Query to ensure data accuracy and consistency across different data sources   Collaborate with data warehouse engineers to enhance data quality and resolve data integration issues   Collaborate with team members to share best practices, provide technical guidance, and support the adoption of Power Platform tools   Train end-users on using Power BI, Power Apps, and Power Automate effectively for their respective needs   Ensure compliance with data governance policies and implement security measures to protect sensitive data within Power Platform solutions   Stay up-to-date with Microsoft's updates and features related to Power Platform to maintain best practices   Knowledge, Skills and Abilities Proficiency in data analysis, visualization, and report creation using Power BI   Strong understanding of data transformation, ETL processes, and data modeling concepts   Familiarity with data governance principles and best practices for maintaining data accuracy and security   Excellent communication skills, both written and verbal, to convey technical concepts to non-technical stakeholders   Analytical mindset with the ability to translate business requirements into effective Power BI Dashboards or power platform apps.  Problem-solving skills to troubleshoot issues and optimize Power Platform applications   Experience working in a collaborative team environment and a track record of delivering results on time   Requirements Bachelor's or Master's degree in Computer Science, Information Technology, Data Science, or a related field   Proven experience (5+ years) as a Data Analyst, with demonstrated expertise in Microsoft Power Platform tools (Power BI, Power Apps, Power Automate) , intermediate SQL knowledge Hands-on experience developing custom Power BI Dashboards, analyzing data within SQL databases, building company wide usable datasets Analyzing raw data and identifying useful metrics and new ways of looking at data to help drive the business Travel to client locations as needed   Benefits Rea offers a wide variety of benefits to help support our employees' health, wellness and financial goals. Health Care Plan (Medical, Dental & Vision) Retirement Plan (401k) Life Insurance (Basic, Voluntary & AD&D) Paid Time Off (Vacation, Sick & Public Holidays) Family Leave (Maternity, Paternity) Short Term & Long Term Disability Training & Development Wellness Resources Four (4) weeks PTO Twelve (12) paid holidays, of which three (3) are floating holidays Rea does not accept unsolicited resumes from individual recruiters or third-party recruiting agencies without pre-approval from Rea’s Talent team. Pre-approval is required before any external candidate can be submitted. Rea will not be responsible for fees related to unsolicited resumes and for candidates who are sent directly to our hiring managers.

Hiring: NBA basketball on-site data analyst. Attend games in person; tickets will be provided. Interested parties should send a private message with the note: New Orleans; contact WeChat: ufofrommars. In addition to game tickets, compensation will be provided. Contact WeChat: ufofrommars

Hiring: Male pipeline workers needed, under 55 years old, mainly responsible for installing pipeline screws, $250 per day, working 6 days a week, weekly salary payment, worker's permit required, 10 hours per day, 3-month project with meals and accommodation provided, round-trip airfare covered, work location: Louisville, Kentucky, starting early September. Interested candidates please contact: 6269771733 9296267666 WeChat: zxm6269771733

Hiring: The Florida factory needs three people. One Chinese-English translator and network administrator who is proficient in various software and web applications. One mechanical equipment installation engineer to manage the production and assembly of golf carts. One electrician who can install electrical equipment in the factory and maintain both high and low voltage systems. Another person who can operate a forklift and manage warehouse operations including unpacking and packing goods. $5000/month. Work permit required. Single candidates who can work in different states are preferred. Company provides accommodation and stock options. Contact: 6269771733, 9296267666. WeChat ID: zxm6269771733

Unity Expert for mobile game app development. Must have experience in compliance for The App Store and Facebook.