Afternoon Data Analyst R Programming Jobs in Hanover, PA

JMT Technology Group, a leading geospatial and information technology solutions provider, is looking for a BI Developer to join our team. The BI Developer will be responsible for designing, developing, and maintaining BI solutions of medium to high complexity. This role is ideal for someone who thrives on transforming raw data into meaningful insights and enjoys building scalable, user-friendly dashboards and reports that drive business decisions.

Immigration sponsorship or support (e.g. H1B, F-1 CPT/OPT/STEM OPT) is not available for this position, except for qualified candidates eligible for the TN visa classification.

Compensation for this position is $85,000.00 - $95,000.00, commensurate with experience, education and certifications. The provided range is a good faith estimate based on the requirements described within the job description. We notice that we receive a wide variety of applicants and recognize that the person selected may be less experienced or more experienced. If so, the actual salary range may vary from the estimate provided.

Essential functions and responsibilities

• Perform business analysis to gather BI report requirements of medium to high complexity across multiple projects
• Collaborate with business stakeholders to understand their data needs and translate them into business intelligence solutions
• Perform SQL development tasks of medium to high complexity across multiple projects
• Design and develop Extract, Transform, and Load (ETL) processes to ensure data accuracy, consistency, and timely delivery for analysis
• Utilize Git-based version control, pull requests, and CI/CD processes to ensure quality, consistency, and maintainability of analytics code and data models
• Design and maintain data marts using dbt to support enterprise reporting and analytics
• Integrate data and reports with dynamic reporting engines such as Tableau and Power BI
• Ensure data design is compliance with internal and external regulations and standards
• Develop mock-ups and wireframes to outline the look and feel of reports prior to development
• Create attractive, data rich, and intuitive static reports, dynamic reports, and dashboards
• Provide ongoing support and training to users on BI tools and data analytics
• Collaborate with project managers, business systems analysts, UX designers, and application developers to deliver high-quality deliverables
• Leverage mentorship and peer relationships to increase proficiency in development
• Mentor and support junior BI developers, providing guidance on best practices, code reviews, and technical problem-solving
• Innovate and contribute to improving standards, techniques, tools, and processes
• Attend conferences, seminars, webinars, and/or on-line training on a regular basis to stay current with industry trends, emerging technologies, and industry best practices

Nonessential functions and responsibilities

• Perform other related duties as assigned

• Bachelor’s degree in computer science, information systems, or a related field
• 3-5 years of experience designing and developing Business Intelligence solutions
• Strong proficiency in DAX and Power Query
• 2+ years of designing and developing SQL solutions
• 1+ years of experience using Git-based source control and collaborative development practices
• Experience working in a code-centric development environment using tools such as Visual Studio Code and command-line interfaces
• Excellent verbal and written communication skills

Preferred Experience

• Microsoft Certified Power BI Data Analyst Associate
• Proven record of leading BI projects from beginning to end
• Ability to communicate effectively with clients, project managers and other team members
• Experience with ETL tools such as Databricks
• Familiarity with dbt (data build tools) concepts including models, tests, documentation, and best practices
• Knowledge of data governance, security, and compliance standards

Working Conditions

Work is performed within a general hybrid office environment. Work is generally sedentary in nature, but may require occasional standing and walking. Lighting and temperature are adequate and there are no hazardous or unpleasant conditions caused by noise, dust, etc. within the office environment.

JMT offers outstanding opportunities for career and professional growth. We are 100% employee-owned (ESOP) and offer outstanding health care coverage and other benefits, including:

• Affordable Medical, Dental & Vision Insurance
• Company paid Life and Disability Insurance
• Paid Time Off
• Paid Holidays
• Paid Caregiver Leave Program
• 401K Retirement Plan (Traditional and Roth options)

Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status or any other characteristic protected by state or federal law.