Data Engineer – Remote Jobs San Antonio
Job Description
Job Type: Data Engineer from home
Location: San Antonio work from home
Company: Lytx
Would you like to advance in your Data Engineering profession further? Do you take pleasure in creating data pipelines that allow for important business insights?
If you love influencing technological decisions through engagement with multi-functional teams and have strong expertise in data streaming, warehousing, ETL, Hadoop, Spark, etc., you’ll know you’re a good fit for this position!As a member of the Client Intelligence team, you will assist the migration to new cloud-based technologies while collaborating with business owners and technology partners to maintain the data warehouses, ETL procedures, and reporting systems that are currently in place. A candidate that welcomes and appreciates learning new technologies is needed for this post, which gives the exciting opportunity to assist the team in developing the futuredata platform for the Lytx company.Our engineers have the technical flexibility to experiment and drive ongoing platform and process improvement since they are enthusiastic about the newest developments in the data engineering field!Candidates should apply if they are data engineers that appreciate working with cross-functional teams and thrive in a fast-paced, collaborative atmosphere.
Responsibilities:
- Create and manage pipelines for streaming data used in client reporting.
- Create T-SQL to load, extract, and transform data from source systems.
- SSIS packages and SQL Server stored procedures should be analyzed, designed, developed, tested, deployed, and maintained.
- Oversee the administration and infrastructure of reporting tools.
- Take part in database system design reviews to learn more about data technologies and Lytx’s implementation of them.
- Work together on significant projects with senior engineers and cross-functional teams.
- Help with the conversion of old code and reports to SQL Server and/or Snowflake cloud-based solutions.
- As a Data Engineering representative, support development teams and take part in estimate, backlog trimming, and other Agile tasks.
- Take part in the development, testing, and research of the next generation of data engine platforms.
- Create and direct a long-term plan for persistent data storage and data pipelines.
- Process reporting and data flow modeling
- As allocated, carry out additional tasks.
Requirements:
What You Require
- A bachelor’s degree in information systems, computer science, analytics, or a similar field of study and experience
- three or more years of expertise in the field creating software or providing OLTP or data warehousing solutions for large-scale businesses.
- three or more years of experience working as a developer, primarily designing relational databases
- demonstrated proficiency with MS SQL Server or another RDBMS
- a demonstrated ability to develop in T-SQL and ETL, including SQL Server Integration Services (SSIS)
- Knowledge of concepts or background in database performance
- familiarity with automated testing, continuous integration, and agile software development
- Outstanding analytical, conceptual, and problem-solving abilities
- experience in a fast-growing company with a track record of producing high-caliber technological results.
- strong attention to detail and organizing abilities
- Self-driven, involved, and responsible
Good to Have:
- familiarity with BI platforms and reporting systems like Tableau, SSRS, and others
- basic familiarity with streaming data solutions such as RedShift, Spark, Kafka, Nifi, Flink, SSIS, or others
- Cloud data warehouse systems (Snowflake, AWS recommended) that employ NoSQL databases like DynamoDB and MongoDB
- Basic familiarity with Python
Advantages:
- Insurance for health, dental, and vision care
- Flexible Spending Accounts for Health Savings Accounts
- 401(k) and 401(k) match for telehealth
- AD&D and life insurance
- Temporary and Permanent Disability
- PTO or FTO
- Program for Employee Well-Being
- Each year, there are 11 paid holidays and 1 included holiday.
- Volunteer Leave of Absence
- Program for Employee Referrals
- Program for Education Reimbursement
- Program for Employee Appreciation and Recognition
- Extra incentive and elective benefit schemes