What You Will Do

The Lead Business Intelligence Engineer is responsible for overall technical delivery of dashboards and reports using the Microsoft BI stack and migration from SSRS reports to Power BI. The Lead Business Intelligence Engineer will perform their job function by executing all phases of the Software Development Lifecycle including: Analysis, Design, Development and Testing while working in a highly collaborative team environment.

The Lead BI Engineer should be able to:

• Participate in requirements sessions to understand business needs and come up with recommendations of features and visualizations that can best achieve the needs of the business using Power BI Dashboards, Power BI Paginate or SSRS.
• Provide input and assist in designing reporting schemas that will be used in the dashboard - based on understanding of metrics and dimensions in report specification.
• Write complex SQL code, as required, to create data source for reports and dashboards.
• Develop dashboards of varying complexity making sure functionality is aligned with business requirements.
• Design and develop SQL stored procedures, functions, views, and triggers
• Design, code, test, document and troubleshoot deliverables
• Develop new or enhance existing reports based on business requirements.
• Determine and communicate project feasibility and sizing estimates through analysis, problem definition, requirement gathering, and solution development.
• Collaborate with others to test and resolve issues with deliverables
• Maintain awareness of and ensure adherence to standards regarding privacy.
• Create and maintain Design documents, unit test cases, data seeding.
• Ability to perform Data Analysis and Data Quality tests.
• Perform Continuous Integration and deployment using Azure Devops and Git

Skills and Experience You Will Need

• 5 years in developing Power BI Dashboards, Power BI Paginated reports.
• Experience with Power BI Premium and Power BI Architecture.
• Experience with Power BI Data Sets, Dimensional Modeling, Performance tuning of Power BI Data Sets.
• Experience with DAX language.
• Experience working with Microsoft BI stack (SSIS/SSRS/SSAS) and Microsoft SQL server. (5+ Years)
• Experience of deployment of Power BI Dataset and reports using ALM toolkit.
• Experience with Git and Azure Devops.
• Experience in Agile, Jira and Confluence.
• Solid understanding of programming SQL objects (procedures, triggers, views, functions) in SQL Server. Experience optimizing SQL queries a plus.
• Advanced understanding of T-SQL, indexes, stored procedures, triggers, functions, views, etc.
• Must be detail-oriented. Must work under limited supervision. Must demonstrate good analytical skills as it relates to data identification and mapping and excellent oral communication skills. Must be flexible and able to multi-task and be able to work within deadlines; must be team-oriented, but also be able to work independently.
• Have Healthcare experience.

Who We Are

GalaxE is a professional IT services firm that specializes in platform-driven solutions and the use of automation to achieve enterprise business transformation and mission-critical change for some of the largest companies in the world. Using our proprietary solution set, GxFource®, we apply machine learning techniques and predictive analytics tools as part of a broad artificial intelligence strategy that provides effective impact and data-driven business transformation.

Since its founding, GalaxE has been dedicated to advancing the benefits of technology. As we continue that legacy and look to the future, a focus on business enablement through agile, cost-efficient, and effective integration of people, process, and technology anchors our success. We revolutionize change in the costs of doing business that transform companies and their ability to leap beyond the competition.

At GalaxE we value people and are committed to diversity and inclusion where our employees are made to feel comfortable and are encouraged to be authentic. We focus on cultivating both traditional IT and non-traditional, new collar, workers through our Outsource to America®, program.

We are always looking for passionate, entrepreneurial-minded innovators and disrupters; game-changers that take ownership of the work they produce and bring it each and every day. Working with like-minded team members you will get a chance to discover, develop, and use cutting-edge technologies to transform the way we deliver creative business solutions.

Sound like you? Join us and find out for yourself what it means for you, and your career, to be part of the GalaxE team. Let's build something, together. #WeAreGalaxE

Equal Opportunity Employer/Veterans/Disabled

Physical Requirements:

• Prolonged periods of remaining stationary at a desk and working on a computer
• Must be able to lift to 15 lbs., as needed
• Must be able to work on-site (corporate/client offices), as needed (not applicable for 100% remote roles)
• Occasionally required to bend, kneel, crouch, and reach overhead.
• Hand-eye coordination necessary to operate computers and various pieces of office equipment.
• Specific vision abilities required include close vision, the ability to tolerate fluorescent lighting, and the ability to adjust focus.

Employees must be able to perform the physical requirements of the position satisfactorily and, if requested, reasonable accommodations will be made to enable employees requiring accommodations to perform the essential functions of their jobs, absent undue hardship.

For more information, please visit https://www.galaxe.com/