Data Architect

Mio Partners - New York, NY

Full-time - Senior

New York, NY

About the position

MIO's IT team is seeking a Data Architect responsible for developing and managing the overall data architecture and strategy. This role involves collaborating with data/software engineers, business users, and stakeholders to design and implement data solutions, including databases and data warehouses, to support efficient data analytics and informed decision-making. The Data Architect will oversee the full life cycle of system development projects, ensuring alignment with organizational needs and business objectives.

Responsibilities

• Provide technical leadership and direction for data management projects that align with long-term business objectives
• Help design a data infrastructure that supports complex data analytical services
• Contribute to thought leadership in build vs. buy decisions for data management solutions
• Work closely with external data management partners to onboard MIO's use cases
• Define data governance policies and oversee implementation to ensure data quality, accuracy, and consistency
• Develop and implement data ingestion, transformation, and synchronization processes
• Evaluate new data technologies, tools, and best practices, advising on potential adoption
• Work with data scientists, engineers, business users, and other stakeholders to understand their data needs
• Maintain detailed documentation for data architecture, flows, and system configurations
• Raise the bar on development capabilities, standards, and processes
• Synthesize requirements gathered from various teams and suggest creative solutions
• Organize with end users, business analysts, and other architects and developers following a scrum methodology
• Recommend steps toward standardizing development processes
• Partner with DevOps, QA, and AppSecOps teams to promote standardization and improved security posture

Requirements

• At least 10+ years of hands-on experience in data strategy, data architecture, data modeling, data governance, business intelligence, Big Data, reporting & data warehousing, AI, and Machine Learning
• Bachelor of science in computer science or related discipline
• Experience with relational databases (e.g., SQL Server, MySQL, Oracle) and non-relational databases (e.g., NoSQL, MongoDB)
• Strong understanding of Cloud technologies (preferably AWS)
• Good understanding of different data architecture patterns
• Experience working closely with business leaders to identify business needs and data opportunities
• Formal problem-solving and/or analytical training/experience
• CFA or FRM certification is a plus
• Design and development experience with data and analytics-intensive applications using Pandas and NumPy libraries
• Ability to write high-performing SQL queries, procs, tables, and views
• Familiarity with general ETL design and development
• Good intuition for end-user requirements gathering
• Practical understanding of design patterns and experience in system design
• Ability to lead a development team
• Strong client relationship management skills and excellent communication skills

Nice-to-haves

• Experience working with management consultants

Benefits

• Health insurance
• 401k plan
• Flexible scheduling
• Professional development opportunities