Senior Principal Data Analyst

We'd prefer it if you saw us at our best.

is not optimized for Internet Explorer. For the optimal experience, please use a modern browser.

Data is the lifeblood of every business, particularly digital organizations. You will join the Global Enterprise Data Management team that is focused on Data Warehouse, Analytics and Data Governance.

Our job is to take data and transform it into actionable, consumable information that is utilized at the executive levels. You will be a key contributor to Pega’s evolving Data and Analytics strategies.

20% Architecting Analytics Solutions

• Architect analytics solution leveraging a full SDLC, industry standards and best practices
• Architecting the data models within the Power BI analytics tool that will serve as the semantic layer to enable self‑service
• Drive cross‑functional alignment on segmentations, metric technology definitions
• Support cross‑functional alignment across data platform technologies, BI and visualization
• Develop strategy for predictive, prescriptive analytics and machine learning

50% Reporting and Visualization

• Develop dashboards and scorecards with Power BI to provide insights into business data
• Drive development of metrics & segmentations that demonstrate the contribution and return of program spend
• Develop prescriptive analytics visualizations and insights
• Develop data quality dashboard to identify issues violating the data quality dimensions
• Perform data quality checks on reports and dashboards
• Provide insights into mitigating data quality risks through regular reporting and ad‑hoc analyses

20% Analysis and Assessment

• Lead business analysis and requirements gathering for the Business Intelligence Analytics team
• Document business needs into clearly defined and detailed functional requirements; drive the process of translating into user stories/use cases prioritized for future development
• Review and understand relevant business processes and workflows to ensure solutions deliver improved efficiencies and support achievement of objectives
• Work with other teams to develop and procure data solutions that meet the organization’s reporting and analytics needs
• Provide business insights and knowledge to ensure analytics framework can sustain business requirements
• Identify opportunities to use analyses to answer core business questions and support improved action‑oriented decision‑making

10% Project Management and Communication

• Contribute to analytics project completion by ensuring project team is developing towards the planned architecture
• Define architecture tasks, timeline and dependencies for analytics project completion
• Adhere to the standards, process and change controls of the Business Intelligence‑Analytics team to ensure operational consistency
• Provide regular updates to management and stakeholders regarding status and timing of projects
• Understand and communicate changes to data systems associated with the project
• Assist in the development of training and knowledge transfer documentation

You are a strong collaborator with the ability to communicate complicated information in a clear, concise and actionable manner. You are highly organized and enjoy working on several projects simultaneously with the ability to prioritize and meet deadlines. You consider yourself to be adaptable and flexible while maintaining a high level of professionalism. You are a lifelong learner!

• 10‑14 years in Enterprise Business Applications / Analytics tools and platforms
• 5+ years architecting Business Intelligence transformations (Power BI / Tableau)
• 5+ years data modeling, data cleansing, data profiling
• 3+ years within a B2B environment
• Proficient in SQL development (stored procedures, triggers and functions)
• Experience with CRM applications and lead generation / sales analytics
• Skilled in data modeling and statistical analysis to drive executive decision‑making
• Experience selecting and rationalizing Business Intelligence and data visualization tools, like Tableau, Power BI, Business Objects, SQL, etc.
• Understanding of relational database management systems, such as Postgre
  
  SQL, SQL Server or Oracle
• Excellent oral and…