Business Intelligence Data Analyst – III

Why Orthofix?
    

Guided by our organizational values – Take Ownership | Innovate Boldly | Win Together – we collaborate closely with world-class surgeons and other partners to improve people’s quality of life. At Orthofix, we want team members who build relationships and share knowledge, challenge the status quo, and deliver results every day to help us achieve our vision to be the unrivaled partner in Med Tech.  

Our global team of over 1,600 employees brings to market highly innovative, cost-effective, and user-friendly medical technologies that heal musculoskeletal pathologies for patients and the healthcare professionals who treat them. Looking to change people’s lives? Look no further.

Job Duties: Work with internal/external customers and IT to gather and validate requirements. Accountable for the understanding of how data is turned into information and knowledge and how that knowledge supports and enables key business processes. Provide development support for various BI outputs such as dashboards, reports and other ad-hoc data requests and ensure data quality standards. Provide administration for BI reporting system environments, perform data model automation expertise. Design, develop, and maintain ETL pipelines and data integration solutions using tools like Azure Data Factory (ADF). Perform data profiling, modeling (logical/physical), and implement dimensional models (star schema). Troubleshoot and optimize SQL/ETL performance; collaborate with DBAs for tuning and migration. Build AI/ML solutions and proactively build POCs/projects to expand data science automation capabilities including Gen AI/Copilot and predictive analytics. Coordinate with offshore teams and cross-functional stakeholders. Work with business and IT leadership on project planning, prioritization, and budgeting. Contribute to the evolution of enterprise data architecture, including migration to modern cloud-based EDW solutions. Implement DevOps and CI/ CD processes for version control and deployment (GitHub preferred). Provide operational support for data refreshes and production issues. Provide work level estimates for projects to establish work plans with the business for IT projects, support, and capitalized initiatives. Maintain and develop functional and technical documentation for BI environments while following documentation guidelines. Perform code reviews on BI changes where appropriate. Maintain appropriate skills needed for team growth in the skills matrix and determine areas requiring training. Act as mentor for newer members of the BI team. Assure execution of Standard Operating Procedures impacting the BI team. Collaborate with Business and IT management on prioritization, budgeting and planning of projects. Continue to develop and assist in the promotion of the company’s corporate culture environment. Work with other departments and company-wide to establish initiatives. Assist in the various audits.

Minimum Requirements: Master’s degree in Computer Science, Computer Engineering, Information Systems, Business Analytics, Business Management, or related field and 2 years of experience working with SQL, including writing and tuning stored procedures; working with Power BI and Fabric architecture, including Desktop, Service, Dataflows, and Row-Level Security; working with Azure Data Factory, DevOps (GitHub), and Data Lake/Lakehouse cloud data platforms; and working with ERP systems, including Oracle EBS, and business processes including Order to Cash, and Procure to Pay.

Job Location: Lewisville, TX

DISCLAIMER

The duties listed above are intended only as representation of the essential functions of this position.  The omission of specific statements of duties does not exclude them from the position if the work is similar, related, or a logical assignment to the position.  The job description does not constitute an employment agreement between the employer and employee and is subject to change at the sole discretion of the employer.  Nothing in this document alters an employee’s at-will employment status.

We are committed to providing equal employment opportunities to all employees and applicants without regard to race (including traits historically associated with race, such as hair texture and protective hairstyles, including braids, locks, and twists), ethnicity, religion, religious creed (including religious dress and grooming practices), color, caste, sex (including childbirth, breast feeding, and related medical conditions), gender, gender identity or expression, sexual orientation, national origin, ancestry, citizenship status, uniform service member and veteran status, marital status, pregnancy, age (40 and over), protected medical condition (including cancer and genetic conditions), genetic information, disability (mental and physical), reproductive health decision-making, medical leave or other types of protected leave (requesting or approved for leave under the Family and Medical Leave Act or the California Family Rights Act), domestic violence victim status, political affiliation, or any other protected status in accordance with all applicable federal, state, and local laws.

This policy extends to all aspects of our employment practices including, but not limited to, recruiting, hiring, discipline, termination, promotions, transfers, compensation, benefits, training, leaves of absence, and other terms and conditions of employment.