Reporting and Analytics Developer - Permanent Night Shift

Reporting and Analytics Developer - Permanent Night Shift

Sysgen RPO Inc
5-10 years
Not Specified

Job Description

Minimum Requirements
5 to 10 years related experience.
Excellent knowledge of data modeling, SQL and data warehousing.
Experience in multiple database platforms including: SQL Server, Oracle and DB2.
Strong knowledge of Microsoft BI technology (SSRS, SSIS, SSAS, Power BI) and other
reporting tools (IBM Cognos).
Proficient building ETLs using SSIS and C#
Experience with parsing data from APIs, XMLs, JSON and other non-relational datasources
Skills and experience using Azure and AWS for BI applications are desirable.

ESSENTIAL DUTIES AND RESPONSIBILITIES
Design and develop enterprise and departmental business intelligence, data warehousing and reporting
solutions.
Work with business users to establish reporting and analytic requirements.
Translate business requirements into ETL and report specifications.
Develop and implement ETL processes, reports and queries in support of business analytics.
Page 2 of 5
HR Use Only – REV 04.26 – Software Developer
Develop and implement interactive analytic reports and dashboards.
Provide technical and business knowledge support to the team.
Compile ad-hoc data and report requests.
Performs advanced statistical analysis for projects and experiments.
Performs and directs QA/testing of dev activities done on the Reporting and Analytics system.
Performs coordination for tasks between other teams and team members.
Must be able to review reports and draw conclusions.

Knowledge, Skills, and Abilities:
Must Have
1. In depth understanding of programming, modern software development process using TFS
2. In depth understanding of relational database concepts and programming
3. Proven ability to implement a solution from inception to production
4. Significant experience and expertise on Microsoft .NET Framework, SSRS, SSIS, and C#
5. Expertise on Microsoft SQL Server (preferably 2008 and up), TSQL, SSIS, SSAS
6. Excellent analytical and troubleshooting skills
7. Experience with Azure and AWS technologies in the context of BI solutions
Should have
1. Experience with data warehousing, star schema, data analysis, service oriented architectures, web
Services
2. Experience with implementing complex scripting, SQL and C# to deliver business requirements
Nice to have
1. Experience in healthcare setting (provider/payer environment)
2. Experience with other Business Intelligence tools like Birst, Power BI and others
3. Experience with VS Team Server System (TFS)
4. Experience with MVC, WCF, Entity Framework in C#
5. Experience with unit testing tools/frameworks
6. Experience with JIRA, Topdesk and other process tracking tools

Sysgen RPO

Similar Jobs

People Also Considered

Career Advice to Find Better