Our BI Team is seeking a Senior Business Intelligence Engineer to support the building and maintenance of Power BI reports across various departments and lines of business. This position works cross-functionally with key business stakeholders and is critical to Array as we use data to drive key business decisions.
- Building & maintaining Power BI reports for the various departments and lines of business.
- Working with the Technical Lead to grow & build out backend tables in the Azure SQL DB Data Warehouse that feeds data into Power BI star schemas.
- Support the flow of data through the data analytics pipeline & troubleshooting any breakdowns (e.g., Ensure data flow from Source SaaS platform to Azure Data Warehouse to Power BI)
- Collaborating with other non-technical departments on what new data can be brought into warehouse to drive value for the company and how to optimally visualize it in Power BI reports/dashboards.
- Proactively identifying and building out additional attributes and metrics that support business use case needs.
- Presenting professional data analytic reports, dashboards, PowerPoints, & other information to the C-Suite & executive teams.
- Designing and building new data processes that can automate the day-to-day work of other employees in the organization.
- Be an advocate for data cleanliness and data governance.
- Bachelor’s degree in related field.
- 3 to 5 years of relevant work experience specifically in Power BI, SQL Scripting, Data Modeling, and Cloud Based Data Warehouses
- Experience with Power BI DAX & Power Query
- Experience building star schemas in Power BI
- Strong data analytic capabilities including experience with data collection, manipulation, cleaning, analysis, ETL, and visualization.
- Experience working with Microsoft Azure Data Factory (or similar system) and ETL
- Experience writing in SQL
- Must have the ability to quickly master and become expert in new data solutions & platforms.
- Preferably experience working with data from Salesforce, NetSuite, and ADP
- Preferably experience working & documenting progress in JIRA
- Preferably experience working with healthcare data or clinical administrative data.
- Preferably experience working with EHR Healthcare Data – ideally Epic.
- Preferably have a working knowledge of
- Connecting data sources through an iPaaS via API connections (Informatica)
- API connections and calls with various SaaS systems work and
- Data Engineering best practices including experience with web services (SOAP / REST).
- Understands the importance of Data Governance and Data Cleanliness
- Excellent organization skills, time management and problem-solving skills; the ability to juggle many tasks at the same time; strong attention to detail.
- Effective communication and interpersonal skills over the phone, in person, and via video conference
- Workable experience using the Microsoft Suite Tools (Excel, PPT, Word, Outlook, etc.)
- Strong ability to “Manage Up” - proactively provide updates to necessary stakeholders.
- Ability to assess needs related to the job function and create new processes, documents, structures, and systems accordingly.
- Experience working with multidisciplinary teams and diverse groups; Independent worker, self-starter.
- Compassionate and kind person to colleagues, likable personality
- Ideally a passion for improving behavioral health access for patients in America.
- Must be based in a CST or EST time zone.
Position Logistics
- 100% remote position but does require you to reside in CST or EST time zones
- Full-time employment
- Reports to Senior Director, Data Analytics & Engineering
- FLSA Status Exempt
- The salary range for this role is $130,000.00 to $150,000.00 annual. This information reflects the anticipated salary for this position using current national data. The final offer will be determined based on an individual’s skills, experience, education, and other job-related factors permitted by law.
At Array we strongly value diversity and are committed to equal opportunity and non-discrimination in all policies and practices, including the area of employment. We are proud to be an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, age, disability, Veteran status, gender identity or expression, marital status, genetic information, or any other legally protected status.