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.
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.
alliantgroup is a national tax consulting services firm that works with CPA firms and their business clients to identify and claim available federal and state government-sponsored tax credits and incentives.