Report Developer

5 days ago

Missoula, United States Allegiance Benefit Plan Management Full time
Job DescriptionJob Description

POSITION RESPONSIBILITIES:

The Report Developer will be responsible for working with internal stakeholders across the company to build and automate reports, dashboards and customer correspondence templates. This role will also serve as an internal consultant with internal teams to help them select optimal data fields and design layouts.

Employee must reside in Missoula, MT or surrounding area for this hybrid opportunity.

ESSENTIAL JOB FUNCTIONS:

  • Translate reporting and dashboard requirements from internal stakeholders into reporting solutions to meet business needs
  • Work with internal stakeholders to fully understand their business problem and design solutions to meet their needs
  • Gather requirements and scope of data and reporting needs from internal clients
  • Gain understanding of the impact and importance of the data underlying reports and dashboards, and become an expert in its use
  • Write SQL queries to extract data from Microsoft SQL Server database for ad-hoc requests
  • Design an automation of reoccurring report deliverables with Microsoft SQL Server Reporting Services (SSRS)
  • Develop methods for improving internal techniques and processes in creating highly effective reports and dashboards.
  • Maintain audit performance dashboards from external data sources, leveraging and improving on existing templates
  • Ensure high level of accuracy and quality in all produced work

NON-ESSENTIAL JOB FUNCTIONS:

  • Performs related or other assigned duties as required or directed

SUPERVISON EXERCISED:

None.

PHYSICAL WORKING CONDITIONS:

Physical requirements are representative of those that must be met to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.


Sitting 70%

Reaching Some

Standing 15%

Manual Dexterity Medium

Walking 15%

Telephone Yes

Kneeling Some

Computer Screen Medium

Bending Some

Lifting up to 20 lbs.


JOB SPECIFICATIONS:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION AND EXPERIENCE REQUIREMENTS:

  • Bachelor's degree in computer science, informatics, business or health care administration or related work experience
  • Three years of demonstrated experience in translating and coding business requirements into SQL reports and dashboards
  • Experience with Visual Studio experience preferred
  • Experience with Bold Reporting Service preferred
  • Experience in health care provider or insurance industry preferred

OTHER QUALIFICATIONS:

  • Expert proficiency with SQL queries (on any relational database platform)
  • Demonstrable relational database practices and techniques
  • Ability to explain and use joins, aggregations, pivots and windowed functions when writing queries
  • Expertise with Microsoft Excel, including charting, functions, pivot tables and macros
  • Ability to think critically to solve complex reporting problems and guide internal stakeholders to successful outcomes
  • Ability to drive change through influencing
  • Excellent oral and written communication skills
  • Detail oriented with strong organizational skills, ability to multitask and work in a dynamic, fast-paced environment
  • Strong internal customer focus and ability to manage stakeholder expectations effectively

The above statements are intended to describe the general nature and level of work being performed. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel as classified.


*Allegiance Benefit Plan Management, INC is an Equal Opportunity Employer. Qualified applicants will be considered without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws.

If you require reasonable accommodation in completing the online application process, please email: recruiting@askallegiance.com for support.



Job Posted by ApplicantPro

  • Education Reporter

    15 hours ago

    Missoula, Montana, United States Lee Enterprises Full time

    Job SummaryWe are seeking an ambitious and enterprising reporter to build a beat around schools and education for our Missoula newsroom. This full-time position in our digital-first newsroom will provide opportunities to write daily news, dig into policy decisions that impact Montana families and children, and explore issues and trends around literacy and...

  • Development Associate

    4 days ago

    Missoula, United States Montana Wildlife Federation Full time

    Montana Wildlife Federation Position Description Development Associate Essential Function The Development Associate (DA) serves a mission-critical role within the organization and supports all MWF fundraising efforts. The DA is responsible for implementing and managing donor-relationship activities, from setting up call time and direct mail processes, to...

  • Business Development Representative

    2 months ago

    Missoula, Montana, United States ALPS INSURANCE AGENCY INC Full time

    :ALPS is a leading provider of insurance solutions for law firms. With a commitment to excellence and a focus on meeting the unique needs of legal professionals, we pride ourselves on delivering comprehensive coverage and exceptional service. We are committed to growth and expanding nationally as such we are seeking a dynamic and results-driven Outbound...

  • Business Development Representative

    2 months ago

    Missoula, United States ALPS INSURANCE AGENCY INC Full time

    Description: ALPS is a leading provider of insurance solutions for law firms. With a commitment to excellence and a focus on meeting the unique needs of legal professionals, we pride ourselves on delivering comprehensive coverage and exceptional service.   We are committed to growth and expanding nationally as such we are seeking a dynamic and...

  • Senior Project Engineer

    1 week ago

    Missoula, Montana, United States Consor Engineers Full time

    About the RoleWe are seeking a highly skilled Senior Project Engineer to join our team at Consor Engineers. As a key member of our bridge design and development team, you will be responsible for coordinating the development of plans for various bridges throughout the country.Key ResponsibilitiesPerform structural and bridge analysis and calculationsPrepare...

  • Chief Banking Officer

    7 days ago

    Missoula, Montana, United States First Security Bank of Missoula Full time

    About the RoleThe Chief Banking Officer / Chief Operations Officer provides senior-level leadership and oversight for the division's retail and operational departments. The position is responsible for encompassing the administration, direction, and oversight of Retail Lending, Branch Retail Services, Operations (Centralized Operations, Wire Processing,...

  • Chief Clinical Officer

    4 days ago

    Missoula, Montana, United States Western Montana Mental Health Center Full time

    Job SummaryThe Western Montana Mental Health Center seeks a highly skilled and experienced Chief Clinical Officer to lead our medical programs and services. As a key member of our executive team, you will be responsible for shaping the strategic direction of our clinical operations and ensuring the delivery of high-quality patient care.Key...

  • Structural Engineer

    6 days ago

    Missoula, Montana, United States CONSOR Engineers Full time

    About the RoleWe are seeking a highly skilled Senior Project Engineer to join our team at CONSOR Engineers. As a key member of our bridge design and development team, you will be responsible for coordinating the development of plans for various bridges throughout the country.Key ResponsibilitiesBridge Design and Analysis: Perform structural and bridge...

  • Senior Project Engineer

    3 days ago

    Missoula, Montana, United States CONSOR Engineers Full time

    About the RoleWe are seeking a highly skilled Senior Project Engineer - Bridge Design to join our team at CONSOR Engineers. As a key member of our bridge design team, you will be responsible for coordinating the development of plans for various bridges throughout the country.Key ResponsibilitiesPerform Structural / Bridge Analysis and Calculations: Utilize...

  • District Manager

    1 month ago

    Missoula, Montana, United States Mondelez International Full time

    Job Description Are You Ready to Make It Happen at Mondelēz International? Join our Mission to Lead the Future of Snacking. Make It With Pride. The District Manager (DM) will execute Retail priorities within a specific geographic territory. The position has responsibility for managing a Direct Store delivery retail sales force. Ensure that all Retail...

  • Program Specialist 1

    2 months ago

    Missoula, United States State of Montana Full time

    Job Overview: The position is responsible for a variety of duties that support business functions in the Good Neighbor Authority Bureau. The position is responsible for assisting the Business Specialist 2 in administrative and fiscal management duties such as GNA budget management and budget reporting as well as maintaining accounting records,...

  • Community Operations Assistant

    1 week ago

    Missoula, Montana, United States ROUNDHOUSE COMMUNITIES LLC Full time

    Schedule: Monday - Friday, 10:00am - 2:00pm ROUNDHOUSE COMMUNITIES LLC, a fast-expanding developer and manager of varied real estate initiatives, is in search of a proactive individual to assume the role of Community Operations Assistant. Established in 2008, our company operates across multiple states, managing over 7,000 multi-family units and assets...

  • Chief Financial Officer

    3 months ago

    Missoula, United States Partners in Home Care Full time

    Job Summary:The Chief Financial Officer (CFO), under the direction of the Chief Executive Officer (CEO), provides leadership and strategic direction for all aspects of financial operations, including budgeting, reporting, auditing, and identifies opportunities relating to fiscal functions. The CFO has responsibility for Revenue Cycle, Accounts Receivable,...

  • Chief Financial Officer

    3 months ago

    Missoula, United States Partners in Home Care Full time

    Job Summary:The Chief Financial Officer (CFO), under the direction of the Chief Executive Officer (CEO), provides leadership and strategic direction for all aspects of financial operations, including budgeting, reporting, auditing, and identifies opportunities relating to fiscal functions. The CFO has responsibility for Revenue Cycle, Accounts Receivable,...

  • Bridge Design and Project Management Professional

    7 days ago

    Missoula, Montana, United States CONSOR Engineers Full time

    About the RoleWe are seeking a highly skilled Senior Project Engineer to join our team at CONSOR Engineers. As a key member of our bridge design and development team, you will be responsible for coordinating the development of plans for various bridges throughout the country.Key ResponsibilitiesBridge Design and Analysis: Perform structural and bridge...

  • Diesel Equipment Trainer

    6 days ago

    Missoula, Montana, United States Western States Machine Company Full time

    Job SummaryThis position is responsible for developing and delivering comprehensive training programs for diesel equipment technicians in alignment with the company's technician career development plan. The successful candidate will facilitate in-house and client training courses, maintain and develop training materials, and ensure compliance with industry...

  • Heavy Machinery Training Specialist

    6 days ago

    Missoula, Montana, United States Western States Machine Company Full time

    Job SummaryThis position is responsible for developing and delivering comprehensive training programs for diesel equipment technicians in alignment with the company's technician career development plan. The successful candidate will facilitate in-house and client training courses, maintain and develop training materials, and ensure compliance with industry...

  • Program Specialist 1

    3 weeks ago

    Missoula, United States State of Montana Full time

    Montana Department of Natural Resources and Conservation's mission is to help ensure that Montana's land and water resources provide benefits for present and future generations.The DNRC believes employees are their most important asset. The DNRC empowers employees to exercise professional judgment in carrying out their duties. Employees are provided with the...

  • Senior Transportation Project Manager

    6 days ago

    Missoula, Montana, United States Morrison Maierle Full time

    About the RoleWe are seeking a highly skilled and experienced Senior Transportation Engineer to join our team at Morrison-Maierle. As a key member of our engineering team, you will be responsible for leading and managing complex transportation projects from inception to completion.Key ResponsibilitiesProject Management: Lead teams to achieve project results...

  • Investment Accounting Manager

    3 weeks ago

    Missoula, United States Envirocon, Inc Full time

    The Investment Accounting Manager will work with the Vice President - Investments and the President/Chief Investment Officer to ensure the investment entities are accounted for correctly, records are maintained accurately, and that periodic reporting is done timely. The position will also coordinate and work closely with the tax team to ensure...