OPPORTUNITIES AT BMK
See the postings below for exciting opportunities at BMK Solutions
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 - Masters 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