Randstad Sr. Data Architect in Saint Louis, Missouri

Sr. Data Architect

job details:

  • location:Saint Louis, MO

  • salary:$56 - $68 per hour

  • date posted:Wednesday, June 13, 2018

  • job type:Contract

  • industry:Finance and Insurance

  • reference:626900

job description

Sr. Data Architect

Sr. Data Architect

  • St. Louis, MO (Downtown)

  • 12 mo Contract

  • US Citizenship Required

  • Non-Exempt

  • Market Rate

Overview:

Company/Division develops and supports applications ranging from off-the-shelf packages to enterprise-level custom accounting systems. Division is made up of two organizations: Engineering and Shared Services. The Engineering team consists of several application development teams, each of which are dedicated to specific business lines. The Shared Services team consists of the Project Management Office, the Architecture Office, the Data Management team, and the Dev Ops teams.

Seeking a Senior Data Architect Contractor to develop and lead effective and efficient database release deliverables into all development, test and production environments. The Senior Data Architect Contractor will assure the database release, along with its associated software, satisfies the business requirements of our customer for systems that are critical to the infrastructure. The Senior Data Architect Contractor will also design well coded database objects such as stored procedures, Oracle packages, functions, and views, as well as database PL/SQL scripts used for data migration, fixes, transformations and test data generation; and, prepares, tests and maintains database release code throughout the project's Software Development Life Cycle.

Responsibilities:

  • Ability to create and implement complex data models for OLTP, Data Warehouse, logical Data warehouse applications.

  • Current knowledge building data models, business data layer using data federation and master data management.

  • Translate business functions into conceptual, logical and physical data models.

  • Build data mappings for new systems and data migration projects. Implement subject area of business functions and publish the models for collaborative development.

  • Analyze databases in various aspects such as data integrity, technical debt, data model, security (DAR), availability and performance.

  • Work with stake holders to create a technology roadmap to remediate the findings.

  • Lead strategic initiatives to design and implement analytics platforms.

  • Provide thought leadership in centralized and distributed data engineering solutions. Capture and share best practices across data systems.

  • Design and implement distributed database solutions in AWS such as Elastic Map Reduce (EMR), Redshift, Kinesis, Amazon Machine Learning, Amazon Web Services Lambda, Data Pipeline, AWS Informatica, Casandra, S3, and the Relational Database Service (RDS).

  • Develop strategies, plan and work with technical team to implement DAR (Data Security at rest). Publish best practices and data dictionary.

  • Incubate and influence innovative technologies to solve complex database and data processing issues that would revolutionize the enterprise data management and add value to business. Must have hands-on experience in key technologies, methodologies and run POC's independently.

  • Self-directed supporting the data needs of multiple teams, systems and products.

  • Manage expectations of software delivery with stake holders, resource planning, effort estimation and drive the data projects for technically sound solutions. Build networking and relationships

Qualifications:

  • Bachelor's degree with a major or specialized courses in Information Technology or commensurate experience.

  • 10+ years related experience.

  • Experience designing and delivering cross functional data analytics and reporting.

  • Experience implementing MDM, data lake in large enterprise.

  • Experience implementing big data solutions using cloud technologies.

  • Experience with AWS cloud services: EC2, S3, RDS, Redshift.

  • Must be resourceful and creative in identifying ways to mitigate issues and risks to avoid project delays.

  • Extremely effective written and verbal communication skills.

  • Travel (5%).

  • US Citizen Required.