Requisition Title: BUSINESS INTELLIGENCE DEVELOPER II.7034900 - 24000759

Work Locations: DATA SERVICES - 500 Elm St, Ste 6400 - Dallas

Organization: INFO TECH SERVICES

Brief DescriptionResponsible for building and maintaining business intelligence reports and dashboards. Primarily support the business in creating and maintaining meaningful reports and analysis aligned with key business metrics. In addition, the position will work closely with key business stakeholders to devise new ways to measure and predict future business performance as well as uncover insights that could help inform management decisions

Detailed DescriptionResponsible for design, Development, publish, schedule reports and dashboards to meet business requirements. Also responsible for unit testing of various components of BI projects, while adhering to architectural requirements of maintainability and scalability. Plans, and coordinates projects with other areas of responsibility; works with outside entities to translate business requirements into stories, tasks, and subtasks in support of delivering consumable value to business partners in an Agile manner. Resolve problems and provide technical evaluation and recommendations; attends status, design and implementation meetings with IT staff and other department staff and stakeholders. Designs, codes, tests, documents, and implements visualizations, reports and dashboards; adheres to defined business requirements and statutes following standard SDLC and best practices. Applies system updates and patches; maintains program customization details; facilitates process to ensure data continuity. Works with end-users and other technical employees to resolve any errors and maintenance issues. Performs other duties and responsibilities as assigned.

Job RequirementsEducation, Experience and Training: Education and experience equivalent to a Bachelor's degree from an accredited college or university in Computer Science, MIS, Mathematics, Business, Engineering, or other related field of study. Four (4) years of related work experience using MS Power BI Stack or other BI tool, developing complex technical data visualizations, dashboards or reports in accordance with development standards and tools utilizing best practices and Education obtained from accredited college or university in Computer Science, Information Systems, Mathematics, Engineering, or a technical job related field of study. Work experience supporting using MS Power BI Stack or other BI tools at an enterprise level. Special Requirements/Knowledge, Skills & Abilities: Must have strong experience utilizing tools and systems on the MS SQL Server BI Stack, including SSRS, SSIS, SSAS, T-SQL, Power Pivot, Power BI, Power Query, MDX, and DAX. Understanding of database fundamentals, including relational database design, multidimensional database design, OLTP, and OLAP. Ability to quickly stage & shape data from data warehouses into reporting and analytics solutions. Proficiency with SSAS Tabular models. Proficiency with developing Power BI reports and Dashboards. Proficiency with writing T-SQL queries and stored procedures. Ability to meet deadlines. Must have the ability to work independently and as a part of a team. Ability to effectively communicate both orally and in writing, and establish and maintain effective working relationships with employees, departments and the general public Desired Skills & Abilities: Experience with Big Data Technologies: Azure Data Lake/ Azure Data warehousing. Must pass a background check for security-sensitive positions. Must possess a valid Texas Driver’s License and good driving record. Will be required to provide a copy of 10-year driving history. Must maintain a good driving record and remain in compliance with Article II, Subdivision II of Chapter 90 of the Dallas County Code. “Individuals holding or considered for a position which has, or may have, access to criminal justice databases including the FBI Criminal Justice Information Systems, NCIC/TCIC and similar databases, must pass a national fingerprint-based records check prior to placement in such position and may be denied placement in such positions and/or access to such systems. Incumbents must also maintain the ability to pass the records check while in the position or until such time that the Commissioners Court and the County Civil Service Commission deem this position no longer has this requirement.” Physical/Environmental Requirements: On-call 24/7. Typically works in a standard office environment and non-standard environment.

Additional DetailsAn extensive pre-employment background investigation will be conducted on all applicants who have been offered a position with Dallas County. The hiring process involves successful completion of each step. The steps include: Criminal History Review, Traffic Violations Record, Review of Personal History Statement and Documents, Physical Examination, and Background Investigation. Dallas County is an Equal Employment Opportunity Employer. AmeriCorps, Peace Corps, National Service Alumni volunteers, and persons with a criminal background are encouraged to apply.

Minimum Salary: 7491.03

Maximum Salary: 9363.77

Currency: US Dollar (USD)