Senior Data Architect

Federal Reserve Bank Saint Louis , MO 63150

Posted 4 months ago

The St Louis Fed is one of 12 Reserve Banks serving all or parts of Missouri, Illinois, Indiana, Kentucky, Tennessee, Mississippi and Arkansas with branches in Little Rock, Louisville and Memphis. The St. Louis Fed's most critical functions include: promoting stable prices and economic growth, fostering a sound financial system, providing payment services to financial institutions, supporting the U.S. Treasury's financial operations, and advancing economic education, community development and fair access to credit.

Overview

Treasury Technology Services (TTS) is the embedded information technology organization for the Treasury Division at FRB St. Louis. TTS develops and supports applications ranging from off-the-shelf cash management packages to enterprise-level custom accounting systems. TTS 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 Treasury business lines. The Shared Services team consists of the Project Management Office, the Architecture Office, the Data Management team, and the Dev Ops teams.

TTS is seeking a Senior Data Architect to develop and lead effective and efficient database release deliverables into all development, test and production environments. The Senior Data Architect 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 of the Department of the Treasury. The Senior Data Architect also will 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

  • 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.

  • 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.

  • 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.

Ranked as a Top Workplace, the Federal Reserve Bank of St Louis is committed to building an inclusive workplace, where employees' diversityin age, gender, race and ethnicity, sexual orientation, gender identity or expression, disability, as well as cultural traditions, religion, life experiences, education and socioeconomic backgroundsare recognized as a strength. Embracing our diversity encourages employees to bring their valued perspectives to the table when generating ideas and solving problems, and promotes an environment where innovation and excellence thrive. Learn more about the Bank and its culture; check out our Careers Site.

The Federal Reserve Bank of St Louis is an Equal Opportunity Employer.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Data Architect

Centric Consulting

Posted 3 months ago

VIEW JOBS 8/3/2019 12:00:00 AM 2019-11-01T00:00 Senior Data Architect Job Location: Boston, Charlotte, Chicago, Cincinnati, Cleveland, Columbus, Indianapolis, Louisville, Miami, Seattle, St. Louis Join our team Centric Consulting is not the typical consulting company. We live our core values and bring them with us in all we do for our clients and community. Our core purpose is simple: every day we strive to provide unmatched customer and employee experiences and foster a culture of respect, diversity, and transparency. It's this culture, our people, and delivery that come together to make Centric a trusted advisor to local businesses. Our Data & Analytics practice believes that data can drive business value and performance. But it takes the right people, skills and approach to deliver expected results. That's where you come in! For us, Data and Analytics is more than just a set of technologies. It's about skilled individuals who can align technical capabilities to bring value to a business. What we value the most: people who are dedicated to delivering high quality solutions. It's not enough for things to look good on the surface. They must be built on strong technical foundations. We're looking for a Senior Data Architect to join our growing team. In this role, you will: * Design modern architectures involving traditional BI, cloud, and big data technologies * Help guide full lifecycle D&A solutions for our clients, including requirements analysis, platform selection, technical architecture design, development, testing, and deployment * Profile and analyze source system data * Design extract methodologies * Document all D&A components of an overall solution architecture on large projects * Communicate a detailed ETL architecture and implementation plan to ETL Developers * Implement the solutions you design and mentor other members of the team * Ensure compliance with the architecture through team oversight * Advise on hardware/infrastructure and software needs * Define a strategy for meeting special data requirements * Build client relationships and participate in business development and proposal work * Interview and facilitate meetings with VP level business stakeholders A successful candidate will have the following characteristics: * Strong communication skills * Ability to fully document the D&A solution architecture * Experience working with client leadership to understand their overarching needs and provide data driven results * Proven capacity to design and implement a full lifecycle D&A solution * Strong SQL skills with an understanding of other query languages (MDX, DAX) * Proficiency with multiple ETL tools and data storage environments * Ability to define a backup, archiving, and disaster recovery strategy * Experience working in a cloud-based solution * Proven aptitude for troubleshooting issues across multiple departments and vendors * Ability to adapt in a fast-paced flexible environment * 5+ years of experience around the skills mentioned above What makes Centric different? * Special Culture – Our people make us different. We have highly talented, intelligent individuals across a broad variety of disciplines – who are eager to learn from you and share their own expertise. We embrace fresh perspectives and each other. Don't take our word for it – check us out on Glassdoor, Facebook, Twitter or Instagram to get a glimpse inside what makes us different. * Growth opportunities – As a mid-size firm, there is more flexibility when it comes to career paths. Figure out what you want to do and we'll help you figure out how to get there. * Impact – We think of ourselves as a big company with a small company feel – a local player with global reach that combines business, technology and industry expertise. * Unmatched Experiences – We are allowed to be ourselves here. We are encouraged to be human. It's at the root of who we are as a firm and why we're here. * Innovation – We value passion, determination, perseverance, and innovation. We are inspired because we believe in what we are doing and where we are going. * Passion for the greater good – We are steadfast in our devotion to the communities we serve and in actively promoting employee involvement in community improvement projects. * The Nitty Gritty – Along with the standard health and 401k benefits, we offer self-managed PTO (manage your own work-life balance!), a company paid trip, profit sharing, parental leave and remote working options for our employees. Centric believes the best solutions come from diverse teams. We strive to have an environment where everyone has an opportunity to be successful regardless of their race, color, religion, gender, national origin, ancestry, age, disability, military or veteran status, sexual orientation or gender identity. Centric Consulting Saint Louis MO

Senior Data Architect

Federal Reserve Bank