Data Warehouse Engineer - Austin, United States - Apiture
Description
At Apiture, our mission is to empower financial institutions to know and serve their clients with the care of a traditional community institution at the scale, speed, and efficiency required in today's digital world.
With more than 300 clients throughout the U.S., we deliver comprehensive online and mobile solutions that support banks and credit unions, ranging from small community financial institutions to new, innovative direct banks.
Summary:
Reporting to the Data Engineering Manager, the Data Warehouse Engineer will work closely with the Data Architect to implement the Data Model.
You will be working with a team of highly talented engineers to develop practical, scalable data reporting and analytics solutions.
Location (Wilmington, NC, Austin, TX, Remote):
We have offices in Wilmington, NC and Austin, TX and while some positions are office based, we will also consider remote candidates depending on their time zone.
Responsibilities:
Core tasks will involve writing SQL and some Python to transform raw data from the staging layer into the human readable Data Model.
Review data in source systems, in databases, or APIs to understand how the data comes into the warehouse and which transformations are needed.
Work with the Data Architect to define and enforce data warehouse standards that align with the larger data management guidelines in place.
Work with data analysts and data scientists to define and refine data analysis goals and implement needed changes in the data warehouse.
Identify and pursue opportunities to automate processes and execute validation strategies to maintain high standards of efficiency and data quality.
Build and maintain documentation around data sets, data classes, data flows, transformations, etc.Work with the information security and compliance teams at Apiture to build, monitor, and enforce data cataloging, asset tracking, and privacy rules/metrics.
Provide input and feedback to support continuous improvement in data governance processes.Requirements:
Bachelor's in computer science or equivalent work experience.
4+ years of hands-on experience with coding data transformations in SQL that involved large data sets.
Well-versed with Advanced SQL scripting.
Experience with programming languages:
Python, Java, Scala, etc.
Experience building data pipelines that integrate data from structured and unstructured data sources.
Experience troubleshooting data integrations to visualization platforms like Domo, Tableau or PowerBI.
Hands-on experience with data warehousing platforms like Snowflake, RedShift, or Synapse Analytics.
Excellent understanding of ETL/ELT fundamentals and building efficient data pipelines.
Excellent verbal and written communication skills.
Nice To Have:
Experience with cloud technologies (Strong preference for AWS technologies like Lambda, DMS, etc.)
Experience with Data Management platforms like OneTrust
Experience working with REST APIs, Streaming APIs, or other Data Ingress techniques.
Experience with data engineering and monitoring for ML applications.
Exposure to test-driven development and automated testing frameworks.
#J-18808-Ljbffr