BI Reporting and Information Architect

at  Micron

Our vision is to transform how the world uses information to enrich life for all.
Micron Technology is a world leader in innovating memory and storage solutions that accelerate the transformation of information into intelligence, inspiring the world to learn, communicate and advance faster than ever.
JR52723 BI Reporting and Information Architect
The Business Intelligence (BI) Developer supports and expands the Business Management team’s business intelligence solution(s), primarily a custom data warehouse built in SQL Server, and reports developed in Microsoft’s SQL Server Reporting Services (SSRS), Excel, Tableau and/or Power BI. They will play a critical role in all phases of the solution’s life cycle. This includes participating in or leading requirements definition, data analysis, data modeling, data warehouse development, modeling and piloting emerging technologies and toolsets, ETL design and development, data integration from disparate data sources, reports creation and deployment, and database cleansing efforts. The BI Developer will focus on building reports that enable support and creation of the Business Management team’s process. This position interviews key partners on report requirements and builds tools that enable the team to work efficiently and accurately. Ultimately, it is the goal of the BI Developer to help ensure the reporting and analysis align with the Business Management team’s charter.

Responsibilities include, but not limited to:

• SQL development in a production environment: develop, test and document stored procedures, views, tables, indexes, constraints, functions and/or SQL scripts. Prepare detailed and comprehensive documentation for al programs.
• Interview key partners about reporting needs: work regularly with the Business Management team members to identify new reports and changes to existing reports; communicate with team members about report requirements; design, test and vet the final report results with relevant team members
• Develop and maintain standardized reports using the most appropriate tool which could include (Power BI/Tableau/Excel/SSRS): build/support a suite of reports that are scheduled and delivered electronically or are available on-demand in a self-service environment for Business Management team members
• Using Microsoft’s Integration Services (SSIS), expand and support the SQL Server-based data warehouse and associated ETL processes for reporting and analysis for the Business Management Team. Provide ample documentation on the data warehouse and associated reports. Use Microsoft’s SQL Server Management Studio (SSMS) throughout all phases.
• Develop methods to identify data anomalies and broken business rules within operational and transactional data systems. Assist in developing data integrity solutions and data cleanup processes.
• Other duties as requested or required

Minimum Qualifications:

• Bachelors in Computer Science and/or Information Technology with 10 years of experience or Masters in Computer Science or MCA with 5 years of experience
• Proficient in:
• Microsoft Office/VBA expertise
• Microsoft SQL (SSMS) – database design
• SSIS – SQL Server Integration Services

• SQL development in a production environment: develop, test and document stored procedures, views, tables, indexes, constraints, functions and/or SQL scripts. Prepare detailed and comprehensive documentation for al programs.
• Interview key partners about reporting needs: work regularly with the Business Management team members to identify new reports and changes to existing reports; communicate with team members about report requirements; design, test and vet the final report results with relevant team members
• Develop and maintain standardized reports using the most appropriate tool which could include (Power BI/Tableau/Excel/SSRS): build/support a suite of reports that are scheduled and delivered electronically or are available on-demand in a self-service environment for Business Management team members
• Using Microsoft’s Integration Services (SSIS), expand and support the SQL Server-based data warehouse and associated ETL processes for reporting and analysis for the Business Management Team. Provide ample documentation on the data warehouse and associated reports. Use Microsoft’s SQL Server Management Studio (SSMS) throughout all phases.
• Develop methods to identify data anomalies and broken business rules within operational and transactional data systems. Assist in developing data integrity solutions and data cleanup processes.
• Other duties as requested or require