Senior Architect

The Senior Data Engineer/Architect will architect, develop, and implement enhancements to our core data infrastructure through data validations, transformations, normalizations, reports and extracts, and integration processes that strengthen internal business applications and client reporting functions.

This individual will also be responsible for working with internal customers to prioritize projects and ensure alignment with business goals. The role demands superior analytical skills, attention to detail, and effective communication and collaboration with both technical and non-technical partners.

Expertise in Microsoft SQL 2019 stack and experience with REST API, Python, and .NET is required.

This position requires hybrid on-site (3 days per week) presence as an essential function of the role. Consistent and predictable on-site presence is required for ongoing business continuity, professional development and effective collaboration with colleagues and management.

Responsibilities

• Collaborate with business sponsors, senior management, and Finance and IS teams to understand, document, and propose data solutions.
• Design, develop, implement, and maintain high-quality data integrations and real-time data services in support of enterprise applications and reporting.
• Architect data infrastructure enhancements to support evolving business needs.
• Work with internal customers to prioritize projects and ensure alignment with business goals.
• Actively participate in program development, be willing to identify and investigate improvements to team processes and tools, and present topics.
• Maintain and effectively communicate accurate project and task estimates and status.
• Mentor junior developers on learning new technologies and approaches to data management.

Essential capabilities include:

• Ability to maintain strict confidentiality of the firm’s internal and personnel affairs as well as those of our clients.
• Customer service focused with internal and external clients with the ability to develop effective partnerships across the organization.
• Ability to organize, plan, and carry out multiple concurrent objectives or activities, and effectively make judgments in prioritizing and time allocation in a high-pressure environment.
• Ability to commit to and deliver on deadlines.
• Excels in an innovative, intellectually challenging, and fast-paced environment.
• Excellent communication skills (written & verbal) and be equally effective interacting with both business and IT professionals.
• Strong leadership and interpersonal skills

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field; or equivalent work experience.
• Minimum 10 years of experience in business intelligence and report development (4 years with Microsoft BI Stack).
• Proficiency with MS SQL Server 2019 or later and related technologies.
• Experience building data pipelines using REST API, .NET, Python, Java, Scala, or similar.
• Experience with TFS or similar work management and coding repositories.
• Strong troubleshooting and performance tuning skills.
• Understanding of relational and multi-dimensional database design and architecture.
• Experience with Profisee, Redgate, Git, Alteryx is a plus.
• Ability to work independently, take ownership, and contribute to team success.
• Strong communication skills and ability to collaborate and build relationships.