Senior Power BI Developer

alliantgroup, LP is currently experiencing explosive growth! As a national consulting firm focused on being the voice to the middle market, our mission is simple: Strengthening American businesses. How do we do this? We hire the brightest talent with the most diverse backgrounds who are passionate about making a difference. It's fun to work in a company where people truly BELIEVE in what they're doing!

alliantgroup, LP is currently experiencing explosive growth! As a national consulting firm focused on being the voice to the middle market, our mission is simple: Strengthening American businesses. How do we do this? We hire the brightest talent with the most diverse backgrounds who are passionate about making a difference.

The individual in this role must be a Senior BI Developer professional who can help expand and maintain the reach of our reporting platform solution. The position requires a broad range of skills and the ability to wear many different hats including leading business-facing interactions; developing business, technical, and data expertise around alliantgroup systems; designing and developing end-to-end business intelligence solution components; and maintaining the solution in production environment.

ESSENTIAL JOB RESPONSIBILITIES:

• Hands-on experience on design, development and execution of Extract, Transform and Load (ETL) & Report Development processes

• Implementation of enterprise BI, analytics and performance management solutions in a complex enterprise environment.

• Collaborate with business and technology leaders to identify key business requirements to enable enterprise BI/Performance Management strategy.

• Responsible for designing, configuring and deploying BI/Performance Management application user functionality using the Microsoft SQL Server BI technology stack.

• Responsible for data architecture and data integration with dimensional data modeling, data sourcing / mapping, and data flow within the implemented solution.

• Partner with business team members and document requirement specifications and determine necessary ETL & Reporting solutions

• Conduct project planning and work estimates.

• Responsible for operational monitoring, maintenance, and troubleshooting for the Microsoft SQL Server BI platform.

• Define and ensure adherence to architecture standards, reference models, clean coding standards and processes.

• Provide technical direction and work with 3rd party vendors to define and deliver BI applications.

KNOWLEDGE, EXPERIENCE AND SKILLS:

• Bachelor's degree from an accredited program in computer science, information technology, or other related field or equivalent experience required.

• Possess proficient analytical, problem solving and decision-making skills.

• Proficient ability to communicate effectively with others using written and spoken English.

• Ability to work cooperatively and collaboratively with others; conducts working relationships in a manner acceptable to others and to the organization.

• Possess a capacity and passion for cross-functional learning, experimentation, and innovation.

• Experienced in working across functions and work groups as needed so the company and department can achieve or exceeds its overall business objectives.

• Experience with Financial Data Preferred

• 7-10 Years of relevant experience in planning and delivering enterprise wide Reporting (preferably SSRS) and data warehouse solutions using proven delivery methodology, frameworks and best practices.

• 7 years competency with Microsoft BI technology stack.

• Expert knowledge with multiple successful implementations of Microsoft BI solution.

• Working knowledge and experiences in data design / dimensional data modeling.

• Working knowledge and experiences in SSIS, SSRS, SSAS and SQL Server development tools.

• Working knowledge Power BI is a plus

• Customer service focused and ability to work effectively within multiple levels of the organization.

• Strong understanding of SDLC and Agile methodologies

• Ability to work independently with little or no supervision.

• Handle a dynamic work environment with competing priorities.