BI/Reporting Engineer-Giftango InComm Holdings
THIS JOB HAS EXPIRED Overview:
Giftango, an InComm Company, redefines the connection between merchants and their customers through our stored value and mobile gifting solutions. As the pioneer of digital gift card delivery, Giftango helps you leverage your gift card program in new ways to drive sales. Giftango delivers digital gift cards through e-commerce, social media, promotional and B2B toolsets. eGift Cards are delivered to Facebook, email and mobile devices.
This position is located at our corporate headquarters in downtown Portland, Oregon. Please visit our website (http://www.giftango.com) for more information about Giftango.
With 113 global patents, InComm is headquartered in Atlanta and has offices in North and South America, Europe and the Asia-Pacific region. For further info see http://www.incomm.com
Giftango is seeking a SQL Server database developer with experience using SQL Server Analysis Services. The Database Developer is responsible for providing detailed analysis, design, tuning, testing, implementation and documentation of business application databases, which are directed toward a common objective and aligned with strategic business goals. The database developer will interface with the applications development teams(s), focusing on the development of Analysis Services databases and business intelligence. The database developer will be responsible for developing applications and integrations using the Microsoft SQL Server platform. This will include database design, data analysis, ETL, BI tasks and a working knowledge of C# for scripting and automation.
Primary job duties:
Builds positive relationships with internal and external customers/business users by providing excellent service/support and consistent communication.
Understands IT projects and concepts as they relate to high-level business objectives, and ability to present those concepts to both IT and non-IT audiences in a concise and easily understandable manner.
Maintains awareness of new and emerging technologies and the potential applications.
Generates innovative solutions by approaching problems with curiosity.
Confers with business units to analyze current operational procedures, identify problems, and learn specific input and output requirements, such as forms of data input, how data is to be summarized, and formats for reports.
Plans, schedules and monitors own work within a limited time horizon.
Prepares system and programming documentation for users and other programmers/analysts in accordance with internal and external standards.
Proactive in providing suggestions in regards to product development, new services, technologies, as well as create and maintain database standards and policies.
Provide technical and system design expertise in the development of new and maintenance of existing tables, stored procedures, functions and other database objects.
Assist developers in analyzing application architecture and application code.
Develops custom ad-hoc reports and enables business development through data analysis.
Performs physical database design and improves database performance by tuning queries at the index level, data access level, file structure and lock level.
Creates and maintains SSIS ETL for BI/Data Warehouse integration functions and third party integration.
Test databases and stored procedures in preparation of installation to production servers
Data modeling, dependency analysis and data mapping
SQL Server Analysis Services
SQL Server 2008/2012 (SSAS, SSMS, SSIS, SSRS)
C# Console Applications/ASP.Net as it relates to automation of ETL.
C# CLR Development to integrate with outside services
Bachelors or Master?s Degree in related field
Red Gate Toolset
Good understanding of OOP (Object Oriented Programming)
||Portland, OR |
THIS JOB HAS EXPIRED