Data Engineer 2

1 month ago


San Antonio, Texas, United States CPS Energy Full time

We are engineers, high line workers, power plant managers, accountants, electricians, project coordinators, risk analysts, customer service operators, community representatives, safety and security specialists, communicators, human resources partners, information technology technicians and much, much more.

We are 3,500 people committed to enhancing the lives of the communities we serve. Together, we are powering the growth and success of our community progress every day

Position Summary

Provide the development and automation of computing processes on premise and in the cloud environment using cloud base architecture to detect, predict and respond to opportunities in business operations.

Working with a variety of disparate datasets that encompass many disciplines and business units including weather, transmission and distribution grid infrastructure, power generation, gas delivery, commercial market operations, safety and security and customer engagement.

Strive to transform and implement true business integration, leveraging top-notch data integration best practices.

Merging and securing data in a way that reduces the cost to maintain and increases the utilization of enterprise-wide data as an asset.

Developing business intelligence.

Grade: 14

Qualifications may warrant placement in a different job level.

Deadline :
Open until filled

Tasks and Responsibilities

  • Design, Develop, and unit test new or existing ETL/Data Integration solutions to meet business requirements.
  • Daily production support for Enterprise Data Warehouse including jobs in Alteryx, Hadoop and Oracle PL/SQL; and be flexible to manage high severity incidents/problem resolution.
  • Develop data integration and ETL/ELT workflows in the cloud environment using Cloud base architecture (Azure).
  • Participate in troubleshooting and resolving data integration issues such as data quality.
  • Deliver increased productivity and effectiveness through rapid delivery of high quality applications.
  • Provide work estimates and communicate status of assignments.
  • Assist in QA efforts on tasks by providing input for test cases and supporting test case execution.
  • Analyze transaction errors, troubleshoot issues in the software, develop bug fixes, involved in performance tuning efforts.
  • Develop Alteryx workflows and complex Oracle PL/SQL programs for the Data Warehouse.
  • Responsible for selecting and using DevOps tools for continuous integration, builds, and monitoring of solutions.
  • May provide input to area budget.
  • Makes some independent decisions and recommendations which affect the section, department and/or division.
  • Performs other duties as assigned.
Minimum Skills
Minimum Knowledge and Abilities

Experience in a data integration role.
Experience using Apache Spark, Nifi and/or Kafka.
Experience using Python.
Experience integrating enterprise software using ETL modules.
Knowledge of data architecture, structures and principles with the ability to critique data and system designs.

Ability to design, create and/or modify data processes that meet key timelines while conforming to predefined specifications utilizing the Informatica and/or Mulesoft platform.

Understanding of big data technologies and platforms (Hadoop, Spark, MapReduce, Hive, HBase, MongoDB).
Ability to integrate data from Web services in XML, JSON, flat file format, SOAP.
Knowledge of core concepts of RESTful API Modeling Language (RAML 1.0) and designing with MuleSoft solutions.

Preferred Qualifications

  • Relevant Certifications
  • Experience in API Management
  • Proficiency with the following databases/technologies: Mulesoft Anypoint Studio, Informatica PowerCenter, Oracle RDMS, PL/SQL, MySQL
  • Knowledge of Test Driven Development (TDD)
  • Familiarity with Cloud base architecture
  • Experience with data analysis & model prototyping using Spark/Python/SQL and common data science tools & libraries (e.
g. NumPy, Pandas, scikit-learn, TensorFlow)

  • Experience in a technology organization
Competencies

Demonstrating Initiative
Communicates Effectively
Using Computers and Technology
Driving for Results

Minimum Education

Bachelor's degree in Computer Science, Engineering, or related field from an accredited university.

Required Certifications
Working Environment

Indoor work, operating computer, manual dexterity, talking, hearing, repetitive motion. Use of personal computing equipment, telephone, multi- functioning printer and calculator.
Ability to travel to and from meetings, training sessions or other business related events. Ability to perform after- hours and weekend work as required.

Physical Demands


Exerting up to 10 pounds of force occasionally, and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body.

Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.
CPS Energy does not discriminate against applicants or employees.

CPS Energy is committed to providing equal opportunity in all of its employment practices, including selection, hiring, promotion, transfers and compensation, to all qualified applicants and employees without regard to race, religion, color, sex, sexual orientation, gender identity, national origin, citizenship status, veteran status, pregnancy, age, disability, genetic information or any other protected status.

CPS Energy will comply with all laws and regulations.
  • Data Engineer 2

    2 months ago


    San Antonio, Texas, United States CPS Energy Full time

    Position SummaryProvide the development and automation of computing processes on premise and in the cloud environment using cloud base architecture to detect, predict and respond to opportunities in business operations. Working with a variety of disparate datasets that encompass many disciplines and business units including weather, transmission and...


  • San Antonio, Texas, United States Arctic Wolf Full time

    Ready to further your career in the fast-paced, exciting world of cyber security?Our mission is simple: End Cyber Risk. We're looking for a Concierge Security Analyst to be part of making this happen.The Concierge Security Engineer 2 (CSE2) is a key member of the Concierge Security Team that delivers world-class Arctic Wolf security services.The CSE2 role...


  • San Antonio, Texas, United States H-E-B Full time

    About the RoleH-E-B is seeking a highly skilled Software Engineer II to join our Digital Technology team. As a key member of our team, you will be responsible for designing, developing, and implementing scalable and secure data platforms using hybrid cloud services.Key ResponsibilitiesImplement infrastructure as code, security, and CI/CD for data...

  • Data Engineer

    3 days ago


    San Antonio, Texas, United States DEF Definitive Logic Full time

    Secure Our Nation, Ignite Your FutureAt DEF Definitive Logic, we're seeking a highly motivated and career-oriented Data Engineer to join our team. As a Data Engineer, you'll play a critical role in designing and implementing complex data integration solutions using Salesforce and ServiceNow.Key Responsibilities:Research and integrate design strategies,...


  • San Antonio, Texas, United States Southwest Research Institute Full time

    About the RoleWe are seeking a highly motivated and detail-oriented individual to join our team as a Student Data Analyst. As a key member of our research team, you will be responsible for supporting the design, analysis, and documentation of digital electronics hardware for space applications.Key ResponsibilitiesCollaborate with our team of engineers to...


  • San Antonio, Texas, United States nVent Full time

    About the RolenVent is seeking a highly skilled Field Application Engineer to join our team. As a key member of our organization, you will play a critical role in advancing our success and driving innovation in the electrical solutions space.Key ResponsibilitiesDomain Authority: Serve as a subject matter expert for nVent Data Solutions products, providing...


  • San Antonio, Texas, United States M.C. Dean, Inc. Full time

    Job SummaryM.C. Dean, Inc. is seeking a highly skilled Data Center-Facilities Engineering Operation and Maintenance Manager to lead and oversee the engineering and maintenance operations of our facilities. This role demands a strong technical understanding, leadership capabilities, and a commitment to excellence in maintaining the facility's infrastructure...

  • Principal Engineer

    2 weeks ago


    San Antonio, Texas, United States Southwest Research Institute Full time

    Position: Senior Research Engineer - Data SystemsAbout Us:At Southwest Research Institute, our Propulsion & Energy Machinery Section is dedicated to pioneering engineering research and development in the realms of industrial heat and power, liquid propulsion, gas turbine combustion, and air-breathing propulsion technologies. Our innovations are driving a...


  • San Antonio, Texas, United States I. C. Thomasson Associates Full time

    About I.C. Thomasson AssociatesWelcome to I.C. Thomasson Associates, a leading engineering consulting firm that specializes in creating innovative solutions for a smarter, healthier, and more sustainable world.As a dynamic and employee-owned company, we pride ourselves on our collaborative environment and commitment to teamwork. Our firm has been recognized...


  • San Antonio, Texas, United States Expedite Technology Solutions Full time

    Job Summary:Expedite Technology Solutions is seeking a highly skilled Data Visualization Engineer to lead the effort in gathering, analyzing, and modeling client data to develop business insights and improve decision-making.Key Responsibilities:Requirements gathering, design, development, and implementation of Power BI reports for a big data application.Lead...


  • San Antonio, Texas, United States KForce Full time

    Job SummaryKforce is seeking a highly skilled Director of Data Analytics to lead multifaceted data projects, ensuring timely delivery within budget and quality standards.Key ResponsibilitiesStrategic project management, including leadership in both project management and data development.Building dimensional tables, performing ETL processes, and using Power...


  • San Antonio, Texas, United States Southwest Research Institute Full time

    About Us:The Materials Science and Failure Analysis Section is dedicated to crafting solutions for intricate materials challenges through both experimental and analytical techniques. We cater to a diverse range of government and commercial clients across various technical domains. Key Responsibilities:Deliver laboratory assistance for research initiatives...


  • San Antonio, Texas, United States Southwest Research Institute Full time

    About Us:The Materials Science and Failure Analysis Section is dedicated to developing innovative solutions for intricate materials challenges through both experimental and analytical techniques. We cater to a diverse range of government and commercial clients across various technical domains. Key Responsibilities:Provide laboratory assistance for research...


  • San Antonio, Texas, United States Southwest Research Institute Full time

    About Us:The Materials Science and Failure Analysis Section specializes in addressing intricate materials challenges through both experimental and analytical techniques. We collaborate with various governmental and commercial entities across multiple technical domains.Key Responsibilities:Support laboratory initiatives for research endeavors focused on...

  • Data Analyst

    1 day ago


    San Antonio, Texas, United States Addison Group Full time

    **Job Summary:**We are seeking a highly skilled Data Analyst to join our team at Addison Group. As a Data Analyst, you will play a critical role in supporting our business operations by analyzing and interpreting complex data sets.**Key Responsibilities:****Data Analysis:**Analyze and interpret large data sets to identify trends and patternsDevelop and...


  • San Antonio, Texas, United States Southwest Research Institute Full time

    About Us:The Materials Science and Failure Analysis Section specializes in creating solutions for intricate materials challenges through both experimental and analytical approaches. We cater to a diverse range of governmental and commercial clients across various technical domains. Key Responsibilities:Support laboratory initiatives for research endeavors...


  • San Antonio, Texas, United States Southwest Research Institute Full time

    About the RoleThe Heavy Duty Engine Laboratory at Southwest Research Institute is responsible for conducting emissions and fuel efficiency measurements of Diesel, Gasoline, and alternative fueled engines. We support OEMs, Tier 1 Suppliers, and Government agencies in evaluating future powertrain systems.Key ResponsibilitiesAssist with the department and...

  • Research Engineer

    5 days ago


    San Antonio, Texas, United States Southwest Research Institute Full time

    About Our TeamThe Powertrain Engineering Engine Certification team at Southwest Research Institute supports various clean air initiatives that benefit mankind by providing engine development certification services for medium and heavy-duty engines for on-highway, nonroad, marine, and various other engine types.Key ObjectivesSupport global clean air...


  • San Antonio, Texas, United States Intertek Full time

    Job SummaryWe are seeking a highly skilled Test Stand Design Engineer to join our team at Intertek. As a key member of our Transportation Technologies team, you will be responsible for designing and installing test stands and facility systems, providing technical support, and managing projects to ensure client satisfaction and business profitability.Key...


  • San Antonio, Texas, United States I. C. Thomasson Associates Full time

    Welcome to I.C. Thomasson Associates, a premier engineering consulting firm dedicated to shaping a smarter, healthier, and more sustainable world. Recognized as one of the Best Places to Work, we embody a collaborative spirit that fosters teamwork and innovation, both within our organization and in our client engagements. If you are passionate about...