Database Engineer

| Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

ThinkMarkets is a global online brokerage firm, specializing in providing multi-asset trading solutions to thousands of clients around the world. With our flagship ThinkTrader platform, we allow our clients to trade the world 24-hours a day. Our mission is to disrupt the brokerage industry by allowing access to global markets and thousands of products to allow our clients to trade the world in the palm of their hand. We use the latest technologies to give traders seamless access to our proprietary trading platforms. Our Chicago office is in the heart of the financial district in the Loop, and is made up by our Leadership, IT, Analytics, and R&D teams. 

We are seeking a Database Engineer to join our rapidly growing global workforce in Chicago. In this role, you will be responsible for designing and developing database instances. This role collaborates with developers and infrastructure engineers to integrate databases with applications and other systems. A strong candidate for this role will have an appreciation of the data and performance requirements in the financial and FinTech industries.

Responsibilities:

  • Develop, implement, and maintain relational database structures, tables, data sets, and user data schemas across MySQL, MS SQL, Oracle, and Postgres instances
  • Design, develop, and own data pipelines and models that power internal analytics for product and business teams
  • Ensure the performance, integrity, and availability of database instances through forward-looking design and proactive monitoring and maintenance
  • 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
  • Provide support for database and application incidents, working closely with application developers, support staff, and infrastructure engineers
  • Provide coding and database architecture assistance to the Application Developers
  • Configure and manage integration and BI tools (e.g. Power BI, SSIS, SSRS, SSAS)
  • Develop custom queries and reports for data modelling through various tool sets to aggregate, analyze, and report results
  • Maintain existing database instances in production and pre-production environments, including replication, clustering, and high availability mechanisms
  • Plan and manage backup/recovery for database instances and provide Disaster Recovery (DR) support
  • Implement and enforce database security based upon best practice, industry regulations, and company policies

Requirements:

  • 5+ years of experience in a Data Engineering or Data Science role, with a focus on building data pipelines or conducting data intensive analysis
  • Prior experience with writing and debugging data pipelines using a distributed data framework (Hadoop/Spark etc…)
  • Knowledge of a scientific computing language (Python, Pyspark, SparkSql, SQL)
  • 5+ years of experience in SQL, Database Development; experience in Financial Services is preferred
  • Experience managing multiple database platforms including MySQL and MS SQL
  • 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 or equivalent preferred
  • Experience with database administration and design of enterprise database systems.
  • Experience managing users accounts privileges, access, and permissions
  • Experience with conflict management and identity parameters in replicated environments
  • Experience with Business Intelligence tools (e.g. Tableau, Power BI) is a plus

Our Benefit Offerings:

  • Medical, Dental, and Vision coverage available
  • Employer-Paid Short-Term Disability and Life Insurance
  • Pre-Tax Transit deduction options
  • Global Employee Assistance Program
  • 401k and Roth 401k (retirement planning) options available and competitive company match
  • Generous Paid Holidays
  • Monthly gym reimbursement
  • Fresh beverages and snacks in office
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
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
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 ThinkMarkets44 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Internships
Marketing
Operations
Product
Project Mgmt
Sales
Marketing
new
Chicago
Internships
new
Chicago
Internships
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
Design + UX
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
HR + Recruiting
new
Chicago
Operations
new
Chicago
Marketing
new
Chicago
Developer
new
Chicago
Finance
new
Chicago
Finance
new
Chicago
Design + UX
new
Chicago
Marketing
new
Chicago
Project Mgmt
new
Chicago
Internships
new
Chicago
Marketing
new
Chicago
Finance
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Finance
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
HR + Recruiting
new
Chicago
Data + Analytics
new
Chicago
HR + Recruiting
new
Chicago
Operations
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Sales
new
Chicago
Developer
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