Role: Data Architect
Client: Indium Software Inc./ MetLife.
Location: NYC, NY day 1 onsite.
Note: Experience in Insurance Domains is preferred
Data Architect
- We are seeking a Data Architect/Data Modeler with experience in DataBricks, Microsoft Full Stack Engineering & Python for a new development project with a large financial client.
- The ideal candidate will have a strong background in SQL Server, producing conceptual, logical and physical database designs.
- In addition, the candidate will have experience working with multiple feature teams and engineers as well as working with offshore DBAs.
- Experience with databricks, data migration, reporting services, integration services, data quality and analysis, test automation with SQL DB, data modeling, and mentoring team members.
Key Responsibilities:
- Conceptual, logical and physical database design using SQL Server and other relevant technologies.
- Analyze existing databases, provide feedback, and recommend improvements.
- Develop and maintain controls for data quality.
- Work with the team to migrate historical data to a new environment.
- Set up standards for database development, maintenance, and operations.
- Develop data models that focus on maintainability, scalability, and performance.
- Collaborate with software developers, business analysts, and other stakeholders to ensure that database design meets project requirements.
- Test and automate database scripts and procedures to ensure data integrity and performance.
Requirements:
- Experience in Insurance Domains is preferred.
- Experience in managing risk data (internal audit, Compliance, ER, ORM etc.) is preferred.
- Strong experience in SQL Server DBA, including database design, development, maintenance, and optimization.
- Expertise in Microsoft Full Stack technologies, including .NET, C#, ASP.NET, MVC, and Web API.
- Experience with data migration, ETL, and integration services, such as SSIS and Azure Data Factory.
- Experience with reporting services, such as SSRS, Power BI for creating visualizations and reports.
- Strong skills in data analysis, data quality, and data modeling, using tools such as Excel, Power BI, and ER/Studio.
- Knowledge of test automation tools and techniques for SQL DB.
- Excellent communication skills and ability to work collaboratively with a diverse team.