Data Warehouse - Edmond, United States - Warren Equipment Company
Description
** Data Warehouse / Integration Developer**
**Job Category****:** Professional **Requisition Number****:** DATAW003536 Showing 1 location **Job Details**
**Description**
TEAM UP WITH US
This Data Warehouse Integration / ETL Developer position will work collaboratively with other stakeholders in the business to understand our data and reporting needs to support our Data Warehouse architecture and integration model that will facilitate the needs of the data and reporting team. This role will deliver the development, testing, ongoing evaluation, and validation of organizational data structures while identifying issues in current processes. In addition, the developer will need to provide effective requirements analysis, adherence to effective scrum practices, on-time product delivery, and proven strategies for ongoing database and data warehouse development relating to internal custom applications development and deployment.
WHAT YOU'LL DO
Define, design, and implement Business Intelligence (BI) and Data Warehouse (DW) strategies for operational, ad-hoc, and other BI related solutions.
Assist in the definition, documentation, and development of mapping rules for movement of data from disparate data sources and into the various components and subject areas of the BI environment.
Create data models including robust data definitions, entity-relationship-attribute models, as well as relational and/or dimensional models.
Work closely with business analyst to transition logical models to physical implementation of data structures.
Design and architect enterprise systems from conceptual model to implementation.
Develop comprehensive implementation plans along with delivering the output as defined in the project's goals and objectives
Provide hands-on data modeling (relational and dimensional) for Data Warehouse.
Provide best practices and guidance regarding use of ETL, data modeling (relational and dimensional), and reporting deliverables.
Collaborate with external technology partners to implement the technology solutions.
Support in the development of the future product strategy for data sharing, analytics, and visualization capabilities.
WHAT YOU'LL NEED
Bachelor's degree and 3+ years of business / data analysis, analysis, Business Intelligence and Datawarehouse / ETL integration or equivalent experience required.
In-depth Knowledge of Business Intelligence, Data Warehousing and ETL integration concepts and proven experience (e.g., Star schema vs. Snowflake, OLAP cube, Kimball, etc.)
Some travel, off- hours maintenance, and extended hours support are required.
Rich experience in data integration, data architecture, data engineering, software engineering / DevOps, data operations, analytics, or BI
Experience with SQL and different kinds of data management technologies, from standard RDBMS to newer big data tools
Experience with modern integration tools and architecture (API, ETL - Boomi, Talend, Informatica, MuleSoft, etc.)
Experience in the Agile software development framework required
We like to take care of business and have fun doing it
We offer health, dental, vision, life, and more as a comprehensive benefits package.
IMPORTANT INFORMATION
While performing the duties of this job, the employee is frequently required to sit. The employee is occasionally required to stand; walk; use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl and talk or hear. Specific vision abilities required by this job include close vision, distance vision, color vision and ability to adjust focus.
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this Job, the employee is occasionally exposed to high, precarious places and risk of electrical shock. The noise level in the work environment is usually quiet.
The noise level in the work environment is usually quiet.
Required travel up to 10%.
This position is considered a safety sensitive position.
The Job description is subject to change by the employer as the needs of the employer and requirements of the job change.
EEO/AA
**Qualifications**
**Skills**
**Behaviors**
**:**
**Motivations**
**:**
**Education**
**Experience**
**Licenses & Certifications**
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractors legal duty to furnish information. 41 CFR c)