Southern Orthodontic Partners
Data Analyst
Southern 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.
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.
Responsibilities
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, and 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
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
Full‑time position. Salary: $65,000.00–$75,000.00 (Goodlettsville, TN) (subject to location). If you are ready to make a measurable impact on orthodontic practice operations, apply today.
#J-18808-Ljbffr
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.
Responsibilities
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, and 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
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
Full‑time position. Salary: $65,000.00–$75,000.00 (Goodlettsville, TN) (subject to location). If you are ready to make a measurable impact on orthodontic practice operations, apply today.
#J-18808-Ljbffr