The Pittsburgh Penguins seek a Data Architect to support data and technology initiatives for business operations. The position will manage the oversight of data infrastructure and processes critical to the Business Intelligence and Analytics team and all other business units. The role will be responsible for expanding, optimizing, and supporting our data environment and ETL pipeline architecture along with assisting in the data architecture with the club’s data warehouse provider and the IT department. The data architect must have a highly technical background, familiar with ETL processes, relational database and design principals, cloud architectures, and API solutions.
Key Responsibilities and Accountabilities:
Identify, design, document, and implement internal process improvements: data infrastructure design, automating manual processes, optimizing data ingress and egress, and data quality assurance
Create and maintain ETL Pipelines from various internal and external data sources to data warehouse and raw analytics environments using SQL and big data technologies
Design and build integrations for existing applications and develop ETL processes to build enhancements into new and existing dimensional models
Maintain, support, and improve data analytics platforms and storage systems
Work with stakeholders including the Executive, Product, Marketing, Data, IT, and Design teams to assist with data-related technical issues and support their data infrastructure needs
Audit end-user data requests and ETL jobs in our analytics environments and run data quality and validation tests between transformed data and source systems
Ensure database integrity, work with IT data integrity audits, enforce standards and prevent duplicate data
Work with Business Intelligence and Analytics team to strive for greater functionality in our data systems
Ideal Candidate should possess many of the following qualifications:
At least 3-5 years of professional experience in an IT consulting, IT analyst, or database management role
Advanced working SQL knowledge and experience working with relational databases, data warehouses, query authoring (SQL) as well as working with a variety of databases
Experience with relational OLTP and OLAP SQL systems: SQL Server, Azure SQL Database, Snowflake, etc.
Experience with Data warehousing systems (i.e., Azure Data Warehouse, Snowflake, Amazon RedShift, etc.)
Experience performing database roles both on-prem and cloud data environments
Strong analytic skills related to working with unstructured datasets, API data extraction and web scraping applications
Experience with data pipeline and workflow management tools (i.e. DBeaver, SSIS)
Experience with CRM Systems (Dynamics 365 preferred)
Experience with object-oriented/object function scripting languages a plus
Some software development experience preferred
General Skills:
Must be able to work effectively as part of a team
Effective communications, both orally and in writing
Must be a self-starter and committed to learning new database skills and remaining aware of industry trends
An ability to establish and maintain effective working relations with those encountered in the course of work using principles of excellent customer service
High level of attention to detail with the ability to multi-task effectively
High degree of professionalism and ability to maintain confidential information
Strong organizational and time management skills required
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.
