PROTECH

BI Analyst, AWS

Job ID
2016-4294
US-FL-Coconut Creek

Overview

We are looking for an a Datawarehouse Analyst, AWS for an exciting role in Coconut Creek, FL. In this position, you will be designing and developing models, schemas and systems as well as developing and maintaining ETL processes and programs. As a data systems analyst, you will assist in developing various logical and physical data models (operational, analytical, dimensional), understand/analyze project requirements to develop the data models. This role requires a good team player that can collaborate with various business and application teams and will participate in the entire SDLC from requirements gathering to deployment and documentation. 

 

Responsibilities

 

  • Create database design specs based on database requirements
  • Stay up to date with technology to assist in choosing solutions to solve user needs/problems
  • Use data modeling tools like ErWin and ER/Studio to understand business data requirements and create data models
  • Analyze ETL code
  • Help with the development of data access protocols
  • Develop and implement database standards and methodologies for across the org
  • Ensure adherence to data standards and manage the quality of metadata
  • Review and analyze data quality issues/data discrepancies and help improve data integrity
  • Support enterprise data architecture 
  • Database responsibilities including installations, configurations, administration, maintenance, and database tuning
  • Backup, recovery, and replication of databases
  • Upgrades and system changes
  • Work with any relevant business partners
  • Maintain a high level view of the business data 
  • Research new data architecture trends

Qualifications

 

  • BS Degree
  • 8+ years of application or systems development
  • 5+ years of data modeling
  • 5+ years of database analysis/design/implementation/administration
  • 3+ years of database architecture in an enterprise environment
  • Experience in large scale environment with variety of platforms, including data warehouses and cloud computing
  • Expertise with enterprise data models, strategies for data architecture, delivery roadmaps, lifecycle management, and data governance 
  • Must have good experience with conceptual and physical models
  • Windows/Linux/Unix and shell scripting required
  • Installation of software on Linux and able to configure Linux OS
  • SQL including MySQL, SQL Server and PostgreSQL as well as NoSQL
  • Any cloud experience, specifically AWS
  • Data warehousing expertise and ETL techniques
  • Scrum/Agile a plus
  • Excellent communication skills and able to communicate with non-technical assets
  • Reporting and visualization tools, like Tableau or similar
  • Knowledge of reporting and visualization tools and Executive Information systems design and implementation. Experience with Tableau or similar technologies and tools desired.

Options

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