Data Specialist (Onsite in San Marcos, CA)

Our Company: 
At PracticeTek, we believe healthcare should be easy for providers, accessible for patients, and simple for everyone involved.
PracticeTek was established by healthcare professionals and entrepreneurs who share a common goal: deliver seamless, high-quality, on-demand healthcare, free of the confusing limitations of traditional technological platforms.
 
PracticeTek is a collection of innovative software companies working together to make healthcare easier, and more accessible, for everyone.  We deliver robust software solutions that support practitioners, and foster exceptional patient experiences, contributing to the growth of healthcare clinics specializing in chiropractic, dental, orthodontics, optometry, and multi-discipline therapy.
Magic Touch is a technology company that provides software solutions tailored exclusively for dental lab manufacturers. The company's software is designed to help manufacturers streamline their operations, manage inventory, track sales, and enhance customer relationships. With a focus on innovation and customer satisfaction, Magic Touch is a trusted partner for dental manufacturers of all sizes. If you are passionate about technology and the dental industry, Seamlessly Efficient may be the right place for you.
The Customer Support Department: 
The Customer Support department provides excellent customer service to all customers calling in by ensuring customers’ needs are met and by going above and beyond their expectations. The department is a team-oriented, customer-focused environment in a setting where innovation, collaboration, and integrity are rewarded.
The Career Opportunity: 
In this position, you will be developing and troubleshooting the system and custom procedures and reports needed for use in our software solutions. Candidates will be responsible for database administration, data consolidation, data analysis and business intelligence reporting. In addition, these positions will provide Tier III technical support for software products we provide for both windows-based clients and .Net applications. This position also supports the Customer Success Team as needed during the implementation process.
Maintain up-to-date and accurate status and documentation for escalated support tickets. Contribute to and manage a knowledge base. Depending on interests, experiences, and skills set, additional opportunities include database administration, PowerShell scripting, installations and upgrades, help documentation, virtual server and hardware administration, software usability, testing, design, maintenance, and interfacing with the QA department.
The position is based in San Marcos, CA working onsite 5 days a week.
Areas of Accountability: 
The Data Engineer has responsibility for the following outcomes:

• Report/Code Development: gathering requirements, logic design, testing, deployment and ongoing maintenance for various projects in the areas of report generation, and automation development.
• Data Analysis and Conversion: Data conversion, data warehousing and general data mining / normalization.
• Collaboration: Interact with all departments when appropriate to gather information, provide feedback regarding workflows, and perform knowledge transfers.

Competencies for Success 

• Education: Bachelor's (Preferred)
• Microsoft SQL Server experience building stored procedures, optimization and troubleshooting.
• Minimum of 5 years of Data Analysis, Report Design, T-SQL Programming and Development skills in Microsoft SQL Server while optimizing performance.
• Proficient in Windows operating systems including Windows Server
• Proficient in MS Office, MS Windows both server and desktop
• Experience with Help Desk Ticketing Systems
• Excellent communication and documentation skills
• Strong critical thinking and problem-solving skills
• Highly motivated and a self-starter. Able to work well in a team environment
• Crystal Reports experience is a plus but not required. Training provided.
• Experience with Software QA Testing and processes is a big plus
• Experience with .Net applications and web app programming a plus
• Experience with PowerShell scripting a plus
• Experience in a Dental Laboratory a plus

At Magic Touch (part of the PracticeTek family of companies) we carefully consider a wide range of compensation factors to determine our offers of employment. This includes internal and external market factors as well as your individual experience and skills. These considerations can cause compensation to vary but we reasonably expect to pay between $33,050 - $86,000 for this position.
PracticeTek is an Equal Opportunity Employer that values employees with a broad cross-cultural perspective. We strive to create an inclusive environment, empower employees, and embrace diversity. We encourage everyone to respond. All applicants will receive fair and impartial treatment without regard to race, color, religion, sex, national origin, ancestry, citizenship status, age, legally protected physical or mental disability, protected veteran status, status in the U.S. uniformed services, sexual orientation, gender identity or expression, marital status, genetic information or on any other basis which is protected under applicable federal, state, or local law.