SQL / ETL Developer (Closed)

SkillStorm is seeking a SQL / ETL Developer for our client in Addison, TX. Candidates must be able to work on SkillStorm's W2; not a C2C position. EOE, including disability/vets.

Job Description:

• 10+ years’ experience in design and creation of Oracle SQL and ETL based frameworks applying good/strong data modeling skills. Be able to design the conceptual, logical and physical data models necessary to support the analytic data requirements for various department reporting needs. Should be comfortable working with both systems and data.
• Expertise in creating and maintaining data models and high performing ETL routines (i.e. DataStage, Infomatica, Alteryx)
• Strong PL/SQL and data analysis experience
• Leads efforts in development of new models, analytic processes or system approaches. Creates documentation for all activities and may work with technology staff in design of any system to run models developed.
• Improving and streamlining processes regarding data flow and data quality to improve data accuracy, viability and value. Challenges data and information integrity.
• Conducts special studies to analyze complex financial actions and prepares recommendations for policy, procedure, control or action. Develops models and provides input and feedback to improve the ability to plan and control financial and business drivers
• Participate in the ongoing development and operations of a business intelligence architecture that enables fact-based decision making and ad hoc analysis and insight generation.
• Operational Data Store modeling, design and development
• Design and prototype new analyses, reports, applications and systems
• Enhancing old processes and defining new ones
• Data mining and producing novel reports for management
• Works closely with Line of Business Client to develop and enhance SQL data base solution
• Strong Excel Skills with pivots and graphs
• Candidate must have strong analytical, problem solving, and communication skills
• Bachelor degree or equivalent in a quantitative field such as computer science, mathematics, engineering, finance, etc.
• Must be comfortable conducting process reengineering "Solve" sessions
• Program in an agile, fast paced, accelerated development environment
• Solid Team player member on a development team, Problem solver, Technical intrigue
• Works under minimal supervision, with general guidance from management
• May assist and help train lower level developers.
• Conversant with all phases of Software Development Life Cycle (SDLC), including requirement gathering, analysis, design, development, implementation, integration and testing

Desired Skills:

• Knowledge of any job scheduling tools ( i.e. Autosys, Shell scripts, etc.)
• 2+ year’s experience in developing Tableau and any other BI Tools.
• Knowledge of Hadoop and Python
• Experience working with large amounts of data, conducting analysis and presenting findings
• Knowledge of banking experience
• Strong working knowledge in Build process and release co-ordination
• Have excellent customer communication and interpersonal skills with high level of adaptability

#LI-DNI