SENIOR DATA WAREHOUSE DEVELOPER

TCM Bank is in Tampa, FL. This is a remote opportunity. If living outside of the area, travel expectations would be at least 4 times (overnight travel) per year. Qualified candidates located in the states where we do business will be considered: AL, AZ, DC, FL, GA, IA, KY, MA, MI, MD, MO, MN, NE, NC, OH, OR, PA, SC, TX, & VA.

SUMMARY:

The Senior Data Warehouse Developer is responsible for the production day-to-day support for all the banks backend databases and processes. This position functions as the bank's senior database developer. The responsibilities related to this role include operational support for all ETL and data processes, internal and external to various TCM Bank systems and applications including the bank's data warehouse. The database developer will lead strategy with various teams, including Application Development and System Engineering to design stable and reliable databases and ETL processes. The senior developer is expected to respond to support requests and help resolve reported issues with junior staff members. Additional responsibilities include leading the strategy related to database development and supporting activities related to end-to-end data life cycle management. The database developer is responsible for ensuring technical documentation standards and best practices are applied and available across back-end processes. The Senior Data Warehouse Developer will be responsible for designing, developing, and maintaining data integration solutions using Informatica Data Management Cloud (IDMC). You will work closely with data architects, analysts, and other IT professionals to ensure data accuracy, integrity, and accessibility. The position will be responsible for SDLC documentation such as unit test results, data dictionaries, and data flow diagrams. Responsibilities will require the database developer to recommend changes to the current database ecosystem including establishing best practices and standards in coordination with other team members. The Senior DW Developer provides functional direction to junior development staff members while developing our automated testing processes for all data environments including support of Dev/Test/DR.

DUTIES & RESPONSIBILITIES:

Day-to-day production support for all the banks' Microsoft SQL database implementations with a primary focus on the data warehouse.

Mentorship and functional direction to junior developers on staff.

Ability to guide design, testing, and migration-related to database activities using Informatica IDMC, MS Azure, and MS SQL Server.

Knowledgeable in code deployment across multiple domains.

Experience improving legacy processes with current best practices and procedures.

Experience writing users stories and extracting requirements from across various internal and external customers.

Outstanding analytical and problem-solving skills with strong communication skills.

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.

Must have strong knowledge of data warehouse concepts, and experience developing ETL processes that load into various data repositories.

Lead 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.

Optimize and enhance the performance of data workflows and mappings.

Implement and manage data quality and data governance policies.

Troubleshoot and resolve data integration issues.

Document data integration processes and workflows.

Ensure data accuracy, integrity, and security in all data integration activities.

Manage vendor file feeds ensuring timely delivery and completeness and review vendor documentation and notices for changes to feeds to add to data warehouse.

Aid in supporting data visualization products for all users to utilize such as Power BI, Tableau, Domo, etc. Ensure we put the tools and training in our end user hands to produce their own ad hoc reports as necessary.

Experience with Data Governance and Master Data Management implementations.

Ability to work extended hours when needed.

Other duties as assigned.

QUALIFICATIONS:

• Bachelor's degree in either Computer Science, Management Information Systems, Math, Applied Statistics, Business Analytics or Artificial Intelligence, and at least 5-7 years' experience in a similar role.
• General knowledge of financial services industry; experience with banking, loans, portfolio analysis and credit card processing a plus.
• 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.
• 5+ years of experience in data integration using Informatica IDMC.
• MCSA SQL Certifications (Data Management and Analytics, SQL Server Database Administration, Business Applications/BI Development tracks.) a plus.
• 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.
• Experience working in Azure 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.
• Minimum 3 years' experience with Agile and User Story definition

TCM Bank, N.A. embraces the diversity of its applicants and employees and is proud to be an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, veteran status or any other characteristic protected by applicable law.

The actual compensation offered to the candidate will be finalized at the offer and may be above or below the posted range due to skill level, experience, industry-specific knowledge, education/certifications, etc. The offer rate represents one component of TCM Bank's total compensation package. Employees will also receive several benefits as listed below. Other compensation for this position may include bonus eligibility in the TCM Bank Annual Bonus Plan.

Benefits Offered:

• Competitive medical, dental and vision benefits
• 401(k) and Roth 401(k) retirement plans with company match
• Flexible spending accounts (medical and dependent care)
• Company-paid parental leave
• Educational assistance
• Company-paid continuing education credits
• Paid employee assistance program
• 12 paid holidays, including discretionary early closures before holidays and company events. (More than your average company!)
• Multiple time-off options for vacation, volunteering, or caring for yourself or loved ones.

TCM Bank is in Tampa, FL. This is a remote opportunity. If living outside of the area, travel expectations would be at least 4 times (overnight travel) per year. Qualified candidates located in the states where we do business will be considered: AL, AZ, DC, FL, GA, IA, KY, MA, MI, MD, MO, MN, NE, NC, OH, OR, PA, SC, TX, & VA or will be willing to relocate (TCM does not provide relocation).

No sponsorships available for this position.

Principals Only. No Agencies Please.