Skip navigation
Sr. Data Integration Engineer

Sr. Data Integration Engineer

Job Description

Making a World of Difference -At Ecova, we believe each individual, no matter the role, can make a difference for our clients, the environment and for themselves. Ecova is built on a strong foundation of integrity, community, leadership, persistence and urgency.

Our highest goal is to be the market leading, trusted advisor to organizations driven to maximize results, reduce expenses, manage risk and improve environmental performance. Our focus is to grow results on saving resources for our clients – from utilities to facilities. We apply data-driven insights – from demand to impact – to target inefficiencies and See More, Save More and Sustain More for our clients.

We strive to deliver results and innovation through efforts of our unparalleled people to each and every client with whom we engage. We’re on the look-out for team players to work with us in serving as an integral extension of our clients to measure, analyze and improve resource management. Come join the Ecova family… together we can Make a World of Difference.


Role Summary:

This senior data integration engineer position is responsible for the effort to design, development, implement, manage and support enterprise ETL processes and environments.  This person must have the ability to become adept at domain and tool experience.


Role Description

  • Plan and conduct development work on projects necessitating the origination and application of new and unique approaches
  • Translate business requirements into data models that drive data warehouse or data mart design and configuration
  • Work with cross-functional teams to gather, document, and approve business requirements for data analysis and reporting projects
  • Translate business requirements into system design specification to manage Unstructured, Transactional, Hierarchical, Master and meta data
  • Design, develop and implement data integration (ETL) processes to transform unstructured and disparate source data into the target data stores, data warehouses or data mart
  • Oversee implementation and maintenance of ETL processes that support feature development and testing
  • Monitoring of data warehouse ETL processes and implementation of tuning as needed to address scalability, recoverability and performance impediments
  • Provide 24x7 support to ensure availability of BI environments for internal and external users

Job Requirements

  • BS in Computer Science or related field; or equivalent combination of education and experience.
  • Advanced knowledge of logical and physical data modeling concepts for OLTP and OLAP databases
  • Advanced Knowledge of with an emphasis on of Informatica Powercenter or other comparable server/integration tool
  • Knowledge of SQL Server 2008/2012 with an emphasis on Integration Services (SSIS) or other comparable server/integration tool
  • performing Extract, Transform and Load (ETL) responsibilities
  • Minimum 4 years experience with SQL database development or other comparable environment
  • Minimum 4 years with data warehouse implementations
  • Minimum 4 years experience working with users in a requirements analysis role
  • Advanced knowledge of logical and physical data modeling concepts
  • Advanced knowledge of database development techniques and creating and debugging stored procedures
  • Advanced knowledge in data modeling designs and techniques
  • Advanced knowledge of Data Warehouse project lifecycle, tools, technologies, best practices
  • Expert skills to develop complex SQL queries (ex: using various joins and sub-queries) and stored procedures
  • Advanced Experience with performance tuning of integration methodologies and associated code
  • Ability to thrive in a fast paced remote environment with minimal direction, extreme pressure, and tight deadlines
  • Strong problem-solving skills, troubleshooting, and root cause analysis
  • Ability to validate data integration by developing and executing test plans

Ecova Information

Our salaries are competitive and commensurate with experience. We are a performance-based culture and have goal-based incentive programs and generous employee benefits. Our comprehensive benefit package includes medical, dental, vision insurance, life, AD&D, short- and long-term disability insurance. We also offer flexible spending accounts and 401(k) with a generous employer match.

Ecova is an equal opportunity and affirmative action employer. All qualified applicants will be considered without regard to age, race, color, national origin, ancestry, sex, sexual orientation or preference, religion, marital status, citizenship, veteran status, or physical or mental disability.


Job Snapshot

Employment Type Full-Time
Job Type Engineering
Education 4 Year Degree
Experience At least 4 year(s)
Manages Others Not Specified
Industry Industrial
Required Travel Not Specified
Job ID US-oE31Yfwq-1
CareerBuilder Tip:
For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using you are agreeing to comply with and be subject to the Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Sr. Data Integration Engineer

Enter notes about this job: