Back to Job Search

Data Modeler

  • Location: Charlotte, 28202
  • Salary: 71.29
  • Job Type:Contract

Posted about 1 month ago

Work with the brightest minds at one of the largest financial institutions in the world. This is long-term contract opportunity that includes a competitive benefit package!

Our client has been around for over 150 years and is continuously innovating in today's digital age. If you want to work for a company that is not only a household name, but also truly cares about satisfying customers' financial needs and helping people succeed financially, apply today.

Position: Lead Software Engineer
Location: CHARLOTTE, North Carolina, 28202
Term: 12 months

Day-to-Day Responsibilities:

  • Work with Technical analysts and Business Partners to translate business and data requirements into a data warehouse model for reporting and analytics.
  • Analyze the existing data structures and identify the sources of incoming data to drive Source to Target Mapping with assistance from ETL Developers and Data Engineers.
  • Build all database objects (Tables, Relationships, Triggers, Stored Procedures, etc.) with assistance from DBA.
  • Build, maintain and govern all enterprise data models in defined tool (PowerDesigner).
  • Understand database performance factors and trends pertaining to very large database design and collaborate with DBAs to implement mitigating physical modeling solutions.
  • Define data security roles, groups and policies.
  • Responsible for defining and enforcing data modeling design standards, tools, best practices, and related development methodologies for the organization.
  • Partnering with Business Stakeholders and developers to ensure deliverables meet business expectations.
  • Suggest solutions for reporting or process improvement.
  • Must be comfortable working on multiple, complex issues and projects.
  • Participate in production releases as required

Is this a good fit? (Requirements):

  • 7+ years of application development and implementation experience.
  • 7+ years of SQL experience.
  • 7+ years of business intelligence experience.
  • 7+ years of SDLC (System Development Life Cycle) experience.
  • 6+ years of data modeling experience.
  • 5+ years of MS SQL server experience.
  • 5+ years of experience writing Microsoft SQL Server relational database queries, stored procedures, query optimization and performance tuning.
  • 4+ years of RESTful or SOAP web services.
  • 4+ years of ETL (Extract, Transform, Load) Programming experience.
  • 4+ years of experience with data analysis and documentation.
  • 4+ years of experience in Hadoop ecosystem tools for real-time batch data ingestion, processing and provisioning such as Apache Flume, Apache Kafka, Apache Sqoop, Apache Flink, Apache Spark or Apache Storm.
  • 4+ years experience designing and optimizing complex SQL queries involving table joins and correlated sub-queries on large scale data tables.
  • Proven track record of working autonomously to deliver high quality data models in an agile environment.
  • Excellent verbal, written and interpersonal communication skills.
  • Proven ability to meet deadlines.
  • Advanced Microsoft Office skills (Word, Excel, Outlook and PowerPoint).
  • Strong sense of ownership