Data Integration SSIS Engineer

2 weeks ago

Middletown, United States Scientific Games Full time

The Data Integration SSIS Engineer will be responsible for the analysis, design, documentation, development, unit testing, and support of ad hoc data reporting and database object development for a high-volume data warehouse. 

As a Data Integration SSIS Engineer, you will be responsible for the design, development, and maintenance of efficient, repeatable and appropriately scaled solutions in a high-volume Microsoft SQL Server analytic data warehouse. You will define and document reporting solution requirements, both technical and non-technical, and work closely with both business and technical teams to ensure timely, accurate delivery.

As a Data Integration SSIS Engineer, you will provide support and guidance regarding data integration and T-SQL best practices and development standards, and participate in the design, development, and maintenance efforts of the data integration team. 

This role requires excellent communication skills and an ability to work well with customers across a wide range of technical expertise. High proficiency in T-SQL—particularly data modeling, data management and manipulation, code complete programming, and version control—a must.

Essential Job Functions:

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 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

Required Experience:

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

Knowledge, Skills and Abilities:

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


Work Conditions

Scientific Games Corporation and its affiliates (collectively, “SG”) are engaged in highly regulated gaming and lottery businesses. As a result, certain SG employees may, among other things, be required to obtain a gaming or other license(s), undergo background investigations or security checks, or meet certain standards dictated by law, regulation or contracts. In order to ensure SG complies with its regulatory and contractual commitments, as a condition to hiring and continuing to employ its employees, SG requires all of its employees to meet those requirements that are necessary to fulfill their individual roles. As a prerequisite to employment with SG (to the extent permitted by law), you shall be asked to consent to SG conducting a due diligence/background investigation on you.

This job description should not be interpreted as all-inclusive; it is intended to identify major responsibilities and requirements of the job. The employee in this position may be requested to perform other job-related tasks and responsibilities than those stated above. 
 

  • Data Reporting and Integration Engineer

    3 weeks ago

    Middletown, United States Scientific Games Full time

    Scientific Games:Scientific Games is the global leader in lottery games, sports betting and technology, and the partner of choice for government lotteries. From cutting-edge backend systems to exciting entertainment experiences and trailblazing retail and digital solutions, we elevate play every day. We push game designs to the next level and are pioneers in...

  • Data Reporting and Integration Engineer

    2 weeks ago

    Middletown, Pennsylvania, United States Scientific Games Full time

    Scientific Games:Scientific Games is the global leader in lottery games, sports betting and technology, and the partner of choice for government lotteries. From cutting-edge backend systems to exciting entertainment experiences and trailblazing retail and digital solutions, we elevate play every day. We push game designs to the next level and are pioneers in...

  • Data Integrity Specialist

    3 weeks ago

    Middletown, United States Encore Fire Protection Full time

    Overview: Are you a recent college graduate that is confident in your ability to succeed in any role, given the opportunity and the proper training? Do you have the ability to focus on the immediate work that needs to be done while maintaining a systematic and patient approach? If the answer is yes, then this may be the perfect role for you. Encore is an...

  • Data Engineer

    4 weeks ago

    Middletown, United States Virtual Full time

    We are seeking a Data Engineer to help build and support data infrastructure for the virtual data warehouse. The responsibilities of this role include developing jobs to ingest, validate, and verify incoming data from internal and external data sources. The Data Engineer will also be expected to analyze and review pre-existing systems for potential...

  • Data Engineer

    4 weeks ago

    Middletown, United States Virtual Full time

    We are seeking a Data Engineer to help build and support data infrastructure for the virtual data warehouse. The responsibilities of this role include developing jobs to ingest, validate, and verify incoming data from internal and external data sources. The Data Engineer will also be expected to analyze and review pre-existing systems for potential...

  • Data Engineer

    4 weeks ago

    Middletown, United States Vaco Full time

    We are seeking a Data Engineer to help build and support data infrastructure for the virtual data warehouse. The responsibilities of this role include developing jobs to ingest, validate, and verify incoming data from internal and external data sources. The Data Engineer will also be expected to analyze and review pre-existing systems for potential...

  • Embedded Systems Engineer

    4 weeks ago

    Middletown, United States SAIC Full time

    Are you an Embedded Systems Engineer looking to support an exciting Navy mission in our new state-of-the-art labs? Are you seeking long term career growth and a company that values work life balance? Job Summary: SAIC is seeking an organized and motivated Embedded Systems Engineer who will effectively support a fast-paced work environment with the Naval...

  • Data Engineer

    3 weeks ago

    Middletown, United States Vaco Full time

    Job Title: Data Engineer Direct Hire - NO C2C Hybrid near Wethersfield, CT Responsibilities:Develop and maintain data infrastructure for a virtual data warehouse.Ingest, validate, and verify data from internal and external sources.Analyze existing systems for improvements and implement enhancements.Collaborate with data analysts on view and report...

  • Data Engineer

    3 weeks ago

    Middletown, United States Virtual Full time

    Job Title: Data Engineer Direct Hire - NO C2C  Hybrid near Wethersfield, CT  Responsibilities: Develop and maintain data infrastructure for a virtual data warehouse. Ingest, validate, and verify data from internal and external sources. Analyze existing systems for improvements and implement enhancements. Collaborate with data analysts on view and...

  • Software/Hardware Integration Engineer

    2 weeks ago

    Middletown, Rhode Island, United States General Dynamics Mission Systems Full time

    Requires a Bachelor's degree in Software Engineering, or a related Science, Engineering or Mathematics field. Also requires 2 years of job-related experience or a Master's degree. Agile experience preferred.CLEARANCE REQUIREMENTS:Department of Defense Secret security clearance is required at time of hire. Applicants selected will be subject to a U.S....

  • Data Center Mechanical Engineer

    2 weeks ago

    Middletown, United States Edged Full time

    Edged has an exciting opportunity for someone passionate about sustainability and eager to be part of an innovative company that's on a journey to transform the world's data center infrastructure. We are seeking a Data Center Mechanical Engineerto work directly with the CEO and focus on sales support to the Edged Data Centers. We are looking for someone who...

  • Data Center Mechanical Engineer

    2 weeks ago

    Middletown, United States Edged Full time

    Edged has an exciting opportunity for someone passionate about sustainability and eager to be part of an innovative company thats on a journey to transform the worlds data center infrastructure. We are seeking a Data Center Mechanical Engineerto work directly with the CEO and focus on sales support to the Edged Data Centers. We are looking for someone who is...

  • Data Center Mechanical Engineer

    3 weeks ago

    Middletown, United States Edged Full time

    Edged has an exciting opportunity for someone passionate about sustainability and eager to be part of an innovative company that’s on a journey to transform the world’s data center infrastructure. We are seeking a Data Center Mechanical Engineer to work directly with the CEO and focus on sales support to the Edged Data Centers. We are looking for someone...

  • Data Center Mechanical Engineer

    3 weeks ago

    Middletown, United States Edged Full time

    Edged has an exciting opportunity for someone passionate about sustainability and eager to be part of an innovative company that’s on a journey to transform the world’s data center infrastructure. We are seeking a Data Center Mechanical Engineer to work directly with the CEO and focus on sales support to the Edged Data Centers. We are looking for someone...

  • Data Engineer

    3 weeks ago

    Middletown, United States Vaco Full time

    Job Title: Data Engineer Direct Hire - NO C2C Hybrid near Wethersfield, CT Responsibilities: Develop and maintain data infrastructure for a virtual data warehouse. Ingest, validate, and verify data from internal and external sources. Analyze existing systems for improvements and implement enhancements. Collaborate with data analysts on view and report...

  • Data architect with AI

    2 weeks ago

    Middletown, United States Avance Consulting Full time

    About the Job:We are looking for a Data Architect with substantial experience and expertise in Azure, Databricks, and Synapse to join our team. This role requires a deep understanding of data architecture and the ability to develop cutting-edge solutions that drive business success.Qualifications Experience: Minimum of 15+ years of experience in data...

  • Integration Architect

    4 weeks ago

    Middletown, United States Liberty Bank (Connecticut) Full time

    Integration Architect Middletown, CT 06457, USA Req #1543 Wednesday, May 22, 2024 At Liberty, we are proud to integrate our Diversity, Equity and Inclusion (DE&I) throughout all functions and areas of the Bank in order to maximize our impact and exceed goals. We believe that deepening our DE&I strategies in the workplace and communities we serve, creates...

  • Integration Architect

    2 weeks ago

    Middletown, Connecticut, United States Liberty Bank (Connecticut) Full time

    Integration Architect at Liberty BankLocation: Middletown, CT, USAReq #1543At Liberty Bank, we are committed to integrating Diversity, Equity, and Inclusion (DE&I) principles throughout our operations to enhance our impact and exceed objectives.We strongly believe that by enhancing our DE&I strategies within our workplace and the communities we serve, we...

  • Senior Data Architect

    4 weeks ago

    Middletown, United States Avance Consulting Full time

    Job Description Qualifications Experience: Minimum of 15+ years of experience in data architecture, with at least 5 years of hands-on experience with Azure, Databricks, and Synapse. Technical Skills: Proficient in SQL, Python, and/or R. Strong knowledge of data warehousing, ETL processes, and AI/ML model development. Certifications: Relevant certifications...

  • Senior Data Architect

    1 month ago

    Middletown, United States Avance Consulting Full time

    Job DescriptionQualificationsExperience: Minimum of 15+ years of experience in data architecture, with at least 5 years of hands-on experience with Azure, Databricks, and Synapse.Technical Skills: Proficient in SQL, Python, and/or R. Strong knowledge of data warehousing, ETL processes, and AI/ML model development.Certifications: Relevant certifications such...