Sr. BI Developer

It's fun to work in a company where people truly BELIEVE in what they're doing!

We're committed to bringing passion and customer focus to the business.

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 pri