Annexus has been certified as a great place to work – again!
We are a leading financial institution that designs and distributes highly innovative investment and retirement solutions that have been revolutionizing the retirement planning industry for over 15 years. We have an immediate opening for an outstanding Data Architect.
The Data Architect oversees the creation and implementation of the Enterprise Datawarehouse as well as the migration of existing data. This hands-on position requires data modeling and integrating with external departments and stakeholders to determine data extract needs as well as implementation. This position will also assist with ETL development for the interim systems.
Responsibilities:
Architect, design, develop, automate, troubleshoot, evaluate, modify, test, deploy, and document high quality data solutions to support all aspects of Annexus.
Identify and connect to various systems of record (SORs) and data warehouses throughout the enterprise to access needed data attributes
Collect, standardize, transform, and prepare data
Perform final data modeling and analysis
Produce ad-hoc data extracts and reports
Develop KPIs and KRIs that effectively measure operations
Perform thorough testing ensuring the quality of your work
Build positive relationships and work with leaders, team members, Product Owners, and end users to build and test delivered work
Work as part of an Agile team and organization using common Agile methodologies
Debug components, identify fixes, and verify remediation of code defects
Carry out detailed and rational analysis to identify the root cause of problems
Look for opportunities to embrace innovative technologies
Ability to challenge the status quo and drive innovation
Proactive communication and risk management skills
Requirements:
MS SQL Server
TSQLT experience is a plus
Enterprise Data modeling
Cloud Technologies (Azure/AWS/GCP – certification a plus)
MPP data technologies
Relational modeling
Non relational data modeling
Experience with Kafka message streaming is a plus
All applicants are required to take a PI Survey and are subject to a background check prior to hire. We offer a competitive compensation and benefits package including health benefits and 401(k). Annexus Management Company is an Equal Opportunity Employer.
If you have any technical issues completing the Predictive Index survey or submitting your application please email [email protected] for assistance.