This job has expired and you can't apply for it anymore. Start a new search.

Business Intelligence Developer

Location: Greenwich, CT

 

Department: Information Technology

 

Business Unit: Business Intelligence     

 

 

JOB SUMMARY:

 

Seeking a hands-on technology professional to join a business intelligence development team in a growth-oriented financial services sales and marketing support operation. The Business Intelligence Developer Analyst  will assist with the development of the firm’s internal reporting platform and data warehousing capability. This role will involve database administration, data management and integration, report development and analytics in both  relational (OLTP) and analytical (OLAP) environments, primarily using Microsoft tools. The BI Developer Analyst will be a key member of the technical team that builds data integration with CRM and Marketing systems and supports all downstream data warehousing and reporting. This position requires a strong customer service attitude, attention to detail and quality, the ability to multi-task, a team focus, strong interpersonal skills and adherence to firm IT standards and change management procedures. The BI team works across departments to build common strategic frameworks that supports the overall business analysis capability of the firm.

 

 

 

ESSENTIAL FUNCTIONS:

 

  • Design and develop custom BI reports using Microsoft SQL Reporting  Services to support the firm’s sales and marketing strategy
  • Design and develop Microsoft SQL Integration Services programming objects for gathering, manipulating and loading data
  • Manage, monitor and improve Microsoft SQL Server Analysis Services  environment including ongoing changes and active product backlog
  • Perform complex data analysis and working with time series data
  • Perform and/or automate varying levels of data quality and data stewardship tasks
  • Design and build robust business data analytics solutions
  • Adhere to compliance procedure and internal/operational risk controls in accordance with any and all applicable regulatory standards and policies

 

 

 

KNOWLEDGE, SKILLS AND ABILITIES:

 

  • Self-starter who enjoys working with  data-centric technologies, keeping up with the latest trends and always looking for innovative solutions to solve business requirements
  • Deep knowledge of the Microsoft Business Intelligence Stack (SSIS, SSAS, SSRS)
  • Well versed in Agile methodology and change management procedures
  • Strong Database Administration and SQL Coding/Debugging Skills
  • Skilled in report design and creation
  • Experience managing and maintaining Microsoft SQL Server Analysis Services Cubes
  • SAP BusinessObjects a plus
  • JavaScript and MEAN stack development are a plus
  • .NET and Powershell scripting skills a plus
  • Strong problem-solving skills and relies on experience to make good decisions
  • Meticulous attention to detail an eye for consistency
  • Pro-Active and resourceful with the ability to work independently and problem solve
  • Communicates effectively with colleagues, clients and partner vendors
  • Excels in a fast-paced environment while meeting deadlines and executing responsibilities with minimal errors
  • Familiarity with CRM systems - Preferably Infor CRM or Salesforce
  • Supports and upholds Company values and treats others with respect and consideration.

 

 

 

EDUCATION AND EXPERIENCE:    

 

  • Bachelor’s degree in a business or technology related field required
  • Preferably mutual fund distribution data/investment management back office  experience
  • Five plus years of experience in a similar role

 

 

 

AMG Funds provides access to many of Affiliated Managers Group’s (AMG) boutique investment Affiliates through our family of mutual funds, separately managed accounts and asset-allocation products. In addition, we oversee and distribute a number of complementary open-architecture mutual funds subadvised by unaffiliated investment managers. This broad combination of investment products allows us to serve the needs of the financial advisor community and their clients. With AMG Funds, you can rely on our distinctive array of actively managed, return-oriented investment strategies to help your clients achieve their long-term investing goals. AMG Funds LLC is a wholly owned subsidiary and the U.S. retail distribution arm of Affiliated Managers Group, Inc. AMG is a global asset management company with investments in leading boutique investment management firms. For over 20 years, AMG has partnered with these firms using direct equity ownership.