Data Warehouse Developer, Mid Level (Remote)

Data Warehouse Developer, Mid Level (Remote) Join to apply for the Data Warehouse Developer, Mid Level (Remote) role at Jobright.ai Data Warehouse Developer, Mid Level (Remote) 2 days ago Be among the first 25 applicants Join to apply for the Data Warehouse Developer, Mid Level (Remote) role at Jobright.ai Get AI-powered advice on this job and more exclusive features. Jobright is an AI-powered career platform that helps job seekers discover the top opportunities in the US. We are NOT a staffing agency. Jobright does not hire directly for these positions. We connect you with verified openings from employers you can trust. Job Summary: TCM Bank, N.A. is a financial institution based in Tampa, FL, offering a remote opportunity for the role of Data Warehouse Developer. The primary responsibility of this position involves supporting the bank’s backend databases and processes, with a focus on operational support for ETL and data processes related to the bank's data warehouse. Responsibilities: • Day-to-day production support for all the banks’ Database implementations with a primary focus on the data warehouse. This includes supporting all production, development, test and disaster recovery database instances and their related infrastructure. This includes implementing and maintaining database objects and database security. Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc. • Outstanding analytical and problem-solving skills with strong communication skills. • Assist in the implementation data exception processing methodologies and best practices • Support audit and assessment efforts to ensure compliance with any audit or regulatory requirements. • Strong debugging skills with the ability to easily and quickly read and modify existing code. • Monitor and support data import and extraction processes and related ETL with the ability to effectively prioritize and escalate issues. • Create and maintain documentation including procedures, best practices, user guides, schema, physical layout and data flows, object references, data dictionary, repository, entity diagrams, data models, data marts, database instance names. • Must have strong knowledge of data warehouse concepts, and experience developing ETL processes that load into various data repositories. • Assist with the creation, management, and optimization of multiple production databases and processes increasing efficiencies. for greater efficiencies. • Create, manage, and optimize multiple production databases and processes and have demonstrated the ability to troubleshoot software/database issues independently. • Monitor and manage user permissions to ensure data security and integrity. Assist in implementation of role-based access and encryption. • Manage vendor file feeds ensuring timely delivery and completeness and review vendor documentation and notices for changes to feeds to add to data warehouse. • Support managing the vendor interfaces for all issues, upgrades, and patches. • Aid supporting data visualization products for all users to utilize such as Power BI, SSRS, etc. Ensure we put the tools and training in our end user hands to produce their own ad hoc reports as necessary. • Ability to work extended hours when needed. • Other duties as assigned. Qualifications: Required: • Bachelor’s degree in either Computer Science, Management Information Systems, Math, Applied Statistics, Business Analytics or Artificial Intelligence, and 5+ years’ experience in a similar role. • General knowledge of financial services industry; experience with banking, loans, portfolio analysis and credit card processing a plus. • 1-3 years of Informatica IDMC experience including CDQ and MDM. • Knowledge and hands-on experience deploying and supporting Microsoft SQL Server (2012 through 2022), SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), and Power BI. • Strong data analysis and data integration abilities which involves moving, cleansing, and transforming large amount of data between multiple systems. Ensure data quality through creation of audit controls, proactive monitoring, and data cleansing techniques. • Ability to analyze structured and unstructured data comprehensively. • Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports. • Strong problem-solving, time management, and decision-making skills. • Proven experience tuning databases and with query design and optimization both on premise and in the cloud. • Must be a team player and work effectively through collaboration with co-workers by sharing ideas in a constructive and positive manner while maintaining excellent listening skills. • Excellent oral and written communication skills interfacing with audiences of various levels within the bank is a must. • Individual must be able to work independently while a part of larger project team including internal and external resources and is expected to keep management up to date with current written and verbal status reports. Company: TCM strengthens your bank, so you can strengthen your community. Founded in 1998, headquartered in Tampa, Florida, USA, team size 51-200 employees, currently Growth Stage. Seniority level Seniority level Mid-Senior level Employment type Employment type Full-time Job function Industries Software Development Referrals increase your chances of interviewing at Jobright.ai by 2x Inferred from the description for this job Medical insurance Vision insurance 401(k) Get notified when a new job is posted. Sign in to set job alerts for “Data Warehouse Engineer” roles. Tampa, FL $103,800.00-$119,400.00 3 days ago Data Engineer - Growing Maritime Technology Business St. Petersburg, FL $100,000.00-$120,000.00 1 week ago Greater Tampa Bay Area $172,500.00-$227,500.00 4 days ago Staff Engineer - Finance Data Specialist (Remote) Tampa, FL $115,000.00-$260,000.00 3 days ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr