Mariner Finance · 1 week ago
Business Intelligence Architect
Wonder how qualified you are to the job?
FinanceFinancial Services
Insider Connection @Mariner Finance
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.
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
Mariner Finance is a consumer finance industry.
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)
Funding
Current Stage
Late StageTotal Funding
unknown2013-01-01Private Equity· Undisclosed
2009-12-15Acquired· by Milestone Partners
Recent News
2024-05-24
2024-04-06
Company data provided by crunchbase