Sr. Consultant-Data Architect

Centric Consulting Charlotte , NC 28201

Posted 2 months ago

Sr. Consultant- 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 Sr. Consultant- Data Architect to join our growing team.

Sr. Consultant-Data Architect, Centric Consulting LLC, Dayton, OH.

Work to build new solutions to enhance and extend enterprise systems. Design software application architecture for the processing and subsequent analysis of data. Design, develop, test, and implement new software and software upgrades.

Gather analytics requirements from business, create required data models/solutions and communicate results effectively to management. Conduct analysis of source system data for the purpose of transformation for data capture in a warehouse or mart environment and preparation for required analytics. Perform advanced solution optimization using existing mastery of SQL Server, Microsoft BI stack (SSIS, SSRS and SSAS) and Power BI.

Design and implement data warehouses, data marts and databases using best practice concepts related to data warehouse design and implementation, data architecture, ETL development, data quality processes, data modeling, logical and physical database design. Design and implement reporting and visualizations for structured and semi-structured data using Power BI, SSRS or any other similar tool. Use requirements to extract, transform, load data and then visualize it using a variety of tools.

Build Microsoft Analysis Services multidimensional and tabular OLAP cubes to create KPIs for business analysis. Build ETL packages to fetch data from different sources and integrate into data warehouse or mart environment. Design and develop data cleansing routines.

Create SQL queries to verify data quality. Publish dashboards and data sources as well as manage access and user security. Perform database maintenance and administration.

Perform production support and process monitoring to ensure business continuity. Provide technical review of other developers' work. Requires Bachelors degree in computer science, engineering, or related technical field plus 60 months of experience in data warehousing, business intelligence, and cloud and data analytics.

Also requires demonstrated skill with Informatica, SSIS, Tableau, Power BI, SSAS, Azure, and AWS. This position reports to corporate headquarters in Dayton OH and requires travel to various unanticipated worksites throughout the U.S. for short and long-term assignments. Apply to melissa.scheidt@centricconsulting.com

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.

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.



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
Sr Data Architect

Bank Of America Corporation

Posted 1 week ago

VIEW JOBS 9/7/2019 12:00:00 AM 2019-12-06T00:00 Job Description: Role Summary: Senior leader with analytic and reporting experience as well as significant time building and maintaining business relationships across various levels of the organization all leading to a proven track record of building new and innovative capabilities from the ground up. Role will focus on the following items: * Define and manage the central reporting function for EDM DQT including the creation of an ad hoc self service capability * Drive the creation and evolution of the EDM Coverage Story and associated messaging including the data driven outcomes used to describe risk and confidence for the Enterprise * Identify, monitor and communicate testing triggers through the analysis of the coverage work * Restart and drive the Control Tower Effort including integration with ETR and Op Ex Role will be an IC role with one or more team members available to assist – given the nature of it being an IC role, much of the heavy lifting will be completed by the role themselves Skills: * Communication skills (written and verbal) – Telling a story with metrics, teasing out what matters and how to tell clearly communicate a compelling message * Executive presence - Focus on the outcome/so what of the reporting – will need significant experience pulling out what matters and communicating it to various audiences * Collaboration – work with partners (often executive level) to get the data we need to support Control Tower/Coverage efforts * Self Starter – Able to build something quickly and iteratively from the ground up * Project Management – Able to create and drive against a clear plan * Reporting and analytics – self explanatory * Database design – Review and evolve our data model * Control Partner Experience – Able to build and defend solutions to various control partners * Deliver predictive capabilities leveraging change, time series and incident vs testing data Role Details: Reporting Service Function: * Identify data needed from Quality Center (QC) to support reporting and analytics process * Clean up QC data * Establish Data Quality (DQ) reporting / QC views to maintain DQ * Refresh SQL data model and Tableau capability * Inventory existing reporting needs and future reporting needs from Teams and Coverage Function (reporting aspect serves as a service provider, ie: report requirements in, report, etc out) – develop roadmap and plan to implement * Test Mgmt Reporting * Includes Process Metrics – how do we know we are effectively executing? * Executive Summary Reporting * Coverage Reporting * Risk and Frequency Approach for prioritizing domains of data to test – This includes running it on an annual basis * Monthly Reporting Metrics (Scorecards) * Quarterly Domain Health Profile Metrics * Refine current reporting capability to support current and future reports * Establish self-service filtering capability for ad hoc requests * Create documentation of all data, metrics, reports and data controls Coverage Story: * Create and execution against a coverage story/ visualization strategy including: * Expand Test Data: * EDMG controls test coverage – Provides full EDM Test Coverage View * Data Quality test results – Enables comparison of Test Results to EDIM Incidents * Control Tower data – Provides Enterprise Test Coverage View * Delineate Test volume and Test Source vs Target– Provides more comprehensive view of testing * Time evaluation capability – Enables Test effectiveness to be compared to EDIM incidents * Increase filtering capabilities (ADS, Services, PDSC, etc.) – Enables focus to be targeted * Service coverage (Info Quality, Frontier, NDM, etc.) – Shows coverage of Data Quality Services * Change Data – Enables the potential for predictive analytics and aids targeting testing * Align with Op Ex efforts * Craft coverage story for EDM Testing (Domains vs AIT, direct vs indirect testing, etc) for sharing with PwC, FRB, SOD, etc Posting Date: 09/05/2019 Location: Charlotte, NC, International Trade Center, 200 N College St, - United States Travel: No Full / Part-time: Full time Hours Per Week: 40 Shift: 1st shift Bank Of America Corporation Charlotte NC

Sr. Consultant-Data Architect

Centric Consulting