Senior Business Intelligence Engineer
Posted on: March 28, 2020
In just 18 years, OEC has grown globally to more than 1,000
employees with a double-digit revenue increase nearly every year.
We provide a lively culture, employee rewards and recognition, and
the opportunity to develop and implement innovative technology
Develops effective business intelligence solutions for OEC by
designing, developing, and deploying systems to support business
intelligence, reporting, data warehousing, and integration with
enterprise applications. Owns and architects business intelligence
solutions. Designs, develops and maintains Enterprise Data
Warehouse. Evaluates business needs in support of delivering
effective business intelligence and reporting solutions. Maintains
documentation of processes, reports, applications, and
Manages small projects as assigned by Associate Manager or Manager;
provides training and leads others as a recognized business
Guides and coaches developers, shares best practices and performs
Designs Business Intelligence solutions in the areas of enterprise
reporting, query and analysis, and analytical services.
Facilitates KPI definition and implements strong BI processes
throughout the organization; evaluates and makes recommendations on
BI and analytics tools.
Designs logical Data Warehouse architecture and data models.
Implements physical data warehouse design and data cubes.
Designs ETL (Extract, Transform, Load) architecture including
mappings, data flows, procedures, schedules, etc.
Implements user access controls and data security measures, as
Anticipates opportunities for improvement; outlines and identifies
alternate solutions and presents to management for final approval
Designs and develops interactive dashboards and reports. Creates
and maintains documentation of processes, reports, applications,
and procedures in accordance with department policy.
Develops and tests database scripts, stored procedures, triggers,
functions, SSIS packages, and other back-end processes to support
system integration and ETL to facilitate the creation and
population of the Enterprise Data Warehouse.
Develops and performs system testing and fixes defects identified
during testing and re-executes unit tests to validate results.
An undergraduate degree from an accredited college or university
with a focus in Information Technology, Computer Science or related
discipline; or in the absence of a degree, directly-related job
experience in business Intelligence, data analytics and data
warehouse reporting, where a number of years and proven knowledge
may offset the degree requirement.
Experience & Skills:
In addition to the education outlined above, a minimum of 5 years
of experience in business intelligence, data analytics and data
warehouse reporting required. Strong knowledge of data modeling,
data quality, and ETL/SQL server needed along with Strong SQL
skills and business intelligence tool expertise are required. This
includes developing and testing database scripts, stored
procedures, triggers, functions, SSIS packages, SQL agent jobs and
other back-end processes to support system integration and ETL to
facilitate the creation and population of the Enterprise Data
Warehouse. Experience in formulating DAX calculations, data
storytelling, and dashboard design. Understanding of Tabular
models, Power BI and its components (Desktop, Service, Gateways,
etc.). Writing relational and multi-dimensional database queries;
configuring, deploying, and maintaining database servers. Strong
written and oral communication skills with the ability to work in a
cross functional team environment are a must. Refined analytical
thinking and problem solving skills are needed. Strong desire to
keep abreast of trends in the Business Intelligence technical
landscape and shape the vision for future capabilities. General
knowledge of Cloud Solutions such as Azure, AWS, and leveraging
PaaS. Working knowledge of .Net along with general knowledge of
NoSQL platforms such as MongoDB.
Travel for this position is rare.
OEConnection is subject to certain governmental recordkeeping and
reporting requirements for the administration of civil rights laws
and regulations. In order to comply with these laws, we invite
applicants and employees to voluntarily self-identify their gender,
race and ethnicity. Submission of this information is strictly
voluntary and refusal to provide it will not subject you to any
adverse treatment. The information obtained will be kept
confidential and may only be used in accordance with the provision
of applicable laws, executive orders, and regulations, including
those that require the information to be summarized and reported to
the federal government for civil rights enforcement. When reported,
data will not identify any specific individual. This information
will be maintained separately from your application for employment.
If you do not wish to self-identify at this time, you may do so in
the future by submitting this form. Failure to provide the
following information will not subject you to any adverse action or
treatment. OEConnection is an Equal Opportunity/ Affirmative Action
employer. We provide equal employment opportunities to all
qualified employees and applicants for employment without regard to
race, religion, sex, age, marital status, national origin, sexual
orientation, citizenship status, veteran status, disability or any
other legally protected status. We prohibit discrimination in
decisions concerning recruitment, hiring, compensation, benefits,
training, termination, promotions, or any other condition of
employment or career development.
Keywords: OEConnection, Cleveland , Senior Business Intelligence Engineer, Engineering , Richfield, Ohio
Didn't find what you're looking for? Search again!