Data Architect

  • location: Morrisville, NC
  • type: Permanent
  • salary: $150,000 per year

job description

Data Architect

job summary:
We have a direct FTE opportunity for a Data Architect with a client of ours in Morrisville, NC.

We are is looking for the right Data Architect that can help grow and mature our application and warehouse data architecture. The candidate must be able to work with both new and existing business application teams, be able to review OLTP designs, define the OLAP objects and support a general reporting/BI solution. This position will work hand in hand with business users, development staff and production operations to ensure business needs are met within development, QA and production guidelines. The candidate must be highly self-motivated, committed to solving business needs efficiently and without disruption of service. This candidate must want to be part of an organization committed to continuous improvement.

ESSENTIAL:

  • Education: Bachelor of Science in related engineering or computer science discipline.
  • General Experience: 7+ years of experience responding to business needs to identify effective solutions, documenting and implementing solutions to enhance the user satisfaction. Experience in working in a team-oriented, collaborative environment.
  • Technical Experience: Minimum of 7 years of experience in application systems development with an emphasis on database design and architecture in heterogeneous information systems and business environments.
  • 5 years of experience in data modeling and integration, data mining, data migration and quality (assessment) management. Heavy emphasis on data warehousing including ETL, star and snowflake schemas, bulk loading.
  • 3-5 years of experience with Microsoft Azure, SQL Server, SQL, TSQL development, SSIS, SSRS, PowerBI
  • Must be familiar with Monitoring and Tuning ETL processes.
  • Knowledge and practical experience in full systems development life cycle and methodologies, emphasis on Agile software process development (e.g. SCRUM) and its impact to the development of enterprise data architecture.
  • strong customer service orientation.
  • Ability to work independently as well as with team members.
  • strong soft skills and capable of communicating complex technical issues to non-technical business personnel.
  • Excellent listening and interpersonal skills.
  • Excellent understanding of organization's goals and objectives.
  • Ability to effectively prioritize and execute tasks in a high-pressure environment.
  • Keen attention to detail.
DESIRED:

  • 1-2 years' experience using ETL tools (such as SSIS, Talend Open Studio).
  • Experience with Team Foundation Server (TFS).
  • Experience with Salesforce.
  • Previous experience working with accounting and financial business functions/software.
  • Previous experience working with title insurance, real estate, mortgage banking business functions/software.
JOB FUNCTIONS:

Primary

  • Develop logical and physical corporate data model and supporting database objects in accordance with data architecture standards for both application development and data warehouse activities.
  • Evolve the data warehouse architecture (e.g., ETL process, EDW, Data Marts); supporting both existing and planned systems and applications.
  • Ensure development efforts are in-line with upcoming development schedules.
  • Enhance and implement corporate best practices with data reporting ETL processes.
  • Publication of information on all corporate reporting data facts, dimensions, business rules, and data element attributes.
  • Document models and ETL processes clearly.
  • Tune performance to ensure our servers and applications are highly scalable.
  • Develop and test enhancements for improving performance, scalability, reliability
  • Develop data quality standards and data security policies.
  • Investigate data quality issues.
Secondary

  • Providing assistance to the business analysts, product managers, systems architects and application development staff on design and integration of data reporting applications.
  • Work with product managers to research and propose solutions to business problems.
  • Participate in the review and selection of tools and technologies to optimize existing data and pave the way for future initiatives.
  • Research emerging technologies and recommend where these might be used to improve Investors Title business systems and technology infrastructure.
  • Mentor and coach business and technical groups in methods, processes and procedures in delivering quality data reporting solutions to end-users.
 
location: Morrisville, North Carolina
job type: Permanent
work hours: 9am to 6pm
education: Bachelors
 
responsibilities:
We are is looking for the right Data Architect that can help grow and mature our application and warehouse data architecture. The candidate must be able to work with both new and existing business application teams, be able to review OLTP designs, define the OLAP objects and support a general reporting/BI solution. This position will work hand in hand with business users, development staff and production operations to ensure business needs are met within development, QA and production guidelines. The candidate must be highly self-motivated, committed to solving business needs efficiently and without disruption of service. This candidate must want to be part of an organization committed to continuous improvement.

ESSENTIAL:

  • Education: Bachelor of Science in related engineering or computer science discipline.
  • General Experience: 7+ years of experience responding to business needs to identify effective solutions, documenting and implementing solutions to enhance the user satisfaction. Experience in working in a team-oriented, collaborative environment.
  • Technical Experience: Minimum of 7 years of experience in application systems development with an emphasis on database design and architecture in heterogeneous information systems and business environments.
  • 5 years of experience in data modeling and integration, data mining, data migration and quality (assessment) management. Heavy emphasis on data warehousing including ETL, star and snowflake schemas, bulk loading.
  • 3-5 years of experience with Microsoft Azure, SQL Server, SQL, TSQL development, SSIS, SSRS, PowerBI
  • Must be familiar with Monitoring and Tuning ETL processes.
  • Knowledge and practical experience in full systems development life cycle and methodologies, emphasis on Agile software process development (e.g. SCRUM) and its impact to the development of enterprise data architecture.
  • strong customer service orientation.
  • Ability to work independently as well as with team members.
  • strong soft skills and capable of communicating complex technical issues to non-technical business personnel.
  • Excellent listening and interpersonal skills.
  • Excellent understanding of organization's goals and objectives.
  • Ability to effectively prioritize and execute tasks in a high-pressure environment.
  • Keen attention to detail.
DESIRED:

  • 1-2 years' experience using ETL tools (such as SSIS, Talend Open Studio).
  • Experience with Team Foundation Server (TFS).
  • Experience with Salesforce.
  • Previous experience working with accounting and financial business functions/software.
  • Previous experience working with title insurance, real estate, mortgage banking business functions/software.
JOB FUNCTIONS:

Primary

  • Develop logical and physical corporate data model and supporting database objects in accordance with data architecture standards for both application development and data warehouse activities.
  • Evolve the data warehouse architecture (e.g., ETL process, EDW, Data Marts); supporting both existing and planned systems and applications.
  • Ensure development efforts are in-line with upcoming development schedules.
  • Enhance and implement corporate best practices with data reporting ETL processes.
  • Publication of information on all corporate reporting data facts, dimensions, business rules, and data element attributes.
  • Document models and ETL processes clearly.
  • Tune performance to ensure our servers and applications are highly scalable.
  • Develop and test enhancements for improving performance, scalability, reliability
  • Develop data quality standards and data security policies.
  • Investigate data quality issues.
Secondary

  • Providing assistance to the business analysts, product managers, systems architects and application development staff on design and integration of data reporting applications.
  • Work with product managers to research and propose solutions to business problems.
  • Participate in the review and selection of tools and technologies to optimize existing data and pave the way for future initiatives.
  • Research emerging technologies and recommend where these might be used to improve Investors Title business systems and technology infrastructure.
  • Mentor and coach business and technical groups in methods, processes and procedures in delivering quality data reporting solutions to end-users.
 
qualifications:
  • Experience level: Experienced
  • Minimum 7 years of experience
  • Education: Bachelors (required)
 
skills:
  • SQL Server (3 years of experience is required)
  • Data Architect (7 years of experience is required)
  • Power BI (2 years of experience is required)
  • ETL (3 years of experience is required)
  • Network Data Mover

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    Database Architect

  • location: Cary, NC
  • job type: Permanent
  • salary: $115,000 - $125,000 per year
  • date posted: 12/21/2020

    Data Mgmt Consultant 3

  • location: Raleigh, NC
  • job type: Temporary
  • salary: $50.92 per hour
  • date posted: 3/1/2021

    Data Mgmt Consultant

  • location: Raleigh, NC
  • job type: Contract
  • salary: $47.22 - $52.22 per hour
  • date posted: 3/1/2021