In this role, you will be responsible to designs and constructs appropriate data structures to meet project requirements and comply with overall enterprise data warehouse (EDW) design standards and principles.
In this role, the selected candidate will evaluate, test and produce recommendations for the selection, user and deployment of DBMS software, data management tools and utilities, data warehouse and replication tools.
In this role, the selected candidate must have a senior architecture skills - communication, balancing and understanding multiple projects, driving towards and working with the business to outline and strategy / roadmap.
The selected candidate will create, design, and develop programs to load and extract data to and from data warehouse.Maintain SQL database and move data in and out of the data warehouse to deliver to data marts.
In this role, the selected candidate will perform routine DBA activities, such as setting user's permissions and resolving space issues on Production and lower environments as well as configuring maintenance plans.
To help you find the most relevant
jobs, we've come up with an approximate compensation for this
position. This is based on similar jobs with compensation
$110K to $150K -Saint Paul, MN
As a BI Solutions Architect with the company, you will work with cutting edge, multi-terra byte data warehouse solutions across various industries. We work on a project basis, so you get to be part of both the creation and delivery team.
In this role, the selected candidate must have strong technical and platform knowledge, including some or all of: Talend, Talend Administration, ETL tool (Datastage/Abinitio/Informatica), Databases (DB2/Oracle/Teradata), UNIX platform (Shell/Perl scripting), Scheduling tools (TWS/Autosys/ControlM).