BI Engineer, Sr.

We are a technology services company that puts people before technology. Yes, we have deep experience consulting, implementing solutions, providing managed services and staffing engagements. But we believe that, by focusing on relationships, we are better able to improve people’s experiences and lives through technology.

Technology is at its best when it complements our natural abilities and enhances our interactions. Which is why we say that, at Prosum, we make technology human.

Responsibilities

• Curious, analytical mind that can quickly ramp up on new domains and problem sets by asking insightful questions, understand what clients are trying to achieve, and drilling into and profiling data sources.

• Track record of successfully delivering value to companies through business intelligence solutions.

• Key contributor on agile teams where their processes and practices helped, not hurt, providing continuous business value.

• Influence and contribute to client and business projects as a member of an agile team that speaks to clients and internal customers, analyzes and clarifies what they are trying to achieve, and provides thought partnership in driving to a solution.

• Design and develop all areas of a business intelligence solution, including databases, ETL, reports, cubes, and dashboards, primarily using the Microsoft BI stack.

• Contribute to growing the platform's capabilities, some examples being reducing data latency in the ETL architecture and approaches, building intelligent process that can make decisions and send pertinent and actionable notifications, expanding ad hoc query and visualization capabilities.

• Work with the team to pragmatically and continually reduce the gap between getting things done fast and getting things done right. This includes aligning with the team on development practices, sharing approaches, code reviews, automating development, testing, integration, and deployment tasks.

• Answer data questions, consult on tools, suggest approaches, triage and troubleshoot issues.

echnical chops:

• T-SQL
• SSIS
• SSRS
• SSAS, MDX, DAX
• Modeling normalized and dimensional data marts/warehouses with ER tools such as ERwin, ER/Studio, PowerDesigner
• BI solutions in SharePoint
• Visualization tools such as PowerView, QlikView, Dundas
• C#/.NET
• Using TFS as a source control and ALM tool