Enterprise

Engineer 2, Data (ETL Developer) - Fleet Management IT

Location
St. Louis
Category
Information Technology - All Positions
Job ID
2021-363063

Overview

Enterprise Fleet Management (EFM) is a full-service fleet management company for businesses with mid-size fleets. With 57 fully staffed offices nationwide, EFM supplies cars, light and medium duty trucks and service vehicles to businesses in the United States.

 

Enterprise Fleet Management Information Technology (EFMIT) provides streamlined and effective solutions to serve our growing operation. We offer solid architectural platforms with a strategic focus that clearly align to business growth and improving the customer experience. The Fleet Management systems, including EDGE, Fleet Commissions, Fleet Web and Autodata, are web based applications built using J2EE technology and are integrated with our PeopleSoft financials system as well as our Oracle BI data warehouse.

 

Being a member of EFMIT offers all the advantages of a smaller shop including the opportunity to shape a more progressive architecture. Professionals who effectively navigate change and readily wear many hats will find this an opportunity to maximize skill diversity and build broad IT experience.

 

As you are considering a position with Enterprise Holdings, we invite you to learn more about our business. Today – and every day – the safety and wellbeing of employees, customers and the communities we serve is our top priority. For the latest on our COVID-19 response, please click here.

 

Responsibilities

The ETL Developer is responsible for the design, development, implementation, and support of new and existing highly efficient, highly scalable ETL processes. This individual will apply proven communication skills, problem-solving skills, and knowledge of best practices related to the design, development, and deployment of Data Warehouse and Business Intelligence solutions.

 

The ideal candidate will be a self-motivated individual and active listener. You will be an important member of the team tasked with transforming a traditional enterprise data architecture into a next-generation cloud-based streaming platform in a fun, challenging, fast paced work environment.

 

 

Equal Opportunity Employer/Disability/Veterans

Qualifications

Required:

  • Must be presently authorized to work in the U.S. without a requirement for work authorization sponsorship by our company for this position now or in the future
  • Experience with monitoring real-time and/or batch ETL processes
  • 3+ years of  developing and supporting data warehouse (including slowly changing dimensions)
  • Exceptional problem solving and troubleshooting skills
  • Extensive SQL programming experience, including stored procedures, analytic SQL, complex join conditions, and error trapping
  • Ability to produce high-quality, thoroughly tested solutions with extraordinary attention to detail.
  • Ability to confidently and independently research/analyze/develop while still engaged within a team structure (following standards and best practices where appropriate)
  • Analyze requirements and provide solutions to meet business needs
  • Excellent verbal and written communications skills and ability to multi-task within a team-oriented environment
  • Commitment to creation and maintenance of documentation on ETL process and procedures
  • Demonstrated proficiency developing and supporting extract, transform, and load (ETL) processes
  • Ability to create and maintain ETL documentation (e.g., source-to-target maps) with an emphasis on data governance
  • Ability to participate in production on-call support rotation schedule for ETL processing and completion
  • Ability to provide estimates for ETL processes and suggest/implement tuning improvements
  • Must be committed to incorporating security into all decisions and daily job responsibilities

 

Preferred:

  • Bachelor's degree in Computer Science, Computer Information Systems, Management Information Systems, or related field preferred
  • Prior experience extending or migrating existing data pipelines to cloud platforms such as AWS
  • Experience with AWS services
  • Experience with Oracle Data Integrator
  • Oracle Database, Snowflake, PostgreSQL experience a plus
  • Experience building self-service reporting solutions using business intelligence software (e.g., OBIEE, Tableau, MicroStrategy, etc.)

 

Position-Specific Competencies:

 

Agile Communicator

  • Drives open communication in team; strong ability to communicate to technical and non-technical audiences and across levels in the organization; able to leverage multiple modes of communication; exhibits cultural sensitivity in communication

Collaborative & Team Focused

  • Actively seeks out and values input from team members and key stakeholders; highly effective and agile in operating as a member of multiple teams; actively shares valuable information within and outside of team; builds relationships and collaborates with one’s team, as well as teams across the organization; participates in teambuilding activities; takes time to understand and partner with other IT teams; champions a team mentality and creates an environment that fosters collaboration and idea sharing within and outside of one’s team 

Customer Focused

  • Places a critical emphasis on understanding customer needs, prioritizing work appropriately and leveraging internal and external business partners to enable quality solutions 

Models EHI Culture

  • Consistently displays a positive attitude towards EHI and team members; operates with trust and transparency; exhibits a strong degree of flexibility; adapts easily and quickly to change; flexible and agile in work and problem solving approach; adapts work methods and behaviors to changing conditions, new technology and business trends; possesses an appreciation for others’ strengths, adapting to and leveraging what others uniquely bring 

Owns the Outcome

  • Takes ownership of responsibilities - leveraging both internal and external service-oriented business partners - and holds self and others to high standards; successfully delivers in the face of ambiguity; goes above and beyond to improve and exceed expectations; exhibits a strong work ethic, as well as ownership of individual and team results; recognizes and drives solution opportunities and improvements 

Technology Savvy-extensive

  • Stays current on technology trends and how they impact one’s function; drives solutions by proposing, initiating, or explaining technical ideas to solve major problems; stays up-to-date on latest technology trends

Thrives in Change

  • Embraces, adapts, and proactively responds to change; manages risk and uncertainty; takes conceptual ideas and turns them into reality; proponent of change; with an appreciation and respect for the past, pushes past norms and involves champions who will adopt new approaches and technology; avoids a reactive approach by constantly looking for and implementing new opportunities; remains flexible to meet changing and sometimes opposing demands; approaches change in a thoughtful and logical manner 

Thinks & Acts Innovatively

  • Uses technical and professional knowledge to design new methods where established methods and procedures are inapplicable or unavailable; pushes past the status quo and questions common practices in order to identify better ways of doing things; recommends and implements improvements and provides others with freedom to explore and be inventive; encourages others to frequently take a fresh look at existing policies, practices, and programs 

Leverages Influence

  • Influences to achieve small wins within own team or department that support an overall vision as set forth by leadership; understands and explains benefits of initiatives; proactively networks within and outside the organization; leverages multiple communication channels; remains open and engages thoughts of others; able to lead discussions and sell ideas

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed