Click here to login or register
Reference # : 18-09319 Title : IT - Business Systems Analyst III
Location : Irving, TX
Experience Level : Start Date : 11/02/2018  
This is Thomas from CompNova , LLC
We have an immediate Job Opportunity for our Direct Client.
Kindly have a look at the below Job Description and do reply back on the same at your earliest with a copy of your updated resume in word Doc.
Position Title: IT - Business Systems Analyst III 3544-1
Location: Irving, Texas 75063
Duration: 6 Months
Job Summary /Responsibilities:
The Data Analyst Sr. position plays a key role in facilitating data requirement meetings with business and technical stakeholders and resolve conflicts to drive decisions. This person will participate in all IT and Business related discussions in understanding the data generation (upstream) and data consumption (downstream).
This position is critical to driving the strategic value in laying strong foundational models, providing clear directional path to Data Integration (ETL) team to develop jobs; in helping Database Administrators (DBA) in ease of maintenance and in operations such as loading and extracting data into those; and in providing inputs to the Architecture team for designing the solution.
Essential Job Functions:
  • Establish and maintain comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships
  • Be able to analysis on data and access patterns to determine constraints.
  • Provide data mappings requirements, user interface specifications, processing logic as per business requirements to the ETL team.
  • Understands the flow of data, business processes/technical interfaces that would be created or impacted.
  • Document purpose and driver behind each of the models.
  • Document logical, physical models complete with business definitions .
  • Maintain the data dictionary, business data glossary, naming conventions, standards and abbreviations and their intended meanings in a central repository
  • Identifies and document sources of existing data as well as the new data. Understands use of master and reference data including sources and contributors
  • Consult, discussion with business partners, peer Data Architects, Engineers in understanding the requirements, setting and managing expectations in relation to deliverables
  • Ability to prioritize and handle multiple projects.
  • Have joint accountability with data stewards and data architects on the projects to ensure conformance to enterprise data governance policies around information risk and data protection guidelines. Data analysts should be familiar with common policies around data masking and protection schemes.
  • Be able to provide best approaches to data storage in terms of achieving separable Business data vs non-business data (Natural keys vs Surrogate keys)
  • Present the model, access path and lineage as needed (into such formats as excel, if required)
  • Be able to participate in Business discussion and prepare initial source-to-target mappings
  • Have working knowledge in Agile environments and adopt to multiple itineraries running in concurrency. Must be able to document user stories and take it forward with the development team to implement stories.
  • Other related duties as assigned (to data modeling, data access)
  • Maintains data dictionary by revising and entering definitions.
Education / experience requirements:
  • Senior level knowledge in Core Competencies: Hands-on experience in developing data models, and data warehouses, development knowledge
  • Locate data sets and prepares data or defines the specifications to prepare data from multiple sources: scripting, database management and queries
  • Must have good knowledge and experience with industry leading Modeling tools
  • Good hands-on experience in working with relational databases (in creating DDLs and Access paths – DCL). Preferred knowledge in: SQL*Server, Netezza, Oracle, MySQL, ETL ,BI
  • Demonstrated superior competence in soft skills associated with core competencies such as documentation, communication, leadership, facilitation, team management & customer relationships.
  • Ability to clearly communicate outcomes, technical artifacts and status to senior management team.
  • Must have familiarity and deep knowledge of modeling multi-source (Systems of Record – SOR) integration (into single 'source of truth') type data architecture
  • Must have knowledge of and working experiencing in modeling "SCD – type 2” for tracking historical changes
  • Highly skilled in managing all aspects of all sizes and complexities of multiple projects simultaneously across the software development life cycle phases (SDLC)
  • Knowledge of Finance industry – especially Mortgage industry is a plus
  • Strong track record of interviewing business partners, setting and managing expectations in relation to deliverables and requirements
  • Solid understanding of Agile development methodologies and software project life cycle and associated methodologies
  • Development experience in SQL / ETL / BI ( package , stored procedure ) is preferred.
  • Strong analytical skills with the ability to collect, organise, analyse, and disseminate significant amounts of information with attention to detail and accuracy
  • Knowledge of Finance-Mortgage industry is preferable
  • Experience with standard systems analysis tools and procedures
  • Excellent problem solving skills and analytical skills
  • Excellent verbal and written communication skills with the ability to establish deep understanding of clients' business issues
  • Excellent customer servicing skills
  • When required, be able to lead teams and implementing measures and processes
  • Proven ability to confirm testing objectives, verify requirements are testable and trace testability back to requirements
  • Minimum 5+ years of experience as a data analyst with modeling experience
If interested in applying for the position please send us a latest copy of your resume in Word Doc along with the below details ASAP, we would get back to you immediately
Candidate Details:
Expected rate:
Full Name:                                                     
Email id:                                                                                     
Present Location:
Zip code:                                           
Visa status:                                                     
Relocation (Y/N):                                          
Time for Interview:                                                     
Total Years of Experience:                            
Background Check:
Thanks & Regards
300 N Coit Road Suite
# 340 Richardson, TX 75080
Tel: 972-638-7028