Search Jobs

Browse the latest opportunities at TPI.

IT Developer Senior

Atlanta, GA

Posted: 09/09/2022 Job Number: 17732600

Job Description

Additional Notes from Manager:
As a reminder, this position is remote and worker can be located in the 5 state footprint (GA, FL, AL, SC, TN)

The data architect role fills two work needs:
1. Project support data model, data flows, completes design document for data solution (usually designs a data mart or expands data in data warehouse). Using the requirements, hands over documents for the programmers to code solution.
2. Future state leads into the cloud, doing POC with new technology, providing initial implementation with the new software, and coaching data developers into cloud. For example, we have selected Informatica EDC (data catalog), Information Axon (data governance), ADF (orchestrate data movement to data lake), and data bricks for ELT/ETL/Data Analytics. Looking for people experienced in one or more of these technologies. Future items - What tools for data virtualization? What tools for cloud databases/warehouse? Tools to support Real Time processing in the cloud. The person would be involved in POCs to choose the best selection within the parameters Synovus sets.

Duties
Job Summary: Designs, develops, maintains and improves data structures, queries, reporting solutions, extract-transform-load (ETL) processes and data warehousing strategies for all mission critical projects. Serves as a subject matter expert in data and databases. Mentors junior staff members and works with other developers and production DBAs to ensure scalable, efficient and optimized solutions. Provides best practice guidance to the development team with regard to database design and usage, including code reviews and data validation. Works closely with customers, management, business analysts, and team members to understand business requirements that drive the analysis and design of quality technical solutions. Ensures solutions are aligned with business and IT strategies and comply with the organization's architectural standards. May leads a team of developers on more complex projects.Job Duties and Responsibilities: Designs, develops, tests and troubleshoots applicable software packages that implement complex ETL processes in accordance with business requirements and service level agreements. Works with application developers, business partners, management and Data Warehouse team. Extends the data model to house additional structures as needed to meet applicable regulatory requirements. Designs data warehouse or data mart fact tables, aggregate tables, and dimensions. Delivers quality data integration projects, standards, best practices and data dictionary. Develops ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds. Develops and documents systems, processes and logic required to expose existing data sets in the warehouse to end users for reporting and analytical purposes. Monitors ETL applications for performance and improvement opportunities. Ensures quality, consistency and security of company data and data warehouse systems. Troubleshoots and diagnoses complex software problems. Conducts packaging, release and change management. Communicates open items and issues to key stakeholders, including management, development teams, and business areas. Reviews requirements, architecture and design components of ongoing and upcoming Tier 1 projects. Conducts and manages code review sessions between developers to review applicable software programs and packages, stored procedures, and views. Keeps informed of tools, techniques and components utilized in the industry through research and applies this knowledge to system(s) being developed. Mentors less experienced database / ETL developers. Each team member is expected to be aware of risk within their functional area. This includes observing all policies, procedures, laws, regulations and risk limits specific to their role. Additionally, they should raise and report known or suspected violations to the appropriate Company authority in a timely fashion. Performs other related duties as required. The information on this description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job. Synovus is an Equal Opportunity Employer supporting diversity in the workplace.
Skills
Required Knowledge, Skills, & Abilities: Knowledge of data modeling and designing databases. Good knowledge of metadata, and using/managing metadata. Solid understanding of systems development life cycle (SDLC), software best practices and development methodologies. Understanding of building data warehouses for analytical and business intelligence solutions. Understanding of business solutions that the data warehouse serves. Strong technologist with excellent data analysis and ETL skills. Strong architecture/design/development skills. Strong analytical and diagnostic skills. Skill in developing and organizing high-quality documentation. Skill and flexibility managing multiple projects with large volumes of data in a rapidly changing environment. Skill troubleshooting issues in a multi-tier environment. Skill working with both business team members and technologists. Leadership skills with an emphasis on teamwork. Preferred Knowledge, Skills, & Abilities: Microsoft Certified Solutions Expert (MCSE), Microsoft Certified Database Administrator (MCDBA), Certified Data Management Professional (CDMP) or a Business Intelligence designation. Knowledge of various databases such as MySQL and Oracle. Knowledge of scripting languages such as C# and VB.Net. Knowledge of Master Data Management (MDM) and Governance. Knowledge of System DBA. Banking industry experience.
Education
Minimum Education: Bachelor's Degree in Computer Science, Information Systems, or related field or equivalent relevant experience. Minimum Experience: Six years of experience designing, developing, testing, and implementing ETL solutions utilizing applicable software products and experience working with data warehousing and data marts OR an equivalent combination of education and experience.

==============================================================

Description Requisition Status: Pending Status Reason: Pending Sourcing Reason: Addition Reason Detail: Temp to Perm Manager: Department: Data Management: 6805013 Job Category: IT - Technology Job Code: TEC258: IT Developer Senior Job Title: IT Developer Senior Keywords: Number of Positions: 1 Remaining Positions: 1 Duties: Skills: Education: Languages: English Read Write Speak Attachments: TEC258 job Description.Docx Skills and Experience Skills: Required
  • APPLICATION SUPPORT
  • ARCHITECTURE
  • BUSINESS INTELLIGENCE
  • C#
  • DATA ANALYSIS
Additional
  • DATA MANAGEMENT
  • DATA MODELING
  • DATA STRUCTURES
  • DATA WAREHOUSE
  • DATA WAREHOUSES
  • DATA WAREHOUSING
  • DATABASES
  • DOCUMENTATION
  • ETL
  • GOVERNANCE
  • INTEGRATION
  • INVENTORY
  • LEADERSHIP SKILLS
  • LIFE CYCLE
  • MAINTENANCE
  • MASTER DATA MANAGEMENT
  • MDM
  • METADATA
  • MYSQL
  • OBJECT-ORIENTED
  • ORACLE
  • PROJECT MANAGEMENT
  • SCRIPTING
  • SDLC
  • SYSTEMS DEVELOPMENT
  • TECHNICAL DOCUMENTATION
  • TECHNICAL REQUIREMENTS
  • TECHNICAL SPECIFICATIONS
  • UNIT TESTS
  • VB.NET
  • BUSINESS REQUIREMENTS
  • DATABASE
  • INTEGRATOR
  • MARKETING ANALYSIS
Languages: English( Speak, Read, Write ) Minimum Degree Required: Also Preferred: Location Client Location Country: United States State/Province: Georgia City: Atlanta Address: 3400 Overton Park Dr SE, GA336 * Overton (FL01) Postal Code: 30339 Work Location Same as Client Location Other Client Location Country: United States State/Province: Georgia City: Remote Address: Remote, GA470 * Remote - GA - S Postal Code: 30334 Work Completed Offsite Schedule Start Date: 09/19/2022 Hours Per Week: 40.00 Est. End Date: 12/19/2022 Hours Per Day: 8.00 Schedule Notes: 8: 30am-5: 30pm EST occasional weekends as needed Days Per Week: 5.00 Financials Department: Data Management: 6805013 Max Rate: $80.53 Rate Application: Per Hour Currency: USD Supplier FLSA Classification: N/A H-1B: No Contact Information MSP Contact: Oldag, Ashley Additional Contact: MSP Phone: 6787139097 Additional Phone: HR Contact: Additional Email: Supplier Notes Contacts Edit Requisition Custom Fields Dates of Interest Date Created: 09/08/2022 Date Closed: Date Pending: 09/08/2022 Date Cancelled:

Meet Your Recruiter

Lavi Dixit

Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.