Database Engineer at ThinkMarkets

| Chicago
Sorry, this job was removed at 4:22 p.m. (CST) on Wednesday, February 26, 2020
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

ThinkMarkets has an exciting opportunity for an experienced Database Engineer to join our Chicago office. This position will be responsible for working with the customer to define requirements, analyze business and technical processes in order to design application functionality that will be accessible by internal customers from various branches across the globe.  The candidate must be a self-starter and work well with others and must have excellent written and verbal communication skills and effectively communicate with all stakeholders.  This successful candidate will apply extensive technical expertise and have deep knowledge of databases and data warehousing and develop technical solutions to complex problems which require regular use of ingenuity and creativity. 

 

Responsibilities:

Data Warehousing

  • Define standards and frameworks for data architecture design.
  • Formulate event modelling; conceptual, logical, and physical data warehouse design; data warehouse optimization and performance; load strategy design and implementation; change management.
  • Perform data profiling and analysis to assess data quality patterns, recommend data cleansing rules – conforming data standard rules and matching algorithms.
  • Write database documentation, including data standards, procedures, and definitions for the data dictionary.
  • Implement and enforce database security based upon best practice, industry regulations, and company policies.
  • Deliver data to end user in appropriate requested formats, such as spreadsheets, SSRS Reports, Tableau dashboards and reports, etc.

MS SQL Responsibilities

  • Provide SQL coding focused database development assistance to the Application Developers.
  • Perform SQL Migrations to new Servers and configure and setup BI tools (SSRS, SSIS etc.)
  • Work with System/Network Administrators to develop and maintain the replication, backup, and restoration of data within the system.
  • Develop custom queries and reports for data modelling through various tool sets to aggregate, analyze, and report results.
  • Maintain clustered, highly redundant database environments.

MySQL Responsibilities

  • 4-6 years experience working with MySQL
  • Develop, implement, and maintain MySQL database structures in test, quality assurance, and production environments utilizing current standards policies and procedures.
  • Provide performance-related support and systems related support for MySQL data structures in production, test, development, and QA environments utilizing current tool sets.
  • Maintain existing MySQL environments, including replication environments and High Availability environments.
  • Manage backup/recovery for MySQL instances and provide Disaster Recovery (DR) support.
  • Implement and enforce database security based upon best practice, industry regulations, and company policies.

 

Requirements:

  • Bachelor's degree in Computer Science or an equivalent combination of education and experience sufficient to successfully perform the essential duties of the job.
  • Certification in MCSE: Data Management and Analytics preferred.
  • 3+ years of experience in SQL, Database Development; experience in Financial Services is preferred.
  • Minimum 2 -3 years experience working with cloud integration (AWS, Azure)
  • Experience and advanced knowledge of security and management of databases.
  • Experience with deploying databases on a global scale.
  • Experience working with Real-Time/Time Series databases.
  • Experience with database administration and design of enterprise database systems. (Influx DB and Redis-AWS)
  • Experience managing users accounts privileges, access, and permissions.
  • Experience with conflict management and identity parameters in replicated environments.
  • Experience with utilizing database performance analysis tools: SolarWinds or Redgate.
  • Experience with BI and Tableau is a plus.
Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • SwiftLanguages
    • Objective CLanguages
    • SwiftLanguages
    • Cocoa TouchLanguages
    • HTMLLanguages
    • CSSLanguages
    • SolidityLanguages
    • EtherumLanguages
    • ReactLibraries
    • AngularJSFrameworks
    • Node.jsFrameworks
    • SpringFrameworks
    • CassandraDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • JIRAManagement
    • WordpressCMS
    • KenticoCMS

Location

We are in the financial district of the city, located in the UBS Tower. We welcome others who would like to master the latest in tech with us.

An Insider's view of ThinkMarkets

What’s the vibe like in the office?

We're definitely a hardworking bunch, and we're very passionate about what we do. The culture is dynamic and collaborative, and there's always something to work on which helps the day fly by!

Ashley

Executive Assistant to the CEO

What does your typical day look like?

We start the day with a web call summarizing portfolio risks, exposures & order flow with our teams in Dubai & London. We track, measure, & report any trade issues with our clients; we’re always aware of changes in the risk profile of the firm portfolio. We're constantly checking on pricing, liquidity & execution across all our product offerings.

Pat

Head of Options

What makes someone successful on your team?

Above all, having passion for what you do will make an individual successful in any position! Specifically here at ThinkMarkets, we value a collaborative and innovative mindset to make our team run the most efficiently.

Theresa

Human Resources Associate

How do your team's ideas influence the company's direction?

At ThinkMarkets, ideation that challenges the norm and status quo is embraced! We prioritize growth and innovation to drive the business forward. As a Marketing Team, our mission is to bring the brand personality to life across the globe with a lean methodology that enables ThinkMarkets to proactively and constantly drive progress and efficiency.

Rich

Head of Performance Marketing

What projects are you most excited about?

It's amazing to design a web-based trading platform, providing users with the most effortless and exciting trading experience! I enjoy collaborating with a team of professional and smart co-workers, whose expertise in different domains solve user problems, fuel creativity, gain industry value, and shoot for more exciting outcomes for the company!

Athens

UI/UX Designer

What are ThinkMarkets Perks + Benefits

Culture
Friends outside of work
Eat lunch together
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Highly diverse management team
Mean gender pay gap below 10%
Health Insurance & Wellness Benefits
Dental Benefits
Health Insurance Benefits
Wellness Programs
Retirement & Stock Options Benefits
401(K)
Performance Bonus
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Commuter Benefits
ThinkMarkets covers up to 85% of transit costs and the remaining balance can be deducted from paychecks pre-tax.
Stocked Kitchen
We have an espresso and coffee machine, tea, and snacks stocked in our kitchen!
Some Meals Provided
Free lunch catered in on Fridays!
Fitness Subsidies
ThinkMarkets provides $65 a month to each employee to use towards gym memberships or classes (yoga, barre, kick-boxing, etc.) to promote a healthy lifestyle!
Professional Development Benefits
Promote from within
More Jobs at ThinkMarkets21 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
HR + Recruiting
Legal
Marketing
Operations
Data + Analytics
new
Chicago
Finance
new
Chicago
HR + Recruiting
new
Chicago
Data + Analytics
new
Chicago
Finance
new
Chicago
Finance
new
Chicago
Finance
new
Chicago
Finance
new
Chicago
Marketing
new
Chicago
Design + UX
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Marketing
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Marketing
new
Chicago
Marketing
new
Chicago
Design + UX
new
Chicago
Finance
new
Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView ThinkMarkets's full profileSee more ThinkMarkets jobs