Employment Opportunities

Access Management (IAM) Engineer Columbus, OH 
Posted:  3/27/2019
Category:  Information Technology
Job Type:  -
Minimum Experience:  -
Required Education:  -
Benefits:  -
Job Description

The Paragon Group is a Columbus, Ohio based Information Technology firm delivering high quality, cost effective resources to a progressive clientele. Founded in 1998, The Paragon Group has a full-time staff of highly skilled, motivated professionals. The Paragon Group provides staff augmentation, temp-to-perm placements, permanent placements, and consulting services both locally and nationally. We are a full-time employer and offer a full benefits package. We are currently looking for an Access Management (IAM) Engineer for a long-term employment opportunity.
Job Description:
The Enterprise Information Management team is seeking an Access Management Engineer for the Data Platform. The primary responsibility of the role is to implement role-based access layer for EDW and other tools by business function. The access management engineer will be responsible for gathering the requirements and work with infrastructure and Database DBA teams in implementing the solution.  This person will also provide recommendations on proper design for building the access layer for EDW.
  • Design and Implement Role Based Access Layer for End User Queries and Reporting
  • Determine best approach and design for building appropriate access design for EDW, Data marts, Data stage, SAS & Microstrategy Reporting Tools
  • Segregate views and tables by business function in EDW and create mapping documents
  • Build Segregated views for PII and Non PII Data
  • Guide and lead access reviews for data platform
  • Develop a process to identify personal identifiers like SSN etc across EDW tables and views
  • Performance tuning of poorly performing SQL queries
  • Proactively gather workload characteristics from EDW and provide recommendations to the DBAs for workload adjustments
  • Estimate and communicate the work effort to EDW management, Stakeholders and own the deliverables from inception, review and signoff of the deliverables.
  • May need to perform other EDW Platform functions like capacity planning, SLAs, monitoring etc.

Job Requirements

Basic Qualifications:
  • Bachelor's degree preferably in computer science
  • 4 years of experience in Application DBA role design and implementation of EDW access layer
  • 4 years of experience in design and implementation of role-based access layer for multiple data platform tools like EDW, reporting, ETL etc.
  • 2 year of experience in leading access reviews for a tool
  • 4 years of SQL writing and SQL performance tuning experience
  • Experience in DB2 Role Design
  • Good communication and interpersonal skills for interacting and collaborating with business users, DBA’s and application developers
Preferred Qualifications:
  • 5+ years of experience in Data warehousing
  • Experience in all EDW ITIL functions

Login to Apply
User ID: 
Forgot password? 

Other Options
   Create an account
   Return to search results

Bookmark and Share

Return to search results | Email this job to a friend

Bookmark and Share
*Logged in members may also add jobs to their job cart