Data / Business Analyst

Locations: Irving TX, OR O Fallon, MO- Onsite

Full Time

JD:

• Mortgage Banking Domain Bank experience most preferable.
• Any SQL experience.
• Basics of ETL
• Excel Formulas / Pivot table for Data Analysis
• Basic Concepts on Data Model and Analysis
• Basics of Agile/Scrum Process
• Min 6 years of IT Experience.

Job Description:

Description:

IT Sr. Data Analyst works with business, data governance and IT partners to understand the data needs and identifies and documents the requirements for the project efforts. The DA works closely with the identified business data owner/SMEs and performs his/her own research to understand the elements, performs data analysis, gathers all necessary element attributes and performs any required mapping. The DA performs data tracing and data lineage exercises to bring transparency to the flow of data. The DA also performs root cause analysis on data quality issues to determine where the issue is and then works with business and IT partners to determine a solution. The DA serves as a requirement liaison between business and IT to ensure all questions are answered, requirements are clarified and necessary updates are captured. The DA supports the development and testing through requirement development and validation. The DA reports team activities to project management, team management, functional experts, team members, and project stakeholders. The resource will resolve cross-functional issues and involve appropriate functional units to ensure a seamless project implementation.

Qualifications:

• Experience with projects relating to data management efforts including but not limited to the implementation of a Enterprise Data Model, Operational Data Store, Metadata Repository and Master Data Management
• Strong understanding of relational databases
• Experience performing extensive data mapping exercises
• Experience performing in-depth data analysis and data profiling activities
• Strong ability to both write and interpret complex SQL
• Experience eliciting requirements during real time collaborative sessions with stakeholders located in different geographic locations
• Strong interpersonal skills and techniques to solve dynamic problems; excellent teamwork skills
• Must have excellent written and verbal communication skills, along with strong consulting skills
• Experience identifying and implementing process improvement
• Solid skills effectively working multiple projects simultaneously in a cross-functional environment
• Strong organizational skills and ability to influence team dynamics
• Proficiency in project management methods and techniques
• Ability to estimate work effort at project milestones for data analysis activities with progressively improved variance to actual effort as scope and requirements are refined
• Ability to research, classify, and prioritize business, user, functional and non-functional requirements
• Experience in varying SDLC methodologies especially Agile
• Must have experience working with Mainframe, Client/Server, Web, and system architecture
• Proficiency in MS Office (Word, Excel, Visio, PowerPoint) with extensive experience using Excel for data analysis
• Education: Bachelor's Degree or Equivalent work experience

Successful Candidates MAY also have:

• Knowledge of Mortgage and Retail business
• Knowledge/experience using JIRA or similar requirement management tools
• Experience with the development and documentation of use cases and stories
• Previous programming experience
• Good understanding of interface design patterns and concepts