Principal, Data Analytics Engineering

What You'll Do:

This role is responsible for expanding OCC’s analytics capabilities by making data accessible and usable to analysts throughout the organization. In this role you will lead the design and build of our internal analytics data warehouse and the maintenance of the supporting extract, load, and transform processes. You will demonstrate and disseminate expertise in OCC’s data sets and support teams across the organization in successfully harnessing this data. You will collaborate with business users and technical teams across the organization to facilitate data-driven decision making by enabling exploration and analysis of historical and near real-time data access using cloud-based tools and technologies. Lastly, you will be responsible for gathering requirements and designing solutions that address the problem at hand while also anticipating yet-to-be-asked analytical questions and developing and maintaining our analytics platform to meet the company’s security and IT standards.

Primary Duties and Responsibilities:

To perform this job successfully, an individual must be able to perform each primary duty satisfactorily.

• Partner with Data Architecture and other relevant teams to design and implement new cloud data warehouse infrastructure for internal facing analytics

• Work with various business and functional teams to understand their data and technical requirements and ensure delivered solutions address needs

• Manage the validation of data models to ensure information is available in our analytics warehouse for downstream uses, such as ad hoc analysis and dashboard development

• Maintain performance requirements of our analytics warehouse by tuning warehouse optimizations and storage processes

• Direct and enable the team to collaborate with Data Governance team and DBAs to design access controls around our analytics warehouse to meet business and Data Governance needs

• Approve documentation and testing to ensure data is accurate and easily understandable

• Promote self-service capabilities and data literacy for business users leveraging the platform through development of training presentations and resources

• Discover and share best practices for data and analytics engineering with members of the team

• Invest in continued learning on data and analytics engineering best practices and evaluate them for fit in improving maintainability and reliability of analytics infrastructure

Supervisory Responsibilities:

• None

Qualifications:

The requirements listed are representative of the knowledge, skill, and/or ability required.  Reasonable accommodations may be made to enable individuals with disabilities to perform the primary functions.

• [Required] Ability to collaborate with multiple partners (e.g., Business Functional areas, Data Platform, Platform Engineering, Security Services, Data Governance, Information Governance, etc.) to craft solutions that align business goals with internal security and development standards

• [Required] Ability to communicate technical concepts to audiences with varying levels of technical background and synthesize non-technical requests into technical output

• [Required] Comfortable supporting business analysts on high-priority projects

• [Required] High attention to detail and ability to think structurally about a solution

• [Required] Knowledge of and experience working with analytics/reporting technology and underlying databases

• [Required] Strong presentation and communication skills, including ability to clearly explain deliverables/results to non-technical audiences

• [Required] Experience working within an agile environment

Technical Skills:

Demonstrated proficiency in:

• [Required] Experience implementing and maintaining cloud-based data warehouses and curating a semantic layer that meets the needs of business stakeholders

• [Required] Knowledge of and experience working with various analytics/reporting technologies

• [Required] Strong presentation and communication skills, including ability to clearly explain deliverables/results to non-technical audiences

• [Required] Ability to complete work iteratively in an agile environment

• [Required] Proficiency in SQL

• [Preferred] Experience with Python and/or R

• [Preferred] Experience with visualization/reporting tools, such as Tableau

• [Preferred] Experience with ETL tools, such as Alteryx

Education and/or Experience:

• [Required] Bachelor's degree in quantitative