SQL ETL Data Analyst
Posted on: February 14, 2019
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
Didn't find what you're looking for? Search again!