IT Data Architect Senior

Educational Testing Service - Princeton, NJ

Full-time - Senior

Princeton, NJ

Educational Services

About the position

The Senior Data Architect at ETS is responsible for defining and implementing the overall architectural vision for data management across the organization. This role involves conceptualizing and experimenting with various architectural approaches to enhance data collection, storage, processing, and integration, ultimately empowering business intelligence and advanced analytics initiatives. The Data Architect will lead the development of data frameworks and cloud data platforms, ensuring compliance with industry standards while continuously improving data practices to support the organization's strategic goals.

Responsibilities

• Articulate and document a data architecture solution vision.
• Oversee data architecture designs, business requirements, prototypes, testing, and training.
• Develop conceptual, logical, and physical data models, and support the development of data strategies by building roadmaps and creating processes to meet current and future needs.
• Develop data frameworks and scalable approaches to support an evolving data architecture and integration needs that can be leveraged and re-used for new data-driven business products, services, and functions.
• Develop and implement cloud data platforms to support product strategy and roadmap, advanced analytics, data science and SQL/NO-SQL datasets to give business, products, and operations a competitive advantage.
• Provide recommendations on innovative data platforms, tools and services, and align decision-making with the organization's strategic data vision and all standard policies, processes, and procedures.
• Manage a repository of documentation related to data architecture standards, protocols, and frameworks, and regularly evaluate for improvement opportunities.
• Maintain currency with emerging technologies, leveraging industry knowledge and expertise to drive continuous improvement and innovation efforts in data architecture and related areas.
• Ensure data architecture and practices comply with relevant industry standards and regulations, such as GDPR, HIPPA, and CCPA.
• Establish and enforce data quality standards and practices.
• Continuously improve processes, technologies, and platforms to provide best value to business.
• Adhere to ethical standards and comply with the laws and regulations applicable to your job function.

Requirements

• Extensive knowledge of and experience in database development, developing and delivering data architecture solutions and strategies.
• Firm understanding of data modeling, master data management, enterprise data warehousing, ETL, reporting, querying, requirements analysis, and data integration techniques.
• Extensive knowledge and experience with network architecture, IT Architecture principles, frameworks, methodologies, standards and best practices.
• Excellent communication and presentation skills, with the ability to convey complex technical concepts to non-technical stakeholders and executive audiences.
• Proven ability to collaborate effectively with cross-functional teams and stakeholders.
• Adaptable and flexible in response to changing business needs and priorities.
• Strong expertise in Azure Analysis Services (AAS), Power BI Premium Gen2, Azure Data Factory, Azure Synapse, Data/Delta Lake, Microsoft Fabric, and Data Pipelines.
• Proven experience in designing and implementing data solution on the Azure Platform.
• Experience with cloud data platforms (e.g., AWS, Azure, Google Cloud) and data warehousing solutions (e.g., Redshift, BigQuery, Snowflake).
• Strong knowledge of SQL and experience with relational databases (e.g., Oracle, PostgreSQL, SQL Server).
• Experience with Pyspark framework building data lake (S3/Iceburg), data warehouse (on Redshift Serverless/Spectrum), EMR (serverless), pipelines & catalogs construction (Glue, Athena).
• Experience with NoSQL databases (e.g., DynamoDB, Cassandra) and big data technologies (e.g., Hadoop, Spark).
• Understanding of ETL processes and tools (e.g., Python).
• Knowledge of data governance, data quality, and data security practices.

Nice-to-haves

• Master's degree in a relevant field.
• Experience in higher education data architecture.

Benefits

• Health, Vision, Dental insurance plans to choose from
• Generous continuous learning support, including tuition reimbursement and online learning access
• Generous PTO and vacation time
• Additional 8 hours of PTO for volunteer work
• Retirement plan (401(a)) and traditional Roth (403b) with company contribution
• Commuter Benefits
• Pet Insurance
• 1 year subscription to Calm App