InComm

Data Warehouse Engineer II

US-GA-Alpharetta
Type
Full-Time

Overview

Leveraging deep integrations into retailers’ point-of-sale systems, InComm provides connectivity to a variety of service providers that allow consumers to conduct everyday business at more than 450,000 points of retail distribution worldwide. Whether those consumers are activating prepaid products, paying bills, enjoying real-time discounts through a membership card, purchasing digital goods in-store or adding funds to an online account, InComm is there to provide unique gift-gifting opportunities, cater to on-the-go shoppers, deliver added value through loyalty programs and serve cash-based consumers. With 186 global patents, InComm is headquartered in Atlanta with a presence in over 30 countries in North and South America, Europe and the Asia-Pacific region. Learn more at www.incomm.com or connect with us on www.twitter.com/incomm, www.facebook.com/incomm, www.linkedin.com/company/incomm or www.incomm.com/blog.

 

About This Opportunity

InComm is currently seeking a Data Warehouse Engineer to be a part of our Enterprise Data Warehouse group.  This position reports directly to Manager, EDW Development.  The EDW Development group consists of 2 teams, EDW Development and EDW Reporting.  The DW Engineer will be a part of EDW Development, a team of 5 who is responsible for collecting data from multiple sources sending data to a centralized DW for the organization.

 

The current EDW team consists primarily of developers.  However, the Data Warehouse Engineer will be dedicated to problem resolution and coordination of changes with other teams, (Network, DBA, Server Systems, etc.).  This role is key to the success of this team. The primary responsibilities for this role will include:

  • Provide critical systems support and timely problem resolution
  • Heavily involved with the data center migration activities for the BI servers
  • Coordinate for other team on special projects
  • ETL files
  • Transfer files to loadable data warehouse
  • Work closely with report development team
  • Extra data from Data Warehouse and put it into a defined mart

 

The Data Warehouse Engineer should have experience with the following:

  • ETL (SSIS)
  • Previous database experience
  • SQL queries
  • Data marts
  • Pentaho experience is a plus but, not required

 

Responsibilities

 

  • Primary responsibility for problem investigation and resolution during normal work hours.
  • Participation in after hours support rotation
  • On-going platform maintenance 
  • Coordination with Data Integration, Network, DBA, Server Systems, and Storage Systems for cross-team projects, resource procurement, system maintenance, server migrations or upgrades, database maintenance, and general change management.

 

 

Qualifications

 

  • Minimum 5, Preferred 7+ years experience in Data warehousing or related position
  • 4-year degree in related field
  • Extensive knowledge of Microsoft BI Stack (SSIS, SSAS, SSRS)
  • Extensive knowledge of Microsoft SQL Server and query performance tuning
  • Extensive knowledge of ETL and best practices
  • Extensive knowledge of C# and VB as it pertains to Scripting in SSIS
  • Knowledge of data warehouse modeling and design
  • Knowledge of creating and managing restfull services for accessing data warehouses
  • Strong collaboration skills and ability to build strong working relationships across multiple teams to include Data 
  • Integration, Network, DBA, Server Systems, etc.
  • Strong written and oral communication skills

 

 

InComm provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity or national origin, citizenship, veteran’s status, age, disability status, genetics or any other category protected by federal, state, or local law.

 

*This position is eligible for the Employee Referral Bonus Program - Tier 4 

 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed