SQL Developer

Why is Health Advocate a great place to work? For starters, Health Advocate employees enjoy helping people every single day. Employees are given the training they need to do their jobs well, and they work with supervisors and staff who are supportive and friendly. Employees have room to grow, and many of Health Advocate's supervisors are promoted from within the company. Join our award winning team! 2025: Stevie® Awards for Sales & Customer Service: Customer Service Department of the Year – Healthcare, Pharmaceuticals, and Related Industries, Bronze Winner 2024: Excellence in Customer Service Awards: Organization of the Year (Small) Stevie® Awards for Sales & Customer Service: Customer Service Department of the Year – Healthcare, Pharmaceuticals, and Related Industries, Bronze Winner Best in Biz Awards: Most Customer-Friendly Company of the Year – Medium and large category (Silver) As part of Teleperformance in the US, we were also named #95 in the 2024 ‘Fortune 100 Best Companies to Work For®’ in the USA by Great Places to Work (GPTW®) Position Summary We're looking for a Business Intelligence Developer who enjoys turning data into meaningful insights. In this role, you'll partner with business teams to understand their goals, explore data, and create dashboards and reports that support informed decision-making. The ideal candidate is naturally curious, enjoys solving complex problems, and is comfortable working through evolving business requirements. You'll have the opportunity to design reporting solutions, improve existing processes, and contribute to a growing analytics environment. Key Responsibilities Develop interactive Power BI reports and dashboards that help users understand business performance. Write efficient SQL queries to extract, transform, and validate data from multiple sources. Create and maintain operational and analytical reports using SSRS. Work closely with business partners to understand reporting needs and recommend effective solutions. Design data models that support accurate, scalable, and high-performing reporting. Investigate trends, identify data patterns, and provide actionable insights. Validate data accuracy and resolve reporting issues by working with source systems and data teams. Improve existing reporting processes through automation and continuous enhancement. Document reporting logic, calculations, and technical solutions. Participate in design discussions, code reviews, and knowledge sharing across the team. Qualifications 3–5 years of experience developing Business Intelligence or reporting solutions. Hands-on experience building reports and dashboards in Power BI. Strong knowledge of DAX, Power Query, and dimensional data modeling. Advanced SQL skills, including joins, CTEs, window functions, and query optimization. Experience developing and supporting SSRS reports. Understanding of relational databases and data warehousing concepts. Ability to analyze business requirements and translate them into technical solutions. Strong analytical, troubleshooting, and problem-solving skills. Nice to Have Experience working with healthcare or insurance data. Exposure to Azure data services or Microsoft Fabric. Familiarity with ETL processes and tools such as SSIS or Azure Data Factory. Experience using Azure DevOps, Git, or other version control tools. Understanding of Agile development practices. Knowledge of data governance and security best practices. What Makes You Successful You enjoy learning how a business works and using data to answer meaningful questions. You can independently manage your work while collaborating effectively with teammates and stakeholders. You're comfortable asking questions, challenging assumptions, and proposing better approaches. You take pride in delivering accurate, reliable, and user-friendly reporting solutions. You're adaptable, eager to learn new technologies, and always looking for ways to improve. You communicate technical concepts clearly to both technical and non-technical audiences. You value quality, attention to detail, and continuous improvement. Company Overview Health Advocate is the nation’s leading provider of health advocacy, navigation, well-being and integrated benefits programs. For 20 years, Health Advocate has provided expert support to help our members navigate the complexities of healthcare and achieve the best possible health and well-being. Our solutions leverage a unique combination of best-in-class, personalized support with powerful predictive data analytics and a proprietary technology platform to address nearly every clinical, administrative, wellness or behavioral health need. Whether facing common issues or an unprecedented challenge like COVID-19, our team of highly trained, compassionate experts work together to go above and beyond expectations, making healthcare easier for our members and ensuring they get the care they need. Learn more Health Advocate https://www.healthadvocate.com/site/ Facebook https://www.facebook.com/healthadvocateinc/ Video https://vimeo.com/386733264/eb447da080 Awards: 2025: Stevie® Awards for Sales & Customer Service: Customer Service Department of the Year – Healthcare, Pharmaceuticals, and Related Industries, Bronze Winner 2024: Excellence in Customer Service Awards: Organization of the Year (Small) Stevie® Awards for Sales & Customer Service: Customer Service Department of the Year – Healthcare, Pharmaceuticals, and Related Industries, Bronze Winner Best in Biz Awards: Most Customer-Friendly Company of the Year – Medium and large category (Silver) 2023: National Customer Service Association All-Stars Award: Service Organization of the Year. Stevie® Awards for Sales & Customer Service: Customer Service Department of the Year – Healthcare, Pharmaceuticals, and Related Industries, Bronze Winner 2022: Stevie® Awards for Sales & Customer Service: Customer Service Department of the Year – Healthcare, Pharmaceuticals, and Related Industries, Bronze Winner Excellence in Customer Service Awards: Organization of the Year (Small) Best in Biz Awards: Most Customer-Friendly Company of the Year – Medium and large category (Silver) 2021: Stevie® Awards for Sales & Customer Service: Customer Service Department of the Year – Healthcare, Pharmaceuticals, and Related Industries, Silver Winner Stevie® Awards for Sales & Customer Service: Most Valuable Response by a Customer Service Team (COVID-19). Bronze Winner Best in Biz Awards: Most Customer-Friendly Company of the Year – Medium and large category (Silver) 2020: National Customer Service Association All-Stars Award: Organizations of 100 or Greater, Runner-Up Communicator Award of Distinction: October 2019 Broker News MarCom Awards: Gold, COVID Staycation Ideas brochure MarCom Awards: Platinum, 2021 Well-being Calendar Best in Biz Awards: Most Customer-Friendly Company of the Year - Medium category (Silver) VEVRAA Federal Contractor requesting appropriate employment service delivery systems, such as state workforce agencies and local employment delivery systems, to provide priority referrals of protected veterans. PAY TRANSPARENCY NONDISCRIMINATION PROVISION The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-I.35(c)