Develop architectural patterns, guidelines, and methods to manage data assets across the data life cycle, from acquisition through archival and purge
Design and develop efficient BI solutions that meet the approved requirements and align with the IT and data strategy
Build and maintain positive relationships with Information Technology team and business partners
Act as technical expert for all BI and Data Modeling technologies
Mentor and manage junior resources. Guide and assist the team on best practices; modify existing and develop new processes for smoother functioning
Manage multiple tasks and projects simultaneously
Effectively troubleshoot production issues and perform root-cause analysis
Requirements
Minimum 10 years of data warehousing design and development experience supporting development activities for ETL, reporting, and advanced query design
Bachelor's degree in Computer Science, Data Science, Engineering, or equivalent work experience
SQL Server development experience required (T-SQL, stored procedures, optimization techniques, SSIS, SSRS)
Proven track record of driving and delivering results
Business Intelligence tools such as Power BI/ Tableau is strongly recommended
Familiarity with Microsoft Fabric and Azure a plus
Strong interpersonal and communication skills
Ability to stay current with rapidly changing technology and apply it to business needs
Relevant experience in the financial services industry a plus
Tech Stack
Azure
ETL
SQL
SSIS
Tableau
Benefits
Medical, dental, vision, life insurance, disability insurance
Paid Time Off (PTO)
Leave of absences, such as parental and military leave
401(k) plan with company match (up to 4%)
Company-funded pension plan
Wellness Programs including up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needs
Work/Life Resources to help support topics such as parenting, housing, senior care, finances, pets, legal matters, education, emotional and mental health, and career development
Education Benefit to help finance traditional college enrollment toward obtaining an approved degree and many accredited certificate programs
Employee Stock Purchase Plan: Shares can be purchased at 85% of the lower of two prices (Beginning or End of the purchase period), after one year of service
Eligibility to participate in a discretionary annual incentive program is subject to the rules governing the program, whereby an award, if any, depends on various factors including, without limitation, individual and organizational performance