ETL Developer Position
At a glance
Mid-level Data Engineering role at Integrated Resources INC. Detroit · no salary stated · we estimate $112,500–$160,000 across the United States.
Integrated Resources INC has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Build warehouse code for business intelligence work and bring information together from multiple source systems
- Keep logical and physical data models aligned, and maintain shared definitions used across the warehouse
- Apply warehouse standards for security, archiving, backups and recovery
- Help shape data movement from source systems through staging and operational stores into the enterprise warehouse
- Spot system or process problems, work through fixes with the team, and communicate progress
What you bring
- At least eight years in IT, including three or more years in data warehousing
- Three or more years developing warehouse solutions and running them in an Oracle enterprise environment
- At least three years using Data Stage for ETL and loading enterprise warehouse data into production
- Dimensional modeling capability across conceptual, logical and physical layers, with experience recording the models
Who this fits
This mid-level, onsite Detroit role suits an experienced warehouse developer who can work independently and alongside technical teams and business users. You’ll need to communicate clearly, assess customer requirements, and adjust your hours when needed.
From the employer
A Few Words About Us Integrated Resources, Inc is a premier staffing firm recognized as one of the tri-states most well-respected professional specialty firms. IRI has built its reputation on excellent service and integrity since its inception in 1996. Our mission centers on delivering only the best quality talent, the first time and every time. We provide quality resources in four specialty areas: Information Technology (IT), Clinical Research, Rehabilitation Therapy and Nursing.
Position Description
Position will be responsible for the integration, expansion, and support of the North American Automotive and Insurance data warehouse solutions. The Data Warehouse Developer is responsible for interpreting, organizing, designing, executing, and coordinating technical assignments within the Data Warehouse.
Candidates must have hands on experience with Oracle 10g or higher and Data Stage. Applicant will work closely with a multitude of groups throughout the organization, which will require the ability to communicate with associates with backgrounds ranging from DB development, Application Support, Networking, Operating System Administrators, Software Development Managers, and Business users from a wide range of operating units.
Principal Accountabilities
• Develop code for Data Warehouse in support of business intelligence projects
• Ensure consistency of Logical and Physical Data Models for all Data Warehouse applications
• Possess a broad understanding of multiple technologies, including DBMS, ETL, Reporting, OLAP, performance tuning for high-end hardware and storage
• Maintain responsibility for global data definitions used in the Data Warehouse
• Integrate data from multiple source systems into Data Warehouse
• Adhere to standards for Data Warehouse, including security, archiving, backup, and recovery
• Participate in architectural decisions for data transitions from source to staging to ODS to EDW
• Communicate regularly and effectively with team members and supervisors
• Identify system and process issues then engage the team in problem solving
• Plan and participate in cross-training with team members
• Develop technical skills comparable to other developers
• Fill in for other developers as requested
• Recognize accomplishments and contributions of team members
• Promote an image of a high quality organization through expertise and responsiveness
• Take responsibility for assignment completion and follow-through
• Provide high level of customer service
• Establish and maintain good working relationships with internal and external customers
• Facilitate satisfactory communication and resolution of problems
Minimum Requirements
• 8+ years of IT experience
• 3+ years of Data Warehouse experience
• 3+ years of experience with extraction, transformation, and loading tools and development of strategies for loading data into production enterprise Data Warehouse
• 3+ years of Data Warehouse development experience
• 3+ years of production experience in an Oracle enterprise Data Warehouse
• 3+ years of Data Stage ETL experience
• Ability to effectively present information and respond to questions from executives, directors, managers, clients and customers
• Must have dimensional modeling skills at the conceptual, logical, and physical levels, and experience documenting data models
• Ability to work in a rapid-development environment
• Ability to work closely with customers in analyzing requirements
• Ability to work flexible hours
• Project management and technical leadership
• Strong communication skills, written and spoken
• Comfortable working independently, but has experience working in a team environment
• Skills establishing and maintaining effective working relationships with clients and staff
• Ability to read, write, speak, and understand English required
• Can discern when escalation is needed
• Experience in Agile / SCRUM with sprint methodologies preferred
• Finance or Automotive Industry experience preferred
• BS and 6 + years or equivalent
Regards,
Sweta Verma
IT Recruiter
Integrated Resources, Inc.
Inc. 5000 – 2007-2014 (8th Year)
Certified MBE I GSA - Schedule 66 I GSA - Schedule 621I I GSA - Schedule 70
(Direct) 732 549 5907 | (W) 732 -549 - 2030 x 210| (F) (732) 549 5549
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.