Sr BI Engineer

Triad Digital Media   •  

Saint Petersburg, FL

Not Specified years

Posted 241 days ago

This job is no longer available.

You will:

  • 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

You have:

  • 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