Fusion HCR
Data Engineer
Fusion HCR, Las Vegas, Nevada, us, 89105
Fusion is in search for a local, Las Vegas professional who is authorized to work in the US without any third parties.This Data Engineer will create and support enterprise class data centric solutions, providing business value from corporate data assets to big queries. The Data Engineer is expected to maintain expertise across application technology stacks like (Microsoft SQL and Google) as well as skills like (SQL, SSIS, Data Marts, DataFlow) in production environments. Full-time role with 401k, bonuses, paid benefits for you and your family and much more! If you meet the qualifications, please apply or reach out to me directly! The primary responsibility of the Data Engineer is to create and support enterprise class data centric solutions, providing business value from corporate data assets. The Data Engineer is expected to maintain expertise across an application technology stack (Microsoft SQL Server BI) as well as a technology domain (Data Management, BI/DW, MDM) and can embrace and leverage new technologies while working effectively with other information technology professionals and business users to ensure that the data solutions are stable, efficient, and responsive to business needs. This person is expected to possess a strong domain knowledge of gaming and hospitality and experience on how data technologies are best implemented to enhance these domains. The Data Engineer must possess strong communication and people skills for assuming Technical Leadership roles for projects, including the ability to effectively present technical information to stakeholders and management. Responsibilities:
Design, build, deliver and support Data Warehouse and ETL structures and, SQL procedures and query solutions.Act as an internal consultant, providing architecture, vision, problem anticipation, and problem solving for the assigned project(s), as well as a Subject Matter Expertise for data and analytic users.Provide subject matter expertise for the data associated with gaming and hospitality systems.Provide senior level application and on-call support for data and integration solutions.Participate and at times lead project teams within an agile environment.Successfully engage in multiple initiatives concurrently, including application and on call support, minor projects, major projects, functional requirements, systems specifications, and subject matter expertise.Prepare clear and concise documentation for delivered solutions and processes, integrating documentation with corporate knowledgebase.In partnership with the Product Management team, provide subject matter expertise for determining business requirements to address business opportunities or issues across business functions for data centric solutions.Maintain familiarity with technological trends and innovations in the data warehousing and data management domains.Interpret and satisfy business needs by building and enhancing systems to transform, cleanse and provision corporate data assets in a governed, secure and high-performance manner.Provide subject matter expertise for data and analytics.Participate in the ongoing Data Management maturation process.Proof of authorization/eligibility to work in the United States.Bachelor's degree or equivalent in relevant disciplineMust be able to obtain and maintain Nevada Gaming Control Board Registration and any other certification or license, as required by law or policy.8 years ETL experience using SQL Server SSIS 2008r2-2016.10 years with T-SQL programming.Must exhibit a high level of mastery of the Microsoft BI Stack, including: SSIS (or something equivalent), SharePoint, PowerPivot, etc.Must understand Relational and Dimensional database modeling.Should be experienced in automated file handling with ETL tools via FTP and other means.Should have administrative experience with SQL Server 2008-2016.Preferred experience with cloud; python scripting languages, and web site operations is a plus.Prefer experience with key concepts of Data Management such as Data Quality and MDM.Experience with Data Preparation for Data Science a plus.Experience with Big Data, Advanced Analytic techniques and Real Time data a plus.Must be willing and capable of adopting new technologies and paradigms such as Big Data technologies (Hadoop, hive, etc.), event-based analytics, etc.Must be able to adhere to SOPs and methodologies and be willing to improve them when necessary.Must have strong organizational skills, customer service focus, attention to detail, and process orientation.Must be willing to be 24 x 7 on-call support.
Design, build, deliver and support Data Warehouse and ETL structures and, SQL procedures and query solutions.Act as an internal consultant, providing architecture, vision, problem anticipation, and problem solving for the assigned project(s), as well as a Subject Matter Expertise for data and analytic users.Provide subject matter expertise for the data associated with gaming and hospitality systems.Provide senior level application and on-call support for data and integration solutions.Participate and at times lead project teams within an agile environment.Successfully engage in multiple initiatives concurrently, including application and on call support, minor projects, major projects, functional requirements, systems specifications, and subject matter expertise.Prepare clear and concise documentation for delivered solutions and processes, integrating documentation with corporate knowledgebase.In partnership with the Product Management team, provide subject matter expertise for determining business requirements to address business opportunities or issues across business functions for data centric solutions.Maintain familiarity with technological trends and innovations in the data warehousing and data management domains.Interpret and satisfy business needs by building and enhancing systems to transform, cleanse and provision corporate data assets in a governed, secure and high-performance manner.Provide subject matter expertise for data and analytics.Participate in the ongoing Data Management maturation process.Proof of authorization/eligibility to work in the United States.Bachelor's degree or equivalent in relevant disciplineMust be able to obtain and maintain Nevada Gaming Control Board Registration and any other certification or license, as required by law or policy.8 years ETL experience using SQL Server SSIS 2008r2-2016.10 years with T-SQL programming.Must exhibit a high level of mastery of the Microsoft BI Stack, including: SSIS (or something equivalent), SharePoint, PowerPivot, etc.Must understand Relational and Dimensional database modeling.Should be experienced in automated file handling with ETL tools via FTP and other means.Should have administrative experience with SQL Server 2008-2016.Preferred experience with cloud; python scripting languages, and web site operations is a plus.Prefer experience with key concepts of Data Management such as Data Quality and MDM.Experience with Data Preparation for Data Science a plus.Experience with Big Data, Advanced Analytic techniques and Real Time data a plus.Must be willing and capable of adopting new technologies and paradigms such as Big Data technologies (Hadoop, hive, etc.), event-based analytics, etc.Must be able to adhere to SOPs and methodologies and be willing to improve them when necessary.Must have strong organizational skills, customer service focus, attention to detail, and process orientation.Must be willing to be 24 x 7 on-call support.