Business Intelligence (BI) Analyst / Developer — Kansas City, KS

Participate in a cross-functional team environment responsible for development and support of core aavNZ HjNFjET Mw ZSrMgqq (DFA) business applications and processes. The Business Intelligence (BI) analyst / developer will architect, develop, and provide operational support skills to deliver and maintain Snowflake and Power BI data platforms, data warehousing, business intelligence, reporting, and visualization solutions for a wide range of business functions and user communities. The BI analyst / developer will function as part of DFA’s IT organization and follow relevant applications, infrastructure and governance processes.

Job Duties And Responsibilities

• Design, develop, and maintain scalable Snowflake/Power BI data models, schemas, tables, and views to support enterprise BI, analytics, and reporting.

• Build and optimize BI data pipelines and transformation processes, ensuring efficient performance, reliability, and scalability.

• Develop and maintain transformations, stored procedures, tasks, and data integration processes within Snowflake and Microsoft.

• Translate business requirements into well-governed, reusable data models aligned with enterprise standards.

• Define and enforce development standards, naming conventions, data governance, and data modeling best practices.

• Coordinate development, testing, deployment, and change management activities with business analysts and BI team members.

• Proactively identify opportunities to improve query performance, warehouse efficiency, data quality, cost management, and usability.

• The requirements herein are intended to describe the general nature and level of work performed by employee, but is not a complete list of responsibilities, duties, and skills required. Other duties may be assigned as required.

,

Education And Experience

• Bachelor’s degree in Computer or Data Science or equivalent experience

• 2-3 years of experience as a SQL developer, Snowflake developer, Data Warehouse developer, or BI Developer

• Strong skills with Snowflake and SQL

Preferred Qualifications

• Strong knowledge of SQL and relational data concepts

• Knowledge of Snowflake architecture, development, and performance optimization

• Working knowledge of Power BI and enterprise reporting concepts

• Familiarity with working in an Agile development environment

Knowledge, Skills And Abilities

• Able to work on-call rotation

• Able to demonstrate written and verbal communications skills with the ability to effectively communicate with business users, stakeholders, technical teams, and various levels of management

• Able to work independently

• Able to work on multiple projects simultaneously, including the ability to prioritize

• Able to organize time and resources effectively to achieve goals (i.e., organizational skills)

• Able to demonstrate leadership qualities as a self-starter, set direction, and complete assignments

• Able to interact effectively and cooperatively with employees at all levels

• Able to demonstrate strong customer service orientation

• Strong work ethic

• Must be able to read, write, and speak English

An Equal Opportunity Employer including Disabled/Veterans