Provide or enhance solutions for data management reporting and analytics in a disciplined manner. This includes the full scope of these systems from Semantic Layer database development, business requirements, and wireframes and service level agreements
Resolve data integrity issues by profiling data and understating data behavior and business rules
Collaborate with peers on solution design, work estimation, and implementation of new features including interfaces, data transformations, and handoff of client teams
Be responsible for reviewing requirements, architecture, and design components for both projects in progress and forthcoming
Monitor applications for performance and improvement opportunities
Ensure the quality, consistency and security of BI focused applications
Build solution prototypes for review by business that will determine feasibility and investment justification
Triage issues and provide Root Cause Analysis that include recommendations for short-term and long-term solutions
Document all work in a centralized repository that enables elastic support of deployed applications
Keep abreast of the tools, techniques and components being used in the industry through research and applies this knowledge to the system(s) being developed
Work on multiple projects and deliver consistently on time
Work comfortably with both business team members and technologists
Expert level knowledge of SQL. Ability to diagnose and tune queries, use of advanced SQL features such as window / analytic functions.
Experienced and knowledgeable in data modeling concepts such as star schemas, snowflake schemas, and highly-normalized models.
Hands-on experience in developing solutions within Microsoft BI & database platform stack - Power BI, SQL Server, Analysis Services, Reporting Services, and Integration Services
Experience in development and administration in at least two mainstream BI platforms (ie: Tableau, Power BI, Microstrategy, Birst, Oracle OBIEE)
Experience in building semantic layer data marts and incorporating business rules via stored procedure development.
Experience in creating interactive complex data visualizations and dashboards
Demonstrated proficiency of MS Office – Visio, Word, Excel, PowerPoint, Outlook
Ability to thrive in a dynamic and fast-paced environment, drive change, and collaborate effectively with a variety of individuals and organization
Excellent communication and relationship building skills