Business Intelligence (BI) Architect

New York, NY

Share This Job

Job Description

Overview:

Innovative strategies. Proactive thinking. Comprehensive know-how. That's what we expect from a Senior Software Engineer at TMP. Here, you'll be part of a fiercely collaborative technology team charged with creating digital solutions that are transforming the way employers and job seekers connect. That means contributing to high-traffic websites for a broad range of high-profile companies. Developing next-generation applications and products for some of the most recognized brands in the world. And actively supporting our diverse suite of best-in-class technologies. All this in an environment that constantly challenges you to push beyond boundaries and enhance your expertise—with the support of a global team of industry experts. Sound like a fit for your talent and passion? Read on.

The Business Intelligence (BI) Developer’s role is to design and implement BI software and systems. This includes requirements gathering, analysis, planning, selection, blueprinting, designing, developing, rolling out, and end-user training of BI solutions to the user community. The Business Intelligence Developer is also responsible for timely data availability and system up-time through support functions and in-depth testing.

Responsibilities:

  • Gathers requirements, analyzes, creates design documents, and performs impact analysis.
  • Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.
  • Continuously evaluate industry trends for opportunities to utilize new technologies and data sources for BI improvement and prepare strategies to implement these enhancements in the BI environment.
  • Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
  •  Develops Extraction, Transformation and Loading (ETL) processes to acquire and load data from internal and external sources.
  • Develop, enhance and maintain the metadata layers, reports, report definitions and dashboards.
  • Produce guidelines and standards for ETL usage, manageability and maintainability within the organization.
  • Build database models, dashboards, reports, interfaces for BI packages.
  • Assist users with problems and resolves issues independently.
  • Creates test plans, test cases, test scripts and performs testing of the BI and related environments.
  • Promote BI benefits to the organization and usage of our tools to relevant business groups.
  • Plan and organize tasks, reports progress to manager.
     

To learn more about TMP Software Development and what we are working on- check out these links:

 

http://jobsattmp.com/livecode

 

Stack Overflow page: http://careers.stackoverflow.com/company/tmp-worldwide?searchTerm=tmp%20worldwide

Skills & Requirements

  • 7+ years of database design and management experience of traditional relational and dimensional databases.
  • 5+ years of experience with an ETL or ELT tool for data extraction transformation and loading preferred.
  • Well versed in advanced query development and design using SQL.
  • Well versed with dimensional data modeling and the construction of ETL routines
  • 5+ years experience using Microsoft SQL Server BI Suite
  • 5+ years experience working with non-traditional databases including more than one of the following systems: Hadoop, Cloudera, MongoDB, Teradata, Hive, Azure, Cassandra, etc.
  • 5+ years of experience with data warehouses, data marts, and OLAP technologies.
  • Experience with web services integration architectures including SOAP and REST, a plus
  • Experience with agile methods a plus
  • Strong written and oral communications skills.
  • Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.
  • Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem solving skills.

TMP Worldwide is committed to providing a safe workplace for all employees. It is the policy of TMP Worldwide to conduct a background check for all candidates who accept an offer of employment with us.

 

TMP Worldwide is an Equal Opportunity and Affirmative Action Employer, M/F/D/V.