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