Database Architect – Create database architecture. Design, construct and implement the database architecture that achieves the business goals and internal performance requirements and integrate new systems with existing warehouse structure and refine system performance and functionality. Develop ETL (extract, transform and load) jobs in Java Talend (Jasper ETL). Automate business process. Develop business automation processes for better efficiency and write shell scripts to automate data loading process. Write SQL statements and functions for adhoc queries, reports and projects. Write advanced SQL statements including multiple joins, sub-selects and other advanced SQL techniques. Create tables and triggers. Develop tables and triggers with appropriate constraints such as primary keys, foreign keys and indices to fulfill business requirements. Modify and trouble shoot database issues. Read and understand existing database and (ETL) designs to trouble shoot issues in order to modify and implement solutions with existing databases to improve performance. Review and analyze peers database structure. Will evaluate database structure to determine if the database design achieves the business goals and internal performance requirements and recommend changes if necessary.
Requirements - Master's or foreign degree equivalent in computer science and 2 years of experience in the job offered or 2 years of experience in data warehouse development for identifying and designing dimensions and facts, ETL development, and processing XML, CSV, TXT files. Special Skills - 2 months of coursework, internship or work experience in the following: Data Mining; Data Modeling; Artificial Intelligence Programming; Cognos BI; PL/SQL, T-SQL; Unix Shell Scripting; PowerBI & C++; and WEKA. Travel to various unanticipated client sites required. May reside anywhere in the United States.
Employer – BMK Solutions, LLC, 11977 Harrison, Romulus, MI 48174.
BMK Solutions, LLC
11977 Harrison Road
Romulus, MI 48174