Senior Business Intelligence Engineer

Role Summary

Senior Business Intelligence Engineer

Responsibilities

• Technical liaison with Data Engineering team to build databases and sources for reporting in Power BI and other tools.
• Help guide the direction of the Data Engineering team building an analytical infrastructure for BI and Analytics.
• Technical lead on complex data modeling, measure building, advanced analytics, data science, etc.
• Supports analytic efforts to translate business needs into analytic solutions that provide actionable, decision-making information throughout the organization.
• Support the Informatics & Applications Team by developing and deploying dashboards and reports in Microsoft Power BI.
• Build Power BI and PowerPivot data models using SQL Queries, DAX, M and advanced Excel functions.
• Set up and share dashboards and reports with end users through the Power BI online service.
• Support end users from all departments with questions, navigation, set up and functionality of new and current dashboards and reports.
• Extracts and manages large data sets to develop reports, leverages understanding of data warehouses and information management systems to do so effectively.
• Responsible for data investigations and queries.
• Responsible for ensuring data accuracy throughout all reports.
• Communicate with Project Managers and end users to ensure timelines are agreed upon and being met.
• Participates with varying degree of involvement in cross-functional projects as needed.
• Other requests as needed by the Manager, Data Engineering & Business Intelligence

Qualifications

• 4-year college degree or equivalent work experience required.
• 5+ years of Business Intelligence experience required.
• Educational background in Computer Science or Engineering, Math, Statistics, Informatics, Information Systems or another quantitative field.
• Experience with relational SQL databases, including MS SQL Server, PostgreSQL.
• Experience with Microsoft Azure cloud services: Azure Data Factory, Data Pipelines, Data Bricks, Azure Functions, Storage, SQL Database and/or Data Warehouse, etc.
• Working knowledge of the differences between different database designs and data storage techniques, i.e. Operational Database vs. Data Warehouse/Star Schema or SQL vs. NOSQL and where or why you might use each.
• Understanding of Data Lake design, implementation, and organization.
• Some familiarity with the Microsoft Dynamics 365 suite, particularly the Finance & Operations and Retail modules.
• Passion for learning new and better ways to do things – you are always tweaking your current processes and finding ways to improve them or make them more efficient.
• Willingness to take ownership of your projects and research new applications, languages, or modalities that you are not familiar with.
• Intellectual curiosity to find new and unusual ways of how to solve data management issues.
• Familiarity with Health data and the healthcare space is a big plus.

Skills

• Power BI
• SQL
• DAX
• Data modeling
• Azure data services
• Dashboard/report development

Education

• 4-year college degree or equivalent work experience

Additional Requirements

• Remote position