ETL IT Designer

CUNA Mutual Group - Madison, WI (30+ days ago)4.0


Salary Grade 245
3 Open Positions
New Positions
Full Time
Work Schedule: TBD

Job Purpose:
Under the direction of Information Technology Management, this position will be responsible for designing ETL components related to projects and/or functional enhancements. This person will provide technical leadership which includes designing and data modeling, partnering with IT Architecture to define solutions, and articulating those solutions to the development staff for delivery. This role will have the ability to understand the scope of the project(s) and design solutions that scalable, reliable and strategic.

Additional details included but are not limited to:
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), assist with defining standards and assure adherence to standards. Continuously evolve your understanding of where the overall enterprise data strategy is going. Create/Evolve internal teams’ ETL architecture and design 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. Experience in leading a technical team to drive technical results. 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 of designed solutions. Collaborate with others across the 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 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 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
XML
Microsoft Visual Studio Team Foundation Server
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
Experience with Scrum software development
Ensures adherence to design/development standards
Experience in leading a technical team including both 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.