Responsibilities
Help write and optimize in-application SQL statements
Ensure performance, security, and availability of databases
Prepare documentations and specifications
Profile server resource usage, and optimize and tweak as necessary
Collaborate with other team members and stakeholders
Translate business needs to technical specifications
Design, build and deploy BI solutions (e.g. reporting tools)
Maintain and support data analytics platforms (e.g. MicroStrategy)
Create tools to store data (e.g. OLAP cubes)
Conduct unit testing and troubleshooting Evaluate and improve existing BI systems
Collaborate with teams to integrate systems
Develop and execute database queries and conduct analyses
Create visualizations and reports for requested projects
Develop and update technical documentation
Requirements
Strong proficiency with SQL and its variation among popular databases
Experience with some of the modern relational databases
Skilled at optimizing large complicated SQL statements
Knowledge of best practices when dealing with relational databases
Capable of configuring popular database engines and orchestrating clusters as necessary
Proven experience as a BI Developer or Data Scientist
Industry experience is preferred
Background in data warehouse design (e.g. dimensional modeling) and data mining
In-depth understanding of database management systems, online analytical processing
(OLAP) and ETL (Extract, transform, load) framework
Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI)
Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server
Integration Services (SSIS)
Proven abilities to take initiative and be innovative Analytical mind with a problem-solving aptitude
Keyskills: SQL Development T-SQL SQL Server Development Sql Stored Procedures SSRS statements SQL Server SSIS
AIS is a Texas-based fintech firm committed to lowering operating costs, improving quality and reducing cycle time with back-office automation, highly skilled talent and standardized reporting and analytics solutions. AIS manages the day-to-day work so our clients can focus on growing their busin...