BI Developer II

Job Description: • Serve as an integral part of HSAG Data Science & Advanced Analytics division. • Works in conjunction with staff and customers to define dashboard requirements. • Design, develop, and maintain reports and multi-level dashboards. • Design and implement proof of concept solutions and create advanced BI visualizations. • Experience working with Ad-hoc Business Objects Web Intelligence Reports. • Develop impactful presentations and documents. • Design, develop, and automate end-to-end ETL solutions using dynamic SQL to perform file validation, manage staging-to-production pipelines, and process large-scale datasets. • Architect and implement complex business rules within the SQL environment to ensure data transformation meets rigorous contract and project specifications. • Lead data quality management by developing SQL-based validation frameworks and implementing automated corrective actions to resolve data anomalies. • Author and maintain comprehensive technical documentation, including data mapping, ETL workflow diagrams, and internal policies that ensure data is secure, accurate, and accessible. • Provide advanced technical support and troubleshooting to corporate staff, HSAG clients, and contractors regarding data gathering, database design, and dissemination activities. • Oversee the technical User Acceptance Testing (UAT) process to validate that data loads and system outputs meet customer and budget requirements. • Manage the full data project lifecycle, ensuring the timely delivery of high-quality data products while adhering to project schedules and contract milestones. • Collaborate with other HSAG departments to troubleshoot project activities and provide data support services for complex customer research issues. • Stay current on emerging database structures, ETL technologies, and analytic methodologies, communicating relevant advancements to the team to improve internal data infrastructure. • Communicate complex topics to team through both written and oral communications. Requirements: • Bachelor’s degree in computer science, computer information systems, or a quantitative discipline; Master’s degree preferred. • At least 3 years of experience building visualization solutions using Tableau, Amazon QuickSight, and Power BI. • At least three (3) years of experience with ETL processes in a Microsoft SQL server environment. • At least three (3) years of data warehousing experience. • Experience gathering and refining requirements, interviewing business users to understand and document data requirements is required. • Strong attention to detail, documenting business and technical requirement based on user interviews is required. • Experience with Microsoft SQL Server, SSIS, and SSAS is preferred. • Experience working with healthcare data is strongly preferred. Benefits: • UNIQUE BENEFITS • The BI Developer II position benefits from HSAG’s desire to grow its staff into future leaders in the areas of healthcare data science and quality improvement. Under the direction of the Director of Business Intelligence and other senior DSAA leaders, the BI Developer II position collaborates directly with analysts and data scientists on a wide array of projects that would benefit from the visual display of data in Tableau, Amazon QuickSight, or comparable software.