"Alerted.org

SUMMARY

The Sr. Data Architect is responsible for designing, creating, and managing an organization’s data architecture. This role is critical in establishing a solid foundation for data management within an organization, ensuring that data is organized, accessible, secure, and aligned with business objectives. The data architect designs warehouses, file systems and databases, and defines how data will be collected and organized.

STATUS: Full time

DEPARTMENT: Information Technology Applications - Data Analytics

Required Qualifications:

+ A bachelor’s degree in computer science, data science, engineering, or related field

+ 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 Azure Fabric, Snowflake, PySpark, and Power BI/Tableau

Preferred Qualifications:

+ Demonstrated expertise with programming languages such as .NET, Python, or Java

+ Demonstrated expertise with data science languages/tools such as SQL, R, SAS, or Excel

+ Proficiency in the design and implementation of modern data architectures and concepts such as cloud services (AWS, Azure, GCP), real-time data distribution (Kafka, Dataflow), version control (Git), Infrastructure as Code (Terraform), and modern data warehouse tools (Snowflake, Databricks, Microsoft Fabric)

RESPONSIBILITIES

+ Interprets and delivers impactful strategic plans improving data integration, data quality, and data delivery in support of business initiatives and roadmaps

+ Designs the structure and layout of data systems, including databases, warehouses, and lakes

+ Selects and implements database management systems that meet the organization’s needs by defining data schemas, optimizing data storage, and establishing data access controls and security measures

+ Defines and implements the long-term technology strategy and innovations roadmaps across analytics, data engineering, and data platforms

+ Designs and implements ETL processes from various sources into the organization’s data systems

+ Translates high-level business requirements into data models and appropriate metadata, test data, and data quality standards

+ Manages senior business stakeholders to secure strong engagement and ensures project deliverables align with longer-term strategic roadmaps

+ Simplifies the existing data architecture, delivering reusable services and cost-saving opportunities in line with the policies and standards of the company

EDUCATION:

LICENSES / CERTIFICATIONS:

PHYSICAL REQUIREMENTS:

L - Light Work - Exerting up to 20 pounds of force occasionally, and/or up to 10 pounds of force frequently, and/or a negligible amount of force constantly; requires occasional walking, standing or squatting.

For disease specific care programs refer to the program specific requirements of the department for further specifications on experience and educational expectations, including continuing education requirements.

Any physical requirements reported by a prospective employee and/or employee’s physician or delegate will be considered for accommodations.

PAY RANGE:

$110,000.00 - $138,000.00

CITY:

Rochester

POSTAL CODE:

14617

The listed base pay range is a good faith representation of current potential base pay for a successful full time applicant. It may be modified in the future and eligible for additional pay components. Pay is determined by factors including experience, relevant qualifications, specialty, internal equity, location, and contracts.

Rochester Regional Health is an Equal Opportunity/Affirmative Action Employer. Minority/Female/Disability/Veterans by a prospective employee and/or employee’s Physician or delegate will be considered for accommodations.