Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Data Architect

Expired Job

Donnelley Financial Solutions Chicago , IL 60602

Posted 4 months ago

Title: Data Architect

Job ID: 155

Location:

Chicago, IL, US

Category: Information Technology

Description:

Donnelley Financial Solutions (NYSE: DFIN) provides software and services that enable clients to communicate with confidence in a complex regulatory environment. With 3,500 employees in 61 locations across 18 countries, we provide thousands of clients globally with innovative tools for content creation, management and distribution, as well as data analytics and multi-lingual translations services. Leveraging advanced technology, deep-domain expertise and 24/7 support, we deliver cost-effective solutions to meet the evolving needs of our clients.

Company Intro

Donnelley Financial Solutions (NYSE: DFIN) provides software and services that enable clients to communicate with confidence in a complex regulatory environment. With 3,500 employees in 61 locations across 18 countries, we provide thousands of clients globally with innovative tools for content creation, management and distribution, as well as data analytics and multi-lingual translations services. Leveraging advanced technology, deep-domain expertise and 24/7 support, we deliver cost-effective solutions to meet the evolving needs of our client.

Position Summary

Donnelley Financial Solutions is seeking a Data Architect to join our Data and Analytics Team. The ideal candidate is a self-starter who is effective working with large development teams in a highly collaborative environment.

Position Description

  • Develop, maintain, test, and troubleshoot data solutions, including Database Development, ETL / Data Migration Development, and Big Data Development.

  • Collaborate with technical and non-technical resources to solve issues and develop new functionality.

  • Participate in Requirements Gathering and Analysis meetings with Team Members, Internal Customers, and Stakeholders.

  • Mentors and assists Data Engineers and Data Developers as needed.

Required Skills

  • Database development skills (SQL, T-SQL)

  • Data Analysis

  • Requirements Analysis

  • Big Data Technologies including (Azure Data Factory, Spark, NoSQL, Hadoop, HDInsight, Big Data Architecture) a plus

  • SQL Server 2012 or later, SQL Azure, SSIS

  • SQL Server 2016 Experience is a plus

  • Architect and manage teams of developers performing Data Integration, Data Quality management, Data Blending

  • Knowledge of structured programming languages: Example C# or Python

  • SQL Performance Tuning and Optimization

  • Troubleshooting of complex data solutions

  • 6+ Years experience leading on-short and off-shore teams of developers

  • Experience working on large teams a plus.

  • Experience with Project Planning and more specifically sprint planning a plus.

  • 6+ Years development and leadership experience with SQL and TSQL.

  • 6+ Years development and leadership experience using ETL / Data Integration Tools (SSIS preferred).

  • 7+ Years of experience performing Data Analysis / Data Profiling.

  • 7+ Years of requirements analysis experience.

  • 7+ Years of experience working in environments with formal SDLC (Software Development Life Cycle) experience.

  • 3 + years of experience working on teams utilizing Agile Methodologies.

  • 6+ Years authoring technical and functional documentation.

  • Bachelor's Degree in Computer Science, Information Technology or relevant experience

It is the policy of Donnelley Financial Solutions to select, place and manage all its employees without discrimination based on race, color, national origin, gender, age, religion, actual or perceived disability, veteran's status, actual or perceived sexual orientation, genetic information or any other protected status.

If you are a qualified individual with a disability or a disabled veteran, you have the right to request a reasonable accommodation if you are unable or limited in your ability to use or access jobs.dfsco.com as a result of your disability. You can request a reasonable accommodation by sending an email to AccommodationRequests@dfsco.com.


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
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
Data Architect

Nextcapital

Posted 1 week ago

VIEW JOBS 12/5/2018 12:00:00 AM 2019-03-05T00:00 ABOUT US NextCapital's Digital Advice Platform is a holistic service built around the investor, providing world-class advice at an affordable price. It is the only service that offers integrated planning, advice, and portfolio management capabilities. Because of the breadth of advice services, NextCapital serves a broad range of investor types, from the low-balance beginning investor to the sophisticated high net worth investor. Learn more about NextCapital at www.themuse.com/companies/nextcapital JOIN OUR TEAM We're looking for an organized and highly motivated Data Architect to join our team. You will work closely with our designers and developers to ensure that the database structures for the NextCapital Digital Advice Platform are correctly designed for current and future needs. You'll also work with our Data/Analytics team to plan, build, and maintain the reporting and analytics platform - this will be used both internally for strategic decision-making by NextCapital leadership and externally through an interface for partners to access relevant data, both operational and strategic. The ideal candidate is results-driven, able to break down complex problems, uses prototypes to quickly test out possible solutions, and can learn new tools, languages, and DBMS's on the fly. WHAT YOU'LL DO Serve as the NextCapital Data Architect, to provide oversight to our data activities. * Review and modify the security/permissions implementation * Implement review processes for schema changes * Analyze loads and performance, and suggest solutions to bottlenecks * Manage Data Architecture and Catalog for Snowflake Computing, MySQL, MS SQL Server, MongoDB, and other databases. * Establish and contribute to documentation * Provide guidance for new application features * Suggest and work collaboratively to effect architectural improvements * Design and work collaboratively to implement Metadata Management, Master Data Management and data element lineage traceability * Refactor and work collaboratively to implement overall Data Management Lifecycle - Master Audit trail, backups, long term retention, DR/BC * Consult on XML and JSON schema Architecture/Designs * For the reporting/analytics platform: * Review and provide feedback for our full and incremental load processes, which include the use of a third-party ETL/ELT/CDC utilities (Talend, Amazon Glue/Kinesis, FiveTran, and Streamsets are being evaluated), as well as custom solutions. * Build/Update schemas within Snowflake Computing based on reporting, analytics, and data science requirements * Provide assistance for creating models/objects within our Data Visualization software (Looker) * Monitor and improve performance of pipelines, capacity loads and query times Requirements WHO WE'RE LOOKING FOR * You have broad general database data architecture and implementation skills and 7+ years of data warehouse/database administration and architecture experience * Recent experience with ETL/ELT, Data Warehousing, and Reporting/Analytics * Solid DBA skills * Superior SQL skills * Superior scripting/coding skills * Demonstrable ability to learn and become productive on new platforms and tools quickly. * You are a team player, able to work with coworkers in the product and technology areas, as well as upper management. * You have strong communication skills and can convince people to buy into your vision * You are constantly learning, driven to understand the data content of what other product areas produce, and give your opinion on how best to expose it to internal and external audiences. * Plus: You are adept at figuring out how to adjust solutions to meet an expected timeline. Benefits WHY YOU'LL LOVE IT * Disrupt the financial advice industry by bringing affordable, easy to use financial tools to millions of people * Enjoy a laid back work environment & learn from FinTech's best & brightest * Receive great benefits like stock options, 401(k) match, and employer contributions to health, dental and vision coverage * Join a fast growing company where you can have a real impact on the company's future * Participate in company-sponsored cornhole leagues, company outings, wine tastings, fantasy football leagues, hackathons and other fun events * Enjoy a newly built out office on Michigan Avenue with a view of Millennium Park and Lake Michigan. * Sip locally roasted coffee, kombucha, or craft beer at your modular sitting/standing desk * Participate in women in tech events and service days at local organizations * Enjoy monthly, company wide, guided meditation sessions Nextcapital Chicago IL

Data Architect

Expired Job

Donnelley Financial Solutions