Tech Ops Engineer
Scientific Games
- USA
- Permanent
- Full-time
- Work closely with other engineering teams to integrate databases with other applications.
- Responsible for design, development, and implementation of database applications and solutions for managing and integrating data between operational systems, data repositories, and reporting and analytical applications. This includes but is not limited to ETL, stored procedures, views, and functions.
- Recommends and provide guidance regarding data integration and database development, T-SQL best practices, and standards to development team members and data analysts as needed
- Creates technical design documentation which includes current and future functionality, database objects affected, specifications, and flows/diagrams to detail the proposed database and/or data integration implementation.
- Translates stakeholder’s requirements into common language that can be adopted for the use in design and development of data integration processes.
- Provides support for investigating and troubleshooting production issues.
- Participate in the establishment of group standards and processes.
- Works continually on improving performance of source code using industry standard methodologies.
- Collaborates with stakeholders and development team members to define reporting requirements and deadlines.
- Work closely with business and technical teams to translate business knowledge needs into technical development requirements.
- Responsible for design, development, and implementation of ad hoc analytic reporting.
- 5+ years of experience in data-centric industry role (ETL, DBA, etc).
- 5+ years of experience with SQL databases (MS SQL Server preferred, but not required).
- 3+ years data integration technologies and principles.
- Bachelor's degree from four-year college or university (in Information Technology or Computer Science preferred), plus three to five years related experience and/or training; or equivalent combination of education and experience
- Working knowledge and experience in online transactional (OLTP) processing and analytical processing (OLAP) databases and schemas
- Advanced knowledge of T-SQL including complex SQL queries and best practices
- Experience integrating data from structured and unstructured formats
- Strong analytical skills and attention to detail
- Excellent communication skills, both verbal and written
- Experience performing self-directed work in a team environment
- Proven ability to learn complex data systems
- Bachelor's degree from four-year college or university (in Information Technology or Computer Science preferred), plus three to five years related experience and/or training; or equivalent combination of education and experience.