Manager - Data & Analytics

Hi, we’re OnPrem – a people-first community of digital hustlers, bustling under one global roof. We’re seeking an experienced Manager to join our growing Data & Analytics Consulting practice. Together we are technology leaders who bring brands closer to their customers by digitizing, connecting, and protecting disparate content, all while increasing ease of access. We believe hard work pays off in and out of the office. And we’ll help you pursue what matters most to you. Your time. Your goals. Your balance. With minimal travel, unaccrued vacation, bonuses paid every year (yes, even in 2020), and a dedicated training budget, our teammates are rewarded for their efforts and are given the resources they need to succeed.We take our merit to the bank, not the vision board. By operating in a flat organization, contributors of all levels have access to leadership and mentors of all levels. And supporting employee growth doesn’t end with professional development. OnPrem supports the values of our employees with an open onboarding process for Employee Resource Groups (ERGs), giving all OnPrem voices a platform. As we remain committed to pro bono work, we also created donation matching programs to support the communities we live in. We grow because we hire great people. Smart people. Like Matt Damon in Good Will Hunting smart. And they love what they do. What makes us unique is not that we have people like this on our team, but that we only have people like this on our team – a team you can be proud of. What we doProgram management, digital media supply chain, IP and rights management, data and analytics, customer experience, Salesforce, and content securityWhere we playMost often in Media and Entertainment, Consumer Product Goods, and RetailThe positionIn this role, you will oversee projects that drive better data-based decision making for our clients, from strategy and planning, to data management, to analytics and visualization. We are looking for a hands-on technical data lead who can successfully manage projects, teams, and stakeholders.Why you?Because you’re looking for a career that fits your life. Not another role where you’re just a cog in the wheel. We know because we’ve been there. But look at us getting carried away – let’s get back to you.

What you'll bring

• You are passionate about data & analytics, and using data insights to drive smarter decision-making.
• You can write code to manipulate data using languages like SQL, Python, or others.
• You love to manage people, timelines, tasks, issues and risks.
• You can identify project opportunities and make recommendations for new work based on your thorough knowledge of client needs

What you'll do on the job

• Lead project teams through all core project phases, including project setup, requirements gathering, design, development, testing and deployment
• Lead your team through hands-on example by coding, creating data visualizations and building data models
• Facilitate workshops, provide status updates, and lead meetings across the executive levels of client organizations
• Proactively identify risks and issues, and provide mitigation strategies
• Maintain strong client relationships while identifying opportunities beyond your current engagement
• Contribute to internal growth initiatives including mentorship, recruitment, strategy and/or methodology enhancement

Requirements

• 5-7+ years Project Management, Process, Implementation, SDLC, System Integration experience
• 3+ years in consulting / professional services, big firm experience preferred
• Experience designing and building relational database and/or data warehouses on a major vendor platform such as Teradata, Redshift, Snowflake, Microsoft SQL Server, MySQL, MariaDB, or other
• Experience with business driven or self-service BI, using tools similar to Tableau, Birst, Qlik, Cognos, Business Objects, or other
• 5 years’ experience using SQL in a Production environment
• Experience in data modeling using tools such as Erwin, Oracle Data Modeler, or ER/Studio
• Ability to profile, explore, and analyze data to identify common patterns and anti-patterns
• Experience with data migration, profiling, cleansing, and integration, including participation in at least one major data migration project
• Trained and implemented in both an Agile/Kanban and SDLC project management environment
• Thorough experience with client-facing activities such as requirements gathering, meeting facilitation & presentation creation, and deliverable review & approval sessions
• Experience with project planning, including tasks, budgeting, and resource allocation
• Bachelor’s degree in engineering, information systems, computer science, business administration, or other related fields

Preferred

• A solid understanding of key BI trends and the BI vendor landscape
• Experience in Media & Entertainment and/or Consumer Products industries
• Experience at a large consulting firm (e.g., Accenture, Deloitte, EY, CapGemini, PWC)

More about life at OnPremWe were founded on a culture of collaboration and inclusiveness, and this permeates each of our initiatives, both client-facing and internal. We offer a wide selection of benefits including medical, dental & vision, 401k matching and flexible vacation; we sponsor trainings to advance our teams’ skill sets; we prioritize our employees’ professional growth paths. Currently 200+ people strong in four geographic territories, we’ve been recognized as a “Best Place to Work,” a “Great Place to Work,” “Fastest Growing,” and “A Jewel.”Visa StatusApplicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States  (i.e., H1-B visa, F-1 visa (OPT), TN visa or any other non-immigrant status).Equal Employment OpportunityOnPrem Solution Partners ensures equal employment opportunity without discrimination or harassment based on race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity or expression, age, disability (physical or mental), national origin, marital or domestic/civil partnership status, family history or genetic information, citizenship status, military or veteran status, political affiliation, other non-merit based factors, and/or any other characteristic protected by law. OnPrem applies this stance to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including internships, at all levels of employment.