Data Architecture Director I (Hybrid)

Chicago, IL (Hybrid)

The American Medical Association (AMA) is the nation's largest professional Association of physicians and a non-profit organization. We are a unifying voice and powerful ally for America's physicians, the patients they care for, and the promise of a healthier nation. To be part of the AMA is to be part of our Mission to promote the art and science of medicine and the betterment of public health.

We continuously work to embed equity in our internal practices and are committed to increasing the diversity of our staff across all levels of the organization. We intentionally work to create the right conditions to enable our employees to feel that they can be their authentic selves and fully participate in the life of the enterprise.

We encourage and support professional development for our employees, and we are dedicated to social responsibility. We invite you to learn more about us and we look forward to getting to know you.

We have an opportunity at our corporate offices in Chicago for a Data Architecture Director I on our Information Technology team. This is a hybrid position reporting into our Chicago, IL office, requiring 2 days a week in the office.

This role will lead the design of
enterprise data solutions that drive optimal health, operational, and strategic
outcomes by developing roadmaps and solving unique, complex challenges that
have a broad impact across the AMA. This key leadership position will serve as
a subject matter expert on the architecture, management, and governance of data
systems across multiple business units, ensuring data integrity, security, and
accessibility. This role will work closely with cross-functional teams and
business leaders, leveraging advanced data architecture methodologies and
technologies to support the AMA's mission through actionable insights and
innovative solutions.

RESPONSIBILITIES:

• Design a target architecture for the AMA's enterprise data landscape that empowers self-service analytics, ensures data quality and governance, and supports real-time decision-making
• Advise on the integration and flow of data across systems, ensuring seamless access and high data quality for analytical and operational purposes
• Design, develop, and manage robust ETL (Extract, Transform, Load) processes to ensure efficient and accurate data translation within systems and platforms.
• Lead the design of solution data architectures for multiple projects, ensuring that they meet functional and non-functional requirements
• Develop standards for the management, storage, integration, and retrieval of large datasets to ensure consistency and accessibility

• Partner with and influence other leaders, providing expertise and guidance towards the development of a comprehensive enterprise data strategy aligned with the AMA's organizational goals and vision
• Partner with business leaders and IT stakeholders to understand objectives, develop roadmaps, and align data solutions to meet their goals
• Lead and mentor application, infrastructure, and security architects to ensure data is integrated into all layers of the EA program
• Provide guidance to business and IT teams on how to effectively use data

• Stay ahead of emerging data architecture trends, technologies, and industry best practices to ensure the AMA's systems remain innovative and competitive
• Implement tools and processes (e.g., automated data workflows, data orchestration, and real-time analytics) that enable operational efficiency
• Continuously assess and optimize the performance and scalability of data architecture to meet evolving organizational needs
• Lead proof-of-concept (PoC) initiatives to validate new data solutions and approaches

May include other responsibilities as assigned

REQUIREMENTS:

1. Bachelor's degree in Computer Science, Data Science, Information Systems, Engineering, or a related technical field
2. 10 years of experience in data architecture, data engineering, or related fields, including at least 7 years in a leadership role
3. Demonstrated success in delivering data solutions that align with business goals and enterprise architecture
4. Strong experience in implementing data governance frameworks, ensuring compliance with regulations such as HIPAA, PCI, SOC, GDPR, or CCPA
5. Technical certifications (e.g., AWS Certified Data Analytics, AWS Certified Database, Azure Certified Data Engineer, Azure Certified AI Engineer, etc.) are highly desirable
6. Experienced in designing, implementing, and managing large-scale data systems, including data lakes, lake houses, data meshes, data warehouses, and/or cloud-based platforms
7. Expertise in creating conceptual, logical, and physical data models
8. Strong knowledge of relational databases (e.g., Oracle, SQL Server, MySQL, PostgreSQL) and NoSQL databases (e.g., MongoDB, Cassandra)
9. Knowledge of data normalization, denormalization, and dimensional modeling techniques
10. Experience with cloud technologies like AWS or Azure, particularly for data storage and processing (e.g., Databricks, Redshift, Snowflake, or BigQuery)
11. Experience integrating data from disparate sources (structured, semi-structured, and unstructured)
12. Understanding of data security practices, encryption, and access control
13. Ability to align data architecture initiatives with business goals and long-term strategy
14. Strong understanding of how data architecture supports digital transformation
15. Demonstrated stakeholder management skills to communicate technical concepts effectively to non-technical audiences

The ideal candidate will have a strong foundation in many of the following technologies and concepts:

1. Relational Databases: MySQL, PostgreSQL, Microsoft SQL Server, Oracle Database, Amazon RDS, Azure SQL Database, DB2, Informix
2. NoSQL Databases: MongoDB, Cassandra, DynamoDB, Azure Cosmos DB
3. Data Lakes: AWS Lake Formation, Azure Data Lake, Delta Lake
4. Data Warehouses: Redshift, Snowflake, Azure Synapse Analytics, BigQuery
5. File Storage: Amazon S3, Azure Blob Storage

1. ETL/ELT Tools: Informatica, , AWS Glue, Azure Data Factory, MS SSIS, FiveTran
2. Data Pipelines: Amazon Kinesis, Azure Event Hubs, Apache Kafka, Apache Airflow
3. Data Replication and Migration: AWS DMS (Database Migration Service), Azure Database Migration Service
4. Data Governance and Quality
5. Data Governance Platforms: Informatica Axon, Collibra
6. Data Quality Tools: Informatica Identify Resolution, Cloudingo
7. Metadata Management: AWS Glue Data Catalog, Azure Purview, Apache Atlas

1. BI Tools: Tableau, Power BI, Looker, Qlik Sense
2. OLAP Tools: Azure Analysis Services, Apache Druid

This role is an exempt position, and the salary range for this position is $160,650 - $213,384. This is the lowest to highest salary we believe we would pay for this role at the time of this posting. An employee's pay within the salary range will be determined by a variety of factors including but not limited to business consideration, geographical location, and internal equity, as well as candidate qualifications, such as skills, education, and experience. Employees are also eligible to participate in an incentive plan. To learn more about the American Medical Association's benefits offerings, please click here.

The American Medical Association is located at 330 N. Wabash Avenue, Chicago, IL 60611 and is convenient to all public transportation in Chicago.

We are an equal opportunity employer, committed to diversity in our workforce. All qualified applicants will receive consideration for employment. As an EOE/AA employer, the American Medical Association will not discriminate in its employment practices due to an applicant's race, color, religion, sex, age, national origin, sexual orientation, gender identity and veteran or disability status.

THE AMA IS COMMITTED TO IMPROVING THE HEALTH OF THE NATION