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 firstname.lastname@example.org
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.