IT Analyst II

Company: Simmons Bank
Location: Little Rock
Posted on: January 27, 2023

Job Description:

It's fun to work in a company where people truly BELIEVE in what they're doing!We're committed to bringing passion and customer focus to the business.The IT ETL Developer II serves as a developer for data extract, transform and load processes, primarily for use in the data warehouse or for reporting and analytics. This role is primarily focused on transforming source system input data to a star schema / dimensional model output reliably and at scale. There is a large focus on data quality, deduplication, end-to-end data flows and placing business logic in the appropriate transformation layer.Essential Duties and ResponsibilitiesReceive and comprehend change specifications from Business Analysts, management, and business stakeholders as appropriateDevelop solutions using, primarily SQL, in order to achieve success criteria outlined in specificationsEstimating work complexity and timeframes based on specificationsActively participate in code reviews, retrospectives and demosDo initial testing to verify code functionality and correctness according to specificationsUnderstand ETL solutions tradeoffs for indexing, uniqueness, parallelism, and data dependenciesBe tier 2 support for existing production codeMaintain and update tasks and user stories to update progress in an agile projectAcquires and maintains application expertise through certification and educational programs.Provides user support, including researching issues, determining options for resolution as needed.Complies with bank policies as applicable to this position.Performs other duties and responsibilities as assigned.Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.SkillsAbility to read and comprehend simple instructions, short correspondence and memos.Ability to read and interpret documents such as procedure manuals, general business correspondence and/or journals or government regulations.Ability to write simple-to-business correspondence, routine reports, and procedures.Ability to effectively speak, respond to questions, and present information to the following: one-on-one /small groups, customers, employees, clients, managers, top management, public groups, board of directors, and the general public.Education and/or Experience BS/BA Degree (four year) from an accredited university/college ORTwo to four years of experience as an ETL developerComputer Skills Experienced with SQL and data warehousing, particularly star schema modelsMicrosoft Azure Synapse, Data Factory, SQL Server, SSIS, SSRS, SSAS, or similar toolsExperience with cloud based data warehouse platforms a plusGit source control and Agile methodology preferredPower BI or similar tools highly preferredSome Python experience preferredR, SAS or other relevant experience in data analytics is a plusC#, Java, or similar programming experience a plus MS Office programsCertificates, Licenses, RegistrationsMicrosoft Azure certifications a plusOther Qualifications (including physical requirements)Strong oral and written communication skills.Strong organizational, problem solving, and planning skills with the ability to set priorities.Comfortable interacting with co-workers in virtual environments such as MS Teams or ZoomGeneral banking knowledge preferred.Equal Employment Opportunity Information: Simmons First National Corporation and its subsidiaries are committed to a policy of equal employment with respect to a person's race, color, religion, sex, ancestry, sexual orientation, gender identity, national origin, covered veterans, military status, physical or mental disability or any other legally protected classifications. Simmons First National Corporation and its subsidiaries are committed to Affirmative Action Programs consisting of results-oriented procedures to ensure equal employment opportunities. These programs require positive action in lieu of neutral non-discrimination and merit hiring/performance policies.

Keywords: Simmons Bank, Little Rock , IT Analyst II, Professions , Little Rock, Arkansas