City of Miami Beach, FL
Business Intelligence Engineer
City of Miami Beach, FL, Miami Beach, Florida, us, 33119
Salary :
$2,991.20 - $4,991.20 Biweekly
Location :
Miami Beach, FL
Job Type:
Full-time
Job Number:
02332
Department:
Information Technology
Opening Date:
11/01/2024
Closing Date:
11/15/2024 5:00 PM Eastern
Nature of Work
The City of Miami Beach is looking for an experienced, full time Microsoft BI Developer to work with the Data Integration and Analytics team supporting the Business Intelligence environment. The candidate will utilize their experience with the Microsoft stack and other technologies to support the operational, analytical, and data integration needs of the organization. This position will be responsible for the development, support, and documentation of new and existing Business Intelligence initiatives.
This professional position reports to an assigned supervisor and may exercise some degree of autonomy in accomplishing the IT department's strategic goals while providing technical support and project execution for various City departments. This includes assisting other technical staff and stakeholders with the planning, development, installation, configuration, maintenance, support, and optimization of all business intelligence systems as required. The person will also assist technical staff as required to analyze and resolve end user computing experience and global customer issues in a timely and accurate fashion. In addition, this position will provide end user and peer training where required.
Illustrative Examples of Essential Duties
Translate business requirements into specifications that will be used to implement the required reports and dashboards.Work with business units to gather requirements, development and delivery of business intelligence & reporting services.Develops and implements business intelligence & analytics to support organizational initiatives.Build rich and dynamic dashboards using out-of-box features, customizations and visualizations.Design and publish custom dashboards and web applications for business functions, stakeholders and corporate users around the company.Design, model, develop & optimize BI solutions to meet data management and data reporting objectives.Design and model data flows and procedures ensuring data quality and integrityWorking with data engineers and application engineers to ensure that data sets feeding the analytics platforms are tuned for optimal performance.Work with power users of the analytics/reporting tools to advice on best practices for the business Intelligence reporting.Troubleshoot and resolve issues with the processes used and the content produced by the BI platform.Work with business stakeholders to define and improve standardized and ad-hoc analytics/reporting capabilities.Work as part of the BI team to maintain and develop all components of the BI platform.Provide ongoing maintenance support through troubleshooting, report modifications and optimization.Provide input into the technical architecture and the data warehouse technology stack.Create functional and technical design documents and maintain documentation for all reports and dashboards created or modifiedCreates and maintains positive, cohesive work environment
Minimum Requirements
Education: Any combination of education and training which would provide the opportunity to acquire the knowledge and abilities listed. Normally, graduation from a four-year college or university with major coursework in computer science, information systems, or a closely related field would provide this opportunity.
4+ years production SQL Server and Business Intelligence development and support3+ years Production experience working with Microsoft SQL Server (SSRS),(SSIS),(SSAS),(Power BI), APIExperience with data integration methodologies and toolsExperience with the design of relational and multidimensional databaseStrong proficiency in SQL performance tuningUnderstanding of SDLC lifecycleKnowledge of Source Control practicesExperience on Azure Data Platform is a plus
Physical Requirements:
Sitting for extended periods of time.Dexterity of hands and fingers to operate a computer keyboard, mouse, power tools, and to handle other computer components.Occasional inspection of cables in floors and ceilings.Lifting and transporting of moderately heavy objects, such as computers and peripherals.Must have the use of sensory skills in order to effectively communicate and interact with other employees and the public through the use of the telephone and personal contact. Physical capability to effectively use and operate various items of office related equipment. Some standing, walking, moving, climbing, carrying, bending, kneeling, reaching, and handling, sitting, standing, pushing, and pulling.
For all positions:
Ability to establish and maintain effective working relationships with elected officials, coworkers, the press the general public and members of diverse cultural and linguistic backgrounds regardless of race, religion, age, sex, disability, political affiliation, gender identity or sexual orientation.Ability to serve the public and fellow employees with honesty and integrity in full accord with the letter and spirit of all city ethics and conflicts of interest policies. Strong understanding of ethical behavior is required.Ability to maintain regular and punctual attendance.Performs related work as requiredReports to work as directed during an emergency as an essential employee of the City of Miami Beach
For all technical, professional, supervisory and managerial positions:
Ability to develop innovative and creative solutions to issues consistent with the City's strategic plan.
Applicants must detail any related work experience on the application or risk disqualification . It is the applicant's responsibility to update their NEOGOV profile with work experience, education, certifications and personal contact information when submitting each application, failure to do so will result in ineligibility.
City of Miami Beach employees must reflect their current position and detail their work experience on the application to avoid being disqualified.
Veterans Preference:
Veterans Preference is awarded in accordance with Florida State Statute 295.07. If veteran's preference is being claimed, it must be indicated on the application form and proper documentation, including all forms DD-214 (either Member 2 or Member 4), as well as the final Department of Defense Disability Letter (dated within one year)
must be submitted
with the application.
Benefits are available to FULL-TIME employees only.
The City of Miami Beach offers a comprehensive benefits package, including 12 vacation, 12 sick days, 15 paid holidays (11 holidays and 4 floating holidays); partially sponsored by the City group medical (including visual) and dental insurance, life insurance. Excellent retirement plan: pre-tax employee contribution added to the City's contribution; 5 year "cliff vesting."
Voluntary Benefits (fully paid by the employee, but payroll deductible): flexible spending account; 457 Deferred Compensation Plan, and Roth IRA; universal and critical life insurance, disability insurance, long-term care, and lump sum cancer policy. Also, U.S. Legal Services, tuition assistance, pre-tax payroll contributions, continuation of medical and dental coverage up to 18 months upon termination (COBRA).
For a more detailed overview of the benefit package, please visit Benefits section at
01
Do you have any combination of education and training which would provide the opportunity to acquire the knowledge and abilities listed. Normally, graduation from a four-year college or university with major coursework in computer science, information systems, or a closely related field would provide this opportunity?
YesNo
02
Do you have 4+ years production SQL Server and Business Intelligence development and support?
YesNo
03
Do you have 3+ years Production experience working with Microsoft SQL Server (SSRS),(SSIS),(SSAS),(Power BI), API?
YesNo
04
Do you have experience with data integration methodologies and tools?
YesNo
05
Do you have experience with the design of relational and multidimensional database?
YesNo
06
Strong proficiency in SQL performance tuning?
YesNo
07
Do you have the understanding of SDLC lifecycle?
YesNo
08
Do you have knowledge of Source Control practices?
YesNo
09
Do you have experience on Azure Data Platform?
YesNo
10
I acknowledge that I can perform the physical requirements that are listed for this job.
YesNo
11
I acknowledge that in order to claim Veterans Preference, I must indicate it on the application form and attach proper documentation. If you are not claiming Veterans Preference, please check box indicating N/A.
YesNo
Required Question
$2,991.20 - $4,991.20 Biweekly
Location :
Miami Beach, FL
Job Type:
Full-time
Job Number:
02332
Department:
Information Technology
Opening Date:
11/01/2024
Closing Date:
11/15/2024 5:00 PM Eastern
Nature of Work
The City of Miami Beach is looking for an experienced, full time Microsoft BI Developer to work with the Data Integration and Analytics team supporting the Business Intelligence environment. The candidate will utilize their experience with the Microsoft stack and other technologies to support the operational, analytical, and data integration needs of the organization. This position will be responsible for the development, support, and documentation of new and existing Business Intelligence initiatives.
This professional position reports to an assigned supervisor and may exercise some degree of autonomy in accomplishing the IT department's strategic goals while providing technical support and project execution for various City departments. This includes assisting other technical staff and stakeholders with the planning, development, installation, configuration, maintenance, support, and optimization of all business intelligence systems as required. The person will also assist technical staff as required to analyze and resolve end user computing experience and global customer issues in a timely and accurate fashion. In addition, this position will provide end user and peer training where required.
Illustrative Examples of Essential Duties
Translate business requirements into specifications that will be used to implement the required reports and dashboards.Work with business units to gather requirements, development and delivery of business intelligence & reporting services.Develops and implements business intelligence & analytics to support organizational initiatives.Build rich and dynamic dashboards using out-of-box features, customizations and visualizations.Design and publish custom dashboards and web applications for business functions, stakeholders and corporate users around the company.Design, model, develop & optimize BI solutions to meet data management and data reporting objectives.Design and model data flows and procedures ensuring data quality and integrityWorking with data engineers and application engineers to ensure that data sets feeding the analytics platforms are tuned for optimal performance.Work with power users of the analytics/reporting tools to advice on best practices for the business Intelligence reporting.Troubleshoot and resolve issues with the processes used and the content produced by the BI platform.Work with business stakeholders to define and improve standardized and ad-hoc analytics/reporting capabilities.Work as part of the BI team to maintain and develop all components of the BI platform.Provide ongoing maintenance support through troubleshooting, report modifications and optimization.Provide input into the technical architecture and the data warehouse technology stack.Create functional and technical design documents and maintain documentation for all reports and dashboards created or modifiedCreates and maintains positive, cohesive work environment
Minimum Requirements
Education: Any combination of education and training which would provide the opportunity to acquire the knowledge and abilities listed. Normally, graduation from a four-year college or university with major coursework in computer science, information systems, or a closely related field would provide this opportunity.
4+ years production SQL Server and Business Intelligence development and support3+ years Production experience working with Microsoft SQL Server (SSRS),(SSIS),(SSAS),(Power BI), APIExperience with data integration methodologies and toolsExperience with the design of relational and multidimensional databaseStrong proficiency in SQL performance tuningUnderstanding of SDLC lifecycleKnowledge of Source Control practicesExperience on Azure Data Platform is a plus
Physical Requirements:
Sitting for extended periods of time.Dexterity of hands and fingers to operate a computer keyboard, mouse, power tools, and to handle other computer components.Occasional inspection of cables in floors and ceilings.Lifting and transporting of moderately heavy objects, such as computers and peripherals.Must have the use of sensory skills in order to effectively communicate and interact with other employees and the public through the use of the telephone and personal contact. Physical capability to effectively use and operate various items of office related equipment. Some standing, walking, moving, climbing, carrying, bending, kneeling, reaching, and handling, sitting, standing, pushing, and pulling.
For all positions:
Ability to establish and maintain effective working relationships with elected officials, coworkers, the press the general public and members of diverse cultural and linguistic backgrounds regardless of race, religion, age, sex, disability, political affiliation, gender identity or sexual orientation.Ability to serve the public and fellow employees with honesty and integrity in full accord with the letter and spirit of all city ethics and conflicts of interest policies. Strong understanding of ethical behavior is required.Ability to maintain regular and punctual attendance.Performs related work as requiredReports to work as directed during an emergency as an essential employee of the City of Miami Beach
For all technical, professional, supervisory and managerial positions:
Ability to develop innovative and creative solutions to issues consistent with the City's strategic plan.
Applicants must detail any related work experience on the application or risk disqualification . It is the applicant's responsibility to update their NEOGOV profile with work experience, education, certifications and personal contact information when submitting each application, failure to do so will result in ineligibility.
City of Miami Beach employees must reflect their current position and detail their work experience on the application to avoid being disqualified.
Veterans Preference:
Veterans Preference is awarded in accordance with Florida State Statute 295.07. If veteran's preference is being claimed, it must be indicated on the application form and proper documentation, including all forms DD-214 (either Member 2 or Member 4), as well as the final Department of Defense Disability Letter (dated within one year)
must be submitted
with the application.
Benefits are available to FULL-TIME employees only.
The City of Miami Beach offers a comprehensive benefits package, including 12 vacation, 12 sick days, 15 paid holidays (11 holidays and 4 floating holidays); partially sponsored by the City group medical (including visual) and dental insurance, life insurance. Excellent retirement plan: pre-tax employee contribution added to the City's contribution; 5 year "cliff vesting."
Voluntary Benefits (fully paid by the employee, but payroll deductible): flexible spending account; 457 Deferred Compensation Plan, and Roth IRA; universal and critical life insurance, disability insurance, long-term care, and lump sum cancer policy. Also, U.S. Legal Services, tuition assistance, pre-tax payroll contributions, continuation of medical and dental coverage up to 18 months upon termination (COBRA).
For a more detailed overview of the benefit package, please visit Benefits section at
01
Do you have any combination of education and training which would provide the opportunity to acquire the knowledge and abilities listed. Normally, graduation from a four-year college or university with major coursework in computer science, information systems, or a closely related field would provide this opportunity?
YesNo
02
Do you have 4+ years production SQL Server and Business Intelligence development and support?
YesNo
03
Do you have 3+ years Production experience working with Microsoft SQL Server (SSRS),(SSIS),(SSAS),(Power BI), API?
YesNo
04
Do you have experience with data integration methodologies and tools?
YesNo
05
Do you have experience with the design of relational and multidimensional database?
YesNo
06
Strong proficiency in SQL performance tuning?
YesNo
07
Do you have the understanding of SDLC lifecycle?
YesNo
08
Do you have knowledge of Source Control practices?
YesNo
09
Do you have experience on Azure Data Platform?
YesNo
10
I acknowledge that I can perform the physical requirements that are listed for this job.
YesNo
11
I acknowledge that in order to claim Veterans Preference, I must indicate it on the application form and attach proper documentation. If you are not claiming Veterans Preference, please check box indicating N/A.
YesNo
Required Question