1 day old

Data Architect

Kansas City, MO 64105
  • Job Code

Position Summary:

  • The Data Architect's primary focus will be to lead the development of BI Enterprise Data Warehouse
  • Architecture, strategies and solution recommendations.
  • Candidate will work closely with Enterprise Architects, Business Analyst, DBA's, Data Integration specialists and the BI development team and be responsible for reviewing conceptual, logical, physical database models, technical design and the development and maintenance of flexible data architectures and data flows that support various BI initiatives across the company.
  • Additionally, the position provides instruction, training and guidance to internal and external team members to ensure effective and efficient use of system resources.
  • The Data Architect will be responsible for shaping data strategies and governance practices, while leading teams through the SDLC development tasks and implementation of data designs and data related practices.
  • This position will be expected to effectively represent the BI team on a variety of complex enterprise IT working groups lead and/or facilitate discussions within the BI team to define the appropriate data architecture that meets functional requirements.
  • This position will work with Business Analysts, Business Intelligence Analysts, DBAs, other Data
  • Integration Architects, executives and business stakeholders to deploy single source reporting for identified and prioritized critical data assets.
  • Technical aptitude, programming skills, effective oral and written communication skills, and the ability to present insights in a clear concise and effective manner are critical and necessary in this role.

Knowledge & Skills:

  • Demonstrated on-the-job experience with the full software development life-cycle, beginning with requirement's gathering through development and testing to deployment.
  • Conduct analysis in support of department and business line strategic efforts. Assess and determine governance, stewardship, and frameworks for managing MDM.
  • Align data architecture plans with business objectives and ensure data models are consistent and interoperable across the larger enterprise activities.
  • Translate business and functional requirements into detailed data system architecture and design, including capacity planning.
  • Provide direction, review work results and serve as a knowledge SME for Integration Applications. Lead design of high-level conceptual, logical and physical models that facilitate a cross-system/cross functional view of data requirements.
  • Develop ETL/conversion specifications and data mapping documents for database/system upgrades, system replacement initiatives, and integration efforts related to data warehouse development.
  • Develop scalable data models for data acquisition, storage, access, and analysis required for structured, semi-structured and unstructured data.
  • Champions enterprise data management best practices. Provides consultation during strategic planning, prioritization, and implementation projects.
  • Establish, monitor and optimize a reliable and repeatable process for migrating objects and artifacts between Development, UAT and Production environments. Strive to automate the migration process as much as practically possible.
  • Coordinate resolution of production system/server issues. On-call rotation is required to support 24/7 environment and is also expected to be able to work outside business hours to support corporate needs.
  • Produce database/architecture documentation and technical specifications for the ETL programs to implement data warehouse and BI platforms.


  • Bachelor's degree or Master's degree in Computer Science or Information technology from an
  • accredited college or university and IT and IT certifications, preferably related to architectural design
  • 8+ years in Data Warehousing Development and hands on experience as an ETL developer.
  • 3+ years Data architecture experience, with expertise in both transactional and data warehousing.
  • 3+ years of work experience in planning and executing data migrations, release and environment management including, data storage capacity estimation, metadata and version control.
  • DB2, SQL server, Azure DWH, Azure Data Lake experience from the development perspective (database and BI Solution), etc.
  • Experience in various architecture disciplines like Application, Data, Security and Infrastructure.
  • Ability to analyze existing database schema DDL/instance layout and determine impacts migrating to new target schema/instance environment.
  • Strong experience in Business Process Modeling (BPM), provide guidance to offshore developers and lead design activities.
  • Ability to troubleshoot performance and configuration related issues including connectivity issues due to firewalls, load balancers etc. Proactively monitor the overall system and take appropriate actions to improve the overall health of the system.
  • Ability to handle multiple projects, deadlines, and tasks in an environment of changing priorities and limited resources.
  • Must demonstrate strong written and oral communication skills.


Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Architect

Randstad Technologies
Kansas City, MO 64105

Share this job

Data Architect

Randstad Technologies
Kansas City, MO

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast