Skip to content

JobNet: Jobs for Technical People

 

Madison, Wisconsin - USD Full Time Posted: Thursday, 11 October 2018
 
 
Job Purpose
Under the direction of Information Technology Management, this position will be responsible for designing and developing ETL components related to projects and/or functional enhancements. This person will provide technical leadership which include, designing and data modeling the most efficient ETL solutions, partnering with other IT Architecture roles to define those solutions, and articulating those solutions to the development staff for delivery. An important role this person needs to play is the ability to understand the scope of a project, create long term, solid, ETL solutions, while keeping in mind the bigger picture.
Collaborate with Information Technology Architects to understand information, data, and technology standards. Ensure alignment of enterprise standards with internal ETL architecture and designs. Ability to perform Data Modeling (Dimensional/Operational) within Erwin, assist with defining standards and assure adherence to standards. Continuously evolve understanding of where the overall enterprise data strategy is going. Create/Evolve internal teams ETL architecture and designs standards by partnering with other peer ETL designers Design enterprise reusable ETL components to improve design & coding efficiencies. Define/Create ETL design solutions which would include supporting artifacts and design deliverables depending on technology. Define ETL flows, transformation rules and framework to support ETL development. Ability to lead a team of developers to drive to a solution. Lead advanced troubleshooting and problem resolution functions for ETL/Data issues. Make recommendations on increasing scalability and robustness of ETL platforms and solutions. Mentor/Coach less experienced staff. Ability to provide level of effort estimate for the entire ETL strategy as it pertains to a given project. Accountable for the overall delivery and success designed solutions. Collaborate with others across the IT organization to understand all aspects of the project with the goal to drive a collective robust solution. Build collaborative relationships with business customers to understand their goals, needs, and objectives and use as input to the overall ETL architecture and design. Ability to articulate complex solutions in an easy to understand fashion. Ability to articulate all needed activities to assigned project manager/leader on any given project and track actual work back to given estimates.
Job Responsibilities:
75% - Data Model, Design and Architect ETL BIDW internal solutions which would include standard delivery artifacts based on technology. Partner with Information Technology Architects and others across the organization to create a solid, long term supportable solution. Lead a team of developers to execute and drive designed solution towards completion on time and within budget. Continuous communication back to assigned leaders on status and progress of teams activities. Ability to lead and drive work activities that have interdependencies with other teams and drive resolution on any of issues related to your work activity. Overall accountability for ensuring the successful delivery of designed solution, small or large.
15% - Provide level of effort estimates for any work activities as it relates to functional enhancements or projects. Continue to build system knowledge not just within our team but across the organization with the goal of building a better understanding on how data assets should be designed and architected. Continuous partnership with the Enterprise Architecture team to understand the strategy, future technical direction, and enterprise tool standards our team should leverage. Continued partnership with business to understand their requirements and translate those into long term supportable solutions. Continue to understand Data Office to understand their future vision to incorporate into built solutions.
10% - Focus on continuous education, process and architectural improvements as it relates to day to day activity or when designing solutions. Continue education on new technologies or existing technologies with the goal of looking for streamline opportunities.
Required Skills:
  • Bachelor s degree in Computer Science, Mathematics, Information Systems, or Data are preferred or equivalent work experience.
  • 8+ years progressive experience in architecture/system design/data analysis related to ETL, data management, data integration and data delivery work.
  • 8+ ETL experience using one or more of the following tools/database platforms
    • Informatica Power Center version 9. 6 or higher
    • SSIS SQL Server Integration Services
    • Microsoft Azure stack (Hive/Pig/Hadoop/Python)
    • Microsoft SQL Server 2008 or higher
  • Architect/design ETL solutions to process/load source systems data into multiple database
  • 3+ years hands on experience with dimensional and operational data modeling
  • 5+ years hands on lead experience architecting and designing ETL components
  • Strong skills with understanding the tradeoffs of various design options on multiple platforms
  • Experience with preparing technical artifacts to support design efforts
  • Ensures adherence to design/development standards
  • Ability to Lead a team of technical people which would include on/offshore vendor partners
  • Good communicator and proactive approach to daily activities
  • Positive and problem solving attitude
  • Experience in Agile technical project data delivery
  • Ability to build collaborative relationships across the organization
  • Ability to plan, orchestrate, and coordinate technical release activities
  • Very strong analytical complex thinking
  • Ability to communicate back to non-technical stakeholders in a easy to understand manor
CUNA Mutual Group s insurance, retirement and investment products provide financial security and protection to credit unions and their members worldwide. As a dynamic and growing company, we strive to create a culture of performance, high standards and defined values. In return for your skills and contributions, we offer highly competitive compensation and benefit packages, significant professional growth, and the opportunity to win and be rewarded. Please provide your Work Experience and Education or attach a copy of your resume. Applications received without this information may be removed from consideration.

Madison, Wisconsin, United States of America
IT
USD
Credit Union National Association
Credit Union National Association
JS2365_08FE927BEF335C75BF4DFD792BFAAD8C/537580186
10/11/2018 7:02:15 PM

We strongly recommend that you should never provide your bank account details to an advertiser during the job application process. Should you receive a request of this nature please contact support giving the advertiser's name and job reference.

Other jobs like this

Madison, Wisconsin
USD
Madison, Wisconsin
USD