What are the responsibilities and job description for the Business Intelligence Developer position at Medxcel?
Overview
Medxcel is here to lead the transformation of healthcare facilities management by incorporating a new approach to providing services. Created by healthcare, for healthcare, we have a dedicated focus on our people and customers, as well as providing tools, processes, support resources, data analytics and insource strategies that drive results.
The Business Intelligence Developer will provide comprehensive business and technical experience to fill the exponential growth and maturity of reporting. The skills of communication, business acumen to recognize the macro and micro side of business needs, and technical experience to navigate complex projects will be attributes needed to be successful in this role. The job will comprise largely of manipulating large sets of data to develop simple to understand visualizations within reporting.
This position will be located at Central Office- Indianapolis,IN.
“As a healthcare company we have an important responsibility to protect individual and public health. This position will require individuals to be fully vaccinated against COVID-19 as part of their job responsibilities, unless an exemption can be confirmed based on a medical condition or sincerely held religious belief. Submission & Approval of an Exemption does not guarantee that an exemption can be accommodated.”
Responsibilities
Reporting Requirements
- Meet with business/stakeholders to gather process and logic requirements
- Documentation (Azure DevOps) of User Stories and Features
- Follow up with business as needed to insure requirements are being met
Reporting Development/Maintenance
- Review existing reporting to determine if the request can be provided without changes and / or with modifications
- Utilize existing models, develop queries via Microsoft Sequel Query Language(SQL), DAX formulas to perform data discovery
- Data analysis based on data discover for feasibility of request
- Development of plan to provide a Minimum Viable Product (MVP) of reporting requirements based on process and logic
- Provide MVP review time with business/stakeholders to determine if development is meeting business need
- Move MVP to production to provide meaning information as soon as possible and continue refining the report to provide full functionality over time
- Create feedback loop for continuous improvement of report based on business need
Team/Individual Coordination and Development
- Attend recommended training to further refine skills
- Collaborate with team to gain institutional knowledge of process, logic and technical skills
- Utilize defined data models used to create reporting consistency / efficiency
- Share knowledge with team to assist in elevating skills of all exponentially
- Provide feedback to peers to improve internal feedback loop for better communication
Qualifications
Education:
- Microsoft Certified: Azure Enterprise Data Analyst Associate (with 5 years working experience in business/data analytics) required
- Bachelor’s Degree in either: Data Analytics, Data Science, Math, Business or related degree preferred
License/Certification:
- Microsoft Certified: Azure Enterprise Data Analyst Associate (in lieu of bachelor’s degree) required
- Microsoft Certified: Azure Enterprise Data Analyst Associate preferred
Experience:
- 3 years (with bachelor’s degree) required
- 5 years (with Microsoft certification) preferred
Knowledge, Skills and Abilities:
3 years’ experience working in large scale data warehouse environments. Power BI work experience is required. This would include: understanding what visuals best represents the story being conveyed to its end users; extensive knowledge of using SQL / DAX Formulas and knowing how to balance the use of each; familiar with producing reports with user experience at the center of development. Effectively communicate with audiences of all levels of the organization. Ability to flexible and prioritize base of business needs. Creative out of the box thinker while being well versed on business intelligence best practices and practical approaches to meet business initiatives. Collaborative team player/environment with the ability to work independently. Familiar with Agile methodology.
Skills include:
- Intermediate/expert level SQL writer
- Managing large/complex sets of data providing easy to understand results
- Experience using/developing DAX formulas
- Added benefit with experience using software / languages such as DAX Studio, R, Python, Tableau, SSRS, SSMS, SSAS, Excel, Power Platform, Paginated Reports.
#MFMCORP