Business Intelligence (BI) Engineer

POSITION SUMMARY:

The Business Intelligence Engineer will be responsible for expanding our data warehouse through the ingestion of several new data sources, optimizing/tuning existing SQL queries and stored procedures, modeling data to meet business needs, automating several business processes, and developing front-end applications to efficiently cleanse and maintain business processes. This will require a skilled professional who can collect and analyze customer requirements, utilize a wide range of tools, and methodically implement solutions to achieve the company’s goals. As a core member of the team, this person will develop custom solutions that solve problems and improve business operations for internal and external stakeholders.

DUTIES/RESPONSIBILITIES:

• Develop, deploy, maintain, and support high quality applications, including PowerApps user applications.
• Automate business processes with Power Automate.
• Use various connectors to connect disparate systems to Power Platform applications.
• Contribute to the development, maintenance, and support of business intelligence solutions, including data warehousing, metadata management, ETL processes, reports, and multidimensional cubes.
• Address any source system data not currently present in centralized data repository.
• Perform regular data validity and accuracy checks.
• Construct efficient and well-optimized data structures and data links for diverse data sources, ensuring precision and efficient performance.
• Assist in SharePoint customization and administrative duties.
• Keep abreast of modern technologies and be aware of industry standards, best practices, and trends.
• Perform other duties as assigned.

KNOWLEDGE AND SKILLS:

To perform this job successfully, an individual must be able to perform each essential responsibility satisfactorily. The requirements listed below are representative of the knowledge, skills and abilities required.

EDUCATION/EXPERIENCE:

• 5+ years of experience in software development life cycle, relational modeling, and dimensional modeling.
• 5+ years of experience with SQL Development including SQL queries, stored procedures, query tuning, Azure Data Factory, etc.
• Strong technical skills with BI tools including Power BI and DAX (data analysis expressions), SQL Server Reporting Services, and SQL Server Analysis Services, as well as demonstrable experience designing and integrating APIs
• Experience in a healthcare environment preferred
• Knowledge of Azure including Blob Storage and Data Factory, with an understanding of integration between the Power Platform and Azure Services.
• Experience with Power Platform security concepts (business units, roles, and more).
• Experience in data modeling, data visualization, and report development in the healthcare industry.
• Experience in Front End Development including with C#, CSS, JS, Bootstrap, or HTML.
• Strong debugging and troubleshooting skills.
• Strong analytic skills with the ability to extract, collect, organize, analyze, and interpret trends or patterns in complex datasets for insights.
• Strong decision-making and critical thinking skills.
• Strong organization and project management skills.
• Effective interpersonal, verbal, and written communication skills.

ABOUT REGENT SURGICAL HEALTH

Since 2001, Regent Surgical Health has been a leader in developing and managing successful surgery center partnerships between hospitals and physicians. We continually improve and evolve the ASC model based on changing market conditions to stay ahead of emerging trends. From this vantage point, our team has developed proprietary ASC ownership models that give both physicians and hospitals what they need to ensure long-term clinical and financial success.

Regent offers a comprehensive and competitive benefits package as one way to recognize our employee’s contribution to the success of the organization and our role in helping you and your family to be healthy, feel secure and maintain a work/life balance.

Pursuant to the ADA, Regent will provide reasonable accommodation(s) to all qualified employees with known disabilities, where their disability affects the performance of their essential job functions, except where doing so would be unduly disruptive or would result in undue hardship.

We do not discriminate in practices or employment opportunities on the basis of an individual’s race, color, national or ethnic origin, religion, age, sex, gender, sexual orientation, marital status, veteran status, disability, or any other prohibited category set forth in federal or state regulations.

We are an equal opportunity employer.