Business Intelligence (BI) Architect

New York, NY

Share This Job

Job Description

<p class="MsoTitle" style="margin: 0in 0in 0pt; text-align: justify;"> <span><o:p></o:p></span></p> <p> <u><strong>Overview:</strong></u></p> <p> Innovative strategies. Proactive thinking. Comprehensive know-how. That&#39;s what we expect from a Business Intelligence (BI) Architect at TMP. Here, you&#39;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&mdash;with the support of a global team of industry experts. Sound like a fit for your talent and passion? Read on.</p> <p> The Business Intelligence (BI) Developer&rsquo;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.</p> <p> <u><strong><span style="font-size: 12px;">Responsibilities:</span></strong></u></p> <ul> <li> Gathers requirements, analyzes, creates design documents, and performs impact analysis.</li> <li> Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.</li> <li> 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.</li> <li> Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts.</li> <li> &nbsp;Develops Extraction, Transformation and Loading (ETL) processes to acquire and load data from internal and external sources.</li> <li> Develop, enhance and maintain the metadata layers, reports, report definitions and dashboards.</li> <li> Produce guidelines and standards for ETL usage, manageability and maintainability within the organization.</li> <li> Build database models, dashboards, reports, interfaces for BI packages.</li> <li> Assist users with problems and resolves issues independently.</li> <li> Creates test plans, test cases, test scripts and performs testing of the BI and related environments.</li> <li> Promote BI benefits to the organization and usage of our tools to relevant business groups.</li> <li> Plan and organize tasks, reports progress to manager.</li> </ul> <p> To learn more about TMP Software Development and what we are working on- check out these links:</p> <p> <span style="font-size: 12px;">http://jobsattmp.com/livecode</span></p> <p> <span style="font-size: 12px;">Stack Overflow page: http://careers.stackoverflow.com/company/tmp-worldwide?searchTerm=tmp%20worldwide</span></p>

Skills & Requirements

<ul> <li style="margin-left: 0.25in;"> 7+ years of database design and management experience of traditional relational and dimensional databases.</li> <li style="margin-left: 0.25in;"> 5+ years of experience with an ETL or ELT tool for data extraction transformation and loading preferred.</li> <li style="margin-left: 0.25in;"> Well versed in advanced query development and design using SQL.</li> <li style="margin-left: 0.25in;"> Well versed with dimensional data modeling and the construction of ETL routines</li> <li style="margin-left: 0.25in;"> 5+ years experience using Microsoft SQL Server BI Suite</li> <li style="margin-left: 0.25in;"> 5+ years experience working with non-traditional databases including more than one of the following systems: Hadoop, Cloudera, MongoDB, Teradata, Hive, Azure, Cassandra, etc.</li> <li style="margin-left: 0.25in;"> 5+ years of experience with data warehouses, data marts, and OLAP technologies.</li> <li style="margin-left: 0.25in;"> Experience with web services integration architectures including SOAP and REST, a plus</li> <li style="margin-left: 0.25in;"> Experience with agile methods a plus</li> <li style="margin-left: 0.25in;"> Strong written and oral communications skills.</li> <li style="margin-left: 0.25in;"> Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.</li> <li style="margin-left: 0.25in;"> Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem solving skills.</li> </ul> <p style="margin: 1px 0px; color: rgb(0, 0, 0); font-family: Arial, Helvetica, sans-serif;"> 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.</p> <p style="margin: 1px 0px; color: rgb(0, 0, 0); font-family: Arial, Helvetica, sans-serif;"> &nbsp;</p> <p style="margin: 1px 0px; color: rgb(0, 0, 0); font-family: Arial, Helvetica, sans-serif;"> TMP Worldwide is an Equal Opportunity and Affirmative Action Employer, M/F/D/V.&nbsp;</p>