Sr. Consultant- Data Architect in Chicago, IL

$150K - $200K(Ladders Estimates)

Centric Consulting   •  

Chicago, IL 60601

Industry: Technical Services


Not Specified years

Posted 30 days ago

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

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 orInstagram 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

Valid Through: 2019-10-11