Filtr uses AI to scan 1000+ jobs and finds postings that perfectly matches your resume

Compeer Financial is looking to build advanced analytics tools to provide actionable, high-impact insights for decision making, utilizing the data pipeline to empower informed, data-driven decision-making across departments.

Requirements

• Minimum of 7 years of experience with various MS SQL environments (2017 and above), designing and implementing objects using SQL Server Data Tools.
• SQL Server and/or other Microsoft technologies preferred.
• Advanced SQL server knowledge of T-SQL and OLTP topics such as normalization, data types, query tuning, indexing, constraints and query plans, etc.
• Advanced knowledge and experience in Cloud computing (MS Azure).
• Solid experience working in Microsoft Fabric.
• Advanced knowledge and experience in creating stored procedures, views, functions, T-SQL, SQL Scripting.
• Solid experience with data warehouses, APIs, ETL scripting and SQL scripting, Python, R-Script, PySpark, Notebooks.

Responsibilities

• Develops complex data models and data pipelines for research, reporting and machine learning.
• Conceptualizes and generates infrastructure that allows data to be accessed and analyzed.
• Maintains and optimizes the performance of the data User Interface layer to ensure accurate, reliable and timely delivery of key insights for decision making.
• Models data sources to help draw a more comprehensive picture of the data that enables powerful data analysis and reporting.
• Leads the development and execution of new concepts and proof of concept designs.
• Conducts research to answer business questions related to data and the data warehouse.
• Employs a variety of SQL languages to bring data from multiple systems together into the user interface layer.

Other

• Bachelor’s degree in math, computer science, management information systems, or related field or an equivalent combination of education and experience sufficient to perform the essential functions of the job.
• Must be authorized to work for any employer in the United States.
• Strong listening, written and verbal communication skills, with ability to communicate at all levels of the organization.
• Ability to translate highly technical information into non-technical terms.
• Ability to work independently and collaboratively with other teams to achieve goals and represent the business.