Silverchair
Senior Business Intelligence Developer
Silverchair, Charlottesville, Virginia, United States, 22904
About Silverchair
Silverchair is the premier independent platform partner for scholarly and professional publishers, dedicated to expanding the reach of the world's most valuable knowledge. By connecting creators, publishers, and users, we amplify the impact of scholarship and enhance the accessibility of critical information. Our global teams develop, build, and host websites, online products, and digital libraries for prestigious publishers, including the American Medical Association, MIT Press, and Oxford University Press.
Overview
Silverchair is expanding its Analytics team and seeking a Senior BI Developer with a strong background in Microsoft technologies to enhance our data analytics product offerings. This individual will be embedded within our Analytics team, bringing extensive experience in Power BI, Azure, and advanced report building. The successful candidate will play a pivotal role in furthering our data analytics capabilities, ensuring robust, scalable reporting solutions that align with Silverchair's business objectives and building AI-assisted development practices in Power BI. As a Senior BI Developer, you will ensure that data analytics services are robust, scalable, and aligned with business operations. This role is instrumental in supporting key client-facing products and decision-making processes through data-driven insights. This senior-level position requires someone who can influence the shaping of analytics products in addition to building them, with the ability to grow into lead and architect capabilities over time. Responsibilities
Advanced Business Intelligence Development: Create, deploy, and maintain complex Power BI reports and other artifacts using modern tooling and automation practices, ensuring scalable solutions that meet business requirements and deliver measurable value while shaping analytics product direction and execution strategies. Semantic Modeling: Design and maintain enterprise-grade semantic models with multiple dimension and fact tables, implementing accurate DAX calculations, optimizing performance for large datasets, and ensuring scalability across client implementations. Azure Platform Utilization: Leverage various Azure services including Synapse dedicated SQL pool, on-premise SQL databases, Azure SQL databases, and Synapse serverless SQL pool to build and maintain sophisticated data analytics solutions. Multi-Client Analytics Architecture: Work within existing enterprise Power BI infrastructure including standardized workspace environments, deployment pipelines, and version control processes. Contribute to maintaining and improving analytics platform standards and governance. Cross-functional Collaboration: Work closely with data engineering team, internal client-facing teams, and product stakeholders, including coordinating effectively with executive leadership when required. Project Documentation and Standards: Produce thorough documentation for analytics projects, maintaining alignment with platform, architecture, and code standards while supporting deployment automation and version control processes. Maintain AI literacy and understanding of ethical AI applications in academic publishing and scholarly communications Demonstrate basic prompt engineering skills for effective AI tool utilization Exercise judgment in determining when AI assistance is and is not appropriate for tasks Ensure compliance with Silverchair's AI usage policies and data protection requirements Collaborate effectively with AI tools while maintaining human oversight and professional standards Apply advanced prompt patterns for generating high-quality, maintainable code that meets established standards. Design AI integration architectures that incorporate machine learning models into existing software systems. Optimize AI-enhanced applications for performance, including model inference and resource management in production. Implement responsible AI practices including monitoring, bias detection, and ethical governance frameworks. Train AI systems on Silverchair-specific workflows, domain knowledge, and business processes. Required Skills
Power BI Mastery: 5+ years of experience developing and maintaining Power BI reports and semantic models, with demonstrated ability to work independently with minimal guidance. Modern Enterprise Power BI Development: Expertise with standard 3rd-party development tools (including Tabular Editor, DAX Studio) and proficiency with PBIP (Power BI project files) and TMDL (Tabular Model Definition Language) file formats. Power BI Infrastructure & DevOps: Experience working within enterprise Power BI environments including Git-based version control, automated deployment processes, and multi-workspace environments. Advanced Semantic Modeling: Expertise building complex semantic models with multiple dimension and fact tables, including composite models, role-playing dimensions, and advanced data modeling patterns for large-scale analytics platforms. Advanced Data Analytics Techniques: Deep understanding of Dimensional Modeling in Power BI, including proficiency with DAX and dataset performance optimization best practices for large, complex data models. Azure & Database Proficiency: Demonstrated expertise in Azure services relevant to data analytics, including various Azure SQL technologies and Synapse platforms, plus strong ability to understand, modify, and develop T-SQL queries. Professional Skills: Proven ability to work autonomously with strong initiative, comfortable in cross-functional and culturally diverse team environments, with clear communication skills for technical documentation and executive-level interactions. Desired Experience
Paginated Report Building: Expertise in Power BI Report Builder, SQL Server Reporting Services, or other paginated report development tools. Microsoft Fabric & Workspace Management: Familiarity with Microsoft Fabric CLI & APIs, PowerShell automation for workspace provisioning, deployment pipeline configuration, and service principal authentication for automated processes. Data Governance & Multi-Client Architecture: Experience with data governance processes for client-sensitive analytics environments, including anonymization techniques, secure demonstration environments, and multi-tenant analytics platforms. Development & Leadership: Extensive experience with SQL Server or other relational database systems, working knowledge of Agile Scrum practices, proficiency in M (Power Query), Python, or C#, and previous experience mentoring team members or leading technical initiatives. EEO and Hiring Policy
Silverchair is an Equal Opportunity Employer. We do not discriminate against any employee or applicant for employment based on race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, veteran status, or any other characteristic protected by applicable laws. We are dedicated to ensuring a fair and inclusive hiring process for all candidates. We encourage applications from individuals of all backgrounds and experiences and are committed to providing reasonable accommodation for qualified individuals with disabilities in the application and hiring process. At this time, we cannot sponsor a new applicant for employment authorization for this position. No agencies please. Seniority level
Mid-Senior level Employment type
Full-time Industries
Book and Periodical Publishing IT System Custom Software Development Software Development
#J-18808-Ljbffr
Silverchair is expanding its Analytics team and seeking a Senior BI Developer with a strong background in Microsoft technologies to enhance our data analytics product offerings. This individual will be embedded within our Analytics team, bringing extensive experience in Power BI, Azure, and advanced report building. The successful candidate will play a pivotal role in furthering our data analytics capabilities, ensuring robust, scalable reporting solutions that align with Silverchair's business objectives and building AI-assisted development practices in Power BI. As a Senior BI Developer, you will ensure that data analytics services are robust, scalable, and aligned with business operations. This role is instrumental in supporting key client-facing products and decision-making processes through data-driven insights. This senior-level position requires someone who can influence the shaping of analytics products in addition to building them, with the ability to grow into lead and architect capabilities over time. Responsibilities
Advanced Business Intelligence Development: Create, deploy, and maintain complex Power BI reports and other artifacts using modern tooling and automation practices, ensuring scalable solutions that meet business requirements and deliver measurable value while shaping analytics product direction and execution strategies. Semantic Modeling: Design and maintain enterprise-grade semantic models with multiple dimension and fact tables, implementing accurate DAX calculations, optimizing performance for large datasets, and ensuring scalability across client implementations. Azure Platform Utilization: Leverage various Azure services including Synapse dedicated SQL pool, on-premise SQL databases, Azure SQL databases, and Synapse serverless SQL pool to build and maintain sophisticated data analytics solutions. Multi-Client Analytics Architecture: Work within existing enterprise Power BI infrastructure including standardized workspace environments, deployment pipelines, and version control processes. Contribute to maintaining and improving analytics platform standards and governance. Cross-functional Collaboration: Work closely with data engineering team, internal client-facing teams, and product stakeholders, including coordinating effectively with executive leadership when required. Project Documentation and Standards: Produce thorough documentation for analytics projects, maintaining alignment with platform, architecture, and code standards while supporting deployment automation and version control processes. Maintain AI literacy and understanding of ethical AI applications in academic publishing and scholarly communications Demonstrate basic prompt engineering skills for effective AI tool utilization Exercise judgment in determining when AI assistance is and is not appropriate for tasks Ensure compliance with Silverchair's AI usage policies and data protection requirements Collaborate effectively with AI tools while maintaining human oversight and professional standards Apply advanced prompt patterns for generating high-quality, maintainable code that meets established standards. Design AI integration architectures that incorporate machine learning models into existing software systems. Optimize AI-enhanced applications for performance, including model inference and resource management in production. Implement responsible AI practices including monitoring, bias detection, and ethical governance frameworks. Train AI systems on Silverchair-specific workflows, domain knowledge, and business processes. Required Skills
Power BI Mastery: 5+ years of experience developing and maintaining Power BI reports and semantic models, with demonstrated ability to work independently with minimal guidance. Modern Enterprise Power BI Development: Expertise with standard 3rd-party development tools (including Tabular Editor, DAX Studio) and proficiency with PBIP (Power BI project files) and TMDL (Tabular Model Definition Language) file formats. Power BI Infrastructure & DevOps: Experience working within enterprise Power BI environments including Git-based version control, automated deployment processes, and multi-workspace environments. Advanced Semantic Modeling: Expertise building complex semantic models with multiple dimension and fact tables, including composite models, role-playing dimensions, and advanced data modeling patterns for large-scale analytics platforms. Advanced Data Analytics Techniques: Deep understanding of Dimensional Modeling in Power BI, including proficiency with DAX and dataset performance optimization best practices for large, complex data models. Azure & Database Proficiency: Demonstrated expertise in Azure services relevant to data analytics, including various Azure SQL technologies and Synapse platforms, plus strong ability to understand, modify, and develop T-SQL queries. Professional Skills: Proven ability to work autonomously with strong initiative, comfortable in cross-functional and culturally diverse team environments, with clear communication skills for technical documentation and executive-level interactions. Desired Experience
Paginated Report Building: Expertise in Power BI Report Builder, SQL Server Reporting Services, or other paginated report development tools. Microsoft Fabric & Workspace Management: Familiarity with Microsoft Fabric CLI & APIs, PowerShell automation for workspace provisioning, deployment pipeline configuration, and service principal authentication for automated processes. Data Governance & Multi-Client Architecture: Experience with data governance processes for client-sensitive analytics environments, including anonymization techniques, secure demonstration environments, and multi-tenant analytics platforms. Development & Leadership: Extensive experience with SQL Server or other relational database systems, working knowledge of Agile Scrum practices, proficiency in M (Power Query), Python, or C#, and previous experience mentoring team members or leading technical initiatives. EEO and Hiring Policy
Silverchair is an Equal Opportunity Employer. We do not discriminate against any employee or applicant for employment based on race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, veteran status, or any other characteristic protected by applicable laws. We are dedicated to ensuring a fair and inclusive hiring process for all candidates. We encourage applications from individuals of all backgrounds and experiences and are committed to providing reasonable accommodation for qualified individuals with disabilities in the application and hiring process. At this time, we cannot sponsor a new applicant for employment authorization for this position. No agencies please. Seniority level
Mid-Senior level Employment type
Full-time Industries
Book and Periodical Publishing IT System Custom Software Development Software Development
#J-18808-Ljbffr