Database/Data Warehouse Developer jobs in United States
cer-icon
Apply on Employer Site
company-logo

One Inc · 1 day ago

Database/Data Warehouse Developer

One Inc is a rapidly growing digital payments platform in the insurance industry, and they are seeking a talented Database/Data Warehouse Developer to join their team. The role involves developing and maintaining database solutions and data warehouse architectures to support business operations and analytics needs, while collaborating with stakeholders and ensuring data integrity and security.

FinanceFinancial ServicesFinTechInsurTechPayments
check
Growth Opportunities
check
H1B Sponsor Likelynote

Responsibilities

Develop, and maintain database solutions and data warehouse architectures using MSSQL 2019/2022 and MySQL 8
Collaborate with stakeholders to gather requirements and understand business needs for data storage and processing
Develop and maintain ETL processes using SSIS, BIML, and DBT to ensure efficient data integration and transformation
Implement and manage solutions within Power BI Fabric for enterprise-scale data analytics
Write complex SQL queries, stored procedures, functions, and triggers to support application and reporting requirements
Optimize query performance through indexing strategies, execution plan analysis, and database tuning techniques
Troubleshoot and resolve database performance issues, data integrity problems, and system bottlenecks
Monitor database health, perform capacity planning, and implement proactive maintenance strategies
Develop automation scripts using PowerShell and Python to streamline database operations and maintenance tasks
Ensure data security, backup and recovery procedures, and compliance with organizational standards
Utilize version control tools such as Git and project management tools like Jira and Confluence or similar platforms as required
Work effectively in a team environment, collaborating on concurrent developments and contributing to team success
Document database architectures, ETL processes, standards, and procedures
Stay current with database technologies, best practices, and emerging trends in data warehousing
Provide technical guidance and support to team members and end-users as needed
Contribute to continuous improvement initiatives related to data management and analytics infrastructure

Qualification

MSSQL 2019/2022MySQL 8ETL processesPower BI FabricSQL programmingSSISBIMLDBTQuery optimizationPowerShellPythonGitJiraConfluenceAnalytical skillsProblem-solving skillsCommunication skillsCollaboration skills

Required

3+ years of experience in database development and data warehouse solutions
Bachelor's degree in Computer Science, Information Systems, or related field
Proven experience as a Database Developer, Data Warehouse Developer, or similar role
Strong proficiency in MSSQL 2019/2022 and MySQL 8, including advanced SQL programming
Hands-on experience with ETL tools and frameworks: SSIS, BIML, and DBT
Experience with Power BI Fabric and its integration with data warehouse solutions
Expert-level SQL skills with demonstrated ability in query optimization, performance tuning, and troubleshooting
Deep understanding of database design principles, normalization, dimensional modeling, and indexing strategies
Proficiency in scripting and automation using PowerShell and Python
Experience with version control systems (Git) and collaboration tools (Jira, Confluence, or similar)
Excellent analytical and problem-solving skills with attention to detail
Strong communication and collaboration skills, with the ability to work effectively with stakeholders at all levels
Ability to work independently and manage multiple priorities in a fast-paced environment

Preferred

Certification in Microsoft SQL Server, MySQL, or related database technologies is preferred
Knowledge of cloud data platforms (Azure, AWS, or GCP) is a plus

Benefits

Medical, dental, and vision insurance
401(k) plan
A commitment to a solid work/life balance
A policy of promoting from within whenever possible

Company

One Inc

twittertwittertwitter
company-logo
We understand how paramount the customer experience is to a carrier's success.

H1B Sponsorship

One Inc 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
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (1)
2023 (1)
2021 (1)
2020 (6)

Funding

Current Stage
Late Stage
Total Funding
$35.5M
Key Investors
Nordic CapitalAVP
2024-03-14Private Equity
2020-02-20Acquired
2017-05-02Private Equity· $15.5M

Leadership Team

leader-logo
Michael Ellis
CFO
linkedin
leader-logo
Timothy Boyle
Chief Operating Officer
linkedin
Company data provided by crunchbase