The Cincinnati Bengals are seeking a Data Warehouse Engineer to be responsible for assisting with the design, deployment, standards and performance of the team’s customer data warehouse. The successful candidate will work with internal and external business partners to align and design data architecture to identify and centralize the team’s first, second, and third-party data including ticketing, concessions, merchandise, CRM, and mobile applications to support the business needs and strategies.
In addition, this position will lead systems architecture related to business intelligence including data integration, reporting, and analytics partnering with the Business Analyst to turn insights into monetizable actions. This position will report directly into and will work closely with the CFO with support from the Director of IT.
Duties and Responsibilities:
Perform discovery to understand and document process flows and impact on how data is generated and currently stored throughout the organization.
Collaborate with external partners to identify and efficiently extract, transform and load applicable transactional level data sets into the team’s data warehouse.
Understand requirements for data, information, reporting, and analytic needs to ensure alignment with data warehouse architecture and data models.
Support the translation of business and technical objectives into solution architecture requirements, and data architecture designs to deliver BI applications.
Collaborate with the vendor to design and implement scalable and extensible data architectures.
Develop database objects such as data marts cubes, queries, stored procedures, views and tables required to support appropriate levels of reporting and security.
Develop, manage and maintain standards for the enterprise data model. Partner in the development, management, establishment, and enforcement of technical standards.
Integrate multiple cross-functional processes including marketing, ticketing and customer service to meet business and technical requirements by bringing perspective from all architecture domains (process, system, application information, data, and security).
Identify areas for data quality improvement by participating in root cause analysis. Make recommendations to prevent and remediate data quality issues through the appropriate choice of architectures and practices.
Incorporate standards for gathering requirements for aggregate navigation, response time, repeatable queries, row level security etc. into data warehouse design.
Assist with troubleshooting and tuning of business intelligence reports.
Recommend and advocate for data policies, governance structures and control frameworks for the ongoing management of data to ensure convergence, synchronization, accuracy, completeness and reliability.
Make recommendations for optimization and performance improvements to database design, as well as improvements to ETL processes and tuning of software and hardware for existing and projected needs. Work with source system owners to establish and measure data quality metrics, investigate and resolve source data issues, and continuously evaluate and refine transformation rules.
Define roles and responsibilities for centralized and decentralized data management functions.
Bachelor’s Degree in Computer Science or equivalent.
2-4 years of relevant experience
Requires a thorough knowledge of data modeling, data warehouse, data management, and database development.
Strong technical knowledge of data integration tools, data modeling tools, metadata tools, and database design. Additional knowledge of ETL processes, BI tools and analytics and development strategies, SQL programming, R/Python, relational databases and ER/dimensional modeling techniques required
Willingness to work non-traditional hours (nights, weekends, holidays)
Excellent interpersonal skills
Experience with either pro or college sports
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, sexual orientation, age, disability, gender identity, marital or veteran status, or any other protected class.