Business Intelligence Architect

  • 37707
  • Life - Data Science
  • |
  • Massachusetts, United States
  • |
  • Jul 9, 2020
Insurance
RESPONSIBILITIES
  • Lead business intelligence solution architecture, design, development, implementation, and administration across a complex data landscape.
  • Build and maintain schema objects and abstraction layer on top of various, changing enterprise data assets.
  • Partner with peer organizations to interpret and assist in designing normalized and dimensional data modeling as well as experience implementing metadata solutions, and bi-temporal data models to ensure interoperability with BI solutions.
  • Perform metadata modeling and develop complex integrated data sets from disparate data sources with an expert utilization of SQL and optimization of BI objects.
  • Perform detailed documentation of design, development, testing and deployment activities.
  • Conduct troubleshooting, analysis and enhancement development based on issues reported.
  • Write complex SQL queries and stored procedures for report or dashboard development as needed.
  • Contribute to and apply standards and governance of Business Intelligence processes.
  • Customize applications using SDK, API, JavaScript, HTML, CSS.
  • Work with API design, development, and enabling technologies, using state-of-the art programming languages and object-oriented approaches in designing, coding, testing and debugging programs. Including REST, XML, JSON, and HTTP.
  • Provide technical support as needed within the team.
  • Provide support for reports/analysis as needed.
QUALIFICATIONS
  • Bachelor’s degree or equivalent in Information Technology, Computer Science, CIS, Engineering, or Math.
  • 8+ years BI architect or Sr. BI developer experience with increasing responsibilities implementing medium and large scale projects, business intelligence solutions and data modeling.
  • 6+years’ Experience with ETL solutions, relational databases, columnar databases, time series databases, BI Platforms, Big data technology, Metadata, Lineage Quality Modeling, Sanitization, Analytics and Reporting.
  • 4+ years direct work experience with MicroStrategy.
  • Experience with VPN, SSO, and EMM protocols.
  • Must be comfortable working with large amounts of data.
  • Ability to work individually and in a team-oriented, collaborative environment.
  • Ability to handle multiple tasks delivering under the Agile methodology.
  • Strong written and verbal communication skills.
  • Entrepreneurial mind-set with strong financial awareness and personal integrity.
  • Preferred:
  • 10+ years professional experience preferred.
  • Certified MSTR Architect preferred.
  • 2+ years web development experience using REST API services, Java/JavaScript, HTML, Python, D3 Web integration preferred.