Microsoft-sql-server Careers in scottsdale ∙ Page 1

About the Department

Under general supervision from the Assistant IT Director (EA, Dev & Cyber), design, develop, and implement effective business intelligence solutions using Microsoft Power BI. Work closely with department stakeholders, data engineers, and other analysts to transform raw data into actionable insights. This job class is treated as FLSA Exempt.

Essential Functions: Essential functions may vary among positions and may include the following tasks and other characteristics. This list of tasks is ILLUSTRATIVE ONLY and is not intended to be a comprehensive listing of tasks performed by all positions in this classification.

Position Duties

1. Develops and maintains interactive dashboards, reports, and data visualizations using Power BI.

1. Collaborates with departments to translate reporting needs into impactful BI solutions that tell a clear, compelling story.

1. Connects to various data sources (SQL Server, Excel, SharePoint, APIs, etc.) and model data using Power Query and DAX.

1. Optimizes Power BI datasets and reports for performance and usability.

1. Ensures data integrity and accuracy in all reports and dashboards.

1. Creates and maintain documentation related to BI solutions, data models, and report logic.

1. Provides training and support to end-users on Power BI reports and tools.

1. Performs other job-related duties as assigned by the Assistant IT Director (EA, Dev & Cyber) or the IT Director/CIO.

• Knowledge of IT infrastructure and applications.
• Knowledge of database table design methodologies and data table normalization.
• Knowledge of DAX, Power Query (M), and SQL.
• Knowledge of software testing and documentation methodologies.
• Knowledge of Microsoft technologies (Azure, Excel, SharePoint, etc.).
• Knowledge of data governance and data quality best practices.
• Skilled in leading customer requirements sessions and transforming insights into story-driven visuals
• Strong analytical and problem-solving skills. 
• Strong verbal and written communication skills.
• Sharp analytical and problem-solving skills.
• Ability to derive actionable insights from data to enhance customer value.
• Ability to learn new environments and data models quickly with minimum supervision.
• Ability to develop and maintain positive and effective working relationships at all levels within the Tribal Government and Community.
• Ability to perform tasks requiring advanced problem-solving skills.
• Ability to manage multiple projects and work independently or as part of a team.
• Ability to follow verbal and written instructions.
• Ability to explain complex problems or situations.
• Ability to impart specific expertise and knowledge to peers and staff through individual mentoring and team efforts.

Minimum Qualifications

Education: A Bachelor’s degree from an accredited college or university in Computer Science, Engineering or related IT discipline required.

Experience: Three (3) years of experience in BI development with a strong focus on Power BI.

• Demonstrated successful experience performing using the following technologies required:
  • DAX, Power Query (M), and SQL.
  • Data modeling, ETL processes, and database design.
  • Adherence to Agile Software Development Lifecycle methodologies.
  • Microsoft SQL Server or equivalent database technology.
• Demonstrated successful experience in the following technologies is preferred:
  • Azure Synapse, Data Factory, Databricks, Snowflake or other cloud data platforms.
  • Lifecycle management tools (Atlassian Jira and Confluence or similar).
  • Experience with other BI tools (Tableau, Qlik, etc.) is a plus.

Other Qualifications

Special Requirements:   May be required to work outside normal work hours including nights, weekends and holidays. All applicants applying for jobs will be subject to Pre-Employment Drug Test and extensive Fingerprint and Background Check. In addition, all employees providing services to a campus with children will be subject to the “Community Code of Ordinances”, Chapter 11 “Minors”, Article X. “Investigation of Persons Working with Children” random drug testing and completion of a background check every five (5) years.

Prior to hire as an employee, applicants will be subject to drug and alcohol testing. Will be required to pass a pre-employment background/fingerprint check.

"SRPMIC is an Equal Opportunity/Affirmative Action Employer" Preference will be given to a qualified:Community Member Veteran, Community Member, Spouse of Community Member, qualified Native American, and then other qualified candidate.

In order to obtain preference, the following is required: 1) Qualified Community Member Veteran (DD-214) will be required at the time of application submission 2) Qualified Community Member (must provide Tribal I.D at time of application submission),3) Spouse of a Community Member (Marriage License/certificate and spouse Tribal ID or CIB is required at time of application submission), and 4) Native American (Tribal ID or CIB required at time of application submission).

Documents may be submitted by one of the following methods: 

1) attach to application

2) fax (480) 362-5860

3) mail or hand deliver to Human Resources.

Documentation must be received by position closing date. 

The IHS/BIA Form-4432 is not accepted. 

Your Tribal ID/CIB must be submitted to HR-Recruitment-Two Waters.