IT Senior Business Intelligence Solutions Engineer

Position Information We are currently seeking an experienced IT Senior Business Intelligence Solutions Engineer to join our Information Technology Department.
This role offers a unique opportunity to merge BI expertise with integration skills, contributing to the seamless flow of information across diverse platforms and enhancing the overall business intelligence capabilities of New Hanover County.
This role works within the IT Enterprise Analytics team, blending the expertise of a seasoned Business Intelligence Solutions Engineer and the proficiency in developing integrations between diverse software applications.
In this position, you will contribute to the design, development, implementation, and support of comprehensive enterprise BI data solutions, reports, dashboards, and integrations.
Primary Job Responsibilities: Solution Articulation: Provide insights and recommendations on intricate BI and integration-related issues.
Design and implement seamless integrations between various software applications and backend systems.
Operational and Analytical Reporting: Enable operational and analytical reporting capabilities for internal business customers, ensuring data-driven decisions.
Best Practices Implementation: Design and implement technology best practices, guidelines, and repeatable processes to support data analysis efforts, enhancing program outcomes.
Technical Support: Provide support to ensure the availability and performance of developed reports, dashboards, and solutions.
Offer technical assistance and cross-training to team members.
Data Retrieval and Analysis: Write high-quality T-SQL code to retrieve and analyze data from multiple source systems.
Contribute to ongoing development and maintenance of analytical database instances.
Data Quality Enhancement: Troubleshoot data-quality issues, validate result sets, and recommend/implement process and performance improvements for data.
API Analysis and Utilization: Thoroughly analyze APIs, recognizing core industry concepts and workflows.
Leverage APIs to standardize and extend functionality across various platforms.
Real-time Solutions: Provide real-time solutions, demonstrating quick learning ability to understand systems, business processes, and new tools.
Required knowledge and skills: BI and Integration Experience: 5+ years of operational and analytical reporting experience, emphasizing strong expertise in developing integrations between diverse software applications.
Adaptability: Ability to rapidly learn systems, business processes, and new tools to provide real-time solutions.
Analytical Prowess: Excellent analytical ability, communication skills, and solid judgment to effectively collaborate with both business and technical associates.
BI Solutions Development: Strong experience in developing, monitoring, tuning, and deploying scalable BI solutions, reports, and dashboards.
Data Integration: Experience in extracting, cleaning, and integrating data for reporting through ETL and SQL methods.
Modeling Concepts: Knowledge of modeling concepts, including relational and dimensional models.
SQL Expertise: Expertise in writing advanced T-SQL queries, triggers, and designing complex stored procedures.
Programming Skills: Expertise in writing Python scripts, working with REST endpoints, and understanding JSON.
New Hanover County is dedicated to the recruitment and recognition of a talented and diverse workforce that is committed to public service.
Our shared values of professionalism, innovation, equity, integrity, stewardship and accountability guide the way we conduct ourselves and deliver services to our customers.
Supported by the work of our Office of Diversity and Equity, New Hanover County celebrates diversity in our employees’ backgrounds, beliefs, identities, and abilities, while supporting growth opportunities for all.
Our talented team has a passion for providing care and services that effect change on the everyday lives of the citizens they encounter.
The differences that unite us are a reflection of the community we serve.
If this sounds like an organization that models the values you uphold, we invite you to join our team at New Hanover County.
* * * * Hours: 8:00 AM - 5:00 PM, Monday - Friday.
Must be available to report for emergency work assignment during emergency situations.
Employment Type: Full-time, exempt Salary Information: The hiring range for this position is $79,291 - $107,043 annually plus a competitive benefits package.
Salary will be determined based on qualifications, internal equity, budget, and market considerations.
This posting is open until filled.
Priority consideration will be given to candidates who submit an application by Friday, March 1, 2024.
New Hanover County offers: Employer paid 401k contributions; Retirement plan through the NC Retirement system; Flex time and telework availability, depending on your position; Paid sick and personal leave + 13 paid holidays per year; Paid parental leave; Paid community services leave to give back to our community; Education leave to obtain a degree within your line of work; Medical, dental, and vision insurance + many other insurance options; Onsite, employer-paid health and wellness clinic; Professional development trainings & leadership initiatives; Opportunities to make a difference in your community; And so much more! We invite you to explore our careers page at www.
nhcgov.
com/careers for additional information about why New Hanover County is a great place to work, and to check out our competitive benefits package.
Qualifications Required minimum education and experience: Bachelor's degree in a related field 5+ years of operational and analytical reporting experience, emphasizing strong expertise in developing integrations between diverse software applications; or an equivalent combination of education and experience sufficient to successfully perform the essential duties of the job such as those listed above.
Licenses/Certifications Valid Driver's License (from any state) and good driving record required at time of application.
Valid North Carolina Driver’s License required by first date of employment with good driving record.
Other Information Residing in New Hanover County, North Carolina: Embrace an outstanding quality of life in New Hanover County, enriched by its charming coastal setting.
Enjoy the stunning beaches, water activities, and a variety of recreational opportunities right at your doorstep.
Immerse yourself in the vibrant local culture, relish a range of culinary delights, and embark on explorations of historical sites.
The county is known for its strong sense of community, excellent schools, and a thriving arts scene.
With a focus on good governance and a commitment to customer service, New Hanover County provides an ideal environment for both personal and professional growth.
Applicant Information: After the closing date for this position, applications will be screened by Human Resources.
Applicants referred to the department will receive an email requesting important information pertinent to the position applied for.
All updates regarding an application can be viewed through your applicant portal.