The job below is no longer available.
Use left and right arrow keys to navigate
Hours Full-time, Part-time
Location Troy, New York

About this job

Job ID: 82262

3M is seeking a Data Implementation/ETL Engineer for the TREO Business Group located in Troy, NY. Be part of what's next!

3M HIS is working on the cutting edge of healthcare analytics. We are facilitating a transition from volume based to value based healthcare that drives reductions in healthcare costs while improving outcomes by increasing quality of care. The data warehouse and decision support systems are the foundation for initiatives like these. The magic of 3M innovation happens when smart, creative people collaborate to break new ground, solve a problem or create a solution that improves or saves lives.

Job Summary :

This position will be responsible for designing and maintaining the processes and structures used to transform large scale Healthcare data sets into a data warehouse and various data marts which will support a suite of production applications.

Primary Responsibilities include but are not limited to the following:

- Assist in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL-related activities

- Creates automated processes to validate and translate data into our in-house data warehouses.

- Review requirements and data models, and translate into ETL design processes that effectively populate data warehouse and data mart tables

- Participate in meetings with technical peers regarding the solution designs

- Need to communicate with the Business Analysts, Data Modelers and Solution Architects when it comes to converting the ETL design into specific development activities

- Understands and implements best practices, tuning and optimization

- Maintain existing ETL code

- Creates technical documentation

- Workers effectively with data consulting and client services to produce products for the client

- Develop new ETL code using data model and source to target mapping document. Review and interpret data models

- Participate in daily stand-ups and weekly status reporting

- Ability to travel 10% if needed

Basic Qualifications:

- Bachelor's degree or higher from an accredited university

- Minimum of 5 years of experience supporting large-scale RDBMS applications with ETL tools, complex SQL logic and query optimization

- Minimum of 5 years working with one (1) or more of the following ETL Tools: Informatica, SyncSort DMX, Data Stage, AB Initiio, or Talend

- Minimum of 5 years of experience with data warehousing methodologies including dimensional modeling

Preferred Qualifications:

- Bachelor's Degree in Information Management or Computer Science or related field.

- 7+ years of experience working in the design, production, and support of data warehouses.

- Advanced knowledge of SQL Server 2008 or later is preferred.

- Informatica ETL and Healthcare Data experience strongly preferred.

- Experience in analysis, data relationships, data aggregation and summarization with the ability to consolidate data from disparate systems is preferred.

- Experience with the Kimball methodology, slowly changing dimensions, and CDC (change data capture) strongly preferred.

Location: Troy, NY

Travel: May include up to 10% domestic

Relocation: Is not authorized

About 3M

Do you see the world differently? Are you inspired by how a simple shift can result in big change? Do you share your ideas in the hopes of coming up with something even better by working together? Then join 3M! With 88,000 people around the world in more than 70 countries and $30 billion in sales, 3M is committed to building on our rich heritage by bringing our best to the innovations we create. Be part of improving how people live and work every day. Be part of what's next at 3M! Follow us @3MCareers and learn more at YouTube.com/3MCareers.

Benefits Information:

This position is a 3M HIS position and is therefore not a 3M benefited position. The position is subject to the benefit package under 3M HIS benefits program. Details will be shared with you at the time of interview with the hiring manager.

Relocation:

No Relocation available

Must be legally authorized to work in country of employment without sponsorship for employment visa status (e.g., H1B status)

Apply now for this exciting opportunity with 3M. 3M is an EEO/AA employer. Women, minorities, veterans, and individuals with disabilities are encouraged to apply.

Posting Notes: ||Troy ||New York ||United States ||US Compliance Boards ||