Data Analyst Job at Southern Orthodontic Partners, Nashville, TN

V3cwMkxjQ1NHUDBhU2FHSUNGQllVZzVYUUE9PQ==
  • Southern Orthodontic Partners
  • Nashville, TN

Job Description

Job Description

S outhern Orthodontic Partners is a fast paced, entrepreneurial organization offering a premier network of orthodontic care. We provide business management expertise to our partner practices, enabling orthodontic professionals to focus on delivering the best possible care to their patients. Our partner practices benefit from our centralized support system, operational best practices, recruiting network, and marketing expertise. Our mission is to positively impact the orthodontic profession through a partnership of clinical and service excellence with the country’s leading doctors.

At Southern Orthodontic Partners we heavily rely on our data from our practices to not only track progress toward operational objectives, but to also provide insight to allow for strategic and timely decisions related to the operations of the business. We are seeking a skilled Data Analyst with strong SQL development capabilities and hands-on experience in data engineering workflows. This role combines analytical expertise with technical proficiency in data transformation, pipeline management, and business intelligence tools. The ideal candidate will bridge the gap between data engineering and analytics, ensuring reliable data flows while delivering actionable insights.

In this role you will:

  • Build and maintain data pipelines using Azure Data Factory, Python, and other ETL tools
  • Monitor data ingestion processes and troubleshoot issues proactively to ensure data availability
  • Design, develop, and optimize SQL queries to extract, transform, and analyze large datasets
  • Perform ad hoc analysis to support business questions and operational needs
  • Collaborate with data engineers and business stakeholders to understand requirements and deliver solutions
  • Document data workflows, transformations, and troubleshooting procedures
  • Ensure data quality through validation, testing, and monitoring procedures
  • Create visualizations and reports using Power BI, Tableau, or similar tools
  • Support data warehouse development and maintenance as needed.

Technical Skills:

  • SQL Development : Intermediate to advanced proficiency in SQL for complex querying, performance optimization, and database management
  • Data Transformation & ETL : Hands-on experience managing data load and transformation processes using:
  • Python for data manipulation and scripting
  • Azure Data Factory for orchestrating data pipelines
  • Other industry-standard ETL/ELT tools and frameworks
  • API Integration : Practical experience working with REST APIs, including:
  • Consuming data from external APIs using authentication methods (OAuth, API keys, tokens)
  • Pushing data to external systems via API endpoints
  • Handling API pagination, rate limiting, and error responses
  • Building automated data workflows that leverage APIs for data ingestion and distribution
  • Problem-Solving : Demonstrated ability to perform ad hoc querying and troubleshoot data ingestion issues with minimal guidance
  • Data Quality : Experience validating data integrity and implementing error handling procedures

Core Competencies:

  • Strong analytical and problem-solving mindset
  • Ability to work independently on technical troubleshooting
  • Effective communication skills for documenting processes and collaborating with stakeholders
  • Attention to detail in data validation and quality assurance

Preferred Job Skills:

Highly Desired:

  • Experience with Databricks for big data processing and analytics
  • Proficiency in Azure Data Factory for cloud-based data integration
  • Business intelligence expertise using Power BI and/or Tableau for visualization and reporting

Job Tags

Similar Jobs

TradeJobsWorkforce

Forensic Psycologist Job at TradeJobsWorkforce

 ...Forensic Psycologist Job Duties: Evaluates patients and defendants for symptoms of mental disorders and behavioral problems. Conducts mental status examinations and psychosocial histories. Develops DSM-5 diagnoses. Performs comprehensive evaluations of competence... 

The Portland Regency Hotel & Spa

Boutique Hotel Housekeeping & Laundry Attendant Job at The Portland Regency Hotel & Spa

 ...A historic boutique hotel in Portland is seeking a Housekeeping team member for both part-time and full-time positions. Responsibilities include cleaning guest rooms, changing bed linens, and ensuring high cleanliness standards. The role requires reliability, attention... 

Cypress HCM

Data Analyst Job at Cypress HCM

 ...Job Description Data Analyst Must be located in Omaha NE to work Hybrid schedule (3 days onsite)*** Overview We are the worlds largest professional...  ...hybrid work option, meaning you can both work from home and commute to a LinkedIn office, depending on what... 

SourcePro Search

Paralegal Specialist (Law Firm Experience) (San Francisco) Job at SourcePro Search

 ...and case files; compile documents for filing with courts and agencies; Process and manage confidential client information using eDiscovery tools, extranets, and similar, including for source code review, document review, and document production; Conduct electronic... 

Stoltzfus Meats, Inc.

Sanitation Worker Job at Stoltzfus Meats, Inc.

 ...The Sanitation Worker plays a critical role in ensuring the cleanliness and food safety of all areas within our meat production and processing facility. This position is responsible for cleaning and sanitizing production equipment, work areas, and common spaces to meet...