Apply on Employer Site

Wright-Patt Credit Union · 1 day ago

Data Warehouse Developer I

Beavercreek, OH

Full-time

Onsite

Senior Level

5+ years exp

Wright-Patt Credit Union is seeking a Data Warehouse Developer I to analyze, design, develop, implement, and maintain software solutions for their Enterprise Data Warehouse and Business Intelligence needs. The role involves development, production support, project engagement, and documentation related to data management and reporting solutions.

FinanceFinancial ServicesNon Profit

Responsibilities

Design and create appropriate database objects (tables, indexes, etc.)

Develop T-SQL scripts, Stored Procedures, SSIS Packages, SQL Server Agent Jobs, etc. to support ETL functions

Incorporate data from multiple sources to provide a 'single source of truth' for the Credit Union’s data needs

Develop SSRS and/or Power BI reports on an ongoing or ad hoc basis

Work with business units and IT to understand requirements and develop reports to meet those needs

Provide 24x7x365 support when required (including after-hours/weekends)

Troubleshoot database-related defects/issues and provide consultation to IT teams

Assist developers and DBAs with database-related activities (e.g. setup/install of DBs)

Aid in the monitoring and performance tuning of databases, queries, and ETL extracts

Interface with 3rd party vendors for technical support (as needed)

Inform Daily IT Status call of any processing issues

Actively work with the Project Management Office to meet data needs inherent in project delivery

Respond quickly and accurately with any project related requests for information from Project Managers and Business Analysts

Escalate issues appropriately and in a timely manner

Document system design, processes, and procedures as appropriate

Maintain source code in WPCU provided repository

Ensures proper policies, procedures, risk mitigation activities, and operating controls are followed. Reports gaps in policies, procedures, and operating controls to leadership to ensure member impact and risk is mitigated

Qualification

MS SQL ServerSSISSSRSDatabase Lifecycle ManagementT-SQLBusiness Intelligence Developer StudioIndependenceInterpersonal skillsCommunication skillsTeamwork

Required

Bachelor's Degree in Information Technology, Computer Science, or a related field; an Associate's Degree in a computer related field and 7 years of IT experience will be considered

Minimum of 5 years of experience using MS SQL Server databases in a Developer or DBA role in a medium-to-large organization

Minimum of 2 years of hands-on experience using the Business Intelligence Developer Studio, including Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), and Microsoft SQL Server Reporting Services (SSRS)

Experience in the entire Database Lifecycle Management (DLM) including SQL source code control, schema compares, data compares, and SQL testing

Hands-on experience writing transaction SQL scripts and stored procedures for ETL needs

Experience with data management and data processing flowcharting techniques

Strong interpersonal skills and excellent communication skills (both written and verbal)

Ability to work independently with minimal supervision, as well as in a team environment