Job Closed
This listing is no longer active.
For centuries, John Wiley & Sons, or simply Wiley, has helped both organizations and people develop the knowledge and skills they need to succeed. The company d
Data Analyst – Power BI Specialist
Location
New Jersey
Posted
94 days ago
Salary
$85.5K - $122.6K / year
Seniority
Senior
Job Description
Data Analyst – Power BI Specialist
Wiley - John Wiley & Sons
• Develop and maintain shared semantic models in Power BI using star schema design • Develop SQL queries to extract and manipulate data from our BigQuery database for use in Power BI • Define and implement best practice report/data management through Microsoft Fabric integrations • Review and maintain reports for performance optimizations, style consistency, and best practice improvements • Consult on and support building a data model and structure that enables efficient and accurate reporting and analysis • Consult on wireframe design during the early stages of building new reports to provide guidance on effective visualization and user experience • Consult on the development of strategically insightful reporting dashboards with actionable insights to support key stakeholder decision-making processes
Job Requirements
- Experience (4+ years) in Data Modelling, Data Analysis, or similar
- Demonstrated experience with Power BI, semantic models, and other Microsoft Fabric tools
- Demonstrated proficiency creating SQL queries to manipulate large datasets
- Strong analytical and problem-solving skills, with a focus on best practice and data governance
- Strong attention-to-detail, with the ability to organize and maintain datasets using meticulous, self-determined methods
- Strong communication skills, with the ability to define requirements and explain technical concepts to both technical and non-technical stakeholders
- Experience with BigQuery or other data warehousing platforms
Benefits
- Professional development opportunities
- Meeting-free Friday afternoons
- Robust body of employee programming to foster community
- Health and well-being support for employees
Related Guides
Related Categories
Related Job Pages
More Business Intelligence Developer Jobs
Lead Business Intelligence Analyst, Adobe Analytics, Power BI
BounteousCreating digital solutions for today's challenges and tomorrow's opportunities.
• Turn Marketing Data Into Business Insight • Translate Adobe Analytics behavioral data into clear performance insights across acquisition, engagement, and revenue • Connect cross-channel marketing performance (paid media, CRM, ecommerce, web, and app) into unified reporting narratives • Lead monthly, quarterly, and executive reporting discussions • Elevate attribution, cohort analysis, and performance reporting into decision frameworks • Identify optimization opportunities that influence marketing strategy • Design Scalable BI Solutions (Power BI) • Build end-to-end Power BI solutions including semantic modeling, DAX development, and visualization design • Create executive dashboards that become the trusted source of truth • Modernize fragmented reporting into scalable BI frameworks • Write advanced SQL to transform and validate large-scale datasets • Partner with data engineering teams across Snowflake, Azure, or BigQuery environments • Operate as a Strategic Analytics Partner • Bridge marketing, engineering, and business leadership • Help define enterprise measurement frameworks and KPI standards • Lead client-facing analytics discussions with confidence and clarity.
Senior Business Value Manager
OktaFounded in 2009, Okta is a publicly-traded software company headquartered in San Francisco, California. Described as the leading independent provider of identit
This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description Reporting to the Senior Director of Global Business Value & Strategy, this role you will work to identify, define, quantify, and deliver business value to customers acquiring and implementing Okta solutions. You will develop and present compelling value propositions, proposals, and business cases, and then track post-sales benefit realization in support of Okta’s largest customers and opportunities. - Support sales engagements through initial business value proposition creation, process and capability assessments, and financial projections for CFO-Ready Business case presentations. - Draw insights for customers using public sources. - Lead sales, pre-sales, post-sales and other ecosystem members to discover, document, and present the business value of our solution in our largest opportunities. - Build and present customized presentations to C-level audiences (CIO, CFO, or board level) considering strategic transformational investments in Okta products and services. - Be the “go-to person” for sales management in your supported territory for value related activities. - Coordinate with sales management, marketing, and other pre-sales functions to grow the amount of value related activity in your region. - Define new Business Value deliverables/processes + support standard tools/templates. - Build out standard value cases and calculations for new capabilities. - Develop and deliver training material used to enable sales teams and the broader ecosystem. Qualifications - Ability to develop and deliver detailed presentations to customers on current/future state of processes and solutions in scope. - Excellent consulting skill-set, including discovery, analysis, quantitative modeling, listening, communication, presentation, persuasion and project leadership skills. - Comfortable navigating through investor presentations, press releases, earnings transcripts and financial documents (10K & 10Q); familiarity with industry-specific publications a plus. - Understanding of software deal dynamics and ability to think strategically about driving software opportunities forward. - “Get it done” mentality - willingness to roll up the sleeves in a fast-paced, highly varied environment. - Drive and motivation to take on additional responsibilities over time. - Ability to work independently and creatively. - Willingness to travel to customer sites; average of 30% travel; typically “day trips;” you control personal travel schedule. - Working knowledge of how IT functions, particularly in the areas of Operations, IT Service Management, Infrastructure and Application provisioning and management. - Experience performing high-level briefings and presentations to senior executives and C-suite customers as required. - Proficient in building financial models (ROI & TCO) for executives. - Comfortable building customized PowerPoint slides. - Bachelor's Degree in a financial or technical field OR equivalent work experience, advanced degrees a plus. Requirements - Requires in-person onboarding and travel to our San Francisco, CA HQ office or our Chicago office during the first week of employment. Benefits - Annual On Target Compensation (OTE) range for candidates located in the San Francisco Bay area: $202,000 — $277,000 USD. - Annual OTE range for candidates located in California (excluding San Francisco Bay Area), Colorado, Illinois, New York, and Washington: $180,000 — $247,000 USD. - Equity (where applicable) and benefits, including health, dental and vision insurance, 401(k), flexible spending account, and paid leave (including PTO and parental leave).
• Administer and manage Sigma Cloud environment including user provisioning, role-based access, and governance. • Manage warehouse connections (Snowflake / cloud DW integrations). • Monitor query performance and cost governance. • Troubleshoot dashboard performance, model-level issues, and data refresh failures. • Implement SSO and authentication integrations (Okta / Entra ID). • Coordinate with Sigma support for escalations and product issues. • Administer Power BI Service, workspaces, and capacities. • Manage licenses, roles, RLS policies, and Service Principals. • Maintain and monitor Gateways. • Support Fabric capacities (if applicable). • Automate tasks via Power BI REST APIs. • Perform RCA for refresh failures, dataset performance issues. • Manage Tableau Cloud / Server environments. • User access management and license governance. • Maintain Bridge nodes (if applicable). • Perform version upgrades and patching. • Monitor extract refresh failures and server performance. • Own platform health monitoring across all BI tools. • Conduct root cause analysis for dashboard/report failures. • Ensure SLA adherence during support window (4:30 PM – 1:00 AM IST). • Maintain SOPs and documentation. • Collaborate with data engineering teams for data pipeline troubleshooting. • Communicate outages, planned upgrades, and platform advisories.
Position: Senior Business Intelligence Developer Company Bio: Founded by industry pioneers, SlateRx provides simple and affordable pharmacy benefit programs to employer groups, unions, public sector groups, health systems, and other payers throughout the United States. As the industry’s only PBXTM, SlateRx is creating real value for plan sponsors on day one through purchasing scale and continued management via innovation and transparency. Our model is designed to improve an out-of-touch healthcare model to make pharmacy benefits simple and affordable for plan sponsors and members. Job Overview: As the Senior Business Intelligence Developer, you will play a pivotal role in delivering innovative, high-quality solutions and actionable insights to our clients and business partners. You will be leveraging your expertise in translating complex healthcare data into clear, actionable intelligence for our diverse user base. Collaborating closely with cross-functional teams, you will drive the success of our organization, enhance member health outcomes, and contribute to the growth of our organization. Responsibilities: As Senior Business Intelligence Developer, your key responsibilities will include: - Reporting & Dashboard Development: Design, develop, and maintain insightful reports, interactive dashboards, and compelling visualizations using leading BI tools (e.g., Looker, Tableau, Power BI) for various stakeholders, including hospital providers, managed care organization operators, healthcare providers, and healthcare executives. - Data Analysis & Insights: Conduct deep-dive analyses on large, complex healthcare datasets to identify trends, opportunities, and areas for improvement related to patient outcomes, medical costs, financial performance, and operational efficiency. - SQL & Database Proficiency: Write complex, optimized raw SQL queries to extract, transform, and load data from various relational and non-relational databases, ensuring data accuracy and performance. - Healthcare Domain Expertise: Apply exceptional knowledge of healthcare metrics, statistics, HCC coding, DRG coding, and the operational intricacies of various commercial and government healthcare plans (e.g., Medicare, Medicaid, commercial payers) to contextualize data and generate relevant insights. - Data Structure Understanding: Leverage a strong understanding of how healthcare data is structured across different sources (e.g., claims, EMRs, clinical notes) to effectively integrate and analyze information. - Cross-Functional Collaboration: Partner seamlessly with data engineers, product managers, clinical experts, and executives to understand their analytical needs, deliver tailored solutions, and provide expert data interpretation. - Requirements Gathering: Lead sessions to define reporting and analytical requirements from business users, translating their needs into technical specifications and data models. - Quality Assurance: Implement robust data validation and quality assurance processes to ensure the accuracy and reliability of all reports and dashboards. - Technical Leadership: Provide guidance and mentorship on BI best practices, data visualization techniques, and analytical methodologies to junior analysts and cross-functional partners. - Hiring & Onboarding: Participate in interviewing and onboarding new team members, helping to grow a world-class data and BI organization. - Other duties as assigned. Qualifications: To excel in this role, you should possess the following qualifications: - 8+ years of deep, hands-on experience as a Business Intelligence Analyst, Data Analyst, or a similar role, with a strong focus on delivering actionable insights. - Exceptional knowledge of healthcare metrics and statistics, including an in-depth understanding of how various commercial and government healthcare plans operate. - Extreme proficiency with databases, including how to access them and the ability to write complex, raw SQL queries for data extraction and manipulation. - Mastery of various BI visualization tools, specifically Tableau. - Comprehensive understanding of how healthcare data is structured across different systems and formats. - Intimate knowledge of and ability to implement data validation, quality assurance, and testing strategies for BI deliverables. - Experience providing technical leadership and guidance, and thinking strategically and analytically to solve complex business problems. - Friendly communication skills and ability to work well in a diverse, cross-functional team setting. - Demonstrated experience working with many cross-functional partners (Product, Engineering, Clinical Teams, Executives). - Demonstrated experience leading the analytical vision and delivery plan for a business intelligence product or component. Preferred Qualifications - Strong actuarial background or related experience in risk assessment and financial modeling within healthcare. - Direct experience having worked at a health plan (commercial, Medicare Advantage, Medicaid, or self-funded employer plans). - Knowledge of various standard plan formats (e.g., X12, HL7, FHIR, custom payer feeds). - Experience with big data technologies and cloud data platforms (e.g., Google Cloud Platform, AWS, Snowflake, Databricks). - Proficiency in scripting languages like Python for data manipulation and automation. - Experience with statistical analysis and predictive modeling. Education: - Undergraduate bachelor’s degree, with record of strong academic performance in Computer Science, Actuarial Science, Statistics, or Economics preferred License Requirement: Job Benefits: Health, Dental, Vision, Life, 401k, Paid Time Off. Location: Remote



