PeoriaILRecruiter
the smart solution for Peoria jobs

SQL ETL Data Analyst

Company: TEKsystems
Location: Peoria
Posted on: February 14, 2019

Job Description:

Job Summary The Data Analyst is responsible for working with the Company's Data Architect and IT Management to achieve corporate goals and objectives. The Analyst acts as an advocate of data governance and data management best practices to ensure all data is defined and used consistently across all systems. The Data Analyst works within data modeling methodologies best practices, by strategically reviewing and creating data models for enterprise-level applications and systems.The Analyst provides technical support to the research, experimentation, business analysis and use of systems technology including analysis, integration capabilities and database management.

Responsibilities Technologies: SQL (server), T-SQL, Advanced Excel, .NET framework, * Works closely with other IT groups to coordinate current and future plans and activities, including coordination and technical assistance to facilitate specific development projects that involve the computing environment, the coordination of software upgrades and the installation of new products * Recognizes and identifies potential areas where existing policies and procedures require change, or where new ones need to be developed, especially regarding future business expansion * Participates in the development of data centric strategies, solutions, and systems design * Works within standards for naming, describing, governing, managing, modeling, cleansing, enriching, transforming, moving, storing, searching and delivering all data within the enterprise * Serves as a liaison between data consumer representatives and data solution development, integration and governance teams ETL, SSRS, SSIS* Informs and interprets data project sponsors * Must understand how data is, or will be used, and implication on people, processes, products and technology * Model and develop OLAP cubes * Leverage technical expertise of peers and external resources as needed to ensure high-quality, effective solutions are delivered. * Authors technical and functional specifications associated with data Analysis and associated solutions. * Works with the Database Administration team to design tables, queries, and packages to obtain information from and send information to remote databases

Skills * Experience in complete life cycle of design, development and implementation of data warehousing projects including specifically designing enterprise data model; Creating OLAP Cubes, star schemas and data Analysis; logical and physical database design, reporting * Proven Track record of successful data analysis solution delivery and involvement * Working knowledge of fundamentals across data modeling and data analysis * Strong understanding of Dimensional and Star Schema data modeling * Strong understanding of Relational Database concepts including SQL. * Thorough knowledge of data warehouse design and ETL Development methodologies and best practices * Ability to work in a fast-paced, dynamic, team-oriented environment * Ability to work independently * Strong attention to detail * Strong troubleshooting and problem-solving skills * Strong verbal and written communication skills * Experience delivering formal designs to teams of developers. * Experience reviewing requirements with the business users and business analysts. * Experience in presenting and demonstrating solutions to clients * Strong familiarity with metadata management and associated processes * Hands-on knowledge of enterprise repository tools, data modeling tools, data mapping tools, and data profiling tools * Able to prioritize and execute tasks in a fast paced environment Experience, Education, and Certifications * Required Experience: 5 years experience as a data/information analyst including BI/DW technologies * Required Education: Bachelor's Degree, Masters preferred, in Computer Science or related field or 8 years experience and certifications. * Recommended Certifications: MCSE - Business Intelligence, MCITP About TEKsystems: We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. - provided by Dice SQL ETL Data Analyst

Keywords: TEKsystems, Peoria , SQL ETL Data Analyst, IT / Software / Systems , Peoria, Illinois

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Entry Level Software Engineer - Joliet
Description: br Employer is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. br Our Software Engineers design, analyze (more...)
Company: Revature
Location: Joliet
Posted on: 02/20/2019

PHP Developer - PaaS
Description: Minimum Required Skills:PHP, JavaScript, PaaS, Development, fullstackJob Title: PHP DeveloperJob Location: Davenport, IASalary: 75k - 85kRequirements: PHP, MySQL, JavaScript, PaaSBased in Davenport, (more...)
Company: CyberCoders
Location: Davenport
Posted on: 02/21/2019

Junior Software Engineer - Bloomington
Description: Employer is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. Our Software Engineers design, analyze and build (more...)
Company: Revature
Location: Bloomington
Posted on: 02/21/2019


Python Scripting
Description: The Global Security team has heightened standards and increased our workload. In order to effectively manage the high volume and prioritize risk and potential threat levels they need to utilize automate (more...)
Company: TEKsystems
Location: Peoria
Posted on: 02/21/2019

Entry Level Java Developer
Description: br Employer is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. br Our Software Engineers design, analyze (more...)
Company: Revature
Location: Peoria
Posted on: 02/21/2019

Junior Software Developer
Description: br Employer is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. br Our Software Engineers design, analyze (more...)
Company: Revature
Location: Joliet
Posted on: 02/20/2019

College Graduates - Beta Tester
Description: Whether you are new to WayUp or have used it for ages, we're looking
Company: Demo Company
Location: Joliet
Posted on: 02/20/2019

Software Developer (Junior)
Description: Revature is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers.Our Software Engineers design, analyze and build next-gen (more...)
Company: Revature
Location: Moline
Posted on: 02/21/2019

Entry Level Software Engineer - Peoria
Description: Employer is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. Our Software Engineers design, analyze and build (more...)
Company: Revature
Location: Peoria
Posted on: 02/21/2019

Junior Software Developer
Description: br Employer is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. br Our Software Engineers design, analyze (more...)
Company: Revature
Location: Champaign
Posted on: 02/21/2019

Log In or Create An Account

Get the latest Illinois jobs by following @recnetIL on Twitter!

Peoria RSS job feeds