View all jobs
Data Engineer / Database Architect
New York, New YorkWe are seeking an experienced Data Engineer / Data Platform Architect to join our client’s team to help us modernize and enhance our industry-leading financial analytics and data management Software as a Service (SaaS) platform. You will join a New York City-based team of passionate, end user-focused technologists to practice your craft and develop new skills as we evolve our platform, which was shifted from a legacy data center to the AWS cloud, into a platform that fully leverages all that the Amazon cloud has to offer.
Responsibilities
Responsibilities
- Spend your time thinking about and evolving the SaaS data platform. This will be a combination of evolving / refactoring the current relational database design, evolving the performance monitoring and data integrity processes, and identifying opportunities and strategies for incorporating non-relational data stores into our architecture.
- Actively participate in cross-functional (DevOps) meetings and bring new ideas for continuous improvement to the team
- Work closely with our Cloud Operations team to communicate cloud infrastructure needs and to support the code that you write once it is in production
- Assist with improvements to our continuous integration / continuous delivery capabilities as related to the data platform
- Participate in the agile ceremonies that are at the core of our SDLC (standups, grooming, sprint planning, and retrospectives)
- Develop and support ongoing ETL processes for both internal operations and client integrations.
- Experiment with (spike) new data technologies and help determine how best to apply them to solve the business problems we face
- Consult with the broader technology team on data-specific challenges and establish best practices relative to the data platform.
- Operate with limited direction while effectively communicating progress or roadblocks and seeking clarification and assistance when needed
- Subscribe to our standards and values
- SQL Server (7+ years)
- Query writing
- Testing
- Performance tuning
- Data Modeling
- NoSQL (1+ years)
- Working knowledge of the major non-SQL data engines
- Non-Relational Data Modeling
- ETL / Systems Integration (5+ years)
- REST / APIs (2+ years)
- BI / Reporting / Data Warehousing experience (3+ years)
- Database CI / CD (2+ years)
- Experience writing code in at least one structured programming / scripting language
- Experience working with event-based platform architectures
- Experience writing database unit tests and data integrity tests
- Experience working on a team practicing continuous integration / continuous delivery
- Applied knowledge of distributed application architecture principles
- A “can-do” attitude, comfortable rolling-up sleeves to get the work done, and meeting deadlines
- An appreciation of amazing co-workers. We feel more like a family than an employer
- Apply prior professional experience to new contexts to deliver solutions to complex problems
- Strong communication and collaboration skills - the ability to understand and express concepts, directions, and ideas effectively through writing, speaking, presenting, and over video conference
- A deep intellectual curiosity with the ability to fill knowledge gaps