Jobs 2017-06-14T10:05:04+00:00

Sr. SQL Server Developer - Data Analyst (SSIS)

Farmers Branch, Texas

Job ID: 5891 Category: Data

The  Senior SQL Server Developer – Data Analyst will collaborate with business, reporting and other teams to understand business requirements and perform data analysis.

  • Work with back-end data architects/systems engineers to construct data objects necessary for supporting these business requirements
  • Participate in data warehouse design, creation and monitoring to ensure that data is clean, accurate, available and complete
  • Analyze and create complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts
  • Serve as subject matter expert within the team
  • Work under general supervision and report to Manager, Director or VP of department
  • Adhere to general work requirements
  • Serve as subject matter expert within the team and apply specialized knowledge to support the organization’ s vision and direction
  • Design and support database and table structures for new and evolving sources of data being brought into the organization
  • Coordinate development of ETL/data warehouse best practices needed to support new and evolving sources of data used in reporting, transaction processing and analytics
  • Perform extensive and detailed data analysis necessary to ensure strict adherence to data quality guidelines
  • Create and analyze complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts
  • Participate in production support and code deployment after regular business hours
  • Take on end-to-end ownership and perform different roles as per the phase/requirement of tickets/projects assigned:
  • Analysis phase - Requirements gathering, data analysis, documentation, source-to-target mapping, data/process flow diagrams
  • Development phase - Coding/development, unit testing. peer code reviews, code performance aspects, impact analysis
    • Set/manage expectations with clients, provide proactive communication and status updates, prioritize deliverables with client/requestor, and follow and implement Change Control and release management processes
    • Perform other duties as assigned
  • Bachelor’ s degree in a related field
  • 5+ years of experience with SQL Server 2005/2008/2012 T-SQL coding
  • 2+ years of experience with SSIS
  • 5+ years of experience as a data analyst and/or SQL/SSIS developer
  • 3-4 years of experience working in the mortgage industry
  • Good understanding of database modeling concepts, preferably in the context of mortgage industry (originations and/or servicing). Example – MISMO specifications
  • Experience using data warehouse with underlying SQL databases and/or analytical tools for business purposes
  • Knowledge of key data warehousing and database processes
  • Good verbal and written communication skills
  • Ability to provide outstanding customer service in fast-paced environments
  • Proficient working knowledge of computerized applications such as word processing, spreadsheet, database, presentation software, email and specialized business applications software
  • Presentation skills necessary to effectively communicate, update, persuade and/or facilitate discussions with all levels of management
  • Interpersonal skills necessary to establish and maintain effective working relationships with coworkers, other business areas and government agencies as required
  • Ability to read and interpret complex reports and documents; assimilate and interpret various sources of data and provide and make decisions on recommendations to executive management to solve highly complex problems from start to finish
  • Planning and organizational skills necessary to coordinate workload around multiple assignments

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: