Senior Business Intelligence Developer

Company DescriptionAmwell digitally empowers payers, providers and innovators, enabling an ecosystem of care that spans across in-person, virtual and automated care.Amwell provides a leading hybrid care enablement platform in the United States and globally, connecting and enabling providers, payers, patients, and innovators to deliver greater access to more affordable, higher quality care.Amwell believes that hybrid care delivery will transform healthcare. The company offers a single, comprehensive platform to support all digital health needs from urgent to acute and post-acute care, as well as chronic care management and healthy living.With nearly two decades of experience, Amwell powers the hybrid care of more than 55 health plans, which collectively represent more than 90 million covered lives, and many of the nation’s largest health systems, representing over 2,000 hospitals, have access to Amwell solutions.For more information, please visit Amwell.com.Brief Overview:Working closely with cross-functional business partners, the Business Intelligence Developer will proactively identify, define, and lead the development of BI reporting solutions. In this role, you’ll be updating existing reports with new data on a recurring basis and responding to business requests for new analytic deliverables.The ideal candidate is a self-starter with an insatiable curiosity. The ideal candidate must be able to proactively identify and lead opportunities to improve processes and deliverables while demonstrating quality and accuracy of data assets and analytic deliverables through close attention to detail and strong follow-through. This role offers opportunities for growth within the broader team as we expand our telehealth solution to more customers and new capabilities, as you’ll pitch in to support our overall workload.Core Responsibilities:• Identify and lead the development of scalable and automated analytic processes and workflows• Identify and lead the development of ETL data flows• Ensure quality and accuracy of data assets and analytic deliverables• Identify and lead initiatives to improve processes for, and the quality of, data assets and analytic deliverables• Interpret data, analyze results, and provide ongoing analysis to key stakeholders as needed• Analyze data for anomalies and early indication of bugs in reporting• Build intuitive and modern analytic dashboards, while adhering to data visualization best practices• Stay abreast of analytic technologies (e.g. Data lakes and analytics on AWS, R, Python, Tableau, etc.)• Document programming scripts, processes, and deliverables• Develop an internal network of colleagues, based on a reputation for collaboration, execution, and high-quality workQualifications:• Bachelors or higher in an Informatics or Quantitative field (e.g. Mathematics, Statistics, Economics, Engineering, Computer Science, Information Management)• 3+ years of experience in business intelligence, data analysis, and data engineering• 3+ years of SQL, including complex queries of multiple data sources• 3+ years of developing scalable and automated ETL processes• 2+ years of experience in the SaaS industry (preferably in a data analyst-type role) is a plus• Expert-level experience with Business Intelligence tools (e.g. Domo, Looker, Qlik, Tableau, etc.)• Expert-level data visualization skills• Basic to intermediate proficiency with general-purpose programming languages (e.g. JavaScript, VB, PHP, C++)• Capable of working on multiple projects and context shifts quickly in a fast-paced environment• Ability to translate incomplete or immature objectives into well-defined requirements• Excellent verbal and written communication• Familiarity with the healthcare industry is a plusSkills Required• MS Access, MS Excel, VBA• SSIS and/or other ETL tools• SQL, SQL Stored procedure, SQL data modeling, SQL performance tuning, SQL DBA-related tasks• DOS/BAT file commands• SalesForce/Data Maintenance• WINSCP Scripting• BI tool (eg. Looker)Additional informationJob Level: P3Working at Amwell:Amwell is changing how care is delivered through online and mobile technology. We strive to make the hard work of healthcare look easy. In order to make this a reality, we look for people with a fast-paced, mission-driven mentality. We’re a culture that prides itself on quality, efficiency, smarts, initiative, creative thinking, and a strong work ethic.Our Core Values include One Team, Customer First, and Deliver Awesome. Customer First and Deliver Awesome are all about our product and services and how we strive to serve. As part of One Team, we operate the Amwell Cares program, which brings needed assistance to our communities, whether that be free healthcare for the underserved or for people affected by natural disasters, support for equality, honoring doctors and nurses, or annual Amwell-matched donations to food banks. Amwell aims to be a force for good for our employees, our clients, and our communities.Amwell cares deeply about and supports Diversity, Equity and Inclusion. These initiatives are highlighted and reflected within our Three DE&I Pillars - our Workplace, our Workforce and our Community.Amwell is a "virtual first" workplace, which means you can work from anywhere, coming together physically for ideation, collaboration and client meetings. We enable our employees with the tools, resources and opportunities to do their jobs effectively wherever they are!The typical base salary range for this position is $92,400- $127,050. The actual salary offer will ultimately depend on multiple factors including, but not limited to, knowledge, skills, relevant education, experience, complexity or specialization of talent, and other objective factors. In addition to base salary, this role may be eligible for an annual bonus based on a combination of company performance and employee performance. Long-term incentives and short-term variable compensation may be offered as part of the compensation package dependent on the role. Some roles may be commission based, in which case the total compensation will be based on a commission and the above range may not be an accurate representation of total compensation.Further, the above range is subject to change based on market demands and operational needs and does not constitute a promise of a particular wage or a guarantee of employment. Your recruiter can share more during the hiring process about the specific salary range based on the above factors listed.Additional Benefits• Flexible Personal Time Off (Vacation time)• 401K match• Competitive healthcare, dental and vision insurance plans• Birthing parents at Amwell enjoy up to 18 weeks of paid maternity leave• Non-birthing parents enjoy 10 weeks of paid leave• US employees experiencing reproductive loss are eligible for up to 7 days of paid leave• Employee Stock Purchase Program• Free access to Amwell’s Telehealth Services, SilverCloud and The Clinic by Cleveland Clinic’s second opinion program• Free Subscription to the Calm App• Tuition Assistance Program• Pet Insurance