$150K - $200K(Ladders Estimates)
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?
Valid Through: 2019-10-11