Data Analyst III

Are you passionate about transforming data into actionable insights? We’re on the lookout for a skilled Data Analyst III to lead the way in managing and optimizing our databases. In this pivotal role, you’ll coordinate updates, test, and implement robust database solutions, and apply your expertise in database management systems. Your efforts will also include designing and executing security measures to protect critical data assets. If you thrive in a dynamic environment and have a keen eye for detail, this is your chance to make a significant impact! Job Responsibilities • Collaborate with growth marketers, program managers, and our central analytics team to gather data and metrics requirements. • Design, build, and maintain automated reporting, dashboards, and ongoing analysis to enable data-driven decisions across our team and with partner teams. (e.g., using Tableau, etc.). • Build and optimize ETL processes to run marketing campaigns at scale and automate the campaign reporting. • Write high-quality SQL queries to retrieve and analyze data from database tables. • Partner with our analytics and cross-functional stakeholders to identify and rectify data integrity/accuracy issues across our reporting, data infrastructure, and dashboards. Skills • BA or BS degree. • 5+ years of experience with SQL (Oracle, Vertica, Hive, MySQL, etc.). • Experience building/operating distributed systems of data extraction, ingestion, and processing of large data sets from multiple sources. • Experience in ETL design, implementation, and maintenance. • Experience with Business Intelligence tools (such as Tableau, MicroStrategy, etc.) and report automation. • Experience using Python and R. • Self-starter with flexibility to work in a fast-changing environment and ambiguous situations. • Experience working in organizations with cross-functional teams. • Experience working independently and a track record of taking initiative. • Interpersonal skills, including written and oral communication skills. Education/Experience • BA or BS degree in a STEM field. Benefits • 401(k). • Dental Insurance. • Health insurance. • Vision insurance. • We are an equal-opportunity employer and value diversity, equality, inclusion, and respect for people. • The salary will be determined based on several factors, including, but not limited to, location, relevant education, qualifications, experience, technical skills, and business needs. Additional Responsibilities • Participate in OP monthly team meetings and participate in team-building efforts. • Contribute to OP technical discussions, peer reviews, etc. • Contribute content and collaborate via the OP-Wiki/Knowledge Base. • Provide status reports to OP Account Management as requested. About Us At OP, we help you harness the power of technology for maximum impact. A technology consulting and solutions company, we offer advisory and managed services, innovative platforms, and staffing solutions across a wide range of fields including AI, cyber security, enterprise architecture, and beyond. For nearly two decades, we’ve been challenging the status quo of the consulting industry, serving up fresh, ingenious thinking through a radically lean structure. Together, this strategy delivers unprecedented performance at an unparalleled pace for faster results that propel your business forward.