Job description
Data Engineer
Summary:
We are looking for a passionate data-focused individual to join our data management group and help us build out our data warehouse version 2.0. The ideal candidate is someone who has several years of experience working with analytical data infrastructures and are looking to take the next step to help bring a vision to life. The ideal candidate is proficient in designing and building SQL Server Database objects, such as tables, indexes, views, and stored procedures as well as developing integration packages with SSIS or similar tools.
Responsibilities:
- Design, implement, and scale an analytical SQL Server or Azure SQL database infrastructure in line with analytical and business requirements
- Create robust, efficient, and reliable ETL/ELT processes and pipelines
- Facilitate migration from on-prem SQL Server to Azure SQL as needed
- Work closely with data users to develop data marts to facilitate analytical objectives
- Identify, design, and implement internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
- Integrate new data sources into the data warehouse as they become available
- Design a high performing data schema to support dashboards and reporting using tools like Power BI
- Create documentation and data dictionaries to support end-users of data systems
- Design, construct, test, document, and maintain data architectures and processing workflows
- Ongoing development and documentation of data engineering methods and tools to transform data into suitable structures for data users
- Create SSIS packages to automate exporting of reports and data to end users and third party applications
- Work closely with DBA to reformulate existing infrastructure and framework to optimize storage, availability, and usability
Skills & Requirements:
- 3+ years' experience in technology/data roles
- Experience with Microsoft SQL Server and Azure SQL platforms
- Experience with SSIS packages
- Advanced skills in data scripting and database development technologies (SQL, C#, Python, Powershell, Batch)
- Experience with the Microsoft Azure data ecosystem
- Experience in designing, developing, and managing data warehouses or other complex relational databases
- Experience in designing, developing, and managing ETL processes
- Banking/Credit Union experience is a plus
General Electric Credit Union is an Equal Opportunity Employer.
#LI-DNI
PM22
PI216905204
johnandkristie.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, johnandkristie.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, johnandkristie.com is the ideal place to find your next job.