Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Data Modeler

Expired Job

Bb&T Winston , FL 33811

Posted 2 months ago

Specific information related to the position is outlined below. To apply, click on the button above.

You will be required to create an account (or sign in with an existing account). Your account will provide you access to your application information. Need Help?

Should you have a disability and need assistance with the application process, please request a reasonable accommodation by emailing BB&T Accessibility or by calling 866-362-6451. This email inbox is monitored for reasonable accommodation requests only. Any other correspondence will not receive a response.

Regular or Temporary:

Regular

Language Fluency: English (Required)

Work Shift:
1st shift (United States of America)

Please review the following job description:

Establish and maintain an adaptable infrastructure to facilitate the access, definition, management, security and integrity of data across the Bank. Work at an advanced level of all phases of data management.

Essential Duties and Responsibilities:

Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.
1.Work with data analysts, application programmers, business user personnel and project managers to gather data requirements to support creating logical and physical data models for applications and Business Intelligence (BI) reporting, including those with specialized or complex requirements.
2.Develop, manage and update data models, including physical and logical models of the data warehouse, data mart and staging area.
3.Lead design reviews of data models and other relevant metadata to ensure consistency, quality, accuracy and integrity. Promote and enforce adherence to corporate information architectures, policies and standards.
4.Consult with Database Administrators concerning the creation of physical data schema from the physical model by making recommendations, designing referential integrity, and ensuring business requirements are satisfied.
5.Generate Data Definition Language (DDL) scripts for the update of database objects so that the database reflects the structure represented by the physical model.
6.Consult with application programmers and database users concerning how to use the database as designed and how to navigate efficiently within the database.
7.Serve as a project leader on complex internally assigned projects. Analyze, evaluate and make recommendations concerning proposed data analysis products, as well as products to facilitate the extraction, transformation, loading and reporting of data.
8.Develop, document and adhere to Enterprise Data Office (EDO) standards for the use, control, creation and maintenance of metadata. Assist with the planning and implementation of the corporate metadata architecture. Develop and maintain documentation and training materials for the organization's metadata facilities and their use.
9.Support data architecture requirements for multiple development teams, advising teams on data model requirements and impact analysis.

Required Skills and Competencies:

The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
1.Bachelor's degree in computer science-related field, or equivalent education and related training
2.Ten years of experience, including six years of hands-on experience working as a data analyst and two years of application programming and analysis experience
3.Experience in database design and data modeling for medium to large projects
4.Knowledgeable in all areas of data management and application development lifecycle; possess solid understanding of metadata systems and metadata architecture; knowledgeable in modeling for data warehouses, including dimensional modeling; possess knowledge and understanding of business needs, with the ability to establish and maintain high level of customer trust and confidence
5.A strong understanding of and competence with tools for entity relationship modeling
6.Skilled in requirements gathering for medium to large projects with strong analytical and problem-solving background
7.Sound written and verbal communication skills
8.Ability to work as a member of a team
9.Demonstrated proficiency in basic computer applications, such as Microsoft Office software products
10. Ability to travel, occasionally overnight

Desired Skills:

1.Experience with Erwin Data Modeler
2.Experience with Structured Query Language (SQL)

BB&T is an Equal Opportunity Employer and considers all qualified applicants regardless of race, gender, color, religion, national origin, age, sexual orientation, gender identity, disability, veteran status or other classification protected by law.

EEO is the Law Pay Transparency Nondiscrimination Provision E-Verify



See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Enterprise Data Office Technical Lead

Bb&T

Posted 2 days ago

VIEW JOBS 11/14/2018 12:00:00 AM 2019-02-12T00:00 Specific information related to the position is outlined below. To apply, click on the button above. You will be required to create an account (or sign in with an existing account). Your account will provide you access to your application information. Need Help? Should you have a disability and need assistance with the application process, please request a reasonable accommodation by emailing BB&T Accessibility or by calling 866-362-6451. This email inbox is monitored for reasonable accommodation requests only. Any other correspondence will not receive a response. Regular or Temporary: Regular Language Fluency: English (Required) Work Shift: 1st shift (United States of America) Please review the following job description: POSITION: Enterprise Data Office Technical Lead POSITION DESCRIPTION: Establish strong partnership with various lines of business and data stakeholder communities; gather business requirements and express those requirements in business as well as technical language; communicate at all levels, and within all stakeholder communities, both business and technically oriented; summarize and communicate the impact of technical design choices as well as business scope decisions; establish and promote standard project artifacts and best practices for an Enterprise Data Office; establish and promote standard project artifacts and best practices for an Enterprise Data Office; mentor junior analysts and engineers and provide guidance to all technical staff; work with the following tools, techniques and design principles of the following: Data Warehouse, Big Data, Business Intelligence, Data Analysis, Data Profiling, Data Wrangling, Data Virtualization, Data Federation, and Data Modeling; implement Operational Data sources, Operations Data Marts, Analytical Data Marts, Data Lake and OLTP Applications; work with Hadoop (Big Data), Dimensional Data modeling, Star Schema/snowflakes schema and with the Relational Modeling, including system architecture, design and development of big data solutions using Hadoop, HDFS, Map Reduce, Hive, HBase, Pig, Hue, Oozie, Sqoop, R, Presto, Spark and Scala; provide BI Solution Design and Architecture working through Semantic Layer. (using tools such as Tableau, Business Objects and Micro Strategy); build dashboards using Tableau; perform data modeling using Hive and HBASE Models; and design end to end solutions to business problems that integrate with existing solutions such to provide economies of scale while limiting impact to existing systems. REQUIREMENTS: (1) Master's degree in Computer Science, Computer Information Systems or related field, plus three (3) years of experience in Enterprise Data Offices; OR (2) Bachelor's Degree in Computer Science, Computer Information Systems or related field plus (5) years of progressive experience in Enterprise Data Offices. Foreign equivalents accepted. SPECIAL REQUIREMENTS: Experience with financial institutions; design and implementation of data oriented business solutions; data modeling tools, including Erwin and IBM Infosphere Data Architect; Agile Methodologies; full SDLC; Business Intelligence tools, including Tableau and Micro Strategy; Data Governance/Quality and Metadata Management; Big Data design and architecture; Master Data Modeling; Conceptual/Logical/Physical Modeling; SQL, including performance tuning; working with Python, Netezza, SQL Server or DB2. BB&T is an Equal Opportunity Employer and considers all qualified applicants regardless of race, gender, color, religion, national origin, age, sexual orientation, gender identity, disability, veteran status or other classification protected by law. EEO is the Law Pay Transparency Nondiscrimination Provision E-Verify Bb&T Winston FL

Data Modeler

Expired Job

Bb&T