Implement T-SQL code (procedures and views) and SSRS reports in line with established plans and architectural standards for the department.
Implement, enhance, triage existing stored procedures and SSIS packages employed in the overnight or real-time integration with source systems.
Implement, enhance SSAS multi-dimensional and tabular cubes.
Act as a liaison with architects, business analysts, developers and testing teams for content input and document reviews to ensure that report functionality is well documented.
Interpret requirements provided by business analysts and occasionally directly from end users
Pro-actively understand changes to project scope and make relevant changes to report design and stored procedures.
Understand relational databases and data analysis, data models, data extracts, and reporting in context.
Assist Quality Assurance team with validating reports.
Escalating issues in a timely manner and suggesting improvements.
Providing peer review support to work produced by others, confirming use of relevant coding standards; approving work produced by others.
Demonstrate understanding of the Software Development Life Cycle.
Other duties as assigned.
What we're looking for:
4+ years of experience in SSRS development.
6+ years of experience with Microsoft SQL Server and T-SQL code development.
2+ years of experience with SSAS multi-dimensional or tabular cubes.
Solid understanding of database development best practices.
Strong organizational skills.
Good problem solving mindset; should be motivated and self-directed
Must have ability to coordinate multiple tasks, set priorities, and meet deadlines.
Must have good attention to detail.
Experience with SQL Server 2016 Enterprise is a plus.
C# experience is a plus.
Web development experience is a plus.
Predictive analytics experience is a plus.
Bonus Points:
N/A
Education:
Bachelor's degree
Travel:
<10%
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
IT/IS