51 applicants

This job has closed.

Company

Original Job Post

Mariner Finance · 6 days ago

Business Intelligence Architect

United States

Full-time

Remote

Senior Level

3+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

FinanceFinancial Services

H1B Sponsorship

Insider Connection @Mariner Finance

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Gather and process raw data from multiple disparate sources into a form suitable for analysis.

Review and interpret ongoing business requirements, research required data, and build appropriate deliverables.

Refactor or develop relational data models, dimensional data models, data dictionaries, and necessary metadata.

Code, test, and document new or modified data systems to create robust and scalable applications for analytics.

Contribute to the design and direction of enterprise-wide data architecture.

Create supporting technical and functional documentation, including data flow diagrams.

Design and build high-performance algorithms, prototypes, predictive models, and proof of concepts.

Create advanced multi-leveled tabular and graphical reports to meet user requirements.

Identify and implement process improvements through the design and implementation of policies, procedures, and analytics infrastructure.

Assist in the maintenance of SQL Servers and troubleshoot faults.

Complete projects, prioritize tasks, and provide progress reports based on company needs.

Act as a resource to junior team members and support business decisions with ad-hoc analysis.

Participate in rotation of after-hours support and explain tasks clearly to non-technical associates.

Cultivate business relationships with stakeholders and provide consistent quality customer service.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Database developmentMicrosoft sql serverSsrsSsisSsasOlap servicesC#Restful apiLinqOrmModel bindingPower biSql queryEtlData architectureT-sqlSql code troubleshootingTable designData-martsDatabasesReporting needsSql database administrationGitEmerging technologiesMethodologiesAutomated solutionsDeadlines managementComputer skillsMicrosoft officeProblem-solving

Required

Bachelor’s degree in Computer Science, Information Systems Management, Engineering, or related field; additional, applicable years of experience may be substituted for the bachelor’s degree.

Minimum of three (3) years of related database development experience.

Advanced experience using Microsoft’s SQL Server, SSRS, and SSIS, SSAS, and OLAP services.

Knowledgeable with C#, capable of interacting with RESTful API’s. Basic understanding of LINQ, ORM and Model Binding.

Advanced experience with Power BI required, preferably in an on-premises context.

Advanced SQL Query, ETL, and Data Architecture experience.

Advanced knowledge in writing complex T-SQL code.

Ability to quickly identify and troubleshoot problematic SQL code.

Ability to design tables, data-marts, and/or databases to suit reporting needs.

Experience with SQL Database Administration.

Experience with code repositories with a good understanding of Git.

Desire and ability to learn emerging technologies and methodologies.

Ability to interpret report requests and requirements in order to build appropriate automated solutions.

Ability to work with shifting deadlines in a fast-paced environment.

Strong computer skills, including Microsoft Office (Access, Excel, Word, & Outlook).

Strong attention to detail, interpersonal skills, and notation skills.

Preferred

Experience using Jira, Bitbucket, GitKraken, and/or SourceTree.

Knowledge of data mapping, database design, and data warehouse concepts.

Experience with Cloud Related services, such as AWS Redshift, DynamoDB, or Amazon RDS.

Consumer Lending/Financial Services experience.

Company

Mariner Finance

Glassdoor

3.4

Mariner Finance is a consumer finance industry.

Founded in 2002

Nottingham, Maryland, USA

1,001-5,000 employees

http://www.marinerfinance.com

H1B Sponsorship

Mariner Finance has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Trends of Total Sponsorships

2023 (1)

2022 (1)

2021 (2)

2020 (7)