BI Developer

At Lucet, we are industry leaders in behavioral health, dedicated to helping people live healthy, balanced lives. Our purpose is to advocate for and improve the overall well-being of those we serve, through balanced treatment of the mind and body. When you join Lucet, you become a valued member of our team, serving more than 15 million people across the U.S. Our employees have a passion for helping others - and it shows. From entry-level employees to senior leaders, we are inspired by our members, putting them first in everything we do. From day one, youll see firsthand the impact you have on our members, knowing you can make a true difference in their lives. Why join our team at Lucet? We are a team of collaborative and hard-working professionals working to improve behavioral health outcomes working in a fast-paced and changing environment. At Lucet, no two days are the same. If you find joy in meaningful work and delivering excellent results, we encourage you to apply! We are looking for top-tier skills and experience in our remote-work environment and that’s because we offer top-tier compensation and benefits, which include : Annual compensation between $95,000 - $115,000, PLUS an annual performance-based, discretionary incentive. Compensation is dependent on non-discriminatory factors including but not limited to an applicants skills, education / degrees, certifications, prior experience, market data, and other relevant factors. Health Insurance – $0 premium for employee-only coverage in our core program for those participating in our Wellbeing Incentive Program. 401(k) with competitive employer match Company paid life and disability insurance, wellbeing incentives, and parental leave Professional development opportunities and tuition reimbursement Paid time off including paid time off for volunteering Opportunity for meaningful growth, both personally and professionally, where your unique background and experience is welcomed and valued. What You Will Do - Essential Functions As a Business Intelligence Developer, you will be responsible for aggregating data from multiple data sources and designing, building, and supporting enterprise level BI and analytics solutions that will enable business users to make informed business decisions. The individual will work closely with business stakeholders to gather requirements, design and develop reports, dashboards, and ad-hoc queries against Lucet’s data warehouse and operational systems. In addition, the role will collaborate with the larger Reporting and Analytics and Data Engineering teams to provide advice and requirements for data modeling, predictive analytics, data visualization, and data governance. Data Analysis & BI Solution Development Perform analysis of data sources, business processes and data mining to understand the nuances, integrity, completeness, and accuracy of the data. Utilize tools such as SQL, SSIS, SSRS, and Tableau to architect business intelligence and reporting solutions. Design and implement best-practice BI solutions and reports that will support business decisions. Stakeholder Collaboration & Support Consult with all levels of users to help them solve problems regarding the use and management of data as well as work on design, maintenance, and completion of highly visible organizational projects. Establish and maintain cooperative and supportive relationships with customers and stakeholders Create and maintain of data domain specific documentation including reporting requirements and data maps. Project Management & Continuous Improvement Manage multiple tasks / projects to timely completion with attention to detail and responsiveness. Demonstrate independent thought, critical thinking, and a proactive approach to problem-solving. Support data governance initiatives, including metadata management and data stewardship. Adhere to Lucet’s Mission Statement, Core Values, Behaviors, Code of Ethical Business Conduct, and Compliance Program. Comply with all Federal and applicable State and local laws and Lucet Policies and Procedures regarding privacy, confidentiality, and security of health information, and other designated information. Who You Are Required Qualifications Behavioral health and EAP experience required. BS / BA degree plus with demonstrated experience in BI, with experience in Healthcare Industry strongly preferred Strong knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS). Experience with SSAS is a plus. Proficiency in analytic tools such as SQL,SAS,R or Python Strong experience with Tableau and familiarity with other data visualization tools In-depth understanding of database management systems and data modeling (relational and dimensional) Experience in data warehousing, particularly within the healthcare industry Experience building scalable BI applications Experience working with end-users and translating their business needs into technical solutions Good working knowledge skills with Microsoft Office products. Good working knowledge of gathering requirements and agile processes. Analytical mindset with a problem-solving aptitude Willingness to work occasionally outside of normal business hours. Ability to pass background check upon hire and throughout employment to include criminal felony & misdemeanor search, SSN validation / trace search (LEIE), education report (highest degree obtained), civil upper and lower search, 7-year employment report, federal criminal search, statewide criminal search, widescreen plus national criminal search, health care sanctions-state med (SAM), national sex offender registry, prohibited parties (OFAC) (terrorist watchlist), and a 10-Panel Drug Screen. Preferred Qualifications Experience in healthcare industry Experience with SSAS Someone who embodies our values by : Serving everyone with compassion and leading with empathy. Stepping up and creating value by taking charge and acting when there is an opportunity. Adapting in a changing world by recognizing our responsibility to be agile and respond quickly. Nurturing growth and belonging by respecting and celebrating everyone for who they are. Competencies Collaboration skills and leadership attributes Ability to proactively communicate status, issues, and risks to management Ability to problem solve Working Conditions : Work is performed from home with company-provided equipment. Sitting for long periods of time is expected and use of fingers and hands for typing is necessary. A quiet workspace with minimal background noise for calls. High-speed internet service (cable or fiber optic) with minimum download Speed of 20 Mbps, Upload Speed of 5 Mbps, and Maximum Latency of 100 milliseconds (must be installed before starting). We encourage applicants with a range of experiences who can demonstrate how their qualifications and skills align with the requirements of this role. This position will accept and review new applications and resumes no less than 5 business days after the original posting date and may remain open an extended period of time with no set end date based on the level of interest. Qualifications Education Required Bachelors or better. Experience Preferred Data Analyst BI Developer Equal Opportunity Employer / Protected Veterans / Individuals with Disabilities This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.aa415a4b-8b21-40fc-a65c-70d2b25ca29a