Homeoffice SQL and Data Integration Developer bei Beacon Funding
Beacon Funding · Vereinigte Staaten Von Amerika · Remote
- Senior
The ideal candidate has a strong background in T-SQL development, enterprise data architecture, and cloud-based tools like Azure Data Factory, with excellent communication skills and a proactive approach to problem-solving in a distributed team environment.
- Design, develop, and maintain SQL database schemas and scripts, including views, stored procedures, and SQL jobs
- Develop both logical and physical data models to support robust and scalable database design.
- Monitor and maintain our existing data to ensure it remains, clean, accurate, consistent, and impactful
- Write and optimize complex stored procedures, functions, and views using T-SQL for high-performance data operations
- Build and maintain data integration workflows using ETL/ELT tools such as Azure Data Factory, facilitating data movement between systems and environments.
- Integrate and import data from third-party APIs into SQL databases, ensuring data accuracy, security, and consistency.
- Collaborate closely with application developers to implement and optimize database structures that support application requirements.
- Design and implement scalable data warehouse solutions that align with business goals and support enterprise analytics.
- Serve as the primary liaison from the SQL development team to cross-functional teams, including marketing, accounting, graphic design, and customer support.
- Create comprehensive technical documentation, including design specifications, architecture documentation, and user instructions.
- Continuously evaluate existing software components and tools, recommending improvements to ensure efficiency and scalability.
- Participate in an agile development environment, coordinating with a distributed team across multiple time zones to deliver high-quality solutions on time and within budget.
- India, Work From Home (Shift: 2 pm - 11 pm)
- 5+ years of hands-on experience with SQL development.
- 3+ years of experience working with ETL/ELT tools, preferably Azure Data Factory.
- Skilled in writing and optimizing complex T-SQL queries, with expertise in performance tuning and query development.
- Proven experience developing and maintaining enterprise data warehouse architectures.
- Experience integrating data from external APIs and importing third-party data into relational databases.
- Hands-on experience with version control systems such as TFS, GIT, or Azure DevOps.
- Experience with Azure SQL, SQL Source Control, and Azure Logic Apps is a plus.
- Exposure to Master Data Management (MDM) concepts and practices is advantageous.
- Solid understanding of database troubleshooting and implementation of industry best practices.
- Bachelor’s degree (or higher) in Computer Science, Information Systems, or a related field.
- Excellent communication and collaboration skills, with a proven ability to work effectively with globally distributed teams.
- Group Mediclaim Policy
- Parental Insurance Coverage
- Accident Policy
- Retirement Benefits (Provident Fund)
- Gratuity
- Overtime Bonus, Paid Vacation & Holidays, Profit Sharing & Incentives