Analytics Engineer

• Design, build, and troubleshoot integrations and automated data pipelines between Snowflake, Salesforce, and external sources
• Develop REST API connections, secure authentication, and daily ETL processes with error logging
• Develop and optimize complex SQL queries, views, and middleware
• Design dimensional data models and transformation layers for fundraising tools and actionable insights
• Establish Git code-management practices, branching strategies, pull requests, and documentation-as-code
• Version, audit, and maintain recoverability of SQL, R, and Python analytical scripts
• Implement CI/CD principles for reliable, tested, automated deployment of data models
• Track project milestones, manage backlogs, and communicate project health
• Gather requirements and translate business needs into technical specifications and timelines
• Advise Development and Alumni Relations users on data-solution planning, selection, and implementation
• Deploy and maintain visualization tools and statistical environments across Qlik Cloud, Snowflake, and Posit Connect
• Leverage Snowflake Cortex AI for data engineering and AI-driven analytics
• Monitor application health and provide technical support across Penn schools and centers
• Support fundraising and alumni-relations analytics for 18 schools and central Development and Alumni Relations staff
• Report directly to the Senior Director of Advancement Analytics

• Build and maintain Microsoft Fabric lakehouses, warehouses, data pipelines, and semantic models under established architecture and governance standards
• Integrate D365, WMS, OTTO, EDI, manufacturing, IoT, and other enterprise data sources into the analytics platform
• Develop and maintain Power BI dashboards and reports for executive, finance, supply-chain, warehouse, and manufacturing users
• Support manufacturing KPIs including OEE, downtime, yield, production variance, and line performance
• Support warehouse and supply-chain analytics including inventory accuracy, pick rates, OTTO utilization, and dock-to-stock
• Develop reusable data models and establish consistent business definitions and reporting standards
• Implement data-quality checks, reconciliation routines, exception handling, and monitoring
• Support role-based security and governance for enterprise reporting and analytics
• Develop and optimize SQL, DAX, semantic models, and data pipelines
• Integrate IoT and operational telemetry into Fabric for reporting, analytics, and future AI use cases
• Support AI, Copilot, and agent-based analytics solutions
• Consume governed D365 APIs, entities, and integration services in partnership with ERP teams
• Monitor data pipelines and troubleshoot data or reporting issues
• Maintain data architecture, pipeline, report, and support documentation
• Provide occasional after-hours and weekend support during planned releases, cutovers, maintenance, and critical production incidents
• Collaborate with IT, business teams, implementation partners, vendors, and systems integrators
• Lead or coordinate cross-functional technical initiatives in a fast-paced manufacturing environment
• Evaluate technical solutions for scalability, maintainability, and operational supportability

Data Analytics Engineer

• Design, build, and troubleshoot system-to-system integrations and automated data pipelines between Snowflake, Salesforce, and external sources
• Implement REST API-based connections, secure authentication, and daily ETL processes with error logging
• Develop and optimize complex SQL queries, views, and middleware
• Design dimensional data models and transformation layers for strategic fundraising tools and actionable insights
• Establish Git code-management practices, including branching strategies, pull requests, and documentation-as-code
• Ensure SQL, R, and Python analytical scripts are versioned, audited, and recoverable
• Implement CI/CD principles for reliable, tested, automated deployment of data models
• Track project milestones, manage backlogs, and communicate project health
• Coordinate requirements gathering and translate business needs into technical specifications and timelines
• Advise Development and Alumni Relations users on data-solution planning, selection, and implementation
• Deploy and maintain visualization tools and statistical environments across Qlik Cloud, Snowflake, and Posit Connect
• Leverage Snowflake Cortex AI for data engineering and AI-driven analytics
• Monitor application health and provide technical support across Penn schools and centers
• Report directly to the Senior Director of Advancement Analytics in Development and Alumni Relations

• Assess information needs, design studies, manage projects, analyze results and present key findings to business leaders
• Plan and manage moderate- to high-complexity data and analytics projects
• Create models and develop data warehouse programs to meet business needs
• Analyze metrics and support audits of source data
• Define and implement research designs and quantitative techniques using high-level analytical tools
• Liaise with internal and external suppliers of data and insights
• Support planning, development, modeling, implementation and reporting of data
• Prepare ad hoc and recurring reports using programming languages and software tools
• Analyze financial implications of business decisions and identify solutions to business problems
• Monitor and report progress and results
• Identify short- and long-term data and analytics goals with leaders and subject matter experts
• Measure the effectiveness of data and analytics strategies in improving performance
• Analyze current landscapes and trends to support planning and recommend strategy and tactic changes
• Create files covering industry, competitors, products, service innovations and trends
• Develop, communicate and enforce standards for documentation and organization of electronic files, data and actuarial data deliverables
• Train less experienced specialists
• Conduct special research studies as directed

Analytics Engineer jobs in Pennsylvania