Mystic Lake Casino Hotel | Hiring | Data Analyst (ETL) – Hybrid | Prior Lake, MN | BigDataKB.com | 2022-09-29

0
61

Job Location: Prior Lake, MN

The ideal candidate will analyze business requirements and defines data requirements from upstream systems. Translates requirements into technical specifications, data models, data mapping, and transform rules. Leads extensive QA/UAT in partnership with the Business Intelligence (BI) team. Develops the ETL (Extract/Transform/Load) code needed to gather data from the appropriate source systems into the BI databases using the Microsoft suite of business intelligence tools. Work with support teams to understand existing systems and to help troubleshoot, optimize and tune the ETL process as needed.

Responsibilities

  • Takes ownership of minor modeling and ETL tasks.
  • Knowledge of internal business processes as they relate to the applications and their data.
  • Act in a supporting role on larger analytics projects and data warehouse maintenance efforts.
  • Maintain accurate system documentation, procedures, logical and physical diagrams.
  • Collects and reviews system data for troubleshooting purposes.
  • Design, develop, and tests all types of data movement or modifications requested and approved by management using SSIS. Production support, maintenance and monitoring of existing ETL processes. Execute performance tuning of ETL loads.
  • Works with some supervision from the Data Architect and ETL Developer.
  • Learns new technologies through the use of self-study materials and mentoring.
  • Ability to articulate technical information clearly and simply to users or other non-technical personnel.
  • Provide support for 24×7 business operations including on-call. Follow incident, problem, and change & release management processes.
  • Multi-task and work in cross functional team.

Basic Requirements

  • Any combination of post secondary education in Business, Information Technology, or related IT field experience to equal 4 years.
  • Must possess excellent interpersonal skills and sound judgment. Strong analytic and troubleshooting skills required.
  • Understand basic ETL concepts of data flow, data enrichment, data consolidation, change data capture and transformation.
  • Experience with SQL language and database concepts (indexing, keys, referential integrity, and table metadata).
  • Experience with Microsoft SQL Server Management Studio, SSIS, SSRS, SSAS.
  • Knowledge and understanding of data warehousing and business intelligence concepts.

Apply Here

Submit CV To All Data Science Job Consultants Across United States For Free

🔍 Explore All Related ITSM Jobs Below! 🚀 ✅ Select your preferred "Job Category" in the Job Category Filter 🎯 🔎 Hit "Search" to find matching jobs 🔥 ➕ Click the "+" icon that appears just before the company name to see the Job Detail & Apply Link 📝💼

LEAVE A REPLY

Please enter your comment!
Please enter your name here