View all jobs

Senior Business Intelligence Engineer

Dayton, Ohio
Fusion HCR is hiring a Senior Business Intelligence Engineer for a direct hire position based in Dayton Ohio or Boston, MA.

Role Summary:

Responsible for the design, implementation, and maintenance of all relational SQL aspects of the data analytics platforms in use within the Firm.  Responsible for interpreting the business needs into technical requirements and develop such requirements on the dimensional model.  Acts as the Technical Reference User for our enterprise data warehouse being fully responsible for documentation, development, and deployment of SSIS packages, SQL objects and queries.

Role Description:
  • Responsible to ensure alignment between the data analytics platforms (Data warehouse) environment and business requirements
  • Leverage SQL schemas develop SSIS packages, SQL tables, views, store procedures, functions and queries.
  • Creates and delivers end-user training and documentation and provides second-line support to power users who develop reports on behalf of their departmental colleagues
  • Performs application deployments, upgrades, and patch planning.
  • Participate and contribute to daily scrum meetings
  • Maintains awareness of technology developments and makes recommendations to the Manager, Data Analytics Services
  • Participates in software licensing and support agreement discussions.
  • Assists with resolution of escalated incidents and participates in problem management activities. Assumes ownership of level 3 support and troubleshooting of assigned data solutions
  • Assists in evaluating the business relevance and requirements of projects under consideration.
  • Maintain existing data solutions, design and build from the ground up new data solutions including data warehousing dimensional models
  • Mentors junior developers.
  • Assumes additional responsibilities as assigned.
  • Contributes to the firm's Service Excellence initiative to consistently improve its image internally and externally. Displays professionalism, quality service and a "can do" attitude to internal members/departments of the firm as well as external clients and vendors via electronic and print correspondence, over the telephone and in-person.

Role Skill / Experience Requirements:
  • Excellent analytical skills, including the ability to perform advanced research that involves interpretation and analysis of data from a variety of sources
  • Translation of business questions and requirements into reports, views, and SQL queries
  • Expert knowledge of data warehouse architecture, data design patterns and data transformation best practices in environments of medium to large volume of data
  • Advanced experience in tuning SQL query performance, identifying the need and creation of SQL indexes
  • Advanced hands-on experience with SQL, data warehouse concepts including dimensional modeling
  • Strong problem-solving and tenacity in creating solutions for complex and performant data challenges while handling hundreds of millions of records
  • Knowledge of DAX is a plus
  • Knowledge in at least one scripting language for predictive analytics and data visualization. (R or Python) is preferred
  • Hands on expertise with implementation of a MS Analyses Services Cube using the Tabular model or PowerBI data models is preferred
  • Working knowledge in developing Power Automate flows is preferred
  • Good knowledge of server hardware, server storage and other infrastructure, client/server applications, and server utilities
  • Expert knowledge of SQL Server 2016/2019 and strong SQL skills is required
  • Strong discipline in following SQL coding styles which improves code supportability
  • Experience supporting a 24x7 production environment
  • Ability to work effectively with both users and technical staff in team-oriented environments
  • Excellent oral and written communication skills and interpersonal skills including the ability to effectively communicate technical information to both technical and non-technical personnel
  • Ability to work successfully and independently in an atmosphere of multiple projects, shifting priorities, and deadline pressures
  • Working knowledge of Information Technology Infrastructure Library (ITIL), Microsoft Operations Framework, ISO 9000 or similar process discipline is preferred

Preferred Skills / Experience Requirements:
  • 8-10 years’ experience in data analysis and data warehousing, with significant specialization in one or more areas of the above-mentioned areas of technology
  • Experience with legal financial data models is a plus
  • College degree in related field preferred however relevant experience will be considered in lieu of degree.

More Openings

Billing Clerk
Dialysis Nurse (RN)

Share This Job

Powered by