Sign in

Senior BI Analyst and Developer

Company:
jra
Location:
Miami, Florida, United States
Posted:
December 11, 2018

Description:

Assist in the analysis, design, hands-on development and delivery of Business Intelligence applications and solutions as well as Production DBA backup responsibilities.

As Production DBA Backup, the candidate will be responsible for SQL Server database administration and database operational functions. Key knowledge areas include SQL Server setup, SSIS, PowerShell scripting, transactional and data warehouse systems, job scheduling, deployments and system maintenance and production application support.

Responsibilities:

- Migrate legacy queries/reports following standards and guidelines.

- Create and maintain SQL Server Reports.

- Optimize Reports and trouble shoot reporting issues.

- Write Database SQL Views and Stored Procedures.

- Work closely with the BI team to create reports using Microsoft BI Tools.

- Work closely with the BI team to support In-House Web Apps.

- Install, maintain, support, and document operational and reporting/DW SQL Server database systems.

• Ensure all database servers are backed up meeting RTO’s (Recovery Point Objective) and RPO’s (Recovery Time Objective) as well as DR testing.

• Investigate, troubleshoot and user related system errors, and ensure data integrity.

• Support SDLC in an enterprise environment, including installation, review, deployment, configuration, jobs, backup, recovery, upgrades, and schema changes.

• Ensure compliance with company policies and procedures, regulations and standards.

• Ability to learn complex business requirements.

• Travel for disaster recovery.

Requirements:

• Must have a working Knowledge in T-SQL, SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), DAX and PowerShell.

• Advanced knowledge of SQL Server’s stored procedures, indexes, views, execution plans, statistics, SQL Server Profiler, backups, failover clustering, always-on.

• Must be skilled in creating and designing reports.

• Working of experience working with SQL Server database setup (version 2012, 2014, 2016) and enterprise architecture patterns, including performance tuning and optimization and DR Setup.

• Strong technical documentation skills, analytical skills and the ability to solve complex and challenging problems in an efficient, maintainable, and flexible way.

• Working in a secure, audited environment meeting SOX or similar compliance requirements is a strong plus.

• Experience in designing and implementing an ODS and Data Marts

• Experience with Microsoft Business Intelligence Stack: Excel Power Pivot, SSAS Tabular, Power BI, Power Query preferred.

• Azure SQL server nice to have.

• Bachelor’s degree, preferably in computer science, information systems or the management of information systems.