Back to Job Search

Data Integration Architect

  • Location: The Woodlands, 77380
  • Salary: 100000.0
  • Job Type:Permanent

Posted about 2 months ago

Financial services company is seeking a Data Integration Architect to join their BI team. This is a permanent opportunity in the Woodlands, TX. 
 

Description:

The Data Integration Architect is primarily responsible for providing ETL architecture and development across the entire enterprise. Design integration architecture that spans both on- premise and cloud. Day-to-day activities will include, but not be limited to designing and deploying optimized ETL (Extract, Transfer, Load) process across the entire enterprise, maintaining and contributing to enterprise data warehouse data model, architecting batch process automation, and ensuring implementation of sound data integrity processes.

 

Key Responsibilities:

  • Architect and develop enterprise and departmental ETL (Extract, Transfer, Load) solutions.

  • Create and help maintain Azure cloud integration services such as Azure Data Factory, Azure Service Bus, App Services, and Azure Functions.

  • Create robust and high-performing ETL mappings using Microsoft SSIS and Azure Data Factory.

  • Coordinate activities with data source application owners to ensure integration, data integrity, and data quality.

  • Create data mapping specifications to be used by the enterprise for ETL projects.

  • Understand and contribute to enterprise data warehouse data model.

  • Create standards to manage and report on errors within ETL packages.

  • Provide training and documentation for the BI team on ETL standards.

  • Provide after-hours, holiday, and weekend support (as needed).

 

Competencies Required:

  • Create architectural design for ETL process across the organization.

  • Provide leadership, training and best practices for the organization on ETL processes.

  • Ability to design, develop and translate business requirements and processes for data matching and merging rules, survivorship criteria, and data stewardship workflows using data management solutions.

  • Resourceful and highly adept at problem identification and incident resolution using experience and developed analytical skills.

  • Exceptional verbal communication and technical writing skills with an ability to effectively interact with and convey information to people who possess varying levels of understanding on applicable topics.

  • Strong attention to detail and concern for data accuracy and data governance.

  • Excellent planning and organizational skills, with an ability to establish a strategic direction and subsequently develop and manage supporting initiatives.

  • Strong overall business acumen with an ability to understand the direction, priorities, and goals of the organization.

  • Strategic and problem solving mindset with developed analytical, process and project management skills.
  • Excellent ETL performance-tuning skills and the ability to analyze and optimize production volumes and batch schedules.
  • Strong experience in building data warehouse solutions.

  • Strong knowledge of data quality, data profiling, and data cleansing techniques.

  • Strong knowledge of SQL server database administration.

  • Excellent listening skills, interpersonal skills, ability to analyze data and test data against business rules.

 

Minimum Qualifications/Experience:

  • 7+ years of experience developing ETL processes with SSIS in a data warehouse environment, plus experience in Visual Studio, 2012, 2014, and 2016, required.

  • 7+ years of experience in a combination of the following required:

    • Developing reporting and analytics solutions with Microsoft SQL Server 2012 or higher version.

    • Building stored procedures, views, functions.

    • Relational and data warehouse database design, optimization and performance with MS SQL.

    • SQL Coding and debugging experience and knowledge of SQL Server database administration.

  • 5+ years of experience building reports with SSRS; including experience migrating SSIS from legacy deployment (Package base) to Project base deployment required.

  • 1+ years of .Net development experience (for scripting purposes with SSIS) required.

  • Experience in developing, publishing, and maintaining all documentation for data models a plus.

  • 3+ years of experience writing .Net services is a plus.

 

Education & Certification:

  • Bachelor’s degree in engineering, information technology, computer science or related field; or an equivalent amount of directly related experience.

 

Candidates will be responsible for following the client's COVID-19 protocols. Please refer to your MATRIX representative for specifics.

About Us

At MATRIX, we expertly match talented professionals with job opportunities to elevate careers. Since 1983, we have placed thousands of professionals at innovative clients across every industry ranging from small startups to Fortune 50 companies. It’s why we’re consistently in the top 25 of all U.S. IT staffing firms and why our consultants rate us well above the industry average, earning us ClearlyRated's Best of Staffing awards year after year. People come to us for a job, and stay with us because of our top-notch consultant care.

MATRIX is and Equal Employment Opportunity employer including disability and veteran and provides reasonable accommodations for all qualified individuals.  Supporting medical or religious documentation will be required where applicable. If you are a qualified individual you may request a reasonable accommodation under the American Disability Act (ADA). If you are a person with a disability needing assistance applying, or at any point in the hiring process, please email us at MATRIX_HR@MatrixRes.com. To ensure a quick response to your request, please use the words “Accommodation request” as the subject line of your email.

For hourly W2 contract roles MATRIX offers a highly competitive benefit package including Medical, Dental, Vision, Life, Disability, HSA, and 401(k) with pre and post-tax options.  Please see MatrixRes.com/Benefits for more information.

For direct hire placement with our clients, benefits would be offered in accordance with that particular client’s offerings. This may include PTO, Medical, Dental, Vision, 401K and other pre and post-tax options.