Data Solutions Architect

APA Corporation - Portland, OR

Full-time - Mid Level

Portland, OR

Administrative and Support Services

About the position

The Data Solutions Architect will lead the design, creation, and management of data architecture at NW Natural, ensuring that data is organized, accessible, secure, and aligned with business objectives. This role involves providing technical leadership, collaborating with various stakeholders, and implementing innovative IT solutions that support the company's strategic vision.

Responsibilities

• Interprets and delivers impactful strategic plans improving data integration, data quality, and data delivery in support of business initiatives and roadmaps.
• Work with enterprise architects and IT&S team members to analyze business requirements and develop data architecture strategies.
• Define standards and guidelines for data modeling, data integration, and data quality management.
• Develop and implement data models for operational and analytical systems to maximize the efficiency and effectiveness of data assets.
• Oversee the design, implementation, and maintenance of data solutions, including data warehouses, data lakes, and data marts.
• Develop strategies for data governance, data security, and data privacy compliance.
• Analyze current data systems to identify deficiencies and recommend improvements.
• Collaborate with business stakeholders, project teams, and IT staff to ensure the alignment of data architecture with business objectives.
• Provide guidance and leadership in data-related technologies, trends, and methodologies.
• Document data architecture designs, decisions, and processes comprehensively.
• Ensure compliance with enterprise data architecture standards and policies.

Requirements

• Bachelor's degree in computer science, Information Systems, or a related field, or equivalent experience.
• At least five years of relevant experience in design and implementation of data models for enterprise data warehouse initiatives.
• Experience leading projects involving data warehousing, data modeling, and data analysis.
• Design experience in Proficiency in Azure Fabric Synapse, Informatica and PowerBI.
• Knowledge of data governance, data quality management, and data security best practices.
• Experience with ETL processes and tools.
• Experience with data visualization tools such as Power BI, or similar.

Nice-to-haves

• Excellent interpersonal skills in areas such as teamwork, facilitation, and negotiation.
• Strong leadership skills.
• Excellent analytical and technical skills.
• Excellent written and verbal communication skills.
• Excellent planning and organizational skills.
• Knowledge of data architecture principles and processes.
• Knowledge of financial models and budgeting.
• Understanding of IT service management (ITSM) and Information Technology Infrastructure Library (ITIL Foundations Certification is encouraged).
• Knowledge and understanding of different data modeling languages and techniques.