Job Description
Job Description
This position is not remote, and will require being on property
Position Summary
Reporting to the Director of BI and EDW, the Azure Data Engineer is responsible for successful delivery of data and information to the entire organization.
This role acts as an acknowledged expert on Azure data engineering resources with knowledge of data warehousing concepts and will be responsible for the design, development, implementation and support of the Enterprise Data Warehouse pipelines, dataflows and data delivery.
Essential Functions
- Translate business requirements into secure and performant Azure solutions
- Design and develop ETL / ELT processes to support population of the Enterprise Data Warehouse and general data delivery needs
- Develop modern Data Warehouse, Data Lake, data storage, and ETL / ELT solutions in Azure
- Support implemented Azure solutions by monitoring pipelines, addressing user questions concerning data integrity, monitoring cost and performance and communicating functional and technical issues
- Evolve a scalable, cost-effective Azure data environment and assist with developing a strategic roadmap for modern Data Warehousing
- Establish and ensure compliance to database standards through the entire development life cycle
- Mentors DW / BI staff and provides feedback and guidance
- Other job-related duties as assigned
- Meet all compliance requirements
Knowledge, Skills & Abilities
- Strong analytical skills to solve and model complex business requirements
- Experience and understanding of data warehouse design concepts, Azure data engineering resources and SQL including complex stored procedures.
- Experience developing Azure Data Warehouse and Data Lake solutions using Azure Data Factory, Data Flows and Azure Notebooks.
- Experience writing scripts and notebooks for Spark (Python, R, SQL) that access and manipulate files and data from storage accounts, SQL Servers, and API’s
- Proficient with Azure Synapse and or MS Fabric
- Knowledge of RDBMS concepts and stored procedures
- Self-starter, with great analytical and communication skills
- Must be a team player
- Some experience with Microsoft SQL Server BI stack (Database, SSIS, SSAS, SSRS) a plus
Education and Experience
- Bachelor’s Degree in Computer Science or other technical discipline or equivalent combination of education and experience
- 5+ years of experience in a complex data warehouse environment
- Hands-on Data warehousing project experience and experience in full life cycle Business Intelligence development, implementation, tuning and support
- Experience extracting reporting / analytics requirements from business users
Required Certification / License
- Ability to obtain, and maintain a Ohio Casino Control Commission Gaming License, Ohio Casino Control Commission Sports Gaming License, and a Ohio Lottery Commission Gaming License
Sr. Data Warehouse Engineer, Azure
Design, build, and maintain data warehouses using Azure technologies such as Azure SQL Data Warehouse, Azure Data Factory, Azure Databricks, and Azure Storage. Deep technical knowledge and hands-on experience with Azure SQL Data Warehouse, Azure Data Factory, Azure Databricks, and Azure Storage. Des...
Senior Software Engineer
Bachelor's Degree Computer Science, Information Technology (Software Development track) or Engineering with a concentration in programming AND 10 years relevant work experience preferred, Master's Degree Computer Science, Information Technology (Software Development track) or Engineering with a con...
Lead Data Domain Architect
Experience with software design approaches such as Domain Driven Design and modern data architecture approaches such as data fabric, data mesh or data marketplaces. Proven experience with data governance and quality frameworks including data standards, data catalogs, and master data management. Inte...
Cloud Engineer
Requirements:Strong knowledge of Google Cloud Platform or another major cloud providerWorking knowledge of command-line tools in Cloud and Linux environments. Strong knowledge of Google Cloud Platform or another major cloud providerWorking knowledge of command-line tools in Cloud and Linux environme...
Senior Data Scientist
Constantly look for useful attributes to expand our core data assets from various data sources, like US census bureau, and validate the usefulness of the new data. You will have the opportunity to train yourself, with help from more senior team members, on using various data tools to analyze various...
Sr. Data Engineer
Analyze, design and develop enterprise data and information architecture deliverables, focusing on data as an asset for the enterprise. Collaborate with team members to improve the company’s engineering tools, systems and procedures, and data security. Understand and follow reusable standards, desig...
Sr. Cloud Engineer (Google Cloud Platform, Azure, Tool Access & Authentication) - Remote
Cloud Engineer will be a Technical Subject Matter Expert / Individual Contributor accountable for expertise and solution concept creation in the areas of cloud identity access management and authentication methods. Create and propose cloud engineering solution concepts related to cloud tool enableme...
Sr Data Architect - GCP, AbInitio, Tableau - Cleveland, OH
Experience Architecting Enterprise Data Platforms for large Enterprises. Very strong, hands-on expertise in Data Supply Chain, Data Pipelines. Leading and Guiding the team on all aspects of Data Engineering, Data Analytics. Evolved point of view and wide ranging experience in Data Governance,. ...
Cloud Security Engineer
Flexjet, the second-largest private aviation company, is currently seeking a qualified candidate to join our IT department as a Cloud Security Engineer at our state-of-the-art facility in Cleveland, Ohio or Dallas, Texas office. As a Cloud Security Engineer, you will work as part of a team to help e...
Consultant, Technology Engineer (Azure Infrastructure Engineer)
This technical, hands-on, role is responsible for the definition and implementation of security policies, enforcement, and automation as a team member of the Cloud Security Engineering team. Participates with the Cloud Security Engineering team by defining, implementing, or maturing cloud controls t...